metadata: contig_metadata: 28 rows where bioproject = "PRJNA692200", tax_kingdom = "Bacillati" and tax

28 rows where bioproject = "PRJNA692200", tax_kingdom = "Bacillati" 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
672700	672700	PRJNA692200_S_NODE_17221_length_177_cov_1.664062_g17164_i0	PRJNA692200	17221	177	1.664062	2.94538974	Parvimonas micra	33033	Bacteria	Bacteria	294	2.25e-75	NTclustered	gi\|2418006839\|gb\|CP101410.1\|	33033	g17164	i0	96.61	248.779661016949	177	6	100	0	1	177	312967	312791	Parvimonas micra strain PM89KC-G-2 chromosome, complete genome	blastn	44034	294	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
672816	672816	PRJNA692200_S_NODE_22861_length_158_cov_2.348624_g22804_i0	PRJNA692200	22861	158	2.348624	3.71082592	Bacillus cereus	1396	Bacteria	Bacteria	65.8	1.68e-6	NTclustered	gi\|1219791826\|gb\|CP022446.1\|	1003239	g22804	i0	75.325	12.9177215189873	154	29	96	6	4	155	652642	652788	Bacillus cereus C1L plasmid pC1L1, complete sequence	blastn	2041	65.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus cereus
1179274	1179274	PRJNA692200_S_NODE_4361_length_303_cov_2.062992_g4304_i0	PRJNA692200	4361	303	2.062992	6.25086576	Bacillota	1239	Bacteria	Bacteria	276	1.5399999999999999e-69	NTclustered	gi\|1840485543\|gb\|CP053187.1\|	154288	g4304	i0	89.545	417.03300330033	220	20	73	3	76	294	681471	681688	Turicibacter sanguinis strain MOL361 chromosome, complete genome	blastn	126361	278	0.992805755395683	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Turicibacteraceae	Turicibacter	Turicibacter sanguinis
2454545	2454545	PRJNA692200_S_NODE_20582_length_165_cov_2.715517_g20525_i0	PRJNA692200	20582	165	2.715517	4.48060305	root	1	Root_unresolved	Root_unresolved	56.5	0.001	NTclustered	gi\|2230200769\|gb\|CP073714.1\|	1472	g20525	i0	100	4.50909090909091	30	0	18	0	74	103	1090459	1090430	Paenibacillus pabuli strain E1 chromosome, complete genome	blastn	744	56.5	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus pabuli
3731070	3731070	PRJNA692200_S_NODE_14283_length_191_cov_18.823944_g14226_i0	PRJNA692200	14283	191	18.823944	35.95373304	Peptostreptococcaceae	186804	Bacteria	Bacteria	348	1.87e-91	NTclustered	gi\|2695214537\|gb\|CP124295.1\|	1505	g14226	i0	99.476	919.79057591623	191	1	100	0	1	191	49199	49389	Paraclostridium sordellii strain C116 chromosome, complete genome	blastn	175680	348	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium sordellii
7051329	7051329	PRJNA692200_S_NODE_18646_length_171_cov_1.278689_g18589_i0	PRJNA692200	18646	171	1.278689	2.18655819	Paraclostridium bifermentans	1490	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2501758084\|gb\|CP124685.1\|	1490	g18589	i0	100	0.16374269005848	28	0	16	0	50	77	2303745	2303718	Paraclostridium bifermentans strain SampleS7P1 isolate gram staining chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Paraclostridium	Paraclostridium bifermentans
7051590	7051590	PRJNA692200_S_NODE_7226_length_254_cov_1.595122_g7169_i0	PRJNA692200	7226	254	1.595122	4.05160988	Streptococcus ferus	1345	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1403304616\|emb\|LS483343.1\|	1345	g7169	i0	100	0.114173228346457	29	0	11	0	20	48	95780	95808	Streptococcus ferus strain NCTC12278 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus ferus
8832235	8832235	PRJNA692200_S_NODE_6387_length_265_cov_1632.189815_g6330_i0	PRJNA692200	6387	265	1632.189815	4325.30300975	Staphylococcus	1279	Bacteria	Bacteria	401	2.0899999999999994e-107	NTclustered	gi\|2814765382\|gb\|CP170661.1\|	1282	g6330	i0	98.253	458.064150943396	229	4	86	0	37	265	793298	793070	Staphylococcus epidermidis strain CCARM 3A686 chromosome, complete genome	blastn	121387	401	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
9601093	9601093	PRJNA692200_S_NODE_15708_length_184_cov_3.696296_g15651_i0	PRJNA692200	15708	184	3.696296	6.80118464	root	1	Root_unresolved	Root_unresolved	80.1	3.72e-18	NR	MDK0835637.1	1502	g15651	i0	71.4	27.3260869565217	49	14	79.9	0	3	149	18	66	MDK0835637.1 peptidylprolyl isomerase [Clostridium perfringens]	diamond	5028	80.9	0.990111248454882	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
10107924	10107924	PRJNA692200_S_NODE_17788_length_174_cov_2.992000_g17731_i0	PRJNA692200	17788	174	2.992	5.20608	Streptococcus	1301	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2072520965\|gb\|CP079821.1\|	1234680	g17731	i0	100	341.505747126437	174	0	100	0	1	174	334145	333972	Streptococcus rubneri strain LPB0404 chromosome, complete genome	blastn	59422	322	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus rubneri
10877034	10877034	PRJNA692200_S_NODE_7289_length_253_cov_1.607843_g7232_i0	PRJNA692200	7289	253	1.607843	4.06784279	Anaerococcus nagyae	1755241	Bacteria	Bacteria	416	7.069999999999999e-112	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g7232	i0	97.154	56.6442687747036	246	7	97	0	8	253	121307	121062	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	14331	416	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
12152105	12152105	PRJNA692200_S_NODE_530_length_499_cov_145.008889_g497_i0	PRJNA692200	530	499	145.008889	723.59435611	Brevibacillus fulvus	1125967	Bacteria	Bacteria	143	7.079999999999998e-41	NR	WP_204516782.1	1125967	g497	i0	61.1	4.15430861723447	113	44	67.9	0	61	399	2	114	WP_204516782.1 group I truncated hemoglobin [Brevibacillus fulvus]	diamond	2073	143	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Brevibacillus	Brevibacillus fulvus
12658626	12658626	PRJNA692200_S_NODE_13310_length_197_cov_18.331081_g13253_i0	PRJNA692200	13310	197	18.331081	36.11222957	Streptococcus	1301	Bacteria	Bacteria	363	6.939999999999998e-96	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g13253	i0	100	326.248730964467	196	0	99	0	1	196	141182	140987	Streptococcus infantis strain SO chromosome, complete genome	blastn	64271	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
13933230	13933230	PRJNA692200_S_NODE_15231_length_186_cov_6.437956_g15174_i0	PRJNA692200	15231	186	6.437956	11.97459816	Abiotrophia	46123	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g15174	i0	100	543.801075268817	186	0	100	0	1	186	863436	863621	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	101147	344	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva
13933256	13933256	PRJNA692200_S_NODE_2691_length_351_cov_14.033113_g2634_i0	PRJNA692200	2691	351	14.033113	49.25622663	Streptococcus	1301	Bacteria	Bacteria	593	4.389999999999998e-165	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g2634	i0	99.691	314.105413105413	324	1	92	0	27	350	1571278	1571601	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	110251	593	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
14701710	14701710	PRJNA692200_S_NODE_19012_length_169_cov_3.816667_g18955_i0	PRJNA692200	19012	169	3.816667	6.45016723	Clostridium perfringens	1502	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2702800439\|gb\|CP148701.1\|	1502	g18955	i0	100	0.177514792899408	30	0	18	0	12	41	502669	502640	Clostridium perfringens strain Z1322PCP0092 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
15207823	15207823	PRJNA692200_S_NODE_10432_length_219_cov_4.505882_g10375_i0	PRJNA692200	10432	219	4.505882	9.86788158	Staphylococcus	1279	Bacteria	Bacteria	392	1.01e-104	NTclustered	gi\|1042399372\|gb\|KU555869.1\|	28035	g10375	i0	99.535	489.744292237443	215	1	98	0	5	219	705	491	Staphylococcus lugdunensis strain SLG13971-4 16S-23S ribosomal RNA intergenic spacer gene, region	blastn	107254	392	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus lugdunensis
16482086	16482086	PRJNA692200_S_NODE_18353_length_172_cov_1.650407_g18296_i0	PRJNA692200	18353	172	1.650407	2.83870004	FCB group	1783270	Bacteria	Bacteria	313	5.989999999999998e-81	NTclustered	gi\|2800799246\|gb\|CP093959.1\|	1358	g18296	i0	99.419	510.860465116279	172	1	100	0	1	172	522031	521860	Lactococcus lactis strain FAM 17919 chromosome, complete genome	blastn	87868	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Lactococcus	Lactococcus lactis
16482089	16482089	PRJNA692200_S_NODE_19013_length_169_cov_3.783333_g18956_i0	PRJNA692200	19013	169	3.783333	6.39383277	Streptococcus	1301	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g18956	i0	100	568.07100591716	169	0	100	0	1	169	16847	16679	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	96004	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
17250376	17250376	PRJNA692200_S_NODE_10154_length_222_cov_2.098266_g10097_i0	PRJNA692200	10154	222	2.098266	4.65815052	Finegoldia magna	1260	Bacteria	Bacteria	399	6.099999999999999e-107	NTclustered	gi\|2831269597\|gb\|CP170999.1\|	1260	g10097	i0	99.103	32.6531531531532	223	1	100	1	1	222	1362698	1362476	Finegoldia magna strain WGS1513 chromosome, complete genome	blastn	7249	399	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
19030925	19030925	PRJNA692200_S_NODE_12635_length_202_cov_1.934641_g12578_i0	PRJNA692200	12635	202	1.934641	3.90797482	Streptococcus	1301	Bacteria	Bacteria	76.8	1.04e-9	NTclustered	gi\|21666288\|gb\|AF389514.1\|	1335	g12578	i0	87.692	12.4257425742574	65	8	32	0	125	189	652	588	Streptococcus bovis GroES gene, complete cds; and GroEL gene, partial cds	blastn	2510	76.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus equinus
23625706	23625706	PRJNA692200_S_NODE_7859_length_245_cov_630.494898_g7802_i0	PRJNA692200	7859	245	630.494898	1544.7125001	Gemella sanguinis	84135	Bacteria	Bacteria	366	6.95e-97	NTclustered	gi\|1780450472\|gb\|CP046313.1\|	84135	g7802	i0	98.095	256.644897959184	210	4	86	0	36	245	519032	519241	Gemella sanguinis strain FDAARGOS_742 chromosome, complete genome	blastn	62878	366	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella sanguinis
24899291	24899291	PRJNA692200_S_NODE_7080_length_255_cov_1593.242718_g7023_i0	PRJNA692200	7080	255	1593.242718	4062.7689309	Paenibacillus azoreducens	116718	Bacteria	Bacteria	180	1.02e-40	NTclustered	gi\|2168704082\|dbj\|AP025343.1\|	116718	g7023	i0	83.495	141.509803921569	206	21	80	11	1	198	994584	994784	Paenibacillus azoreducens J34TS1 DNA, complete genome	blastn	36085	180	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus azoreducens
27114000	27114000	PRJNA692200_S_NODE_13782_length_195_cov_1.267123_g13725_i0	PRJNA692200	13782	195	1.267123	2.47088985	Defluviitaleaceae bacterium	2660712	Bacteria	Bacteria	41.6	0.0492	NR	MCL2378803.1	2660712	g13725	i0	45.2	0.646153846153846	42	20	61.5	2	136	17	265	305	MCL2378803.1 hypothetical protein [Defluviitaleaceae bacterium]	diamond	126	41.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Defluviitaleaceae		Defluviitaleaceae bacterium
27978269	27978269	PRJNA692200_S_NODE_4105_length_309_cov_1.507692_g4048_i0	PRJNA692200	4105	309	1.507692	4.65876828	Peptostreptococcus	1257	Bacteria	Bacteria	112	2.28e-29	NR	WP_002845271.1	1257	g4048	i0	58.9	7.96116504854369	90	37	87.4	0	5	274	32	121	WP_002845271.1 MULTISPECIES: RidA family protein [Peptostreptococcus]	diamond	2460	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Peptostreptococcus
28420522	28420522	PRJNA692200_S_NODE_726_length_472_cov_4.680851_g688_i0	PRJNA692200	726	472	4.680851	22.09361672	root	1	Root_unresolved	Root_unresolved	47.4	8.05e-4	NR	MER2170548.1	126157	g688	i0	46.2	0.889830508474576	52	27	32.4	1	208	56	1	52	MER2170548.1 hypothetical protein [Psychrobacillus psychrodurans]	diamond	420	47.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Psychrobacillus	Psychrobacillus psychrodurans
30335750	30335750	PRJNA692200_S_NODE_20272_length_166_cov_1.384615_g20215_i0	PRJNA692200	20272	166	1.384615	2.2984609	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	46.2	7.85e-4	NR	MCH4039956.1	1898203	g20215	i0	40	0.903614457831325	50	30	90.4	0	16	165	153	202	MCH4039956.1 glycosyltransferase [Lachnospiraceae bacterium]	diamond	150	46.2	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32074129	32074129	PRJNA692200_S_NODE_9658_length_227_cov_1.612360_g9601_i0	PRJNA692200	9658	227	1.61236	3.6600572	Erysipelotrichaceae bacterium	2049044	Bacteria	Bacteria	45.4	0.003	NR	MEA5018092.1	2049044	g9601	i0	50	0.475770925110132	36	18	47.6	0	222	115	188	223	MEA5018092.1 dienelactone hydrolase family protein [Erysipelotrichaceae bacterium]	diamond	108	45.4	1	Bacteria	Bacillati	Bacillota	Erysipelotrichia	Erysipelotrichales	Erysipelotrichaceae		Erysipelotrichaceae 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);;