metadata: contig_metadata: 9 rows where bioproject = "PRJNA1136957" and tax

9 rows where bioproject = "PRJNA1136957" and tax_clade = "Sar"

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_class	tax_order	tax_family	tax_genus	tax_species
2835254	2835254	PRJNA1136957_S_NODE_19223_length_199_cov_1.650000_g19126_i0	PRJNA1136957	19223	199	1.65	3.2835	Trachelocercidae sp. 3 BS-2022	2930473	SAR_Eukaryotes	SAR_Eukaryotes	52.8	0.017	NTclustered	gi\|2261268975\|emb\|OX095823.1\|	2930473	g19126	i0	100	0.14070351758794	28	0	14	0	172	199	37	10	Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-)	blastn	28	52.8	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Protostomatida	Trachelocercidae		Trachelocercidae sp. 3 BS-2022
7937664	7937664	PRJNA1136957_S_NODE_8787_length_285_cov_1.349558_g8690_i0	PRJNA1136957	8787	285	1.349558	3.8462403	Eimeria acervulina	5801	SAR_Eukaryotes	SAR_Eukaryotes	62.1	4.37e-5	NTclustered	gi\|915013718\|ref\|XM_013396634.1\|	5801	g8690	i0	97.297	10.6561403508772	37	0	13	1	247	283	5690	5725	Eimeria acervulina hypothetical protein, conserved partial mRNA	blastn	3037	62.1	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria acervulina
17609662	17609662	PRJNA1136957_S_NODE_10074_length_268_cov_9.875598_g9977_i0	PRJNA1136957	10074	268	9.875598	26.46660264	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	89.8	1.87e-13	NTclustered	gi\|695389557\|ref\|XM_009521174.1\|	67593	g9977	i0	92.063	27.9776119402985	63	5	24	0	1	63	857	919	Phytophthora sojae hypothetical protein partial mRNA	blastn	7498	89.8	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora sojae
19410561	19410561	PRJNA1136957_S_NODE_7016_length_312_cov_12.984190_g6919_i0	PRJNA1136957	7016	312	12.98419	40.5106728	Phytophthora cinnamomi	4785	SAR_Eukaryotes	SAR_Eukaryotes	106	2.21e-18	NTclustered	gi\|2795040101\|ref\|XM_067937224.1\|	4785	g6919	i0	92	29.2692307692308	75	6	24	0	236	310	918	844	Phytophthora cinnamomi Polyubiquitin (IUM83_12589), partial mRNA	blastn	9132	106	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora cinnamomi
20686044	20686044	PRJNA1136957_S_NODE_8737_length_285_cov_7.265487_g8640_i0	PRJNA1136957	8737	285	7.265487	20.70663795	Phytophthora nicotianae	4792	SAR_Eukaryotes	SAR_Eukaryotes	139	1.96e-28	NTclustered	gi\|675167000\|ref\|XM_008894137.1\|	761204	g8640	i0	82.209	52.0771929824561	163	27	57	2	11	172	228	389	Phytophthora parasitica INRA-310 histone H4 mRNA	blastn	14842	139	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Peronosporales	Peronosporaceae	Phytophthora	Phytophthora nicotianae
27228316	27228316	PRJNA1136957_S_NODE_14203_length_229_cov_2.876471_g14106_i0	PRJNA1136957	14203	229	2.876471	6.58711859	Bonamia ostreae	126728	SAR_Eukaryotes	SAR_Eukaryotes	67.4	4.81e-12	NR	MES1922622.1	126728	g14106	i0	48.6	0.96943231441048	74	37	96.9	1	227	6	11	83	MES1922622.1 FACT complex subunit ssrp1 [Bonamia ostreae]	diamond	222	67.4	1	Eukaryota	Sar	Endomyxa	Ascetosporea	Haplosporida		Bonamia	Bonamia ostreae
28238722	28238722	PRJNA1136957_S_NODE_1266_length_539_cov_37.085417_g1174_i0	PRJNA1136957	1266	539	37.085417	199.89039763	Lagenidium giganteum	4803	SAR_Eukaryotes	SAR_Eukaryotes	70.5	1.27e-10	NR	DAZ95331.1	4803	g1174	i0	50.7	2.2987012987013	69	26	34	1	476	294	6	74	DAZ95331.1 TPA: hypothetical protein N0F65_002438 [Lagenidium giganteum]	diamond	1239	70.5	1	Eukaryota	Sar	Oomycota	Peronosporomycetes	Pythiales	Pythiaceae	Lagenidium	Lagenidium giganteum
29269766	29269766	PRJNA1136957_S_NODE_13469_length_235_cov_2.000000_g13372_i0	PRJNA1136957	13469	235	2	4.7	Bacillariophyta	2836	SAR_Eukaryotes	SAR_Eukaryotes	105	5.0400000000000005e-27	NR	KAL3757257.1	259834	g13372	i0	72	11.5276595744681	75	21	95.7	0	235	11	74	148	KAL3757257.1 hypothetical protein ACHAWU_008418 [Discostella pseudostelligera]	diamond	2709	105	1	Eukaryota	Sar	Bacillariophyta	Coscinodiscophyceae	Stephanodiscales	Stephanodiscaceae	Discostella	Discostella pseudostelligera
32399073	32399073	PRJNA1136957_S_NODE_12399_length_244_cov_4.286486_g12302_i0	PRJNA1136957	12399	244	4.286486	10.45902584	Eimeria	5800	SAR_Eukaryotes	SAR_Eukaryotes	50.4	6.78e-5	NR	XP_013230724.1	5802	g12302	i0	59.5	0.909836065573771	37	15	45.5	0	243	133	280	316	XP_013230724.1 uncharacterized protein ETH_00037950, partial [Eimeria tenella]	diamond	222	50.4	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria tenella

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);;