metadata: contig_metadata: 30 rows where bioproject = "PRJNA559720" and tax

30 rows where bioproject = "PRJNA559720" 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
4370851	4370851	PRJNA559720_P_NODE_10304_length_302_cov_1.257642_g10165_i0	PRJNA559720	10304	302	1.257642	3.79807884	Priestia megaterium	1404	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1844619902\|gb\|CP045273.1\|	1404	g10165	i0	100	0.0927152317880795	28	0	9	0	195	222	530134	530107	Priestia megaterium strain FDU301 plasmid pFDU301A, complete sequence	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Priestia	Priestia megaterium
4370932	4370932	PRJNA559720_P_NODE_15544_length_244_cov_0.900585_g15405_i0	PRJNA559720	15544	244	0.900585	2.1974274	Mageeibacillus indolicus	884684	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|307346916\|gb\|CP001850.2\|	699246	g15405	i0	99.18	21.7418032786885	244	2	100	0	1	244	1736426	1736183	Mageeibacillus indolicus UPII9-5 chromosome, complete genome	blastn	5305	440	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Mageeibacillus	Mageeibacillus indolicus
4958469	4958469	PRJNA559720_P_NODE_16104_length_242_cov_0.911243_g15965_i0	PRJNA559720	16104	242	0.911243	2.20520806	Veillonella	29465	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1231683529\|emb\|LT906445.1\|	29466	g15965	i0	100	15.9710743801653	242	0	100	0	1	242	1686633	1686392	Veillonella parvula strain NCTC11810 genome assembly, chromosome: 1	blastn	3865	448	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
9472188	9472188	PRJNA559720_P_NODE_6348_length_406_cov_8.450450_g6209_i0	PRJNA559720	6348	406	8.45045	34.308827	Staphylococcus epidermidis	1282	Bacteria	Bacteria	60.2	2.33e-4	NTclustered	gi\|1369209706\|gb\|MG787416.1\|	1282	g6209	i0	100	0.0788177339901478	32	0	8	0	48	79	3685	3654	Staphylococcus epidermidis strain I14OR1 ACME IV mobile element, complete sequence	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10058917	10058917	PRJNA559720_P_NODE_13048_length_257_cov_1.673913_g12909_i0	PRJNA559720	13048	257	1.673913	4.30195641	Staphylococcus	1279	Bacteria	Bacteria	470	5.45e-128	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g12909	i0	99.611	40.0077821011673	257	1	100	0	1	257	2054992	2054736	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	10282	470	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
10058922	10058922	PRJNA559720_P_NODE_14388_length_248_cov_0.880000_g14249_i0	PRJNA559720	14388	248	0.88	2.1824	Bacillati	1783272	Bacteria	Bacteria	250	7.41e-62	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g14249	i0	93.939	10.1048387096774	165	10	67	0	84	248	675529	675365	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	2506	250	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
10747814	10747814	PRJNA559720_P_NODE_11269_length_285_cov_1.240566_g11130_i0	PRJNA559720	11269	285	1.240566	3.5356131	Staphylococcus epidermidis	1282	Bacteria	Bacteria	521	1.6699999999999996e-143	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g11130	i0	99.649	100	285	1	100	0	1	285	1881201	1880917	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	28500	521	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12609319	12609319	PRJNA559720_P_NODE_13570_length_251_cov_0.865169_g13431_i0	PRJNA559720	13570	251	0.865169	2.17157419	Staphylococcus	1279	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1143273938\|gb\|CP019597.1\|	29382	g13431	i0	100	7	251	0	100	0	1	251	743819	744069	Staphylococcus cohnii strain SNUDS-2 chromosome, complete genome	blastn	1757	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
13297615	13297615	PRJNA559720_P_NODE_16351_length_241_cov_0.916667_g16212_i0	PRJNA559720	16351	241	0.916667	2.20916747	Marinilactibacillus sp. 15R	1911586	Bacteria	Bacteria	351	1.91e-92	NTclustered	gi\|1112927908\|gb\|CP017761.1\|	1911586	g16212	i0	92.946	1	241	17	100	0	1	241	2256372	2256612	Marinilactibacillus sp. 15R chromosome, complete sequence	blastn	241	351	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Marinilactibacillus	Marinilactibacillus sp. 15R
15846315	15846315	PRJNA559720_P_NODE_14453_length_248_cov_0.880000_g14314_i0	PRJNA559720	14453	248	0.88	2.1824	Agathobacter rectalis	39491	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|291526582\|emb\|FP929043.1\|	657317	g14314	i0	99.194	6.54435483870968	248	2	100	0	1	248	2663089	2662842	Eubacterium rectale M104/1 draft genome	blastn	1623	448	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Agathobacter	Agathobacter rectalis
16433079	16433079	PRJNA559720_P_NODE_15873_length_243_cov_0.905882_g15734_i0	PRJNA559720	15873	243	0.905882	2.20129326	Streptococcus	1301	Bacteria	Bacteria	394	3.16e-105	NTclustered	gi\|1985957267\|gb\|CP069427.1\|	1303	g15734	i0	95.885	81.8559670781893	243	10	100	0	1	243	72359	72117	Streptococcus oralis strain SF100 chromosome, complete genome	blastn	19891	396	0.994949494949495	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17121207	17121207	PRJNA559720_P_NODE_13814_length_250_cov_0.870056_g13675_i0	PRJNA559720	13814	250	0.870056	2.17514	Carnobacterium viridans	174587	Bacteria	Bacteria	390	4.22e-104	NTclustered	gi\|2119245265\|gb\|CP084918.1\|	174587	g13675	i0	94.8	2.988	250	13	100	0	1	250	9894	9645	Carnobacterium viridans strain AB01 plasmid pDC01-1, complete sequence	blastn	747	390	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Carnobacterium	Carnobacterium viridans
18981759	18981759	PRJNA559720_P_NODE_13895_length_250_cov_0.870056_g13756_i0	PRJNA559720	13895	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2714337209\|gb\|CP150752.1\|	1280	g13756	i0	100	100	250	0	100	0	1	250	1614193	1613944	Staphylococcus aureus strain TUM22458 chromosome, complete genome	blastn	25000	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
19669980	19669980	PRJNA559720_P_NODE_13636_length_251_cov_0.865169_g13497_i0	PRJNA559720	13636	251	0.865169	2.17157419	Staphylococcus hominis	1290	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1848615759\|gb\|CP054006.1\|	1290	g13497	i0	100	66.6294820717131	251	0	100	0	1	251	1627889	1628139	Staphylococcus hominis strain FDAARGOS_762 chromosome, complete genome	blastn	16724	464	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
19669984	19669984	PRJNA559720_P_NODE_13916_length_250_cov_0.870056_g13777_i0	PRJNA559720	13916	250	0.870056	2.17514	Staphylococcus ureilyticus	94138	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2905461398\|gb\|CP180185.1\|	94138	g13777	i0	98.8	32.844	250	3	100	0	1	250	1443576	1443825	Staphylococcus ureilyticus strain RSM-JSascm chromosome	blastn	8211	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus ureilyticus
20945690	20945690	PRJNA559720_P_NODE_13617_length_251_cov_0.865169_g13478_i0	PRJNA559720	13617	251	0.865169	2.17157419	Veillonella orientalis	2682455	Bacteria	Bacteria	431	2.4999999999999996e-116	NTclustered	gi\|2021399589\|dbj\|AP022322.1\|	2682455	g13478	i0	97.61	14.8486055776892	251	6	100	0	1	251	296872	297122	Veillonella sp. S12025-13 DNA, complete genome	blastn	3727	431	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella orientalis
20945706	20945706	PRJNA559720_P_NODE_15037_length_246_cov_0.890173_g14898_i0	PRJNA559720	15037	246	0.890173	2.18982558	Parvimonas micra	33033	Bacteria	Bacteria	185	2.1e-42	NTclustered	gi\|2702638792\|gb\|CP148048.1\|	33033	g14898	i0	84.211	11.719512195122	190	30	77	0	3	192	6293	6104	Parvimonas micra strain JM503A chromosome, complete genome	blastn	2883	185	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
20945774	20945774	PRJNA559720_P_NODE_5797_length_427_cov_25.158192_g5658_i0	PRJNA559720	5797	427	25.158192	107.42547984	Staphylococcus epidermidis	1282	Bacteria	Bacteria	60.2	2.46e-4	NTclustered	gi\|1369209706\|gb\|MG787416.1\|	1282	g5658	i0	100	0.0749414519906323	32	0	7	0	349	380	3654	3685	Staphylococcus epidermidis strain I14OR1 ACME IV mobile element, complete sequence	blastn	32	60.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23495873	23495873	PRJNA559720_P_NODE_12479_length_266_cov_1.595855_g12340_i0	PRJNA559720	12479	266	1.595855	4.2449743	Staphylococcus pasteuri	45972	Bacteria	Bacteria	296	1.02e-75	NTclustered	gi\|1250047636\|gb\|CP017464.1\|	45972	g12340	i0	88.797	245.804511278195	241	27	100	0	1	241	49681	49441	Staphylococcus pasteuri strain JS7 plasmid pSNJS701, complete sequence	blastn	65384	296	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
26712900	26712900	PRJNA559720_P_NODE_6481_length_402_cov_1.151976_g6342_i0	PRJNA559720	6481	402	1.1519760000000001	4.63094352	Cohnella	329857	Bacteria	Bacteria	104	2.35e-25	NR	WP_204602556.1	768479	g6342	i0	42.9	1.78358208955224	119	68	88.8	0	368	12	23	141	WP_204602556.1 acyl-CoA thioesterase [Cohnella boryungensis]	diamond	717	104	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Cohnella	Cohnella boryungensis
26794197	26794197	PRJNA559720_P_NODE_7881_length_359_cov_1.076923_g7742_i0	PRJNA559720	7881	359	1.076923	3.86615357	Clostridiales bacterium	1898207	Bacteria	Bacteria	88.2	2.95e-18	NR	MBF0987186.1	1898207	g7742	i0	48.6	6.05013927576602	105	51	86.1	3	359	51	3	106	MBF0987186.1 aldo/keto reductase [Clostridiales bacterium]	diamond	2172	88.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
28987960	28987960	PRJNA559720_P_NODE_15108_length_245_cov_1.790698_g14969_i0	PRJNA559720	15108	245	1.790698	4.3872101	Ruminococcus	1263	Bacteria	Bacteria	144	4.69e-41	NR	WP_044976680.1	1514668	g14969	i0	76.9	1.91020408163265	78	18	95.5	0	235	2	1	78	WP_044976680.1 pyruvate formate-lyase-activating protein [Ruminococcus sp. HUN007]	diamond	468	144	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp. HUN007
29510363	29510363	PRJNA559720_P_NODE_15930_length_242_cov_1.668639_g15791_i0	PRJNA559720	15930	242	1.668639	4.03810638	Lactobacillus crispatus	47770	Bacteria	Bacteria	86.7	2.58e-20	NR	WP_205758276.1	47770	g15791	i0	95.7	0.867768595041322	70	3	86.8	0	3	212	5	74	WP_205758276.1 hypothetical protein, partial [Lactobacillus crispatus]	diamond	210	86.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
30300569	30300569	PRJNA559720_P_NODE_4732_length_478_cov_10.101235_g4594_i0	PRJNA559720	4732	478	10.101235	48.2839033	Clostridium lundense	319475	Bacteria	Bacteria	144	3.71e-41	NR	WP_027623586.1	319475	g4594	i0	58.1	3.82217573221757	124	50	76.6	1	448	83	2	125	WP_027623586.1 RidA family protein [Clostridium lundense]	diamond	1827	144	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium lundense
30458508	30458508	PRJNA559720_P_NODE_16453_length_241_cov_0.916667_g16314_i0	PRJNA559720	16453	241	0.916667	2.20916747	Lactiplantibacillus plantarum	1590	Bacteria	Bacteria	48.1	7.1e-5	NR	WP_222850852.1	1590	g16314	i0	57.1	0.435684647302905	35	15	43.6	0	127	23	66	100	WP_222850852.1 hypothetical protein, partial [Lactiplantibacillus plantarum]	diamond	105	48.1	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactiplantibacillus	Lactiplantibacillus plantarum
30932081	30932081	PRJNA559720_P_NODE_13334_length_253_cov_1.283333_g13195_i0	PRJNA559720	13334	253	1.283333	3.24683249	Bacilli bacterium	1903720	Bacteria	Bacteria	42.7	0.0413	NR	MBQ2873053.1	1903720	g13195	i0	30.4	0.936758893280632	79	52	90.1	1	20	247	136	214	MBQ2873053.1 insulinase family protein [Bacilli bacterium]	diamond	237	42.7	1	Bacteria	Bacillati	Bacillota	Bacilli				Bacilli bacterium
31184510	31184510	PRJNA559720_P_NODE_6475_length_402_cov_1.422492_g6336_i0	PRJNA559720	6475	402	1.422492	5.71841784	Peptoniphilaceae bacterium	1891242	Bacteria	Bacteria	46.2	0.00754	NR	MDD7463520.1	1891242	g6336	i0	33.7	0.708955223880597	95	51	67.2	4	293	24	18	105	MDD7463520.1 AraC family transcriptional regulator [Peptoniphilaceae bacterium]	diamond	285	46.2	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae		Peptoniphilaceae bacterium
31564592	31564592	PRJNA559720_P_NODE_5816_length_427_cov_1.553672_g5677_i0	PRJNA559720	5816	427	1.553672	6.63417944	Clostridia bacterium	2044939	Bacteria	Bacteria	45.4	0.027	NR	MBR3697310.1	2044939	g5677	i0	30.4	0.786885245901639	112	69	78.7	2	395	60	255	357	MBR3697310.1 DNA polymerase III subunit gamma/tau [Clostridia bacterium]	diamond	336	45.4	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31817242	31817242	PRJNA559720_P_NODE_6617_length_397_cov_3.191358_g6478_i0	PRJNA559720	6617	397	3.191358	12.66969126	Holdemanella biformis	1735	Bacteria	Bacteria	47.8	0.00343	NR	WP_118356857.1	1735	g6478	i0	35.7	0.846347607052897	112	61	80.9	4	347	27	115	220	WP_118356857.1 DEAD/DEAH box helicase [Holdemanella biformis]	diamond	336	47.8	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae	Holdemanella	Holdemanella biformis
32796827	32796827	PRJNA559720_P_NODE_15740_length_243_cov_0.905882_g15601_i0	PRJNA559720	15740	243	0.905882	2.20129326	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	171	1.59e-49	NR	MCQ2499216.1	1898203	g15601	i0	97.5	0.987654320987654	80	2	98.8	0	3	242	234	313	MCQ2499216.1 AAA family ATPase [Lachnospiraceae bacterium]	diamond	240	171	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae 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);;