metadata: contig_metadata: 28 rows where bioproject = "PRJNA397736" and tax

28 rows where bioproject = "PRJNA397736" 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
412092	412092	PRJNA397736_S_NODE_1061_length_278_cov_16.895582_g1025_i0	PRJNA397736	1061	278	16.895582	46.96971796	Granulicatella elegans	137732	Bacteria	Bacteria	379	1.03e-100	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g1025	i0	93.436	90.0719424460432	259	11	92	6	1	255	242203	242459	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	25040	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
412095	412095	PRJNA397736_S_NODE_2401_length_174_cov_2.503448_g2365_i0	PRJNA397736	2401	174	2.503448	4.35599952	Veillonella atypica	39777	Bacteria	Bacteria	287	3.69e-73	NTclustered	gi\|1175700537\|gb\|CP020566.1\|	39777	g2365	i0	96.532	443.126436781609	173	6	99	0	1	173	81628	81456	Veillonella atypica strain OK5, complete genome	blastn	77104	287	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
1079937	1079937	PRJNA397736_S_NODE_1521_length_225_cov_3.137755_g1485_i0	PRJNA397736	1521	225	3.137755	7.05994875	Veillonella	29465	Bacteria	Bacteria	416	6.159999999999998e-112	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g1485	i0	100	489.137777777778	225	0	100	0	1	225	1031280	1031504	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	110056	416	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
1079940	1079940	PRJNA397736_S_NODE_2121_length_186_cov_4.789809_g2085_i0	PRJNA397736	2121	186	4.789809	8.90904474	Staphylococcus	1279	Bacteria	Bacteria	316	5.11e-82	NTclustered	gi\|2716021442\|gb\|CP114450.1\|	1282	g2085	i0	97.312	96.3602150537634	186	5	100	0	1	186	2357015	2357200	Staphylococcus epidermidis strain SE 4.8 chromosome, complete genome	blastn	17923	318	0.993710691823899	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
2355328	2355328	PRJNA397736_S_NODE_1322_length_243_cov_21.205607_g1286_i0	PRJNA397736	1322	243	21.205607	51.52962501	Aerococcus	1375	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g1286	i0	98.354	484.897119341564	243	4	100	0	1	243	18321	18563	Aerococcus viridans strain CCUG4311, complete genome	blastn	117830	427	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
2962888	2962888	PRJNA397736_S_NODE_1743_length_208_cov_10.430168_g1707_i0	PRJNA397736	1743	208	10.430168	21.69474944	Gemella haemolysans	1379	Bacteria	Bacteria	383	5.69e-102	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g1707	i0	100	264.355769230769	207	0	99	0	1	207	9788	9994	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	54986	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
4239189	4239189	PRJNA397736_S_NODE_1084_length_274_cov_16.191837_g1048_i0	PRJNA397736	1084	274	16.191837	44.36563338	Staphylococcus edaphicus	1955013	Bacteria	Bacteria	453	5.9000000000000006e-123	NTclustered	gi\|2241212604\|gb\|CP093217.1\|	1955013	g1048	i0	97.368	495.058394160584	266	7	97	0	9	274	1063233	1063498	Staphylococcus edaphicus strain CCM 8731 chromosome, complete genome	blastn	135646	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus edaphicus
4239194	4239194	PRJNA397736_S_NODE_2464_length_170_cov_5.056738_g2428_i0	PRJNA397736	2464	170	5.056738	8.5964546	Granulicatella elegans	137732	Bacteria	Bacteria	287	3.58e-73	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g2428	i0	97.059	483.323529411765	170	5	100	0	1	170	104772	104603	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	82165	287	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
4239197	4239197	PRJNA397736_S_NODE_904_length_300_cov_9.830258_g868_i0	PRJNA397736	904	300	9.830258	29.490774	Granulicatella elegans	137732	Bacteria	Bacteria	542	1.36e-149	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g868	i0	99.331	452.606666666667	299	2	99	0	1	299	106063	105765	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	135782	542	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
4907911	4907911	PRJNA397736_S_NODE_224_length_630_cov_41.410982_g205_i0	PRJNA397736	224	630	41.410982	260.8891866	Streptococcus	1301	Bacteria	Bacteria	979	0	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g205	i0	94.795	354.21746031746	634	24	100	8	1	630	423873	424501	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	223157	979	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
4907912	4907912	PRJNA397736_S_NODE_2404_length_173_cov_42.291667_g2368_i0	PRJNA397736	2404	173	42.291667	73.16458391	Streptococcus	1301	Bacteria	Bacteria	291	2.8299999999999998e-74	NTclustered	gi\|1686100242\|gb\|MK330590.1\|	1305	g2368	i0	97.11	331.537572254335	173	4	100	1	1	173	2650	2821	Streptococcus sanguinis strain 4416_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	57356	291	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus sanguinis
5515842	5515842	PRJNA397736_S_NODE_1665_length_214_cov_15.421622_g1629_i0	PRJNA397736	1665	214	15.421622	33.00227108	Gemella haemolysans	1379	Bacteria	Bacteria	379	7.609999999999999e-101	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g1629	i0	98.598	286.771028037383	214	3	100	0	1	214	9512	9725	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	61369	379	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
7457833	7457833	PRJNA397736_S_NODE_1746_length_208_cov_8.921788_g1710_i0	PRJNA397736	1746	208	8.921788	18.55731904	Veillonella	29465	Bacteria	Bacteria	385	1.58e-102	NTclustered	gi\|1175700537\|gb\|CP020566.1\|	39777	g1710	i0	100	637.072115384615	208	0	100	0	1	208	82738	82531	Veillonella atypica strain OK5, complete genome	blastn	132511	385	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella atypica
11283142	11283142	PRJNA397736_S_NODE_1949_length_194_cov_55.903030_g1913_i0	PRJNA397736	1949	194	55.90303	108.4518782	Streptococcus	1301	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|1578096036\|emb\|LR216035.1\|	1313	g1913	i0	99.485	332	194	1	100	0	1	194	1835140	1835333	Streptococcus pneumoniae isolate SA_GPS_SP505-sc-1895675 genome assembly, chromosome: 1	blastn	64408	353	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
11890938	11890938	PRJNA397736_S_NODE_1870_length_200_cov_2.438596_g1834_i0	PRJNA397736	1870	200	2.438596	4.877192	Anaerococcus nagyae	1755241	Bacteria	Bacteria	368	1.52e-97	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g1834	i0	100	274.745	199	0	99	0	2	200	123051	122853	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	54949	368	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
12558633	12558633	PRJNA397736_S_NODE_2190_length_183_cov_1.948052_g2154_i0	PRJNA397736	2190	183	1.948052	3.56493516	root	1	Root_unresolved	Root_unresolved	97.1	7.1e-16	NTclustered	gi\|1374503264\|ref\|NR_102990.2\|	86170	g2154	i0	86.517	55.9508196721311	89	10	48	2	81	168	259	172	Syntrophothermus lipocalidus strain TGB-C1 23S ribosomal RNA, complete sequence	blastn	10239	97.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Syntrophomonadaceae	Syntrophothermus	Syntrophothermus lipocalidus
15107651	15107651	PRJNA397736_S_NODE_232_length_622_cov_40.404722_g201_i1	PRJNA397736	232	622	40.404722	251.31737084	Staphylococcus	1279	Bacteria	Bacteria	948	0	NTclustered	gi\|2476884141\|gb\|CP102571.2\|	1283	g201	i1	94.249	486.509646302251	626	26	99	9	2	622	1062069	1061449	Staphylococcus haemolyticus strain 5 chromosome	blastn	302609	948	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
18931399	18931399	PRJNA397736_S_NODE_2455_length_171_cov_2.802817_g2419_i0	PRJNA397736	2455	171	2.802817	4.79281707	Veillonella	29465	Bacteria	Bacteria	254	3.66e-63	NTclustered	gi\|1540028531\|emb\|LR134375.1\|	39778	g2419	i0	93.529	490.444444444444	170	11	99	0	1	170	1410892	1411061	Veillonella dispar strain NCTC11831 genome assembly, chromosome: 1	blastn	83866	254	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella dispar
19537997	19537997	PRJNA397736_S_NODE_436_length_445_cov_31.622596_g401_i0	PRJNA397736	436	445	31.622596	140.7205522	Gemella haemolysans	1379	Bacteria	Bacteria	573	7.429999999999998e-159	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g401	i0	89.955	239.559550561798	448	40	100	5	1	445	11062	10617	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	106604	573	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
20813741	20813741	PRJNA397736_S_NODE_417_length_456_cov_28.594848_g382_i0	PRJNA397736	417	456	28.594848	130.39250688	Gemella haemolysans	1379	Bacteria	Bacteria	636	9.599999999999999e-178	NTclustered	gi\|2099427058\|gb\|CP083637.1\|	1379	g382	i0	91.921	477.331140350877	458	32	99	5	1	455	1795008	1795463	Gemella haemolysans strain FDAARGOS_1500 chromosome, complete genome	blastn	217663	636	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
22756865	22756865	PRJNA397736_S_NODE_238_length_619_cov_43.784746_g205_i1	PRJNA397736	238	619	43.784746	271.02757774	Streptococcus	1301	Bacteria	Bacteria	1122	0	NTclustered	gi\|1780487221\|gb\|CP046335.1\|	28037	g205	i1	99.354	344.001615508885	619	4	100	0	1	619	3694	3076	Streptococcus mitis strain FDAARGOS_684 chromosome, complete genome	blastn	212937	1127	0.995563442768412	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
23364205	23364205	PRJNA397736_S_NODE_1219_length_255_cov_22.336283_g1183_i0	PRJNA397736	1219	255	22.336283	56.95752165	Granulicatella elegans	137732	Bacteria	Bacteria	405	1.54e-108	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g1183	i0	95.294	545.364705882353	255	12	100	0	1	255	106248	105994	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	139068	405	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
24638532	24638532	PRJNA397736_S_NODE_2960_length_153_cov_4.629032_g2924_i0	PRJNA397736	2960	153	4.629032	7.08241896	Granulicatella elegans	137732	Bacteria	Bacteria	272	8.84e-69	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g2924	i0	98.693	391.02614379085003	153	2	100	0	1	153	104149	103997	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	59827	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
25306066	25306066	PRJNA397736_S_NODE_220_length_633_cov_38.104305_g201_i0	PRJNA397736	220	633	38.104305	241.20025065	Bacillales	1385	Bacteria	Bacteria	1122	0	NTclustered	gi\|1784319663\|gb\|CP045137.2\|	1283	g201	i0	98.736	483.020537124803	633	5	99	3	1	632	2506191	2505561	Staphylococcus haemolyticus strain VB5326 chromosome, complete genome	blastn	305752	1122	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
26712025	26712025	PRJNA397736_S_NODE_1261_length_249_cov_5.981818_g1225_i0	PRJNA397736	1261	249	5.981818	14.89472682	root	1	Root_unresolved	Root_unresolved	165	1.12e-50	NR	MDK0657390.1	1502	g1225	i0	98.8	77.0602409638554	82	1	98.8	0	2	247	27	108	MDK0657390.1 30S ribosomal protein S8 [Clostridium perfringens]	diamond	19188	166	0.993975903614458	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium perfringens
26790667	26790667	PRJNA397736_S_NODE_441_length_444_cov_3.879518_g406_i0	PRJNA397736	441	444	3.879518	17.22505992	Eubacterium sp.	142586	Bacteria	Bacteria	64.3	7.23e-9	NR	MDE6469480.1	142586	g406	i0	31.6	1.75	133	73	83.1	4	56	424	206	330	MDE6469480.1 glycoside hydrolase family 18 protein [Eubacterium sp.]	diamond	777	64.3	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Eubacteriaceae	Eubacterium	Eubacterium sp.
28355322	28355322	PRJNA397736_S_NODE_2466_length_170_cov_4.127660_g2430_i0	PRJNA397736	2466	170	4.12766	7.017022	root	1	Root_unresolved	Root_unresolved	109	1.9e-29	NR	MRB67503.1	1428	g2430	i0	98.2	238.147058823529	56	1	98.8	0	3	170	55	110	MRB67503.1 30S ribosomal protein S11 [Bacillus thuringiensis]	diamond	40485	110	0.990909090909091	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus thuringiensis
31781974	31781974	PRJNA397736_S_NODE_2137_length_185_cov_6.576923_g2101_i0	PRJNA397736	2137	185	6.576923	12.16730755	Streptococcus pneumoniae	1313	Bacteria	Bacteria	89.4	1.41e-21	NR	MDG7606462.1	1313	g2101	i0	97.5	0.648648648648649	40	1	64.9	0	185	66	1	40	MDG7606462.1 hypothetical protein [Streptococcus pneumoniae]	diamond	120	89.4	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae

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