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

5 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_clade = "Bacteria candidate phyla"

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_genus	tax_species
163141	163141	PRJNA1028258_P_NODE_114381_length_249_cov_1.183333_g113818_i0	PRJNA1028258	114381	249	1.183333	2.94649917	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	259	1.24e-64	NTclustered	gi\|2621703606\|emb\|OY761465.1\|	2838779	g113818	i0	86.008	95.4578313253012	243	32	97	2	8	249	1849042	1848801	MAG: Candidatus Binatia bacterium isolate d3e24e22-6b5b-4867-8422-75782eed2520 genome assembly, chromosome: 1	blastn	23769	259	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia		Candidatus Binatia bacterium
2714105	2714105	PRJNA1028258_P_NODE_142943_length_233_cov_0.865854_g142380_i0	PRJNA1028258	142943	233	0.865854	2.01743982	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	348	2.37e-91	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g142380	i0	93.562	92.6094420600858	233	15	100	0	1	233	634885	634653	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	21578	348	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
12917192	12917192	PRJNA1028258_P_NODE_131131_length_235_cov_1.590361_g130568_i0	PRJNA1028258	131131	235	1.590361	3.73734835	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	171	5.569999999999999e-38	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g130568	i0	81.132	28.5872340425532	212	40	90	0	3	214	97398	97187	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	6718	171	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
15468428	15468428	PRJNA1028258_P_NODE_82593_length_284_cov_0.920930_g82030_i0	PRJNA1028258	82593	284	0.92093	2.6154412	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	161	4.1799999999999995e-35	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g82030	i0	86.486	6.59859154929577	148	19	52	1	1	147	679081	679228	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	1874	161	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium RAAC3_TM7_1
16740746	16740746	PRJNA1028258_P_NODE_150814_length_231_cov_0.876543_g150251_i0	PRJNA1028258	150814	231	0.876543	2.02481433	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	255	1.47e-63	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g150251	i0	86.752	57.6233766233766	234	25	100	6	1	231	799888	799658	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	13311	255	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium

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