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

5 rows where analysis = "blastn", bioproject = "PRJNA966993" 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
8595107	8595107	PRJNA966993_P_NODE_35547_length_359_cov_2.006993_g35095_i0	PRJNA966993	35547	359	2.006993	7.20510487	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	235	3.1499999999999996e-57	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g35095	i0	80.793	28.3649025069638	328	39	91	17	1	325	3733	4039	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	10183	235	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
11145714	11145714	PRJNA966993_P_NODE_32009_length_376_cov_2.495050_g31557_i0	PRJNA966993	32009	376	2.49505	9.381388	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	625	1.6799999999999998e-174	NTclustered	gi\|238617602\|gb\|FJ973377.1\|	188950	g31557	i0	96.561	24.5212765957447	378	11	100	2	1	376	469	846	Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence	blastn	9220	625	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
12421443	12421443	PRJNA966993_P_NODE_62970_length_280_cov_2.082126_g62518_i0	PRJNA966993	62970	280	2.082126	5.8299528	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	457	4.6799999999999996e-124	NTclustered	gi\|302026154\|gb\|GQ377660.1\|	188950	g62518	i0	96.071	28.6571428571429	280	11	100	0	1	280	190	469	Bodomorpha minima beta-tubulin (Btub) gene, partial cds	blastn	8024	457	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
23894576	23894576	PRJNA966993_P_NODE_32179_length_375_cov_3.341060_g31727_i0	PRJNA966993	32179	375	3.34106	12.528975	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	638	2.15e-178	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g31727	i0	97.333	99.4666666666667	375	10	100	0	1	375	589	215	Lecythium sp. 3678_261K actin gene, partial cds	blastn	37300	638	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K
25168316	25168316	PRJNA966993_P_NODE_43120_length_329_cov_0.890625_g42668_i0	PRJNA966993	43120	329	0.890625	2.93015625	Lecythium sp. 3678_261K	238773	SAR_Eukaryotes	SAR_Eukaryotes	331	3.55e-86	NTclustered	gi\|33089893\|gb\|AY283756.1\|	238773	g42668	i0	96.059	71.0030395136778	203	8	62	0	126	328	765	563	Lecythium sp. 3678_261K actin gene, partial cds	blastn	23360	331	1	Eukaryota	Sar	Cercozoa	Thecofilosea	Tectofilosida	Chlamydophryidae	Lecythium	Lecythium sp. 3678_261K

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