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

15 rows where analysis = "blastn", bioproject = "PRJNA939415" 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
915854	915854	PRJNA939415_P_NODE_62401_length_271_cov_2.959596_g61979_i0	PRJNA939415	62401	271	2.959596	8.02050516	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	281	2.91e-71	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g61979	i0	85.662	8.22509225092251	272	33	99	5	1	269	887122	886854	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	2229	281	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
4744602	4744602	PRJNA939415_P_NODE_83824_length_250_cov_3.129944_g83402_i0	PRJNA939415	83824	250	3.129944	7.82486	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	204	5.909999999999999e-48	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g83402	i0	82.203	22.788	236	42	94	0	1	236	51110	51345	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	5697	204	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
5085074	5085074	PRJNA939415_P_NODE_86684_length_248_cov_2.182857_g86262_i0	PRJNA939415	86684	248	2.182857	5.41348536	Bacteria	2	Bacteria	Bacteria	91.6	4.75e-14	NTclustered	gi\|2531946086\|emb\|OY282386.1\|	2026781	g86262	i0	93.443	10.8346774193548	61	4	25	0	1	61	4104730	4104790	MAG: Candidatus Poribacteria bacterium genome assembly, chromosome: 1	blastn	2687	91.6	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
6019387	6019387	PRJNA939415_P_NODE_80045_length_254_cov_1.629834_g79623_i0	PRJNA939415	80045	254	1.629834	4.13977836	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	387	5.569999999999998e-103	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g79623	i0	94.466	122.448818897638	253	10	99	4	4	254	150177	150427	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	31102	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
8569398	8569398	PRJNA939415_P_NODE_94347_length_242_cov_1.461538_g93925_i0	PRJNA939415	94347	242	1.461538	3.53692196	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	398	2.4299999999999994e-106	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g93925	i0	96.281	7.82231404958678	242	9	100	0	1	242	532665	532424	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1893	398	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
13668909	13668909	PRJNA939415_P_NODE_32471_length_310_cov_2.772152_g32049_i0	PRJNA939415	32471	310	2.772152	8.5936712	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g32049	i0	100	71.2258064516129	150	0	97	0	1	150	137585	137734	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	22080	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
13669687	13669687	PRJNA939415_P_NODE_73611_length_260_cov_3.016043_g73189_i0	PRJNA939415	73611	260	3.016043	7.8417118	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	303	5.92e-78	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g73189	i0	91.403	10.8192307692308	221	19	85	0	1	221	888997	888777	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	2813	303	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
17493614	17493614	PRJNA939415_P_NODE_31234_length_310_cov_2.962025_g30812_i0	PRJNA939415	31234	310	2.962025	9.1822775	uncultured Methylomirabilota bacterium	991135	Bacteria	Bacteria	69.4	2.88e-7	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g30812	i0	86.154	16.7612903225806	65	7	21	2	87	150	903576	903513	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	5196	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
18766553	18766553	PRJNA939415_P_NODE_106575_length_222_cov_4.530201_g106153_i0	PRJNA939415	106575	222	4.530201	10.05704622	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	191	4e-44	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g106153	i0	86.782	106.887387387387	174	19	78	3	43	215	956418	956588	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	23729	191	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota					Candidatus Kaiserbacteria bacterium
18768081	18768081	PRJNA939415_P_NODE_87975_length_247_cov_2.229885_g87553_i0	PRJNA939415	87975	247	2.229885	5.50781595	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g87553	i0	98.381	1	247	4	100	0	1	247	431476	431230	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	247	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
20042165	20042165	PRJNA939415_P_NODE_43436_length_290_cov_2.013825_g43014_i0	PRJNA939415	43436	290	2.013825	5.8400925	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	226	1.5e-54	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g43014	i0	85.581	9.8551724137931	215	31	74	0	76	290	339488	339274	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	2858	226	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22591781	22591781	PRJNA939415_P_NODE_10278_length_489_cov_2.521635_g9860_i0	PRJNA939415	10278	489	2.521635	12.33079515	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	898	0	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g9860	i0	99.796	109.114519427403	489	1	100	0	1	489	138594	138106	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	53357	898	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
22592196	22592196	PRJNA939415_P_NODE_26038_length_310_cov_4.864979_g25616_i0	PRJNA939415	26038	310	4.864979	15.0814349	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	459	1.46e-124	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g25616	i0	92.258	1	310	24	100	0	1	310	261743	261434	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	310	459	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
22593290	22593290	PRJNA939415_P_NODE_85498_length_249_cov_1.750000_g85076_i0	PRJNA939415	85498	249	1.75	4.3575	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	58.4	4.84e-4	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g85076	i0	100	0.124497991967871	31	0	12	0	155	185	733949	733979	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	31	58.4	1	Bacteria	Bacteria candidate phyla						Candidatus Dependentiae bacterium Noda2021
25140977	25140977	PRJNA939415_P_NODE_109360_length_209_cov_5.213235_g108938_i0	PRJNA939415	109360	209	5.213235	10.89566115	Candidatus Eiseniibacteriota bacterium	2212470	Bacteria	Bacteria	237	4.71e-58	NTclustered	gi\|2874253817\|emb\|OY969801.1\|	2212470	g108938	i0	89.73	83.3540669856459	185	19	89	0	22	206	2440126	2439942	MAG: Candidatus Eisenbacteria bacterium isolate MFD10007.bin.c.4 genome assembly, chromosome: 1	blastn	17421	237	1	Bacteria	Bacteria candidate phyla	Candidatus Eiseniibacteriota					Candidatus Eiseniibacteriota 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);;