metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA667863" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA667863" 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
634136	634136	PRJNA667863_P_NODE_3621_length_331_cov_7.050388_g3587_i0	PRJNA667863	3621	331	7.050388	23.33678428	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	446	1.22e-120	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g3587	i0	90.937	77.1812688821752	331	30	100	0	1	331	523	193	Lecythium sp. 3678_261K actin gene, partial cds	blastn	25547	446	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
9562524	9562524	PRJNA667863_P_NODE_5948_length_288_cov_2.339535_g5914_i0	PRJNA667863	5948	288	2.339535	6.7378608	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	339	1.83e-88	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g5914	i0	87.847	95.1597222222222	288	35	100	0	1	288	285	572	Lecythium sp. 3678_261K actin gene, partial cds	blastn	27406	339	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
14662981	14662981	PRJNA667863_P_NODE_3692_length_330_cov_1.311284_g3658_i0	PRJNA667863	3692	330	1.311284	4.3272372	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	344	4.58e-90	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g3658	i0	85.672	63.5727272727273	335	38	100	10	1	330	3665	3994	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	20979	344	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
23586597	23586597	PRJNA667863_P_NODE_10299_length_256_cov_1.535519_g10265_i0	PRJNA667863	10299	256	1.535519	3.93092864	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	351	2.05e-92	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g10265	i0	91.406	29.0234375	256	22	100	0	1	256	630	375	Lecythium sp. 3678_261K actin gene, partial cds	blastn	7430	351	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
24860210	24860210	PRJNA667863_P_NODE_2120_length_388_cov_8.146032_g2086_i0	PRJNA667863	2120	388	8.146032	31.60660416	Thaumatomonas seravini	188939	SAR_Eukaryotes	SAR_Eukaryotes	294	5.58e-75	NTclustered	gi\|160337323\|gb\|EF455755.1\|	188939	g2086	i0	80.84	94.1572164948454	381	67	97	6	1	378	355	732	Thaumatomonas seravini actin gene, partial cds	blastn	36533	294	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas seravini

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