metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA692200" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA692200" and tax_kingdom = "Bacillati"

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_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
1179261	1179261	PRJNA692200_S_NODE_20521_length_165_cov_4.336207_g20464_i0	PRJNA692200	20521	165	4.336207	7.15474155	Corynebacterium	1716	Bacteria	Bacteria	287	3.47e-73	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g20464	i0	98.758	356.175757575758	161	2	98	0	1	161	760146	759986	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	58769	287	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
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
5776342	5776342	PRJNA692200_S_NODE_3085_length_337_cov_5.892361_g3028_i0	PRJNA692200	3085	337	5.892361	19.85725657	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g3028	i0	100	0.086053412462908	29	0	9	0	253	281	2448791	2448819	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	29	54.7	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
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
9601140	9601140	PRJNA692200_S_NODE_17668_length_175_cov_1.357143_g17611_i0	PRJNA692200	17668	175	1.357143	2.37500025	Dactylosporangium thailandense	47849	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2666977426\|dbj\|AP029195.1\|	47849	g17611	i0	100	0.16	28	0	16	0	137	164	7382693	7382720	Dactylosporangium thailandense JCM 3084 DNA, complete genome	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium thailandense
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
12151837	12151837	PRJNA692200_S_NODE_15290_length_186_cov_2.934307_g15233_i0	PRJNA692200	15290	186	2.934307	5.45781102	Aliterella chasmolithica	2739056	Bacteria	Bacteria	303	3.98e-78	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g15233	i0	96.216	141.220430107527	185	7	99	0	2	186	2173	1989	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	26267	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
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
14701609	14701609	PRJNA692200_S_NODE_14312_length_191_cov_5.035211_g14255_i0	PRJNA692200	14312	191	5.035211	9.61725301	Mycoplasmatota bacterium WC30	3075149	Bacteria	Bacteria	78.7	2.71e-10	NTclustered	gi\|2877983046\|gb\|CP134495.1\|	3075149	g14255	i0	94.118	21.0785340314136	51	3	27	0	29	79	240248	240298	Mycoplasmatota bacterium WC30 chromosome, complete genome	blastn	4026	78.7	1	Bacteria		Bacillati	Mycoplasmatota					Mycoplasmatota bacterium WC30
14701682	14701682	PRJNA692200_S_NODE_17852_length_174_cov_1.928000_g17795_i0	PRJNA692200	17852	174	1.928	3.35472	Embleya sp. NBC_00888	2975960	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2655411662\|gb\|CP108785.1\|	2975960	g17795	i0	100	0.160919540229885	28	0	16	0	98	125	2988534	2988561	Embleya sp. NBC_00888 plasmid unnamed1, complete sequence	blastn	28	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Embleya	Embleya sp. NBC_00888
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
17757084	17757084	PRJNA692200_S_NODE_12674_length_202_cov_0.993464_g12617_i0	PRJNA692200	12674	202	0.993464	2.00679728	Streptomyces	1883	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1751485547\|gb\|CP023693.1\|	67260	g12617	i0	100	0.415841584158416	28	0	14	0	95	122	3959630	3959603	Streptomyces cinereoruber strain ATCC 19740 chromosome, complete genome	blastn	84	52.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cinereoruber
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
21075503	21075503	PRJNA692200_S_NODE_9297_length_230_cov_12.464088_g9240_i0	PRJNA692200	9297	230	12.464088	28.6674024	Candidatus Roseilinea sp.	2838777	Bacteria	Bacteria	147	9.16e-31	NTclustered	gi\|2314722916\|dbj\|AP024676.1\|	2838777	g9240	i0	80	278.760869565217	205	35	88	6	28	229	3494631	3494430	MAG: Candidatus Roseilinea sp. KatS3mg053 DNA, complete genome	blastn	64115	147	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia			Candidatus Roseilinea	Candidatus Roseilinea sp.
21075516	21075516	PRJNA692200_S_NODE_9657_length_227_cov_1.780899_g9600_i0	PRJNA692200	9657	227	1.780899	4.04264073	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	180	8.89e-41	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g9600	i0	81.614	393.022026431718	223	36	98	5	5	226	373699	373481	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	89216	180	1	Bacteria		Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
21581466	21581466	PRJNA692200_S_NODE_13657_length_195_cov_10.554795_g13600_i0	PRJNA692200	13657	195	10.554795	20.58185025	root	1	Root_unresolved	Root_unresolved	52.8	0.017	NTclustered	gi\|1851159111\|gb\|CP054256.1\|	2102	g13600	i0	100	13.7846153846154	28	0	14	0	57	84	261472	261445	Mycoplasma mycoides strain T1/44 GP chromosome, complete genome	blastn	2688	52.8	1	Bacteria		Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
22349861	22349861	PRJNA692200_S_NODE_10538_length_218_cov_5.958580_g10481_i0	PRJNA692200	10538	218	5.95858	12.9897044	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	379	7.779999999999999e-101	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10481	i0	98.157	106.733944954128	217	4	99	0	1	217	3682467	3682683	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	23268	379	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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
25405718	25405718	PRJNA692200_S_NODE_18420_length_172_cov_1.097561_g18363_i0	PRJNA692200	18420	172	1.097561	1.88780492	Corynebacterium	1716	Bacteria	Bacteria	309	7.75e-80	NTclustered	gi\|1403572617\|emb\|LS483460.1\|	38301	g18363	i0	99.412	360.877906976744	170	1	99	0	1	170	145169	145000	Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1	blastn	62071	309	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum

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