metadata: contig_metadata: 7 rows where bioproject = "PRJNA975724" and tax

7 rows where bioproject = "PRJNA975724" and tax_phylum = "Perkinsozoa"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_order	tax_family	tax_genus	tax_species
946039	946039	PRJNA975724_S_NODE_36821_length_328_cov_1.207843_g36640_i0	PRJNA975724	36821	328	1.207843	3.96172504	Perkinsus marinus ATCC 5	31276	SAR_Eukaryotes	SAR_Eukaryotes	167	1.47e-49	NR	XP_002771649.1	423536	g36640	i0	75.5	2.92682926829268	106	26	97	0	9	326	27	132	XP_002771649.1 40S ribosomal protein S6, putative [Perkinsus marinus ATCC 50983]	diamond	960	167	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
8599798	8599798	PRJNA975724_S_NODE_69127_length_264_cov_1.209424_g68946_i0	PRJNA975724	69127	264	1.209424	3.19287936	Dinophyceae	2864	SAR_Eukaryotes	SAR_Eukaryotes	121	7.95e-33	NR	KAF4680316.1	32597	g68946	i0	83.8	15.4545454545455	68	11	77.3	0	2	205	105	172	KAF4680316.1 26S protease regulatory subunit 10B [Perkinsus olseni]	diamond	4080	121	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
16248328	16248328	PRJNA975724_S_NODE_14913_length_413_cov_6.579412_g14732_i0	PRJNA975724	14913	413	6.579412	27.17297156	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	163	1.76e-35	NTclustered	gi\|294953618\|ref\|XM_002787808.1\|	423536	g14732	i0	84.118	2.67070217917676	170	25	41	2	245	413	463	295	Perkinsus marinus ATCC 50983 40S ribosomal protein S14, putative, mRNA	blastn	1103	163	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
17523410	17523410	PRJNA975724_S_NODE_11594_length_436_cov_10.115702_g11413_i0	PRJNA975724	11594	436	10.115702	44.10446072	Perkinsus marinus	31276	SAR_Eukaryotes	SAR_Eukaryotes	183	1.43e-41	NTclustered	gi\|294925483\|ref\|XM_002778887.1\|	423536	g11413	i0	82.464	28.0848623853211	211	35	48	2	6	215	235	444	Perkinsus marinus ATCC 50983 ribosomal protein S23, putative, mRNA	blastn	12245	183	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus marinus
30443124	30443124	PRJNA975724_S_NODE_22013_length_377_cov_3.039474_g21832_i0	PRJNA975724	22013	377	3.039474	11.45881698	Perkinsus	28000	SAR_Eukaryotes	SAR_Eukaryotes	107	4.56e-26	NR	KAF4714106.1	32597	g21832	i0	47.7	2.64190981432361	111	55	86.7	2	8	334	125	234	KAF4714106.1 hypothetical protein FOZ63_008129 [Perkinsus olseni]	diamond	996	107	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30499985	30499985	PRJNA975724_S_NODE_64373_length_271_cov_2.297980_g64192_i0	PRJNA975724	64373	271	2.29798	6.2275257999999996	Perkinsus olseni	32597	SAR_Eukaryotes	SAR_Eukaryotes	62	7.83e-9	NR	KAF4724221.1	32597	g64192	i0	72.7	1.04059040590406	33	9	36.5	0	200	102	18	50	KAF4724221.1 hypothetical protein FOZ62_002425, partial [Perkinsus olseni]	diamond	282	62	1	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus olseni
30632402	30632402	PRJNA975724_S_NODE_56893_length_284_cov_1.744076_g56712_i0	PRJNA975724	56893	284	1.744076	4.95317584	Perkinsida	27998	SAR_Eukaryotes	SAR_Eukaryotes	100	4.26e-22	NR	KAF4671254.1	330153	g56712	i0	62.7	1.76408450704225	83	29	85.6	1	280	38	337	419	KAF4671254.1 hypothetical protein FOL47_001598 [Perkinsus chesapeaki]	diamond	501	101	0.99009900990099	Eukaryota	Sar	Perkinsozoa	Perkinsida	Perkinsidae	Perkinsus	Perkinsus chesapeaki

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;