metadata: contig_metadata: 13 rows where bioproject = "PRJNA657860" and tax

13 rows where bioproject = "PRJNA657860" 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
625427	625427	PRJNA657860_P_NODE_1741_length_239_cov_1.460396_g1685_i0	PRJNA657860	1741	239	1.460396	3.49034644	Ezakiella coagulans	46507	Bacteria	Bacteria	431	2.3599999999999996e-116	NTclustered	gi\|2238283248\|gb\|CP096650.1\|	46507	g1685	i0	99.163	369.585774058577	239	2	100	0	1	239	158431	158669	Ezakiella coagulans strain C0061C1 chromosome, complete genome	blastn	88331	431	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
4989691	4989691	PRJNA657860_P_NODE_2044_length_213_cov_1.829545_g1988_i0	PRJNA657860	2044	213	1.829545	3.89693085	root	1	Root_unresolved	Root_unresolved	388	1.26e-103	NTclustered	gi\|2264785169\|dbj\|LC717921.1\|	46507	g1988	i0	99.531	100	213	1	100	0	1	213	46	258	Ezakiella coagulans JCM:35485 gene for 16S rRNA, partial sequence	blastn	21300	388	1	Bacteria	Bacillati	Bacillota	Tissierellia			Ezakiella	Ezakiella coagulans
7004043	7004043	PRJNA657860_P_NODE_2306_length_198_cov_1.440994_g2250_i0	PRJNA657860	2306	198	1.440994	2.85316812	Veillonella rogosae	423477	Bacteria	Bacteria	278	2.6e-70	NTclustered	gi\|2326448795\|gb\|CP110418.1\|	423477	g2250	i0	91.919	386.954545454545	198	16	100	0	1	198	97740	97543	Veillonella rogosae strain KCOM 3468 chromosome, complete genome	blastn	76617	278	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
10090007	10090007	PRJNA657860_P_NODE_1928_length_223_cov_1.639785_g1872_i0	PRJNA657860	1928	223	1.639785	3.65672055	root	1	Root_unresolved	Root_unresolved	412	7.88e-111	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g1872	i0	100	59.6681614349776	223	0	100	0	1	223	2681340	2681118	Staphylococcus aureus strain WH3018 chromosome	blastn	13306	412	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
10090008	10090008	PRJNA657860_P_NODE_2188_length_205_cov_1.333333_g2132_i0	PRJNA657860	2188	205	1.333333	2.73333265	Lachnospirales	3085636	Bacteria	Bacteria	255	1.27e-63	NTclustered	gi\|2127621832\|gb\|CP085930.1\|	411474	g2132	i0	89.423	483.453658536585	208	15	100	6	1	205	1969978	1969775	Coprococcus eutactus ATCC 27759 strain FDAARGOS_1581 chromosome, complete genome	blastn	99108	257	0.992217898832685	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Coprococcus	Coprococcus eutactus
10090009	10090009	PRJNA657860_P_NODE_2868_length_175_cov_1.144928_g2812_i0	PRJNA657860	2868	175	1.144928	2.003624	Finegoldia	150022	Bacteria	Bacteria	305	1.02e-78	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g2812	i0	98.276	117.6	174	3	99	0	2	175	873431	873604	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	20580	305	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
13915405	13915405	PRJNA657860_P_NODE_731_length_391_cov_8.257062_g675_i0	PRJNA657860	731	391	8.257062	32.28511242	Bacillales	1385	Bacteria	Bacteria	529	1.4199999999999994e-145	NTclustered	gi\|2717532442\|gb\|CP121242.2\|	1280	g675	i0	91.26	648.414322250639	389	32	100	2	4	391	480305	479918	Staphylococcus aureus strain ID029 chromosome, complete genome	blastn	253530	534	0.99063670411985	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
16464221	16464221	PRJNA657860_P_NODE_713_length_397_cov_3.186111_g657_i0	PRJNA657860	713	397	3.186111	12.64886067	Lactobacillus	1578	Bacteria	Bacteria	728	0	NTclustered	gi\|2913931147\|gb\|CP181267.1\|	1584	g657	i0	99.748	542.395465994962	397	1	100	0	1	397	525202	524806	MAG: Lactobacillus delbrueckii isolate UW_FK_LACTO1_1 chromosome	blastn	215331	734	0.991825613079019	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
20287729	20287729	PRJNA657860_P_NODE_2256_length_200_cov_5.815951_g2200_i0	PRJNA657860	2256	200	5.815951	11.631902	Staphylococcus	1279	Bacteria	Bacteria	355	1.18e-93	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g2200	i0	98.99	99	198	2	99	0	3	200	2095143	2094946	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	19800	355	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
21563365	21563365	PRJNA657860_P_NODE_777_length_377_cov_7.052941_g721_i0	PRJNA657860	777	377	7.052941	26.58958757	Bacillati	1783272	Bacteria	Bacteria	697	0	NTclustered	gi\|2784030803\|gb\|CP163515.1\|	1601	g721	i0	100	602.018567639257	377	0	100	0	1	377	1653342	1653718	Ligilactobacillus agilis strain W70 chromosome, complete genome	blastn	226961	697	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus agilis
22302743	22302743	PRJNA657860_P_NODE_3818_length_150_cov_1.017699_g3762_i0	PRJNA657860	3818	150	1.017699	1.5265485	Staphylococcus epidermidis	1282	Bacteria	Bacteria	272	8.609999999999998e-69	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g3762	i0	99.333	100	150	1	100	0	1	150	283657	283806	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	15000	272	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
23578110	23578110	PRJNA657860_P_NODE_3719_length_152_cov_1.321739_g3663_i0	PRJNA657860	3719	152	1.321739	2.00904328	Anaerococcus nagyae	1755241	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|2722731751\|dbj\|AP031484.1\|	1755241	g3663	i0	100	1	152	0	100	0	1	152	1513301	1513452	Anaerococcus nagyae NBRC 113824 DNA, complete genome: sequence1	blastn	152	281	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus nagyae
24851705	24851705	PRJNA657860_P_NODE_3340_length_161_cov_1.516129_g3284_i0	PRJNA657860	3340	161	1.516129	2.44096769	Weissella cibaria	137591	Bacteria	Bacteria	292	7.24e-75	NTclustered	gi\|2804422573\|gb\|CP169283.1\|	137591	g3284	i0	99.379	518.950310559006	161	1	100	0	1	161	741344	741504	Weissella cibaria strain ZJU.1 chromosome, complete genome	blastn	83551	292	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria

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