metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
402615	402615	PRJNA382357_P_NODE_121421_length_222_cov_1.211180_g120682_i0	PRJNA382357	121421	222	1.21118	2.6888196	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	193	1.11e-44	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g120682	i0	83.824	41.6756756756757	204	32	92	1	1	204	913840	913638	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	9252	193	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
1677196	1677196	PRJNA382357_P_NODE_11022_length_633_cov_1.477273_g10313_i0	PRJNA382357	11022	633	1.477273	9.35113809	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	745	0	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g10313	i0	88.088	637.928909952607	638	62	100	11	1	633	160856	161484	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	403809	745	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
1677746	1677746	PRJNA382357_P_NODE_147302_length_205_cov_3.861111_g146563_i0	PRJNA382357	147302	205	3.861111	7.91527755	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	78.7	2.95e-10	NTclustered	gi\|2874253997\|emb\|OY970322.1\|	179883	g146563	i0	88.235	2.31219512195122	68	4	63	3	1	66	770718	770783	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05512.bin.c.2 genome assembly, chromosome: 1	blastn	474	78.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
1678119	1678119	PRJNA382357_P_NODE_170162_length_171_cov_13.609091_g169423_i0	PRJNA382357	170162	171	13.609091	23.27154561	Candidatus Peribacter riflensis	1735162	Bacteria	Bacteria	87.9	3.93e-13	NTclustered	gi\|946529367\|gb\|CP013062.1\|	1735162	g169423	i0	94.643	41.2222222222222	56	3	33	0	116	171	1194302	1194247	MAG: Candidatus Peribacter riflensis, complete genome	blastn	7049	87.9	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacterales		Candidatus Peribacter	Candidatus Peribacter riflensis
1679399	1679399	PRJNA382357_P_NODE_8922_length_689_cov_9.046178_g8234_i0	PRJNA382357	8922	689	9.046178	62.32816642	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2621704339\|emb\|OY760935.1\|	2044595	g8234	i0	100	1.26124818577649	31	0	4	0	375	405	820253	820223	MAG: Candidatus Gracilibacteria bacterium isolate 3c0776cb-dd52-49a3-965b-30fb91b92491 genome assembly, chromosome: 1	blastn	869	58.4	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
2349606	2349606	PRJNA382357_P_NODE_100322_length_242_cov_1.077348_g99583_i0	PRJNA382357	100322	242	1.077348	2.60718216	Bacteria	2	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g99583	i0	94.583	497.239669421488	240	12	99	1	3	242	851011	850773	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	120332	372	0.99462365591397806	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
5508203	5508203	PRJNA382357_P_NODE_84325_length_261_cov_1.240000_g83586_i0	PRJNA382357	84325	261	1.24	3.2364	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	145	3.8199999999999995e-30	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g83586	i0	83.125	0.613026819923372	160	25	61	2	11	169	132090	132248	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	160	145	1	Bacteria	Bacteria candidate phyla						Candidatus Dependentiae bacterium Noda2021
8056194	8056194	PRJNA382357_P_NODE_145807_length_206_cov_1.200000_g145068_i0	PRJNA382357	145807	206	1.2	2.472	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	202	1.6899999999999999e-47	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g145068	i0	91.781	1.02912621359223	146	10	100	2	1	144	718464	718319	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	212	202	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
8057596	8057596	PRJNA382357_P_NODE_74087_length_276_cov_1.837209_g73348_i0	PRJNA382357	74087	276	1.837209	5.07069684	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	159	1.4499999999999999e-34	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g73348	i0	86.275	2.21376811594203	153	14	54	7	110	258	741096	741245	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	611	159	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
9332591	9332591	PRJNA382357_P_NODE_84648_length_260_cov_4.512563_g83909_i0	PRJNA382357	84648	260	4.512563	11.7326638	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	84.2	8.4e-12	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g83909	i0	83.516	0.35	91	13	35	2	137	226	321517	321606	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	91	84.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14433169	14433169	PRJNA382357_P_NODE_77312_length_271_cov_1.319048_g76573_i0	PRJNA382357	77312	271	1.319048	3.57462008	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	78.7	4.1e-10	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g76573	i0	100	0.623616236162362	42	0	25	0	226	267	703128	703169	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	169	78.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
16980481	16980481	PRJNA382357_P_NODE_158514_length_198_cov_2.686131_g157775_i0	PRJNA382357	158514	198	2.686131	5.31853938	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	139	1.2799999999999999e-28	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g157775	i0	89.815	23.0858585858586	108	11	55	0	1	108	598617	598724	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	4571	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
16981242	16981242	PRJNA382357_P_NODE_4694_length_904_cov_6.502966_g4089_i0	PRJNA382357	4694	904	6.502966	58.78681264	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	785	0	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g4089	i0	89.1	2.88716814159292	633	68	99	1	239	870	547008	547640	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	2610	785	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
18254349	18254349	PRJNA382357_P_NODE_13015_length_589_cov_5.723485_g12294_i0	PRJNA382357	13015	589	5.723485	33.71132665	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	363	2.37e-95	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g12294	i0	83.168	36.2563667232598	404	60	99	8	1	399	161797	162197	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	21355	363	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
18255639	18255639	PRJNA382357_P_NODE_60755_length_301_cov_1.625000_g60016_i0	PRJNA382357	60755	301	1.625	4.89125	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	102	2.74e-17	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g60016	i0	98.276	0.568106312292359	58	1	19	0	244	301	748075	748018	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	171	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18255676	18255676	PRJNA382357_P_NODE_6255_length_801_cov_2.091892_g5608_i0	PRJNA382357	6255	801	2.091892	16.75605492	Candidatus Absconditicoccus praedator	2735562	Bacteria	Bacteria	350	2.55e-91	NTclustered	gi\|2160621446\|gb\|CP054059.1\|	2735562	g5608	i0	81.776	75.0711610486891	428	68	53	8	374	796	728945	728523	Candidatus Absconditicoccus praedator strain M39-6 chromosome, complete genome	blastn	60132	350	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		Candidatus Absconditabacterales	Candidatus Absconditicoccaceae	Candidatus Absconditicoccus	Candidatus Absconditicoccus praedator
19530329	19530329	PRJNA382357_P_NODE_82816_length_263_cov_1.509901_g82077_i0	PRJNA382357	82816	263	1.509901	3.97103963	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	86.1	2.37e-12	NTclustered	gi\|1805658607\|gb\|CP047918.1\|	2572087	g82077	i0	82.474	0.847908745247148	97	17	37	0	1	97	771365	771269	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS14P chromosome, complete genome	blastn	223	86.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
22078971	22078971	PRJNA382357_P_NODE_111318_length_231_cov_1.182353_g110579_i0	PRJNA382357	111318	231	1.182353	2.73123543	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2621703383\|emb\|OY762492.1\|	2026781	g110579	i0	100	0.125541125541126	29	0	13	0	119	147	3149910	3149938	MAG: Candidatus Poribacteria bacterium isolate 99769213-57d3-4dda-a27c-563ac69bc0fb genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
23356572	23356572	PRJNA382357_P_NODE_82479_length_263_cov_7.594059_g81740_i0	PRJNA382357	82479	263	7.594059	19.97237517	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	287	6.05e-73	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g81740	i0	94.149	291.456273764259	188	11	71	0	35	222	221023	220836	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	76653	287	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
24628626	24628626	PRJNA382357_P_NODE_10260_length_651_cov_5.188136_g9558_i0	PRJNA382357	10260	651	5.188136	33.77476536	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	355	4.41e-93	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g9558	i0	80.81	95.4070660522273	469	76	94	11	25	486	160503	160964	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	62110	355	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans

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