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

12 rows where analysis = "blastn", bioproject = "PRJNA767802" 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
1206039	1206039	PRJNA767802_P_NODE_6041_length_324_cov_2.018182_g5968_i0	PRJNA767802	6041	324	2.018182	6.53890968	Bacillus	1386	Bacteria	Bacteria	551	2.4599999999999992e-152	NTclustered	gi\|1339799779\|gb\|CP026522.1\|	1402	g5968	i0	98.107	97.8364197530864	317	5	98	1	1	316	3447019	3446703	Bacillus licheniformis strain MBGJa67 chromosome	blastn	31699	551	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Bacillaceae	Bacillus	Bacillus licheniformis
2481502	2481502	PRJNA767802_P_NODE_2502_length_570_cov_12.500960_g2435_i0	PRJNA767802	2502	570	12.50096	71.255472	Bacillati	1783272	Bacteria	Bacteria	989	0	NTclustered	gi\|1227448785\|gb\|CP016766.1\|	1601	g2435	i0	99.814	503.073684210526	538	1	94	0	13	550	53794	53257	Ligilactobacillus agilis strain La3 chromosome, complete genome	blastn	286752	989	1	Bacteria	Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Ligilactobacillus	Ligilactobacillus agilis
3757864	3757864	PRJNA767802_P_NODE_8223_length_261_cov_1.948113_g8150_i0	PRJNA767802	8223	261	1.948113	5.08457493	root	1	Root_unresolved	Root_unresolved	472	1.54e-128	NTclustered	gi\|1796972337\|gb\|CP033085.1\|	1280	g8150	i0	99.234	98.7356321839081	261	2	100	0	1	261	2741333	2741593	Staphylococcus aureus strain WH3018 chromosome	blastn	25770	472	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
8398340	8398340	PRJNA767802_P_NODE_1407_length_774_cov_2.750345_g1357_i0	PRJNA767802	1407	774	2.750345	21.2876703	Clostridium carnis	1530	Bacteria	Bacteria	1140	0	NTclustered	gi\|301051466\|gb\|FJ498870.2\|	1530	g1357	i0	93.299	965.005167958656	776	46	100	6	1	774	421	1192	Clostridium carnis 23S ribosomal RNA gene, partial sequence	blastn	746914	1140	1	Bacteria	Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium carnis
9673663	9673663	PRJNA767802_P_NODE_5288_length_354_cov_4.013115_g5215_i0	PRJNA767802	5288	354	4.013115	14.2064271	Thermoanaerobacterium sp. RBIITD	1550240	Bacteria	Bacteria	612	1.2199999999999996e-170	NTclustered	gi\|1239558912\|emb\|LT906662.1\|	1550240	g5215	i0	98.834	1.94067796610169	343	4	97	0	1	343	3249117	3249459	Thermoanaerobacterium sp. RBIITD genome assembly, chromosome: I	blastn	687	612	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium sp. RBIITD
12224834	12224834	PRJNA767802_P_NODE_16390_length_166_cov_1.307692_g16317_i0	PRJNA767802	16390	166	1.307692	2.17076872	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	257	2.7400000000000003e-64	NTclustered	gi\|302777039\|gb\|CP002171.1\|	580327	g16317	i0	94.578	7.01807228915663	166	9	100	0	1	166	2269182	2269017	Thermoanaerobacterium thermosaccharolyticum DSM 571, complete genome	blastn	1165	257	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum
13960060	13960060	PRJNA767802_P_NODE_5771_length_334_cov_1.880702_g5698_i0	PRJNA767802	5771	334	1.880702	6.28154468	Sporomusa	2375	Bacteria	Bacteria	217	1.06e-51	NTclustered	gi\|2790662264\|gb\|CP155574.1\|	2376	g5698	i0	80.565	3.67964071856287	283	53	84	2	28	309	1993934	1993653	Sporomusa paucivorans strain DSM 3697 chromosome, complete genome	blastn	1229	217	1	Bacteria	Bacillati	Bacillota	Negativicutes	Selenomonadales	Sporomusaceae	Sporomusa	Sporomusa paucivorans
17783667	17783667	PRJNA767802_P_NODE_3274_length_490_cov_3.061224_g3203_i0	PRJNA767802	3274	490	3.061224	14.9999976	Staphylococcus	1279	Bacteria	Bacteria	900	0	NTclustered	gi\|1714026535\|gb\|CP031277.1\|	1290	g3203	i0	99.796	473.132653061225	490	1	100	0	1	490	708498	708009	Staphylococcus hominis strain 19A chromosome, complete genome	blastn	231835	900	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus hominis
19057825	19057825	PRJNA767802_P_NODE_5555_length_342_cov_3.757679_g5482_i0	PRJNA767802	5555	342	3.757679	12.85126218	Geobacillus	129337	Bacteria	Bacteria	592	1.54e-164	NTclustered	gi\|2529062746\|gb\|CP128458.1\|	1422	g5482	i0	99.69	24.1432748538012	323	1	94	0	20	342	3056735	3057057	Geobacillus stearothermophilus strain EF60133 chromosome, complete genome	blastn	8257	592	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Anoxybacillaceae	Geobacillus	Geobacillus stearothermophilus
21147780	21147780	PRJNA767802_P_NODE_4777_length_382_cov_2.417417_g4704_i0	PRJNA767802	4777	382	2.417417	9.23453294	Neomoorella thermoacetica	1525	Bacteria	Bacteria	658	0	NTclustered	gi\|1101494508\|gb\|CP017237.1\|	1525	g4704	i0	98.143	11.6178010471204	377	7	99	0	6	382	1571233	1571609	Moorella thermoacetica strain DSM 103284 chromosome, complete genome	blastn	4438	658	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Neomoorella	Neomoorella thermoacetica
22422404	22422404	PRJNA767802_P_NODE_10298_length_222_cov_2.653179_g10225_i0	PRJNA767802	10298	222	2.653179	5.89005738	Neomoorella thermoacetica	1525	Bacteria	Bacteria	398	2.2e-106	NTclustered	gi\|2702398649\|gb\|CP136551.1\|	1525	g10225	i0	99.095	9.96396396396396	221	2	99	0	1	221	1933034	1932814	Moorella thermoacetica strain COM chromosome, complete genome	blastn	2212	398	1	Bacteria	Bacillati	Bacillota	Clostridia	Neomoorellales	Neomoorellaceae	Neomoorella	Neomoorella thermoacetica
22422526	22422526	PRJNA767802_P_NODE_9538_length_234_cov_2.135135_g9465_i0	PRJNA767802	9538	234	2.135135	4.9962159	Thermoanaerobacterium thermosaccharolyticum	1517	Bacteria	Bacteria	152	2.01e-32	NTclustered	gi\|2504358668\|gb\|CP116033.1\|	1517	g9465	i0	80.488	2.68376068376068	205	35	86	5	5	206	897141	897343	Thermoanaerobacterium thermosaccharolyticum strain MJ1 chromosome, complete genome	blastn	628	152	1	Bacteria	Bacillati	Bacillota	Clostridia	Thermoanaerobacterales	Thermoanaerobacteraceae	Thermoanaerobacterium	Thermoanaerobacterium thermosaccharolyticum

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