metadata: contig_metadata: 9 rows where bioproject = "PRJNA312107", tax_clade = "Sar" and tax

9 rows where bioproject = "PRJNA312107", 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
4204761	4204761	PRJNA312107_P_NODE_18744_length_169_cov_0.866667_g18578_i0	PRJNA312107	18744	169	0.866667	1.46466723	Cercomonas sp. HFCC52	458866	SAR_Eukaryotes	SAR_Eukaryotes	307	2.73e-79	NTclustered	gi\|197723527\|gb\|EF681908.2\|	458866	g18578	i0	99.408	46.2130177514793	169	1	100	0	1	169	732	564	Cercomonas sp. HFCC52 28S ribosomal RNA gene, partial sequence	blastn	7810	307	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC52
5481129	5481129	PRJNA312107_P_NODE_2645_length_427_cov_7.962963_g2479_i0	PRJNA312107	2645	427	7.962963	34.00185201	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	287	1.04e-72	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g2479	i0	93.75	43.2435597189696	192	11	45	1	237	427	3856	3665	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	18465	287	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
6755206	6755206	PRJNA312107_P_NODE_13046_length_202_cov_1.444444_g12880_i0	PRJNA312107	13046	202	1.444444	2.91777688	Trachelocorythion pulchellum	178364	SAR_Eukaryotes	SAR_Eukaryotes	270	4.4599999999999985e-68	NTclustered	gi\|83034982\|gb\|DQ211611.1\|	178364	g12880	i0	91.457	98.6039603960396	199	14	98	3	1	197	331	528	Trachelocorythion pulchellum 28S ribosomal RNA gene, partial sequence	blastn	19918	270	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Sphenoderiidae	Trachelocorythion	Trachelocorythion pulchellum
9305568	9305568	PRJNA312107_P_NODE_10248_length_225_cov_3.409091_g10082_i0	PRJNA312107	10248	225	3.409091	7.67045475	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	243	1.11e-59	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g10082	i0	87.5	59.7066666666667	216	20	96	6	10	225	3916	3708	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	13434	243	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
14406460	14406460	PRJNA312107_P_NODE_10572_length_222_cov_1.809249_g10406_i0	PRJNA312107	10572	222	1.809249	4.01653278	Cercomonas sp.	1979794	SAR_Eukaryotes	SAR_Eukaryotes	344	2.9e-90	NTclustered	gi\|2651357801\|gb\|PP174314.1\|	1979794	g10406	i0	94.595	81.6531531531532	222	12	100	0	1	222	4225	4004	Cercomonas sp. isolate P5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	18127	344	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp.
14406508	14406508	PRJNA312107_P_NODE_19472_length_168_cov_1.310924_g19306_i0	PRJNA312107	19472	168	1.310924	2.20235232	Protaspis grandis	361427	SAR_Eukaryotes	SAR_Eukaryotes	217	4.73e-52	NTclustered	gi\|290760486\|gb\|GQ144689.1\|	361427	g19306	i0	89.881	95.8392857142857	168	17	100	0	1	168	1918	1751	Protaspis grandis large subunit ribosomal RNA gene, partial sequence	blastn	16101	217	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Protaspis	Protaspis grandis
20779142	20779142	PRJNA312107_P_NODE_22277_length_165_cov_6.336207_g22111_i0	PRJNA312107	22277	165	6.336207	10.45474155	Placocista sp. CC-Grouse Mountain	741089	SAR_Eukaryotes	SAR_Eukaryotes	239	9.87e-59	NTclustered	gi\|290760485\|gb\|GQ144688.1\|	741089	g22111	i0	92.727	100.369696969697	165	12	100	0	1	165	1458	1622	Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence	blastn	16561	239	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Placocista	Placocista sp. CC-Grouse Mountain
24603654	24603654	PRJNA312107_P_NODE_2140_length_474_cov_7.665882_g1974_i0	PRJNA312107	2140	474	7.665882	36.33628068	Placocista sp. CC-Grouse Mountain	741089	SAR_Eukaryotes	SAR_Eukaryotes	688	0	NTclustered	gi\|290760485\|gb\|GQ144688.1\|	741089	g1974	i0	92.917	99.9725738396624	480	22	99	8	3	474	1604	2079	Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence	blastn	47387	688	1	Eukaryota	Sar	Cercozoa	Imbricatea	Euglyphida	Euglyphidae	Placocista	Placocista sp. CC-Grouse Mountain
25289766	25289766	PRJNA312107_P_NODE_5000_length_316_cov_1.445693_g4834_i0	PRJNA312107	5000	316	1.445693	4.56838988	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	479	1.1499999999999999e-130	NTclustered	gi\|319659368\|gb\|GU320605.1\|	943207	g4834	i0	94.268	95.9145569620253	314	16	99	2	1	313	1508	1820	Reticulamoeba sp. COHH 9 18S ribosomal RNA gene, partial sequence	blastn	30309	481	0.995841995841996	Eukaryota	Sar	Cercozoa				Reticulamoeba	Reticulamoeba sp. COHH 9

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