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

15 rows where analysis = "blastn", bioproject = "PRJNA1102048" 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
2762404	2762404	PRJNA1102048_P_NODE_13883_length_249_cov_0.875000_g13779_i0	PRJNA1102048	13883	249	0.875	2.17875	Lactobacillus johnsonii	33959	Bacteria	Bacteria	444	3.18e-120	NTclustered	gi\|1785991537\|gb\|CP039261.1\|	33959	g13779	i0	98.8	24.8032128514056	250	2	100	1	1	249	473107	472858	Lactobacillus johnsonii strain DC22.2 chromosome, complete genome	blastn	6176	444	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus johnsonii
4038428	4038428	PRJNA1102048_P_NODE_11364_length_263_cov_3.436842_g11260_i0	PRJNA1102048	11364	263	3.436842	9.03889446	Aerococcus viridans	1377	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|984726517\|gb\|CP014164.1\|	1377	g11260	i0	100	470.699619771863	263	0	100	0	1	263	565794	566056	Aerococcus viridans strain CCUG4311, complete genome	blastn	123794	486	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Aerococcaceae	Aerococcus	Aerococcus viridans
4848021	4848021	PRJNA1102048_P_NODE_10784_length_269_cov_3.005102_g10680_i0	PRJNA1102048	10784	269	3.005102	8.08372438	Anoxybacillus	150247	Bacteria	Bacteria	497	2.63e-136	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g10680	i0	100	872.349442379182	269	0	100	0	1	269	1490587	1490855	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	234662	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus
4848048	4848048	PRJNA1102048_P_NODE_1864_length_588_cov_1.433010_g1763_i0	PRJNA1102048	1864	588	1.43301	8.4260988	Staphylococcus	1279	Bacteria	Bacteria	1027	0	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g1763	i0	99.297	523.58843537415	569	2	97	2	1	568	2278276	2277709	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	307870	1027	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
7397813	7397813	PRJNA1102048_P_NODE_8906_length_291_cov_1.412844_g8802_i0	PRJNA1102048	8906	291	1.412844	4.11137604	Streptococcus	1301	Bacteria	Bacteria	529	1.0199999999999996e-145	NTclustered	gi\|1957483218\|gb\|CP067992.1\|	28037	g8802	i0	99.654	318.945017182131	289	1	99	0	3	291	18632	18344	Streptococcus mitis strain S022-V7-A3 chromosome, complete genome	blastn	92813	529	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus mitis
7864413	7864413	PRJNA1102048_P_NODE_14627_length_247_cov_0.885057_g14523_i0	PRJNA1102048	14627	247	0.885057	2.18609079	Peribacillus muralis	264697	Bacteria	Bacteria	117	7.810000000000001e-22	NTclustered	gi\|2814322198\|gb\|CP048037.1\|	264697	g14523	i0	83.721	19.8259109311741	129	15	51	5	115	240	2058471	2058346	Peribacillus muralis strain A03 chromosome	blastn	4897	117	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Peribacillus	Peribacillus muralis
8673228	8673228	PRJNA1102048_P_NODE_13107_length_250_cov_0.870056_g13003_i0	PRJNA1102048	13107	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g13003	i0	100	100	250	0	100	0	1	250	1646481	1646730	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	25000	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
10415192	10415192	PRJNA1102048_P_NODE_8809_length_293_cov_1.018182_g8705_i0	PRJNA1102048	8809	293	1.018182	2.98327326	Metallumcola ferriviriculae	3039180	Bacteria	Bacteria	65.8	3.49e-6	NTclustered	gi\|2646708121\|gb\|CP121694.1\|	3039180	g8705	i0	93.333	27.3003412969283	45	1	15	1	160	202	134106	134062	Metallumcola ferriviriculae strain MK1 chromosome, complete genome	blastn	7999	65.8	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Desulfitibacteraceae	Metallumcola	Metallumcola ferriviriculae
11690380	11690380	PRJNA1102048_P_NODE_11410_length_263_cov_1.452632_g11306_i0	PRJNA1102048	11410	263	1.452632	3.82042216	Paenibacillus sp. FSL K6-2441	2954679	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|2709489395\|gb\|CP150174.1\|	2954679	g11306	i0	99.24	1	263	2	100	0	1	263	2128139	2127877	Paenibacillus sp. FSL K6-2441 chromosome, complete genome	blastn	263	475	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Paenibacillaceae	Paenibacillus	Paenibacillus sp. FSL K6-2441
11690460	11690460	PRJNA1102048_P_NODE_4650_length_396_cov_1.452012_g4546_i0	PRJNA1102048	4650	396	1.452012	5.74996752	Oceanobacillus sp. FSL W7-1281	2921698	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2709665368\|gb\|CP150214.1\|	2921698	g4546	i0	100	0.0707070707070707	28	0	7	0	64	91	1304867	1304840	Oceanobacillus sp. FSL W7-1281 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Oceanobacillus	Oceanobacillus sp. FSL W7-1281
14240485	14240485	PRJNA1102048_P_NODE_16932_length_242_cov_1.727811_g16828_i0	PRJNA1102048	16932	242	1.727811	4.18130262	Staphylococcus agnetis	985762	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1822095818\|gb\|CP045927.1\|	985762	g16828	i0	100	0.119834710743802	29	0	12	0	88	116	758689	758717	Staphylococcus agnetis strain 1379 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus agnetis
15514381	15514381	PRJNA1102048_P_NODE_18093_length_232_cov_2.503145_g17989_i0	PRJNA1102048	18093	232	2.503145	5.8072964	Staphylococcus haemolyticus	1283	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1347519301\|gb\|CP025031.1\|	1283	g17989	i0	100	0.241379310344828	28	0	12	0	4	31	563067	563040	Staphylococcus haemolyticus strain SGAir0252 chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus
18063432	18063432	PRJNA1102048_P_NODE_15095_length_246_cov_0.890173_g14991_i0	PRJNA1102048	15095	246	0.890173	2.18982558	Mammaliicoccus stepanovicii	643214	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1231729876\|emb\|LT906462.1\|	643214	g14991	i0	100	0.117886178861789	29	0	12	0	144	172	1793642	1793670	Staphylococcus stepanovicii strain NCTC13839 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Mammaliicoccus	Mammaliicoccus stepanovicii
21888638	21888638	PRJNA1102048_P_NODE_9518_length_284_cov_1.142180_g9414_i0	PRJNA1102048	9518	284	1.14218	3.2437912	Staphylococcus auricularis	29379	Bacteria	Bacteria	497	2.8e-136	NTclustered	gi\|1403688813\|emb\|LS483491.1\|	29379	g9414	i0	98.239	488.102112676056	284	5	100	0	1	284	1603504	1603787	Staphylococcus auricularis strain NCTC12101 genome assembly, chromosome: 1	blastn	138621	497	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus auricularis
22696961	22696961	PRJNA1102048_P_NODE_8638_length_295_cov_2.851351_g8534_i0	PRJNA1102048	8638	295	2.851351	8.41148545	Anoxybacillus	150247	Bacteria	Bacteria	540	4.79e-149	NTclustered	gi\|1207877705\|gb\|CP021838.1\|	33934	g8534	i0	99.661	792.664406779661	295	1	100	0	1	295	1976188	1975894	Anoxybacillus flavithermus strain 52-1A chromosome, complete genome	blastn	233836	540	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacillus	Anoxybacillus flavithermus

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