metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA934472" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA934472" 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
2186288	2186288	PRJNA934472_P_NODE_23202_length_304_cov_1.900433_g22824_i0	PRJNA934472	23202	304	1.900433	5.77731632	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g22824	i0	97.674	216.072368421053	301	7	99	0	1	301	139896	140196	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	65686	518	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
3461919	3461919	PRJNA934472_P_NODE_28123_length_279_cov_1.475728_g27745_i0	PRJNA934472	28123	279	1.475728	4.11728112	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	110	1.5e-19	NTclustered	gi\|1958074337\|gb\|CP064994.1\|	2045217	g27745	i0	91.25	64.6236559139785	80	7	29	0	200	279	427901	427822	MAG: Candidatus Moraniibacteriota bacterium isolate Hirt_18-Q3-R61-65_MAXAC.378_cln chromosome, complete genome	blastn	18030	110	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
6359616	6359616	PRJNA934472_P_NODE_36385_length_248_cov_0.880000_g36007_i0	PRJNA934472	36385	248	0.88	2.1824	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	420	5.34e-113	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g36007	i0	97.177	38.1491935483871	248	7	100	0	1	248	431959	431712	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	9461	420	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
12390391	12390391	PRJNA934472_P_NODE_38210_length_243_cov_0.905882_g37832_i0	PRJNA934472	38210	243	0.905882	2.20129326	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	416	6.739999999999998e-112	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g37832	i0	97.531	108.543209876543	243	6	100	0	1	243	112220	112462	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	26376	416	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
12735032	12735032	PRJNA934472_P_NODE_7830_length_503_cov_1.637209_g7511_i0	PRJNA934472	7830	503	1.637209	8.23516127	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	682	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g7511	i0	91.287	76.8369781312127	505	36	100	8	1	503	695983	696481	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	38649	686	0.994169096209913	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
13664757	13664757	PRJNA934472_P_NODE_35131_length_251_cov_1.460674_g34753_i0	PRJNA934472	35131	251	1.460674	3.66629174	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	381	2.549999999999999e-101	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g34753	i0	95.041	117.908366533865	242	12	96	0	10	251	850728	850487	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	29595	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
13664767	13664767	PRJNA934472_P_NODE_35531_length_250_cov_1.305085_g35153_i0	PRJNA934472	35531	250	1.305085	3.2627125	uncultured Candidatus Binatia bacterium	3036252	Bacteria	Bacteria	289	1.59e-73	NTclustered	gi\|2546137839\|emb\|OY282432.1\|	3036252	g35153	i0	87.698	51.124	252	25	99	3	1	248	2262761	2262512	MAG: uncultured Candidatus Binatia bacterium isolate 81991fb1-66cf-4eb3-b653-309a223604dd genome assembly, chromosome: 1	blastn	12781	289	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				uncultured Candidatus Binatia bacterium
13664811	13664811	PRJNA934472_P_NODE_37511_length_245_cov_0.784884_g37133_i0	PRJNA934472	37511	245	0.784884	1.9229658	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	396	8.869999999999996e-106	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g37133	i0	95.918	124.881632653061	245	9	100	1	1	245	884190	883947	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	30596	396	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
17489577	17489577	PRJNA934472_P_NODE_4194_length_664_cov_4.201354_g3894_i0	PRJNA934472	4194	664	4.201354	27.89699056	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	455	4.31e-123	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g3894	i0	79.259	105.579819277108	675	123	100	13	1	664	4746100	4745432	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	70105	455	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
22588011	22588011	PRJNA934472_P_NODE_28998_length_275_cov_1.371287_g28620_i0	PRJNA934472	28998	275	1.371287	3.77103925	Candidatus Saccharibacteria genomosp. TM7-H1	2080739	Bacteria	Bacteria	364	2.859999999999999e-96	NTclustered	gi\|1566427536\|gb\|CP026537.1\|	2080739	g28620	i0	90.545	104.301818181818	275	26	100	0	1	275	542665	542939	Candidatus Saccharibacteria genomosp. TM7-H1 isolate E1 chromosome	blastn	28683	364	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria genomosp. TM7-H1

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