metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA771359" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA771359" 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_order	tax_family	tax_genus	tax_species
747065	747065	PRJNA771359_S_NODE_4481_length_160_cov_2.203252_g4398_i0	PRJNA771359	4481	160	2.203252	3.5252032	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	183	4.5099999999999996e-42	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g4398	i0	87.5	74.45	160	18	100	1	1	160	664849	664692	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	11912	183	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
17784407	17784407	PRJNA771359_S_NODE_654_length_385_cov_11.324713_g571_i0	PRJNA771359	654	385	11.324713	43.60014505	Bacteria	2	Bacteria	Bacteria	353	9e-93	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g571	i0	89.161	79.638961038961	286	28	74	3	1	285	450066	450349	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	30661	353	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
18598785	18598785	PRJNA771359_S_NODE_215_length_625_cov_16.841837_g142_i0	PRJNA771359	215	625	16.841837	105.26148125	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	917	0	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g142	i0	93.131	214.144	626	41	100	2	1	625	667690	667066	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	133840	917	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
19873857	19873857	PRJNA771359_S_NODE_836_length_351_cov_2.391720_g753_i0	PRJNA771359	836	351	2.39172	8.3949372	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	374	6.229999999999998e-99	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g753	i0	90.526	617.068376068376	285	23	81	3	69	351	663320	663038	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	216591	374	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
21608920	21608920	PRJNA771359_S_NODE_377_length_485_cov_3.763393_g299_i0	PRJNA771359	377	485	3.763393	18.25245605	Bacteria	2	Bacteria	Bacteria	774	0	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g299	i0	95.464	160.837113402062	485	22	100	0	1	485	692620	693104	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	78006	774	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
24158397	24158397	PRJNA771359_S_NODE_219_length_618_cov_17.908778_g146_i0	PRJNA771359	219	618	17.908778	110.67624804	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	911	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g146	i0	93.517	101.375404530744	617	33	99	7	3	618	696520	695910	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	62650	917	0.993456924754635	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
24973687	24973687	PRJNA771359_S_NODE_4960_length_153_cov_2.327586_g4877_i0	PRJNA771359	4960	153	2.327586	3.56120658	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	132	1.5600000000000002e-26	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g4877	i0	94.186	70.9738562091503	86	5	56	0	65	150	2261215	2261300	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	10859	132	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
24973696	24973696	PRJNA771359_S_NODE_700_length_373_cov_5.026786_g617_i0	PRJNA771359	700	373	5.026786	18.74991178	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	385	3.08e-102	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g617	i0	92.537	251.512064343164	268	20	72	0	106	373	801140	801407	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	93814	385	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);;