metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA738523" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA738523" 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
5823109	5823109	PRJNA738523_P_NODE_12605_length_247_cov_1.333333_g12534_i0	PRJNA738523	12605	247	1.333333	3.29333251	Anoxybacteroides amylolyticum	294699	Bacteria	Bacteria	429	8.83e-116	NTclustered	gi\|1024277742\|gb\|CP015438.1\|	294699	g12534	i0	97.976	879.943319838057	247	5	100	0	1	247	2405	2159	Anoxybacteroides amylolyticum strain DSM 15939 chromosome, complete genome	blastn	217346	429	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Anoxybacteroides	Anoxybacteroides amylolyticum
6301781	6301781	PRJNA738523_P_NODE_16345_length_241_cov_0.869048_g16274_i0	PRJNA738523	16345	241	0.869048	2.09440568	Geobacillus	129337	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1317793375\|gb\|CP025074.1\|	1394	g16274	i0	99.585	29.0829875518672	241	1	100	0	1	241	2905015	2905255	[Bacillus] caldolyticus strain NEB414 chromosome, complete genome	blastn	7009	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	[Bacillus] caldolyticus
8372792	8372792	PRJNA738523_P_NODE_11227_length_250_cov_0.870056_g11156_i0	PRJNA738523	11227	250	0.870056	2.17514	Ligilactobacillus agilis	1601	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2784030803\|gb\|CP163515.1\|	1601	g11156	i0	100	0.348	29	0	12	0	86	114	1166804	1166832	Ligilactobacillus agilis strain W70 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus agilis
8850708	8850708	PRJNA738523_P_NODE_11607_length_249_cov_0.875000_g11536_i0	PRJNA738523	11607	249	0.875	2.17875	Streptococcus	1301	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g11536	i0	100	339.321285140562	249	0	100	0	1	249	17757	18005	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	84491	460	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
9647940	9647940	PRJNA738523_P_NODE_11028_length_250_cov_1.129944_g10957_i0	PRJNA738523	11028	250	1.129944	2.82486	Veillonella rogosae	423477	Bacteria	Bacteria	374	4.2499999999999986e-99	NTclustered	gi\|2446175566\|gb\|CP117967.1\|	423477	g10957	i0	93.625	14.272	251	15	100	1	1	250	1953780	1954030	Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome	blastn	3568	374	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Veillonella	Veillonella rogosae
11401386	11401386	PRJNA738523_P_NODE_13729_length_245_cov_1.430233_g13658_i0	PRJNA738523	13729	245	1.430233	3.50407085	Bacillaceae	186817	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1387294402\|gb\|CP023704.1\|	35841	g13658	i0	99.592	11.0326530612245	245	1	100	0	1	245	1205984	1205740	Caldibacillus thermoamylovorans strain SSBM chromosome, complete genome	blastn	2703	448	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Caldibacillus	Caldibacillus thermoamylovorans
11401405	11401405	PRJNA738523_P_NODE_7109_length_283_cov_1.152381_g7038_i0	PRJNA738523	7109	283	1.152381	3.26123823	Bacillus	1386	Bacteria	Bacteria	518	2.14e-142	NTclustered	gi\|984728683\|gb\|CP014179.1\|	1392	g7038	i0	99.647	1220.1554770318	283	1	100	0	1	283	12810	13092	Bacillus anthracis strain Stendal chromosome, complete genome	blastn	345304	518	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus anthracis
12198884	12198884	PRJNA738523_P_NODE_12210_length_248_cov_0.880000_g12139_i0	PRJNA738523	12210	248	0.88	2.1824	Geobacillus sp. LC300	1519377	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|909995672\|gb\|CP008903.1\|	1519377	g12139	i0	99.597	26.9516129032258	248	1	100	0	1	248	1873590	1873343	Geobacillus sp. LC300, complete genome	blastn	6684	453	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus sp. LC300
12198900	12198900	PRJNA738523_P_NODE_14170_length_245_cov_0.895349_g14099_i0	PRJNA738523	14170	245	0.895349	2.19360505	Megasphaera hexanoica	1675036	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|2840670333\|gb\|CP171746.1\|	1675036	g14099	i0	96.735	704.812244897959	245	8	100	0	1	245	2863	3107	Megasphaera hexanoica strain MH chromosome, complete genome	blastn	172679	409	1	Bacteria	Bacillati	Bacillota	Negativicutes	Veillonellales	Veillonellaceae	Megasphaera	Megasphaera hexanoica
12677350	12677350	PRJNA738523_P_NODE_4370_length_334_cov_4.114943_g4299_i0	PRJNA738523	4370	334	4.114943	13.74390962	root	1	Root_unresolved	Root_unresolved	612	1.15e-170	NTclustered	gi\|2484409883\|gb\|OQ804706.1\|	1282	g4299	i0	99.701	185	334	1	100	0	1	334	484	817	Staphylococcus epidermidis strain RPB-57 16S ribosomal RNA gene, partial sequence	blastn	61790	612	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
13951673	13951673	PRJNA738523_P_NODE_16391_length_238_cov_2.757576_g16320_i0	PRJNA738523	16391	238	2.757576	6.56303088	Streptococcus	1301	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|2636419880\|gb\|CP139875.1\|	1307	g16320	i0	100	100	238	0	100	0	1	238	1759554	1759317	Streptococcus suis strain Ss_134 chromosome	blastn	23800	440	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus suis
14748456	14748456	PRJNA738523_P_NODE_13612_length_246_cov_0.890173_g13541_i0	PRJNA738523	13612	246	0.890173	2.18982558	Streptococcus oralis	1303	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|2246565702\|gb\|CP097843.1\|	1303	g13541	i0	97.154	99.6626016260163	246	7	100	0	1	246	1937082	1937327	Streptococcus oralis strain HP01 chromosome, complete genome	blastn	24517	416	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus oralis
17297569	17297569	PRJNA738523_P_NODE_10114_length_254_cov_1.701657_g10043_i0	PRJNA738523	10114	254	1.701657	4.32220878	Anaerococcus sp. WGS1579	3366809	Bacteria	Bacteria	431	2.539999999999999e-116	NTclustered	gi\|2831319668\|gb\|CP171106.1\|	3366809	g10043	i0	97.244	238.110236220472	254	7	100	0	1	254	649012	649265	Anaerococcus sp. WGS1579 chromosome, complete genome	blastn	60480	431	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Anaerococcus	Anaerococcus sp. WGS1579
17297654	17297654	PRJNA738523_P_NODE_7754_length_276_cov_2.068966_g7683_i0	PRJNA738523	7754	276	2.068966	5.71034616	Oscillospiraceae bacterium	2485925	Bacteria	Bacteria	459	1.28e-124	NTclustered	gi\|2318996694\|gb\|CP107202.1\|	2485925	g7683	i0	96.727	470.851449275362	275	9	99	0	1	275	1023313	1023587	MAG: Oscillospiraceae bacterium isolate KR001_HAM_0051 chromosome, complete genome	blastn	129955	459	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Oscillospiraceae		Oscillospiraceae bacterium
17775487	17775487	PRJNA738523_P_NODE_11294_length_250_cov_0.870056_g11223_i0	PRJNA738523	11294	250	0.870056	2.17514	Staphylococcus	1279	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1899862668\|gb\|CP061041.1\|	1292	g11223	i0	98	23	250	5	100	0	1	250	1244066	1244315	Staphylococcus warneri strain WS479 chromosome, complete genome	blastn	5750	435	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus warneri
23672547	23672547	PRJNA738523_P_NODE_15999_length_241_cov_0.916667_g15928_i0	PRJNA738523	15999	241	0.916667	2.20916747	Staphylococcus hominis	1290	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2870745991\|gb\|CP134693.1\|	1290	g15928	i0	100	102.684647302905	241	0	100	0	1	241	779461	779701	Staphylococcus hominis strain acrlw chromosome, complete genome	blastn	24747	446	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
25424329	25424329	PRJNA738523_P_NODE_10920_length_250_cov_2.293785_g10849_i0	PRJNA738523	10920	250	2.293785	5.7344625	Streptococcus	1301	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1403375826\|emb\|LS483375.1\|	1302	g10849	i0	100	327	250	0	100	0	1	250	625213	625462	Streptococcus gordonii strain NCTC3165 genome assembly, chromosome: 1	blastn	81750	462	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Streptococcaceae	Streptococcus	Streptococcus gordonii

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