metadata: contig_metadata: 19 rows where bioproject = "PRJNA998413" and tax

19 rows where bioproject = "PRJNA998413" 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
979193	979193	PRJNA998413_S_NODE_5021_length_274_cov_1.270142_g4990_i0	PRJNA998413	5021	274	1.270142	3.48018908	Paenibacillus sp. Cedars	1980674	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|1394605008\|gb\|CP020866.1\|	1980674	g4990	i0	100	16.3503649635037	274	0	100	0	1	274	5427441	5427714	Paenibacillus sp. Cedars chromosome, complete genome	blastn	4480	507	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. Cedars
1273994	1273994	PRJNA998413_S_NODE_9841_length_223_cov_1.675000_g9810_i0	PRJNA998413	9841	223	1.675	3.73525	Staphylococcus	1279	Bacteria	Bacteria	412	7.88e-111	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g9810	i0	100	84.7399103139013	223	0	100	0	1	223	1586199	1585977	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	18897	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
3825926	3825926	PRJNA998413_S_NODE_5203_length_271_cov_1.865385_g5172_i0	PRJNA998413	5203	271	1.865385	5.05519335	root	1	Root_unresolved	Root_unresolved	501	2.05e-137	NTclustered	gi\|1796975023\|gb\|CP033086.1\|	1280	g5172	i0	100	101.80442804428	271	0	100	0	1	271	2411010	2410740	Staphylococcus aureus strain WH9628 chromosome	blastn	27589	501	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
4807171	4807171	PRJNA998413_S_NODE_7824_length_240_cov_1.497175_g7793_i0	PRJNA998413	7824	240	1.497175	3.59322	Granulicatella elegans	137732	Bacteria	Bacteria	333	6.88e-87	NTclustered	gi\|2127543886\|gb\|CP085953.1\|	137732	g7793	i0	91.667	1	240	20	100	0	1	240	1840855	1841094	Granulicatella elegans strain FDAARGOS_1559 chromosome, complete genome	blastn	240	333	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Granulicatella	Granulicatella elegans
7356909	7356909	PRJNA998413_S_NODE_9326_length_227_cov_2.158537_g9295_i0	PRJNA998413	9326	227	2.158537	4.89987899	Anaerococcus mediterraneensis	1870984	Bacteria	Bacteria	396	8.109999999999997e-106	NTclustered	gi\|1105524756\|emb\|LT635772.1\|	1870984	g9295	i0	98.655	316.823788546256	223	3	98	0	1	223	437233	437455	Anaerococcus sp. Marseille-P2765 strain Marseille-P2765T genome assembly, chromosome: contig00001	blastn	71919	396	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus mediterraneensis
7652015	7652015	PRJNA998413_S_NODE_13226_length_209_cov_1.376712_g13195_i0	PRJNA998413	13226	209	1.376712	2.87732808	Streptococcus	1301	Bacteria	Bacteria	307	3.54e-79	NTclustered	gi\|1943211519\|gb\|CP065707.1\|	1303	g13195	i0	93.269	34.7751196172249	208	14	99	0	1	208	1512426	1512219	Streptococcus oralis strain FDAARGOS_885 chromosome, complete genome	blastn	7268	307	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
11477756	11477756	PRJNA998413_S_NODE_6109_length_258_cov_1.676923_g6078_i0	PRJNA998413	6109	258	1.676923	4.32646134	Anaerococcus	165779	Bacteria	Bacteria	405	1.56e-108	NTclustered	gi\|1374529452\|ref\|NR_076129.2\|	33034	g6078	i0	94.981	161.589147286822	259	11	100	2	1	258	782	525	Anaerococcus prevotii strain DSM 20548 23S ribosomal RNA, complete sequence	blastn	41690	405	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus prevotii
18830901	18830901	PRJNA998413_S_NODE_14115_length_198_cov_2.481481_g14084_i0	PRJNA998413	14115	198	2.481481	4.91333238	Roseburia rectibacter	2763062	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2206258461\|gb\|CP092473.1\|	2763062	g14084	i0	96.97	0.166666666666667	33	1	17	0	143	175	2892662	2892630	Roseburia rectibacter strain NSJ-69 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Roseburia	Roseburia rectibacter
20400350	20400350	PRJNA998413_S_NODE_3316_length_311_cov_2.463710_g3285_i0	PRJNA998413	3316	311	2.46371	7.6621381	Staphylococcus	1279	Bacteria	Bacteria	575	1.3899999999999995e-159	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3285	i0	100	100	311	0	100	0	1	311	1695894	1695584	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	31100	575	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
20400364	20400364	PRJNA998413_S_NODE_9856_length_223_cov_1.462500_g9825_i0	PRJNA998413	9856	223	1.4625	3.261375	Streptococcus	1301	Bacteria	Bacteria	398	2.21e-106	NTclustered	gi\|2179901676\|gb\|CP046524.1\|	1303	g9825	i0	99.541	320.645739910314	218	1	98	0	1	218	18381	18598	Streptococcus oralis strain SOT chromosome, complete genome	blastn	71504	398	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22951686	22951686	PRJNA998413_S_NODE_13198_length_209_cov_1.465753_g13167_i0	PRJNA998413	13198	209	1.465753	3.06342377	Jeotgalicoccus sp.	1871619	Bacteria	Bacteria	121	4.75e-30	NR	MDO5360476.1	1871619	g13167	i0	91	1.92344497607656	67	6	96.2	0	2	202	519	585	MDO5360476.1 valine--tRNA ligase [Jeotgalicoccus sp.]	diamond	402	121	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Jeotgalicoccus	Jeotgalicoccus sp.
23931652	23931652	PRJNA998413_S_NODE_9319_length_227_cov_2.451220_g9288_i0	PRJNA998413	9319	227	2.45122	5.5642694	Staphylococcus epidermidis	1282	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|1214725545\|gb\|CP022247.1\|	1282	g9288	i0	100	100.63436123348	227	0	100	0	1	227	1909417	1909643	Staphylococcus epidermidis strain AMT chromosome, complete genome	blastn	22844	420	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
25205350	25205350	PRJNA998413_S_NODE_7700_length_241_cov_2.084270_g7669_i0	PRJNA998413	7700	241	2.08427	5.0230907	Streptococcus pneumoniae	1313	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|404276812\|emb\|HE983624.1\|	869309	g7669	i0	100	316	241	0	100	0	1	241	18459	18699	Streptococcus pneumoniae SPNA45, complete genome	blastn	76156	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus pneumoniae
28289692	28289692	PRJNA998413_S_NODE_11506_length_215_cov_0.881579_g11475_i0	PRJNA998413	11506	215	0.881579	1.89539485	Clostridia bacterium	2044939	Bacteria	Bacteria	122	4.639999999999999e-32	NR	HZK38628.1	2044939	g11475	i0	78.9	0.990697674418605	71	15	99.1	0	1	213	42	112	HZK38628.1 site-specific DNA-methyltransferase [Clostridia bacterium]	diamond	213	122	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
31290313	31290313	PRJNA998413_S_NODE_12635_length_211_cov_0.905405_g12604_i0	PRJNA998413	12635	211	0.905405	1.91040455	Atopostipes sp.	1872652	Bacteria	Bacteria	137	5.38e-39	NR	HZK47199.1	1872652	g12604	i0	98.6	0.995260663507109	70	1	99.5	0	2	211	84	153	HZK47199.1 YpmS family protein [Atopostipes sp.]	diamond	210	137	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Carnobacteriaceae	Atopostipes	Atopostipes sp.
31796306	31796306	PRJNA998413_S_NODE_10057_length_222_cov_1.264151_g10026_i0	PRJNA998413	10057	222	1.264151	2.80641522	Clostridiales bacterium	1898207	Bacteria	Bacteria	138	1.62e-38	NR	MDD6563989.1	1898207	g10026	i0	100	0.932432432432432	69	0	93.2	0	15	221	1	69	MDD6563989.1 GyrI-like domain-containing protein [Clostridiales bacterium]	diamond	207	138	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales			Clostridiales bacterium
32397817	32397817	PRJNA998413_S_NODE_13359_length_209_cov_0.917808_g13328_i0	PRJNA998413	13359	209	0.917808	1.91821872	Paenibacillus glucanolyticus	59843	Bacteria	Bacteria	91.3	2.58e-20	NR	WP_127502923.1	59843	g13328	i0	95.7	1.32057416267943	46	2	66	0	70	207	1	46	WP_127502923.1 type II toxin-antitoxin system PemK/MazF family toxin [Paenibacillus glucanolyticus]	diamond	276	91.3	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus glucanolyticus
32870773	32870773	PRJNA998413_S_NODE_12620_length_211_cov_1.067568_g12589_i0	PRJNA998413	12620	211	1.067568	2.25256848	Clostridia bacterium	2044939	Bacteria	Bacteria	42.7	0.0209	NR	MBQ9849133.1	2044939	g12589	i0	42.9	0.696682464454976	49	27	69.7	1	207	61	6	53	MBQ9849133.1 undecaprenyl diphosphate synthase family protein [Clostridia bacterium]	diamond	147	42.7	1	Bacteria	Bacillati	Bacillota	Clostridia				Clostridia bacterium
32876575	32876575	PRJNA998413_S_NODE_6860_length_250_cov_1.074866_g6829_i0	PRJNA998413	6860	250	1.074866	2.687165	Lactobacillaceae	33958	Bacteria	Bacteria	58.2	9.53e-9	NR	WP_270223814.1	1579	g6829	i0	40.2	2.952	82	47	98.4	1	248	3	4	83	WP_270223814.1 transposase, partial [Lactobacillus acidophilus]	diamond	738	58.2	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus acidophilus

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