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

5 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
1430620	1430620	PRJNA1011844_P_NODE_118122_length_286_cov_3.262911_g109546_i0	PRJNA1011844	118122	286	3.262911	9.33192546	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	239	1.89e-58	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g109546	i0	83.577	18.2692307692308	274	25	94	11	11	280	3750	4007	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	5225	239	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
2706233	2706233	PRJNA1011844_P_NODE_125503_length_275_cov_6.519802_g116925_i0	PRJNA1011844	125503	275	6.519802	17.9294555	uncultured Cercozoa	175275	SAR_Eukaryotes	SAR_Eukaryotes	483	7.559999999999998e-132	NTclustered	gi\|48727806\|gb\|AY620296.1\|	175275	g116925	i0	99.251	95.6472727272727	267	2	97	0	8	274	106	372	Uncultured cercozoan clone 13-1.8 small subunit ribosomal RNA gene, partial sequence	blastn	26303	483	1	Eukaryota	Sar	Cercozoa					uncultured Cercozoa
19281879	19281879	PRJNA1011844_P_NODE_154576_length_245_cov_1.720930_g145996_i0	PRJNA1011844	154576	245	1.72093	4.2162785	Heteromita globosa	45107	SAR_Eukaryotes	SAR_Eukaryotes	333	7.049999999999999e-87	NTclustered	gi\|238617605\|gb\|FJ973380.1\|	45107	g145996	i0	91.983	93.4408163265306	237	19	97	0	6	242	1603	1367	Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence	blastn	22893	333	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita globosa
23108308	23108308	PRJNA1011844_P_NODE_129139_length_271_cov_0.984848_g120561_i0	PRJNA1011844	129139	271	0.984848	2.66893808	Cercomonas sp. HFCC574	458880	SAR_Eukaryotes	SAR_Eukaryotes	355	1.69e-93	NTclustered	gi\|161015720\|gb\|EF681954.1\|	458880	g120561	i0	91.538	13.5719557195572	260	19	95	2	13	269	311	570	Cercomonas sp. HFCC574 28S ribosomal RNA gene, partial sequence	blastn	3678	355	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC574
24381806	24381806	PRJNA1011844_P_NODE_110040_length_302_cov_5.567686_g101465_i0	PRJNA1011844	110040	302	5.567686	16.81441172	Paracercomonas sp.	1979800	SAR_Eukaryotes	SAR_Eukaryotes	527	3.8299999999999985e-145	NTclustered	gi\|1326162414\|gb\|MG775634.1\|	1979800	g101465	i0	100	92.6788079470199	285	0	94	0	8	292	1014	730	Paracercomonas sp. strain SF61_P_Poa small subunit ribosomal RNA gene, partial sequence	blastn	27989	527	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Paracercomonas	Paracercomonas sp.

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