metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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
168870	168870	PRJNA1035005_P_NODE_46921_length_261_cov_1.207447_g46515_i0	PRJNA1035005	46921	261	1.207447	3.15143667	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.55e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g46515	i0	98.092	197.145593869732	262	4	100	1	1	261	136656	136917	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	51455	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
169069	169069	PRJNA1035005_P_NODE_71661_length_247_cov_0.896552_g71255_i0	PRJNA1035005	71661	247	0.896552	2.21448344	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	451	1.88e-122	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g71255	i0	99.595	1.34412955465587	247	1	100	0	1	247	940042	940288	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	332	451	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
2719496	2719496	PRJNA1035005_P_NODE_71323_length_247_cov_0.896552_g70917_i0	PRJNA1035005	71323	247	0.896552	2.21448344	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	224	4.469999999999999e-54	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g70917	i0	84.188	5.8582995951417	234	33	94	4	1	232	126002	125771	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1447	224	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
2719624	2719624	PRJNA1035005_P_NODE_88003_length_234_cov_5.242236_g87597_i0	PRJNA1035005	88003	234	5.242236	12.26683224	Candidatus Ozemobacteraceae bacterium	2818468	Bacteria	Bacteria	231	2.5099999999999996e-56	NTclustered	gi\|2907625676\|emb\|OZ223236.1\|	2818468	g87597	i0	84.615	29.6666666666667	234	35	99	1	2	234	2304247	2304480	MAG: Candidatus Ozemobacteraceae bacterium isolate 4ee0fdf2-fbb4-4151-bfa0-813162405533 genome assembly, chromosome: 2	blastn	6942	231	1	Bacteria	Bacteria candidate phyla		Candidatus Ozemobacteria		Candidatus Ozemobacteraceae		Candidatus Ozemobacteraceae bacterium
3995497	3995497	PRJNA1035005_P_NODE_59164_length_251_cov_0.876404_g58758_i0	PRJNA1035005	59164	251	0.876404	2.19977404	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g58758	i0	98.406	3	251	4	100	0	1	251	668339	668089	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	753	442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
5271594	5271594	PRJNA1035005_P_NODE_27945_length_285_cov_1.471698_g27539_i0	PRJNA1035005	27945	285	1.471698	4.1943393	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	449	7.99e-122	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g27539	i0	95.088	9.00350877192983	285	14	100	0	1	285	22183	22467	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	2566	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
5271863	5271863	PRJNA1035005_P_NODE_64065_length_249_cov_1.744318_g63659_i0	PRJNA1035005	64065	249	1.744318	4.34335182	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	316	7.239999999999998e-82	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g63659	i0	89.558	330.710843373494	249	26	100	0	1	249	885450	885202	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	82347	316	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
9096335	9096335	PRJNA1035005_P_NODE_26508_length_287_cov_1.457944_g26102_i0	PRJNA1035005	26508	287	1.457944	4.18429928	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	503	6.1e-138	NTclustered	gi\|2218410560\|gb\|CP089288.1\|	2899133	g26102	i0	98.258	15.9721254355401	287	5	100	0	1	287	185224	185510	Candidatus Nanosynbacter sp. HMT-352 strain TM7-037 chromosome	blastn	4584	503	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
15471602	15471602	PRJNA1035005_P_NODE_25993_length_288_cov_1.260465_g25587_i0	PRJNA1035005	25993	288	1.260465	3.6301392	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	296	1.11e-75	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g25587	i0	86.282	384.881944444444	277	33	95	5	1	274	162259	161985	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	110846	296	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
16745655	16745655	PRJNA1035005_P_NODE_18174_length_309_cov_0.974576_g17768_i0	PRJNA1035005	18174	309	0.974576	3.01143984	Candidatus Minimicrobia sp. QA0096	3118470	Bacteria	Bacteria	361	4.219999999999999e-95	NTclustered	gi\|2686255593\|emb\|OZ017288.1\|	3118470	g17768	i0	91.892	12.1488673139159	259	19	83	2	50	306	99795	100053	Candidatus Minimicrobia sp. QA0096 genome assembly, chromosome: contig00001	blastn	3754	361	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia sp. QA0096
19294490	19294490	PRJNA1035005_P_NODE_20336_length_299_cov_1.380531_g19930_i0	PRJNA1035005	20336	299	1.380531	4.12778769	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	381	3.119999999999999e-101	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g19930	i0	89.865	10.7993311036789	296	30	99	0	1	296	370900	371195	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	3229	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
20570128	20570128	PRJNA1035005_P_NODE_56577_length_252_cov_0.871508_g56171_i0	PRJNA1035005	56577	252	0.871508	2.19620016	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	383	7.13e-102	NTclustered	gi\|2218409810\|gb\|CP089289.1\|	2899133	g56171	i0	94.048	12.4444444444444	252	15	100	0	1	252	421026	421277	Candidatus Nanosynbacter sp. HMT-352 strain TM7-072 chromosome	blastn	3136	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
20570333	20570333	PRJNA1035005_P_NODE_83517_length_243_cov_0.917647_g83111_i0	PRJNA1035005	83517	243	0.917647	2.22988221	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	191	4.45e-44	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g83111	i0	95.763	22.8395061728395	118	5	49	0	126	243	82263	82146	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	5550	191	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
21409978	21409978	PRJNA1035005_P_NODE_75637_length_245_cov_1.447674_g75231_i0	PRJNA1035005	75637	245	1.447674	3.5468013	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	348	2.5200000000000005e-91	NTclustered	gi\|2218409810\|gb\|CP089289.1\|	2899133	g75231	i0	92.245	7.99591836734694	245	19	100	0	1	245	433056	433300	Candidatus Nanosynbacter sp. HMT-352 strain TM7-072 chromosome	blastn	1959	348	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
22684794	22684794	PRJNA1035005_P_NODE_7358_length_402_cov_2.158055_g6956_i0	PRJNA1035005	7358	402	2.158055	8.6753811	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	649	0	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g6956	i0	95.771	6.76865671641791	402	17	100	0	1	402	331738	331337	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	2721	654	0.992354740061162	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);;