metadata: contig_metadata: 27 rows where bioproject = "PRJNA745923" and tax

27 rows where bioproject = "PRJNA745923" 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
2000928	2000928	PRJNA745923_S_NODE_34642_length_161_cov_0.974576_g34310_i0	PRJNA745923	34642	161	0.974576	1.56906736	Lactobacillus iners	147802	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|1818008110\|gb\|CP049223.1\|	147802	g34310	i0	100	11.6521739130435	161	0	100	0	1	161	1156693	1156533	Lactobacillus iners strain C0094A1 chromosome, complete genome	blastn	1876	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
4553480	4553480	PRJNA745923_S_NODE_40564_length_150_cov_0.897196_g40232_i0	PRJNA745923	40564	150	0.897196	1.345794	Lactobacillus iners	147802	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|1818001851\|gb\|CP049231.1\|	147802	g40232	i0	99.333	74.3333333333333	150	1	100	0	1	150	166451	166302	Lactobacillus iners strain C0254C1 chromosome, complete genome	blastn	11150	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
5027118	5027118	PRJNA745923_S_NODE_24184_length_197_cov_1.558442_g23852_i0	PRJNA745923	24184	197	1.558442	3.07013074	Streptococcus	1301	Bacteria	Bacteria	359	8.98e-95	NTclustered	gi\|2625184810\|dbj\|AP026968.1\|	2993430	g23852	i0	99.492	100	197	1	100	0	1	197	904803	904607	Streptococcus sp. SP4011 DNA, complete genome	blastn	19700	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus parapneumoniae
7103526	7103526	PRJNA745923_S_NODE_32726_length_166_cov_1.170732_g32394_i0	PRJNA745923	32726	166	1.170732	1.94341512	Lactobacillus iners	147802	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g32394	i0	100	13	166	0	100	0	1	166	1302998	1302833	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	2158	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
7576740	7576740	PRJNA745923_S_NODE_13206_length_280_cov_1.759494_g12874_i0	PRJNA745923	13206	280	1.759494	4.9265832	root	1	Root_unresolved	Root_unresolved	512	9.85e-141	NTclustered	gi\|1821622467\|dbj\|LC377539.1\|	1280	g12874	i0	99.643	116.017857142857	280	1	100	0	1	280	12113	12392	Staphylococcus aureus plasmid pNTUH_6457 NTUH_6457 DNA, complete sequence	blastn	32485	512	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8378163	8378163	PRJNA745923_S_NODE_31587_length_169_cov_1.523810_g31255_i0	PRJNA745923	31587	169	1.52381	2.5752389	Lactobacillus iners	147802	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|1818004205\|gb\|CP049228.1\|	147802	g31255	i0	100	12.603550295858	169	0	100	0	1	169	1165023	1165191	Lactobacillus iners strain C0210C1 chromosome, complete genome	blastn	2130	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
8851876	8851876	PRJNA745923_S_NODE_23407_length_200_cov_3.057325_g23075_i0	PRJNA745923	23407	200	3.057325	6.11465	Streptococcus	1301	Bacteria	Bacteria	370	4.22e-98	NTclustered	gi\|2886510793\|emb\|OZ217345.1\|	28037	g23075	i0	100	312	200	0	100	0	1	200	19737	19936	Streptococcus mitis isolate S. mitis F22 genome assembly, chromosome: 1	blastn	62400	370	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
9653040	9653040	PRJNA745923_S_NODE_15908_length_252_cov_1.837321_g15576_i0	PRJNA745923	15908	252	1.837321	4.63004892	Lactobacillus iners	147802	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g15576	i0	100	100.345238095238	252	0	100	0	1	252	1048566	1048315	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	25287	466	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
10928715	10928715	PRJNA745923_S_NODE_27529_length_183_cov_1.028571_g27197_i0	PRJNA745923	27529	183	1.028571	1.88228493	Lactobacillus iners	147802	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g27197	i0	100	13	183	0	100	0	1	183	892847	892665	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	2379	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
10928851	10928851	PRJNA745923_S_NODE_36509_length_156_cov_1.274336_g36177_i0	PRJNA745923	36509	156	1.274336	1.98796416	Lactobacillus iners	147802	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g36177	i0	100	99.5897435897436	156	0	100	0	1	156	419326	419481	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	15536	289	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
10928852	10928852	PRJNA745923_S_NODE_36709_length_155_cov_3.107143_g36377_i0	PRJNA745923	36709	155	3.107143	4.81607165	Streptococcus mitis	28037	Bacteria	Bacteria	254	3.25e-63	NTclustered	gi\|1851386209\|gb\|CP047883.1\|	28037	g36377	i0	97.945	31.6258064516129	146	3	94	0	1	146	1788604	1788749	Streptococcus mitis strain S022-V3-A4 chromosome, complete genome	blastn	4902	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
10928979	10928979	PRJNA745923_S_NODE_8309_length_364_cov_2.557632_g7977_i0	PRJNA745923	8309	364	2.557632	9.30978048	Lactobacillus iners	147802	Bacteria	Bacteria	671	0	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g7977	i0	100	84.7664835164835	363	0	99	0	2	364	357944	357582	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	30855	671	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
12204199	12204199	PRJNA745923_S_NODE_24570_length_195_cov_2.092105_g24238_i0	PRJNA745923	24570	195	2.092105	4.07960475	Lactobacillus iners	147802	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g24238	i0	98.974	99.6666666666667	195	2	100	0	1	195	1008667	1008473	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	19435	350	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
12204245	12204245	PRJNA745923_S_NODE_27510_length_183_cov_1.028571_g27178_i0	PRJNA745923	27510	183	1.028571	1.88228493	Lactobacillus iners	147802	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g27178	i0	100	13	183	0	100	0	1	183	358917	358735	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	2379	339	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
14753868	14753868	PRJNA745923_S_NODE_5592_length_462_cov_3.078759_g5265_i0	PRJNA745923	5592	462	3.078759	14.22386658	Lactobacillus iners	147802	Bacteria	Bacteria	848	0	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g5265	i0	99.784	98.7878787878788	462	1	100	0	1	462	1049692	1049231	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	45640	848	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
15227384	15227384	PRJNA745923_S_NODE_24812_length_194_cov_1.894040_g24480_i0	PRJNA745923	24812	194	1.89404	3.6744376	root	1	Root_unresolved	Root_unresolved	337	4.13e-88	NTclustered	gi\|2179631034\|gb\|CP090928.1\|	1282	g24480	i0	97.938	105.345360824742	194	4	100	0	1	194	1394	1201	Staphylococcus epidermidis strain 48 plasmid pSE48-4, complete sequence	blastn	20437	337	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17776650	17776650	PRJNA745923_S_NODE_32554_length_166_cov_2.186992_g32222_i0	PRJNA745923	32554	166	2.186992	3.63040672	Paenibacillus	44249	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1373996327\|gb\|CP028366.1\|	59843	g32222	i0	100	5.51807228915663	166	0	100	0	1	166	5377113	5377278	Paenibacillus glucanolyticus strain W10507 chromosome	blastn	916	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
18576309	18576309	PRJNA745923_S_NODE_18655_length_228_cov_3.027027_g18323_i0	PRJNA745923	18655	228	3.027027	6.90162156	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	145	1.6499999999999999e-38	NR	MBR5873559.1	2485925	g18323	i0	97.3	2.96052631578947	75	2	98.7	0	226	2	359	433	MBR5873559.1 bifunctional (p)ppGpp synthetase/guanosine-3',5'-bis(diphosphate) 3'-pyrophosphohydrolase [Oscillospiraceae bacterium]	diamond	675	145	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
18576311	18576311	PRJNA745923_S_NODE_18695_length_228_cov_2.075676_g18363_i0	PRJNA745923	18695	228	2.075676	4.73254128	Lactobacillus iners	147802	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g18363	i0	100	89.5745614035088	228	0	100	0	1	228	1047913	1048140	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	20423	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
21127295	21127295	PRJNA745923_S_NODE_23077_length_202_cov_1.207547_g22745_i0	PRJNA745923	23077	202	1.207547	2.43924494	Lactobacillus iners	147802	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|2769738725\|gb\|CP160077.1\|	147802	g22745	i0	99.505	12.0792079207921	202	1	100	0	1	202	1274740	1274539	Lactobacillus iners strain 0809_588_1_1_MRS1 chromosome, complete genome	blastn	2440	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
23677677	23677677	PRJNA745923_S_NODE_20899_length_214_cov_1.380117_g20567_i0	PRJNA745923	20899	214	1.380117	2.95345038	Lactobacillus iners	147802	Bacteria	Bacteria	396	7.559999999999996e-106	NTclustered	gi\|1818003035\|gb\|CP049230.1\|	147802	g20567	i0	100	52.8738317757009	214	0	100	0	1	214	578178	578391	Lactobacillus iners strain C0322A1 chromosome, complete genome	blastn	11315	396	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
24150561	24150561	PRJNA745923_S_NODE_39939_length_150_cov_4.616822_g39607_i0	PRJNA745923	39939	150	4.616822	6.925233	root	1	Root_unresolved	Root_unresolved	272	8.609999999999998e-69	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g39607	i0	99.333	100.886666666667	150	1	100	0	1	150	2730106	2729957	Staphylococcus aureus strain WH3018 chromosome	blastn	15133	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
24951165	24951165	PRJNA745923_S_NODE_19440_length_223_cov_1.333333_g19108_i0	PRJNA745923	19440	223	1.333333	2.97333259	Lactobacillus iners	147802	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|1818006880\|gb\|CP049225.1\|	147802	g19108	i0	100	18.0313901345291	223	0	100	0	1	223	508086	508308	Lactobacillus iners strain C0059G1 chromosome, complete genome	blastn	4021	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
24951508	24951508	PRJNA745923_S_NODE_7520_length_386_cov_1.381924_g7188_i0	PRJNA745923	7520	386	1.381924	5.33422664	Lactobacillus iners	147802	Bacteria	Bacteria	708	0	NTclustered	gi\|1810931560\|gb\|CP048798.1\|	147802	g7188	i0	99.742	11.979274611399	387	0	100	1	1	386	155481	155867	Lactobacillus iners strain KY chromosome, complete genome	blastn	4624	708	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
26609358	26609358	PRJNA745923_S_NODE_40521_length_150_cov_0.897196_g40189_i0	PRJNA745923	40521	150	0.897196	1.345794	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	76.6	7.32e-15	NR	MBR4989582.1	2485925	g40189	i0	91.1	1.8	45	4	90	0	148	14	293	337	MBR4989582.1 ABC transporter permease [Oscillospiraceae bacterium]	diamond	270	76.6	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
32044261	32044261	PRJNA745923_S_NODE_18558_length_229_cov_2.322581_g18226_i0	PRJNA745923	18558	229	2.322581	5.31871049	Lachnospiraceae bacterium	1898203	Bacteria	Bacteria	144	2.12e-39	NR	RKW55286.1	1898203	g18226	i0	97.3	0.982532751091703	75	2	98.3	0	227	3	27	101	RKW55286.1 MAG: pyrimidine-nucleoside phosphorylase [Lachnospiraceae bacterium]	diamond	225	144	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae		Lachnospiraceae bacterium
32360913	32360913	PRJNA745923_S_NODE_27659_length_182_cov_1.920863_g27327_i0	PRJNA745923	27659	182	1.920863	3.49597066	[Clostridium] innocuum	1522	Bacteria	Bacteria	42.4	0.0222	NR	WP_233106945.1	1522	g27327	i0	41.5	0.675824175824176	41	24	67.6	0	47	169	69	109	WP_233106945.1 isoaspartyl peptidase/L-asparaginase [[Clostridium] innocuum]	diamond	123	42.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	[Clostridium] innocuum

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