metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA734313" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA734313" 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
3268027	3268027	PRJNA734313_S_NODE_30183_length_168_cov_1.264463_g30070_i0	PRJNA734313	30183	168	1.264463	2.12429784	Lactobacillus iners	147802	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g30070	i0	100	503.559523809524	168	0	100	0	1	168	380763	380596	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	84598	311	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
8369999	8369999	PRJNA734313_S_NODE_20927_length_204_cov_1.242038_g20814_i0	PRJNA734313	20927	204	1.242038	2.53375752	Streptococcus koreensis	2382163	Bacteria	Bacteria	331	2.04e-86	NTclustered	gi\|1487524770\|gb\|CP032620.1\|	2382163	g20814	i0	98.925	373.759803921569	186	1	91	1	1	186	67769	67953	Streptococcus koreensis strain JS71 chromosome, complete genome	blastn	76247	331	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus koreensis
8370001	8370001	PRJNA734313_S_NODE_21447_length_201_cov_1.655844_g21334_i0	PRJNA734313	21447	201	1.655844	3.32824644	Peptoniphilus harei	54005	Bacteria	Bacteria	333	5.569999999999999e-87	NTclustered	gi\|1958280563\|gb\|CP068103.1\|	54005	g21334	i0	96.535	485.557213930348	202	6	100	1	1	201	600927	601128	Peptoniphilus harei strain FDAARGOS_1136 chromosome, complete genome	blastn	97597	333	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Peptoniphilus	Peptoniphilus harei
8370010	8370010	PRJNA734313_S_NODE_35387_length_159_cov_1.339286_g35274_i0	PRJNA734313	35387	159	1.339286	2.12946474	Parvimonas micra	33033	Bacteria	Bacteria	289	9.22e-74	NTclustered	gi\|2418006839\|gb\|CP101410.1\|	33033	g35274	i0	100	498.503144654088	156	0	100	0	4	159	314133	313978	Parvimonas micra strain PM89KC-G-2 chromosome, complete genome	blastn	79262	289	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Parvimonas	Parvimonas micra
10920645	10920645	PRJNA734313_S_NODE_13069_length_260_cov_1.676056_g12956_i0	PRJNA734313	13069	260	1.676056	4.3577456	Lactobacillus iners	147802	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2769739957\|gb\|CP160078.1\|	147802	g12956	i0	100	524	260	0	100	0	1	260	3160	2901	Lactobacillus iners strain 0998_735_1_CBA_90B_S800 chromosome, complete genome	blastn	136240	481	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus iners
12196031	12196031	PRJNA734313_S_NODE_16910_length_228_cov_1.127072_g16797_i0	PRJNA734313	16910	228	1.127072	2.56972416	Staphylococcus epidermidis	1282	Bacteria	Bacteria	422	1.34e-113	NTclustered	gi\|2536852070\|gb\|CP129374.1\|	1282	g16797	i0	100	99.9912280701754	228	0	100	0	1	228	1205465	1205238	Staphylococcus epidermidis strain CSMH-411EB chromosome, complete genome	blastn	22798	422	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
12196034	12196034	PRJNA734313_S_NODE_18270_length_219_cov_1.186047_g18157_i0	PRJNA734313	18270	219	1.186047	2.59744293	Nosocomiicoccus massiliensis	1232430	Bacteria	Bacteria	198	2.35e-46	NTclustered	gi\|2612677914\|gb\|CP136964.1\|	1232430	g18157	i0	83.105	77.7351598173516	219	35	99	2	1	218	139433	139216	Nosocomiicoccus massiliensis strain UMB0959 chromosome, complete genome	blastn	17024	198	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Nosocomiicoccus	Nosocomiicoccus massiliensis
12196052	12196052	PRJNA734313_S_NODE_7290_length_341_cov_1.292517_g7177_i0	PRJNA734313	7290	341	1.292517	4.40748297	Paenibacillus sp. HWE-109	1306526	Bacteria	Bacteria	580	3.319999999999999e-161	NTclustered	gi\|2191894512\|gb\|CP091881.1\|	1306526	g7177	i0	99.375	972.50146627566	320	2	94	0	22	341	7633397	7633078	Paenibacillus sp. HWE-109 chromosome	blastn	331623	580	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. HWE-109
16499769	16499769	PRJNA734313_S_NODE_16013_length_235_cov_1.143617_g15900_i0	PRJNA734313	16013	235	1.143617	2.68749995	Bacillati	1783272	Bacteria	Bacteria	435	1.79e-117	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g15900	i0	100	518.56170212766	235	0	100	0	1	235	748658	748892	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	121862	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
21598946	21598946	PRJNA734313_S_NODE_29897_length_169_cov_1.155738_g29784_i0	PRJNA734313	29897	169	1.155738	1.95319722	Streptococcus	1301	Bacteria	Bacteria	231	1.6899999999999998e-56	NTclustered	gi\|1782758915\|gb\|CP018189.1\|	1304	g29784	i0	94.667	510.568047337278	150	6	88	2	1	148	17717	17866	Streptococcus salivarius strain ICDC3 chromosome, complete genome	blastn	86286	233	0.991416309012876	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus salivarius
24148385	24148385	PRJNA734313_S_NODE_23939_length_190_cov_1.426573_g23826_i0	PRJNA734313	23939	190	1.426573	2.7104887	Streptococcus	1301	Bacteria	Bacteria	346	6.690000000000001e-91	NTclustered	gi\|2179903814\|gb\|CP046525.1\|	68892	g23826	i0	99.474	99.6052631578947	190	1	100	0	1	190	1501332	1501521	Streptococcus infantis strain SO chromosome, complete genome	blastn	18925	346	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus infantis
24148387	24148387	PRJNA734313_S_NODE_27279_length_177_cov_1.569231_g27166_i0	PRJNA734313	27279	177	1.569231	2.77753887	Abiotrophia	46123	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|1848537030\|gb\|CP053988.1\|	46125	g27166	i0	97.74	2	177	4	100	0	1	177	351544	351720	Abiotrophia defectiva strain FDAARGOS_785 chromosome, complete genome	blastn	354	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Abiotrophia	Abiotrophia defectiva

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