metadata: contig_metadata: 8 rows where bioproject = "PRJNA564013", tax_clade = "Sar" and tax

8 rows where bioproject = "PRJNA564013", tax_clade = "Sar" and tax_phylum = "Cercozoa"

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
1824787	1824787	PRJNA564013_P_NODE_223362_length_284_cov_7.735426_g220511_i0	PRJNA564013	223362	284	7.735426	21.96860984	Protaspis grandis	361427	SAR_Eukaryotes	SAR_Eukaryotes	300	8.480000000000001e-77	NTclustered	gi\|290760486\|gb\|GQ144689.1\|	361427	g220511	i0	85.714	47.4788732394366	287	37	100	4	1	284	2325	2040	Protaspis grandis large subunit ribosomal RNA gene, partial sequence	blastn	13484	300	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Protaspis	Protaspis grandis
14580985	14580985	PRJNA564013_P_NODE_40592_length_610_cov_3.027322_g37882_i0	PRJNA564013	40592	610	3.027322	18.4666642	Dujardina stenomorpha	983147	SAR_Eukaryotes	SAR_Eukaryotes	58.4	0.001	NTclustered	gi\|323320594\|gb\|HQ918171.1\|	983147	g37882	i0	97.143	0.99016393442623	35	0	6	1	577	610	1839	1805	Cercozoa sp. ATCC 50378 18S ribosomal RNA gene, partial sequence	blastn	604	58.4	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Dujardina	Dujardina stenomorpha
18402100	18402100	PRJNA564013_P_NODE_272255_length_244_cov_3.153005_g269403_i0	PRJNA564013	272255	244	3.153005	7.6933322	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	364	2.489999999999999e-96	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g269403	i0	95.982	89.2459016393443	224	9	92	0	21	244	1445	1222	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	21776	364	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
18984242	18984242	PRJNA564013_P_NODE_372455_length_175_cov_9.385965_g369603_i0	PRJNA564013	372455	175	9.385965	16.42543875	Lotharella	74819	SAR_Eukaryotes	SAR_Eukaryotes	126	8.56e-25	NTclustered	gi\|220983373\|dbj\|AB453009.1\|	74820	g369603	i0	84.921	31.3314285714286	126	18	71	1	27	151	3094	2969	Lotharella vacuolata gene for nuclear large subunit ribosomal RNA, partial sequence	blastn	5483	126	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Lotharella	Lotharella vacuolata
20258518	20258518	PRJNA564013_P_NODE_220496_length_287_cov_3.079646_g217645_i0	PRJNA564013	220496	287	3.079646	8.83858402	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	120	1.1699999999999998e-31	NR	MES1916659.1	1215613	g217645	i0	72.2	0.825783972125436	79	22	82.6	0	248	12	106	184	MES1916659.1 Ras-related protein Rab-7 [Cercozoa sp. M6MM]	diamond	237	120	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
22226291	22226291	PRJNA564013_P_NODE_223118_length_284_cov_22.739910_g220267_i0	PRJNA564013	223118	284	22.73991	64.5813444	Amorphochlora amoebiformis	1561963	SAR_Eukaryotes	SAR_Eukaryotes	76.8	1.56e-9	NTclustered	gi\|893150443\|dbj\|AB996604.1\|	1561963	g220267	i0	88.71	0.577464788732394	62	7	22	0	60	121	11009	11070	Amorphochlora amoebiformis nucleomorph DNA, chromosome: 3, complete sequence, strain: CCMP2058	blastn	164	76.8	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Amorphochlora	Amorphochlora amoebiformis
23500457	23500457	PRJNA564013_P_NODE_167479_length_336_cov_2.992727_g164629_i0	PRJNA564013	167479	336	2.992727	10.05556272	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	497	3.3899999999999993e-136	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g164629	i0	93.452	97.2619047619048	336	21	100	1	1	336	1599	1265	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	32680	497	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
30805967	30805967	PRJNA564013_P_NODE_199574_length_306_cov_12.257143_g196723_i0	PRJNA564013	199574	306	12.257143	37.50685758	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	83.2	4.97e-16	NR	MES1911799.1	1215613	g196723	i0	44.4	0.970588235294118	99	50	92.2	3	7	288	363	461	MES1911799.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	297	83.2	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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