metadata: contig_metadata: 20 rows where bioproject = "PRJNA383995" and tax

20 rows where bioproject = "PRJNA383995" 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
1680108	1680108	PRJNA383995_P_NODE_18222_length_162_cov_0.902655_g18123_i0	PRJNA383995	18222	162	0.902655	1.4623011	Staphylococcus hominis	1290	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g18123	i0	100	27.3827160493827	162	0	100	0	1	162	99897	99736	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	4436	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
6178771	6178771	PRJNA383995_P_NODE_15485_length_167_cov_0.864407_g15386_i0	PRJNA383995	15485	167	0.864407	1.44355969	Streptococcus	1301	Bacteria	Bacteria	254	3.58e-63	NTclustered	gi\|1247204361\|gb\|CP023507.1\|	1303	g15386	i0	94.012	99.7664670658683	167	10	100	0	1	167	1751822	1751656	Streptococcus oralis strain FDAARGOS_367 chromosome, complete genome	blastn	16661	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
6782968	6782968	PRJNA383995_P_NODE_17706_length_163_cov_0.894737_g17607_i0	PRJNA383995	17706	163	0.894737	1.45842131	Streptococcus thermophilus	1308	Bacteria	Bacteria	112	5.08e-27	NR	TKW62483.1	1308	g17607	i0	100	1.98773006134969	54	0	99.4	0	1	162	550	603	TKW62483.1 MAG: hypothetical protein DI612_08705, partial [Streptococcus thermophilus]	diamond	324	112	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus thermophilus
8728460	8728460	PRJNA383995_P_NODE_1627_length_464_cov_1.563855_g1528_i0	PRJNA383995	1627	464	1.563855	7.2562872	Streptococcus	1301	Bacteria	Bacteria	852	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1528	i0	99.784	338	464	1	100	0	1	464	1570621	1570158	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	156832	857	0.99416569428238	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
8728474	8728474	PRJNA383995_P_NODE_4147_length_305_cov_1.128906_g4048_i0	PRJNA383995	4147	305	1.128906	3.4431633	Exiguobacterium	33986	Bacteria	Bacteria	551	2.2999999999999993e-152	NTclustered	gi\|2446540574\|gb\|CP118099.1\|	273528	g4048	i0	99.342	747.170491803279	304	2	99	0	1	304	386019	386322	Exiguobacterium marinum strain a-1 chromosome, complete genome	blastn	227887	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium marinum
10609050	10609050	PRJNA383995_P_NODE_12229_length_188_cov_1.158273_g12130_i0	PRJNA383995	12229	188	1.158273	2.17755324	Staphylococcus hominis	1290	Bacteria	Bacteria	346	6.6e-91	NTclustered	gi\|2669659999\|gb\|CP090011.1\|	1290	g12130	i0	100	463.797872340426	187	0	99	0	2	188	1539884	1540070	Staphylococcus hominis strain acrlg chromosome, complete genome	blastn	87194	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
10609071	10609071	PRJNA383995_P_NODE_18489_length_162_cov_0.902655_g18390_i0	PRJNA383995	18489	162	0.902655	1.4623011	Ruminococcus sp.	41978	Bacteria	Bacteria	237	3.47e-58	NTclustered	gi\|2189459107\|gb\|CP091720.1\|	41978	g18390	i0	93.21	27.9753086419753	162	10	100	1	1	162	383055	383215	MAG: Ruminococcus sp. isolate nC33_bin.6.fa chromosome	blastn	4532	237	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae	Ruminococcus	Ruminococcus sp.
11278995	11278995	PRJNA383995_P_NODE_11269_length_196_cov_0.870748_g11170_i0	PRJNA383995	11269	196	0.870748	1.70666608	Lactobacillus	1578	Bacteria	Bacteria	363	6.899999999999998e-96	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g11170	i0	100	426.05612244898	196	0	100	0	1	196	90717	90522	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	83507	363	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
12554449	12554449	PRJNA383995_P_NODE_8050_length_227_cov_1.342697_g7951_i0	PRJNA383995	8050	227	1.342697	3.04792219	Streptococcus	1301	Bacteria	Bacteria	377	2.9400000000000003e-100	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g7951	i0	96.903	339.68281938326	226	5	99	2	2	226	1568960	1568736	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	77108	377	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
13159002	13159002	PRJNA383995_P_NODE_18951_length_161_cov_0.910714_g18852_i0	PRJNA383995	18951	161	0.910714	1.46624954	Streptococcus oralis	1303	Bacteria	Bacteria	254	3.42e-63	NTclustered	gi\|326682110\|emb\|FR720602.1\|	927666	g18852	i0	95.57	24.3850931677019	158	7	98	0	4	161	1040699	1040542	Streptococcus oralis Uo5 complete genome sequence	blastn	3926	254	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
15103604	15103604	PRJNA383995_P_NODE_14912_length_169_cov_3.125000_g14813_i0	PRJNA383995	14912	169	3.125	5.28125	Lysinibacillus	400634	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2007734766\|gb\|CP071738.1\|	1421	g14813	i0	100	1025.12426035503	169	0	100	0	1	169	12458	12290	Lysinibacillus sphaericus strain BS-pTAND672-2 chromosome	blastn	173246	313	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Lysinibacillus	Lysinibacillus sphaericus
16982641	16982641	PRJNA383995_P_NODE_16154_length_166_cov_0.871795_g16055_i0	PRJNA383995	16154	166	0.871795	1.4471797	Staphylococcus cohnii	29382	Bacteria	Bacteria	298	1.62e-76	NTclustered	gi\|2624852950\|gb\|CP119997.1\|	29382	g16055	i0	100	7.59036144578313	161	0	97	0	6	166	290118	289958	Staphylococcus cohnii strain Dog166 chromosome, complete genome	blastn	1260	298	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus cohnii
16982651	16982651	PRJNA383995_P_NODE_18234_length_162_cov_0.902655_g18135_i0	PRJNA383995	18234	162	0.902655	1.4623011	Bacillus paralicheniformis	1648923	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2006893320\|dbj\|AP023090.1\|	1648923	g18135	i0	99.383	99.6481481481482	162	1	100	0	1	162	3044268	3044429	Bacillus paralicheniformis RSC-3 DNA, complete genome	blastn	16143	294	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus paralicheniformis
17653370	17653370	PRJNA383995_P_NODE_12974_length_183_cov_1.067164_g12875_i0	PRJNA383995	12974	183	1.067164	1.95291012	Streptococcus	1301	Bacteria	Bacteria	305	1.08e-78	NTclustered	gi\|2482045817\|gb\|CP121159.1\|	1311	g12875	i0	96.739	610.31693989071	184	5	100	1	1	183	93606	93789	Streptococcus agalactiae strain S1 chromosome, complete genome	blastn	111688	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus agalactiae
18927312	18927312	PRJNA383995_P_NODE_18515_length_162_cov_0.902655_g18416_i0	PRJNA383995	18515	162	0.902655	1.4623011	Lactobacillus	1578	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2096299657\|gb\|CP083392.1\|	47770	g18416	i0	100	584.759259259259	162	0	100	0	1	162	59085	59246	Lactobacillus crispatus strain Lc1226 chromosome, complete genome	blastn	94731	300	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus crispatus
27137919	27137919	PRJNA383995_P_NODE_16622_length_165_cov_0.879310_g16523_i0	PRJNA383995	16622	165	0.87931	1.4508615	Levyella massiliensis	938289	Bacteria	Bacteria	112	2.9e-28	NR	WP_019190309.1	938289	g16523	i0	96.3	0.981818181818182	54	2	98.2	0	3	164	116	169	WP_019190309.1 MaoC/PaaZ C-terminal domain-containing protein [Levyella massiliensis]	diamond	162	112	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales		Levyella	Levyella massiliensis
28085782	28085782	PRJNA383995_P_NODE_17645_length_163_cov_0.894737_g17546_i0	PRJNA383995	17645	163	0.894737	1.45842131	Mediannikoviicoccus vaginalis	2899727	Bacteria	Bacteria	92.4	3.82e-20	NR	WP_237036350.1	2899727	g17546	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	801	853	WP_237036350.1 DNA mismatch repair protein MutS [Mediannikoviicoccus vaginalis]	diamond	159	92.4	1	Bacteria	Bacillati	Bacillota	Clostridia	Peptostreptococcales	Peptostreptococcaceae	Mediannikoviicoccus	Mediannikoviicoccus vaginalis
28686007	28686007	PRJNA383995_P_NODE_16987_length_164_cov_0.939130_g16888_i0	PRJNA383995	16987	164	0.93913	1.5401732	Clostridiales bacterium	1898207	Bacteria	Bacteria	43.1	0.00941	NR	NLE68665.1	1898207	g16888	i0	51.4	0.676829268292683	37	15	67.7	1	3	113	97	130	NLE68665.1 hypothetical protein [Clostridiales bacterium]	diamond	111	43.1	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
30282037	30282037	PRJNA383995_P_NODE_17892_length_163_cov_0.894737_g17793_i0	PRJNA383995	17892	163	0.894737	1.45842131	Bacteria	2	Bacteria	Bacteria	106	7.45e-28	NR	MBN9993869.1	1639	g17793	i0	100	3.97546012269939	54	0	99.4	0	163	2	28	81	MBN9993869.1 hypothetical protein [Listeria monocytogenes]	diamond	648	106	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
30439808	30439808	PRJNA383995_P_NODE_18373_length_162_cov_0.902655_g18274_i0	PRJNA383995	18373	162	0.902655	1.4623011	Peptoniphilus	162289	Bacteria	Bacteria	109	7e-27	NR	WP_316714872.1	1175452	g18274	i0	100	1.96296296296296	53	0	98.1	0	3	161	305	357	WP_316714872.1 Na+/H+ antiporter NhaC family protein, partial [Peptoniphilus rhinitidis]	diamond	318	109	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus rhinitidis

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