metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA407087" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA407087" 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
1081721	1081721	PRJNA407087_S_NODE_7521_length_177_cov_5.324324_g7058_i0	PRJNA407087	7521	177	5.324324	9.42405348	root	1	Root_unresolved	Root_unresolved	327	2.2199999999999996e-85	NTclustered	gi\|2301668455\|gb\|OP432291.1\|	29466	g7058	i0	100	100	177	0	100	0	1	177	879	703	Veillonella parvula strain Granada 16S ribosomal RNA gene, partial sequence	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
4909639	4909639	PRJNA407087_S_NODE_2204_length_438_cov_15.567237_g1744_i0	PRJNA407087	2204	438	15.567237	68.18449806	Streptococcus	1301	Bacteria	Bacteria	787	0	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g1744	i0	99.087	328.799086757991	438	4	100	0	1	438	17669	18106	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	144014	793	0.992433795712484	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
6792704	6792704	PRJNA407087_S_NODE_8166_length_168_cov_4.992806_g7703_i0	PRJNA407087	8166	168	4.992806	8.38791408	Gemella haemolysans	1379	Bacteria	Bacteria	305	9.81e-79	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g7703	i0	99.405	356.916666666667	168	1	100	0	1	168	9597	9764	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	59962	305	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
11284952	11284952	PRJNA407087_S_NODE_7529_length_177_cov_3.891892_g7066_i0	PRJNA407087	7529	177	3.891892	6.88864884	root	1	Root_unresolved	Root_unresolved	327	2.2199999999999996e-85	NTclustered	gi\|285796811\|gb\|GU406793.1\|	29466	g7066	i0	100	100	177	0	100	0	1	177	193	17	Veillonella parvula clone GZ070 16S ribosomal RNA gene, partial sequence	blastn	17700	327	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
13835171	13835171	PRJNA407087_S_NODE_7991_length_170_cov_102.446809_g7528_i0	PRJNA407087	7991	170	102.446809	174.1595753	Listeria	1637	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|2885371214\|gb\|PQ865990.1\|	1639	g7528	i0	99.412	200.017647058824	170	1	100	0	1	170	760	929	Listeria monocytogenes isolate Hass-Sheep isolate 2 16S ribosomal RNA gene, partial sequence	blastn	34003	309	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Listeriaceae	Listeria	Listeria monocytogenes
15109407	15109407	PRJNA407087_S_NODE_5752_length_211_cov_36.829670_g5289_i0	PRJNA407087	5752	211	36.82967	77.7106037	Bacillati	1783272	Bacteria	Bacteria	368	1.6200000000000002e-97	NTclustered	gi\|1821213578\|gb\|CP043788.1\|	1282	g5289	i0	98.104	497.644549763033	211	4	100	0	1	211	1521660	1521870	Staphylococcus epidermidis strain SESURV_p2_0614 chromosome	blastn	105003	368	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
17659226	17659226	PRJNA407087_S_NODE_9214_length_157_cov_3.265625_g8751_i0	PRJNA407087	9214	157	3.265625	5.12703125	Veillonella	29465	Bacteria	Bacteria	285	1.17e-72	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g8751	i0	99.363	494.821656050955	157	1	100	0	1	157	2053	1897	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	77687	285	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula
20207835	20207835	PRJNA407087_S_NODE_1916_length_478_cov_34.730512_g1284_i1	PRJNA407087	1916	478	34.730512	166.01184736	Bacteria	2	Bacteria	Bacteria	833	0	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g1284	i1	98.117	462.949790794979	478	9	100	0	1	478	1128437	1128914	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	221290	833	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
20816619	20816619	PRJNA407087_S_NODE_6757_length_190_cov_6.751553_g6294_i0	PRJNA407087	6757	190	6.751553	12.8279507	Gemella haemolysans	1379	Bacteria	Bacteria	302	1.47e-77	NTclustered	gi\|1540173839\|emb\|LR134484.1\|	1379	g6294	i0	95.263	410.863157894737	190	9	100	0	1	190	10086	10275	Gemella haemolysans strain NCTC10459 genome assembly, chromosome: 1	blastn	78064	302	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Gemellaceae	Gemella	Gemella haemolysans
21483370	21483370	PRJNA407087_S_NODE_1717_length_508_cov_46.306889_g1284_i0	PRJNA407087	1717	508	46.306889	235.23899612	Bacteria	2	Bacteria	Bacteria	939	0	NTclustered	gi\|1848626851\|gb\|CP054017.1\|	1292	g1284	i0	100	483.663385826772	508	0	100	0	1	508	1128914	1128407	Staphylococcus warneri strain FDAARGOS_754 chromosome, complete genome	blastn	245701	939	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
21483371	21483371	PRJNA407087_S_NODE_1837_length_491_cov_20.402597_g1398_i0	PRJNA407087	1837	491	20.402597	100.17675127	Streptococcus	1301	Bacteria	Bacteria	880	0	NTclustered	gi\|1140122741\|gb\|CP019562.1\|	1303	g1398	i0	98.982	345.075356415479	491	5	100	0	1	491	1571101	1571591	Streptococcus oralis strain S.MIT/ORALIS-351 chromosome, complete genome	blastn	169432	885	0.994350282485876	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
22758597	22758597	PRJNA407087_S_NODE_4418_length_258_cov_6.462882_g3955_i0	PRJNA407087	4418	258	6.462882	16.67423556	Staphylococcus	1279	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2894814215\|gb\|CP178526.1\|	1292	g3955	i0	100	99.7286821705426	258	0	100	0	1	258	2216266	2216009	Staphylococcus warneri strain X5R13 chromosome, complete genome	blastn	25730	477	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
24641406	24641406	PRJNA407087_S_NODE_8200_length_168_cov_2.604317_g7737_i0	PRJNA407087	8200	168	2.604317	4.37525256	Solibacillus sp. FSL W8-0372	2921713	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2709615959\|gb\|CP150204.1\|	2921713	g7737	i0	100	0.166666666666667	28	0	17	0	90	117	873214	873187	Solibacillus sp. FSL W8-0372 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Caryophanaceae	Solibacillus	Solibacillus sp. FSL W8-0372
24641414	24641414	PRJNA407087_S_NODE_9820_length_152_cov_1.878049_g9357_i0	PRJNA407087	9820	152	1.878049	2.85463448	Anaerocolumna sedimenticola	2696063	Bacteria	Bacteria	143	7.17e-30	NTclustered	gi\|1802166926\|gb\|CP048000.1\|	2696063	g9357	i0	86.822	422.907894736842	129	15	85	1	10	138	1199529	1199655	Anaerocolumna sedimenticola strain CBA3638 chromosome, complete genome	blastn	64282	143	1	Bacteria	Bacillati	Bacillota	Clostridia	Lachnospirales	Lachnospiraceae	Anaerocolumna	Anaerocolumna sedimenticola
25307795	25307795	PRJNA407087_S_NODE_5560_length_216_cov_3.957219_g5097_i0	PRJNA407087	5560	216	3.957219	8.54759304	Veillonella	29465	Bacteria	Bacteria	385	1.65e-102	NTclustered	gi\|2672138803\|gb\|CP138632.1\|	29466	g5097	i0	99.065	535.388888888889	214	2	99	0	3	216	886142	886355	Veillonella parvula strain PK1910 chromosome, complete genome	blastn	115644	385	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella parvula

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