metadata: contig_metadata: 21 rows where bioproject = "PRJEB6054" and tax

21 rows where bioproject = "PRJEB6054" and tax_phylum = "Bacillota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
25659127	25659127	PRJEB6054_S_NODE_6666_length_201_cov_76658.716867_g6577_i0	PRJEB6054	6666	201	76658.716867	154084.02090267	Anaerococcus nagyae	1755241	Bacteria	Bacteria	235	1.62e-57	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g6577	i0	98.496	59.4129353233831	133	2	66	0	1	133	121195	121327	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	11942	235	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
25751791	25751791	PRJEB6054_S_NODE_10594_length_173_cov_2.550725_g10505_i0	PRJEB6054	10594	173	2.550725	4.41275425	Thomasclavelia	3025755	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2099439025\|gb\|CP083622.1\|	1547	g10505	i0	100	1.45664739884393	28	0	16	0	40	67	1492628	1492655	Thomasclavelia ramosa strain FDAARGOS_1519 chromosome, complete genome	blastn	252	52.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Coprobacillaceae	Thomasclavelia	Thomasclavelia ramosa
25751898	25751898	PRJEB6054_S_NODE_6586_length_202_cov_75868.167665_g6497_i0	PRJEB6054	6586	202	75868.167665	153253.6986833	Leuconostoc	1243	Bacteria	Bacteria	241	3.5e-59	NTclustered	gi\|2531778937\|gb\|OR234663.1\|	1245	g6497	i0	100	64.3564356435644	130	0	64	0	73	202	448	319	Leuconostoc mesenteroides strain M1L5 16S ribosomal RNA gene, partial sequence	blastn	13000	241	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
25751907	25751907	PRJEB6054_S_NODE_794_length_403_cov_35877.758152_g707_i0	PRJEB6054	794	403	35877.758152	144587.36535256	Streptococcus	1301	Bacteria	Bacteria	575	1.8499999999999994e-159	NTclustered	gi\|1948677368\|gb\|CP066059.1\|	1303	g707	i0	99.682	264.124069478908	314	1	78	0	74	387	951384	951697	Streptococcus oralis strain FDAARGOS_1021 chromosome, complete genome	blastn	106442	580	0.991379310344828	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
25795188	25795188	PRJEB6054_S_NODE_7147_length_197_cov_1.697531_g7058_i0	PRJEB6054	7147	197	1.697531	3.34413607	uncultured Acetobacterium sp.	217139	Bacteria	Bacteria	58.4	3.67e-4	NTclustered	gi\|2907625634\|emb\|OZ223194.1\|	217139	g7058	i0	97.059	0.17258883248731	34	1	17	0	4	37	1102498	1102531	MAG: uncultured Acetobacterium sp. isolate 6abcf8f7-2dc5-46ce-9e35-983ba889e1c3 genome assembly, chromosome: 4	blastn	34	58.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Acetobacterium	uncultured Acetobacterium sp.
25887571	25887571	PRJEB6054_S_NODE_1315_length_348_cov_4.293930_g1226_i0	PRJEB6054	1315	348	4.29393	14.9428764	Leuconostoc	1243	Bacteria	Bacteria	547	3.4499999999999984e-151	NTclustered	gi\|1799531339\|gb\|CP028255.1\|	1245	g1226	i0	100	300.252873563218	296	0	85	0	53	348	68046	67751	Leuconostoc mesenteroides strain SRCM102735 chromosome, complete genome	blastn	104488	547	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
25887653	25887653	PRJEB6054_S_NODE_5899_length_211_cov_72812.630682_g5810_i0	PRJEB6054	5899	211	72812.630682	153634.65073902	Leuconostoc	1243	Bacteria	Bacteria	257	3.66e-64	NTclustered	gi\|1721205965\|gb\|CP042420.1\|	1246	g5810	i0	100	228.327014218009	139	0	66	0	1	139	450556	450418	Leuconostoc lactis strain CBA3622 chromosome, complete genome	blastn	48177	257	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc lactis
25887671	25887671	PRJEB6054_S_NODE_795_length_403_cov_35876.394022_g708_i0	PRJEB6054	795	403	35876.394022	144581.86790866	Streptococcus	1301	Bacteria	Bacteria	564	4.009999999999999e-156	NTclustered	gi\|470489451\|ref\|NR_076930.1\|	1318	g708	i0	99.045	448.285359801489	314	3	78	0	74	387	316	3	Streptococcus parasanguinis strain FW213 23S ribosomal RNA gene, complete sequence	blastn	180659	564	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parasanguinis
26023870	26023870	PRJEB6054_S_NODE_2172_length_297_cov_6.923664_g2083_i0	PRJEB6054	2172	297	6.923664	20.56328208	Staphylococcus	1279	Bacteria	Bacteria	508	1.36e-139	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g2083	i0	99.288	520.851851851852	281	2	95	0	17	297	748412	748692	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	154693	508	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
26023884	26023884	PRJEB6054_S_NODE_3420_length_253_cov_22.188073_g3331_i0	PRJEB6054	3420	253	22.188073	56.13582469	Leuconostoc	1243	Bacteria	Bacteria	427	3.26e-115	NTclustered	gi\|2623580878\|gb\|CP137625.1\|	1245	g3331	i0	99.573	321.628458498024	234	1	92	0	18	251	24477	24710	Leuconostoc mesenteroides strain FFL48 chromosome, complete genome	blastn	81372	431	0.990719257540603	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
26160122	26160122	PRJEB6054_S_NODE_549_length_448_cov_3.646489_g471_i0	PRJEB6054	549	448	3.646489	16.33627072	Streptococcus	1301	Bacteria	Bacteria	645	1.5599999999999995e-180	NTclustered	gi\|2190833561\|gb\|CP035238.1\|	1313	g471	i0	93.735	307.792410714286	431	25	96	2	1	429	17691	18121	Streptococcus pneumoniae strain TVO_D39 chromosome, complete genome	blastn	137891	645	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
26339388	26339388	PRJEB6054_S_NODE_2983_length_266_cov_3.606061_g2894_i0	PRJEB6054	2983	266	3.606061	9.59212226	Neobacillus sp. Marseille-Q6967	2963105	Bacteria	Bacteria	145	3.9e-30	NTclustered	gi\|2290158417\|emb\|OX267715.1\|	2963105	g2894	i0	81.818	773.109022556391	176	28	65	4	94	266	781611	781437	Neobacillus sp. Marseille-Q6967 genome assembly, chromosome: contig00001	blastn	205647	145	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Neobacillus	Neobacillus sp. Marseille-Q6967
26339605	26339605	PRJEB6054_S_NODE_9703_length_179_cov_2.694444_g9614_i0	PRJEB6054	9703	179	2.694444	4.82305476	Exiguobacterium sp. 9-2	3112419	Bacteria	Bacteria	183	5.15e-42	NTclustered	gi\|2663195100\|gb\|CP142850.1\|	3112419	g9614	i0	85.475	595.810055865922	179	22	100	2	1	179	32210	32384	Exiguobacterium sp. 9-2 chromosome, complete genome	blastn	106650	183	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium sp. 9-2
26431743	26431743	PRJEB6054_S_NODE_15935_length_150_cov_1.495652_g15846_i0	PRJEB6054	15935	150	1.495652	2.243478	root	1	Root_unresolved	Root_unresolved	217	4.089999999999999e-52	NTclustered	gi\|1799531339\|gb\|CP028255.1\|	1245	g15846	i0	100	433.113333333333	117	0	78	0	1	117	70010	70126	Leuconostoc mesenteroides strain SRCM102735 chromosome, complete genome	blastn	64967	217	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Leuconostoc	Leuconostoc mesenteroides
26431814	26431814	PRJEB6054_S_NODE_5807_length_213_cov_3.112360_g5718_i0	PRJEB6054	5807	213	3.11236	6.6293268	Bacteria	2	Bacteria	Bacteria	67.6	6.69e-7	NTclustered	gi\|1858325381\|gb\|CP054612.1\|	375489	g5718	i0	90.196	10.7417840375587	51	5	24	0	1	51	318284	318234	Paenibacillus cellulosilyticus strain KACC 14175 chromosome, complete genome	blastn	2288	67.6	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus cellulosilyticus
26475789	26475789	PRJEB6054_S_NODE_5776_length_213_cov_2092.073034_g5687_i0	PRJEB6054	5776	213	2092.073034	4456.11556242	Aerococcus viridans	1377	Bacteria	Bacteria	228	2.8999999999999996e-55	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g5687	i0	92.5	413.211267605634	160	10	75	2	55	213	25615	25773	Aerococcus viridans strain CCUG4311, complete genome	blastn	88014	228	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
26567790	26567790	PRJEB6054_S_NODE_14128_length_156_cov_2.115702_g14039_i0	PRJEB6054	14128	156	2.115702	3.30049512	Bacillati	1783272	Bacteria	Bacteria	276	7e-70	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g14039	i0	100	510.685897435897	149	0	96	0	1	149	751182	751330	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	79667	276	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
32911639	32911639	PRJEB6054_S_NODE_12969_length_161_cov_1.309524_g12880_i0	PRJEB6054	12969	161	1.309524	2.10833364	uncultured Clostridium sp.	59620	Bacteria	Bacteria	98.6	3.29e-24	NR	WP_297636592.1	59620	g12880	i0	88.7	1.97515527950311	53	6	98.8	0	2	160	57	109	WP_297636592.1 phage virion morphogenesis protein [uncultured Clostridium sp.]	diamond	318	98.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
32945964	32945964	PRJEB6054_S_NODE_11578_length_167_cov_3.795455_g11489_i0	PRJEB6054	11578	167	3.795455	6.33840985	uncultured Clostridium sp.	59620	Bacteria	Bacteria	92	4.4599999999999996e-23	NR	WP_297636655.1	59620	g11489	i0	93.9	0.880239520958084	49	3	88	0	165	19	10	58	WP_297636655.1 AbrB/MazE/SpoVT family DNA-binding domain-containing protein [uncultured Clostridium sp.]	diamond	147	92	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	uncultured Clostridium sp.
32974477	32974477	PRJEB6054_S_NODE_11298_length_169_cov_1.641791_g11209_i0	PRJEB6054	11298	169	1.641791	2.77462679	root	1	Root_unresolved	Root_unresolved	75.5	1.22e-15	NR	MRB67472.1	1428	g11209	i0	70	21.5147928994083	50	15	88.8	0	169	20	85	134	MRB67472.1 hypothetical protein [Bacillus thuringiensis]	diamond	3636	75.9	0.994729907773386	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
33008467	33008467	PRJEB6054_S_NODE_7587_length_193_cov_1.968354_g7498_i0	PRJEB6054	7587	193	1.968354	3.79892322	Bacteria	2	Bacteria	Bacteria	101	1.84e-26	NR	MCB2621775.1	1639	g7498	i0	94.1	18.2331606217617	51	3	79.3	0	193	41	15	65	MCB2621775.1 fumarate hydratase [Listeria monocytogenes]	diamond	3519	102	0.990196078431373	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes

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