metadata: contig_metadata: 5 rows where bioproject = "PRJNA1010780", tax_clade = "Sar" and tax

5 rows where bioproject = "PRJNA1010780", 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
11633718	11633718	PRJNA1010780_S_NODE_28870_length_275_cov_1.737500_g27581_i0	PRJNA1010780	28870	275	1.7375	4.778125	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	112	8.000000000000001e-29	NR	ACF24574.1	67809	g27581	i0	59.3	32.6290909090909	91	37	99.3	0	1	273	16	106	ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata]	diamond	8973	113	0.991150442477876	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
19280718	19280718	PRJNA1010780_S_NODE_48176_length_180_cov_1.268966_g46887_i0	PRJNA1010780	48176	180	1.268966	2.2841388	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	333	4.87e-87	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g46887	i0	100	98.3666666666667	180	0	100	0	1	180	325	146	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	17706	333	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
27508700	27508700	PRJNA1010780_S_NODE_10323_length_753_cov_4.973538_g9359_i0	PRJNA1010780	10323	753	4.973538	37.45074114	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	69.3	9.46e-11	NR	ADK47156.1	323453	g9359	i0	43.8	6.67330677290837	89	44	33.9	2	399	653	46	132	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	5025	69.3	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
29213883	29213883	PRJNA1010780_S_NODE_56129_length_162_cov_1.425197_g54840_i0	PRJNA1010780	56129	162	1.425197	2.30881914	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	50.4	1.97e-5	NR	MES1916673.1	1215613	g54840	i0	40.8	1.83333333333333	49	29	90.7	0	14	160	85	133	MES1916673.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	297	50.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
30003203	30003203	PRJNA1010780_S_NODE_55371_length_163_cov_2.312500_g54082_i0	PRJNA1010780	55371	163	2.3125	3.769375	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	50.1	3.26e-5	NR	MES1911085.1	1215613	g54082	i0	43.4	0.975460122699387	53	30	97.5	0	159	1	176	228	MES1911085.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	159	50.1	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);;