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

15 rows where analysis = "blastn", bioproject = "PRJNA401346" and tax_kingdom = "Bacillati"

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
1689179	1689179	PRJNA401346_P_NODE_8082_length_203_cov_0.901408_g8061_i0	PRJNA401346	8082	203	0.901408	1.82985824	uncultured Solirubrobacterales bacterium	768556	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874253801\|emb\|OY969785.1\|	768556	g8061	i0	100	0.142857142857143	29	0	14	0	150	178	3218967	3218995	MAG: uncultured Solirubrobacterales bacterium isolate MFD09603.bin.c.7 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
2356526	2356526	PRJNA401346_P_NODE_5962_length_215_cov_1.084416_g5941_i0	PRJNA401346	5962	215	1.084416	2.3314944	Staphylococcus	1279	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|1176884116\|gb\|CP020463.1\|	1282	g5941	i0	98.14	538.413953488372	215	4	100	0	1	215	748752	748538	Staphylococcus epidermidis strain 1457 chromosome, complete genome	blastn	115759	375	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus epidermidis
3631924	3631924	PRJNA401346_P_NODE_4463_length_252_cov_1.005236_g4442_i0	PRJNA401346	4463	252	1.005236	2.53319472	Cutibacterium	1912216	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4442	i0	100	64.2142857142857	252	0	100	0	1	252	438215	438466	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16182	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4909076	4909076	PRJNA401346_P_NODE_1224_length_428_cov_1.700272_g1203_i0	PRJNA401346	1224	428	1.700272	7.27716416	Cutibacterium	1912216	Bacteria	Bacteria	769	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1203	i0	99.065	272.544392523364	428	4	100	0	1	428	56167	56594	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	116649	769	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6792030	6792030	PRJNA401346_P_NODE_6806_length_207_cov_1.746575_g6785_i0	PRJNA401346	6806	207	1.746575	3.61541025	Staphylococcus pasteuri	45972	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|1250045397\|gb\|CP017463.1\|	45972	g6785	i0	100	20.4154589371981	207	0	100	0	1	207	469796	470002	Staphylococcus pasteuri strain JS7 chromosome, complete genome	blastn	4226	383	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pasteuri
8067549	8067549	PRJNA401346_P_NODE_4827_length_242_cov_1.232044_g4806_i0	PRJNA401346	4827	242	1.232044	2.98154648	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	359	1.15e-94	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g4806	i0	95.154	287.838842975207	227	11	94	0	1	227	552164	551938	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	69657	359	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
8733927	8733927	PRJNA401346_P_NODE_8307_length_202_cov_1.758865_g8286_i0	PRJNA401346	8307	202	1.758865	3.5529073	Cutibacterium	1912216	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g8286	i0	100	52.990099009901	202	0	100	0	1	202	2509077	2509278	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10704	374	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12559780	12559780	PRJNA401346_P_NODE_8650_length_201_cov_0.914286_g8629_i0	PRJNA401346	8650	201	0.914286	1.83771486	Finegoldia	150022	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2127562652\|gb\|CP085955.1\|	1260	g8629	i0	100	7.52238805970149	201	0	100	0	1	201	578326	578526	Finegoldia magna strain FDAARGOS_1557 chromosome, complete genome	blastn	1512	372	1	Bacteria	Bacillati	Bacillota	Tissierellia	Tissierellales	Peptoniphilaceae	Finegoldia	Finegoldia magna
13834584	13834584	PRJNA401346_P_NODE_3631_length_274_cov_1.948357_g3610_i0	PRJNA401346	3631	274	1.948357	5.33849818	Exiguobacterium	33986	Bacteria	Bacteria	499	7.48e-137	NTclustered	gi\|2452055134\|gb\|CP109617.1\|	307643	g3610	i0	99.635	826.091240875912	274	0	100	1	1	274	40983	40711	Exiguobacterium profundum strain TSS-3 chromosome, complete genome	blastn	226349	499	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales		Exiguobacterium	Exiguobacterium profundum
15108851	15108851	PRJNA401346_P_NODE_3172_length_290_cov_1.266376_g3151_i0	PRJNA401346	3172	290	1.266376	3.6724904	Actinomycetota	201174	Bacteria	Bacteria	93.5	1.58e-14	NTclustered	gi\|2874253729\|emb\|OY969571.1\|	152507	g3151	i0	96.429	19.3862068965517	56	2	19	0	6	61	320267	320212	MAG: uncultured Actinomycetes bacterium isolate MFD09267.bin.1.216 genome assembly, chromosome: 1	blastn	5622	93.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
15717018	15717018	PRJNA401346_P_NODE_7153_length_206_cov_0.882759_g7132_i0	PRJNA401346	7153	206	0.882759	1.81848354	Staphylococcus pettenkoferi	170573	Bacteria	Bacteria	359	9.47e-95	NTclustered	gi\|1352851708\|gb\|CP022096.2\|	170573	g7132	i0	98.058	5.36407766990291	206	4	100	0	1	206	1990918	1991123	Staphylococcus pettenkoferi strain FDAARGOS_288 chromosome, complete genome	blastn	1105	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus pettenkoferi
18932585	18932585	PRJNA401346_P_NODE_315_length_814_cov_1.560425_g301_i0	PRJNA401346	315	814	1.560425	12.7018595	Cutibacterium	1912216	Bacteria	Bacteria	1504	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g301	i0	100	277.69656019656	814	0	100	0	1	814	55365	56178	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	226045	1504	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22758036	22758036	PRJNA401346_P_NODE_4078_length_263_cov_0.910891_g4057_i0	PRJNA401346	4078	263	0.910891	2.39564333	Microbacterium	33882	Bacteria	Bacteria	436	5.67e-118	NTclustered	gi\|1916862553\|gb\|MW115344.1\|	51671	g4057	i0	96.578	100.007604562738	263	9	100	0	1	263	708	446	Microbacterium sp. strain CPBF 1240 16S ribosomal RNA gene, partial sequence	blastn	26302	436	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp.
22758045	22758045	PRJNA401346_P_NODE_6198_length_209_cov_1.297297_g6177_i0	PRJNA401346	6198	209	1.297297	2.71135073	Mycobacterium	1763	Bacteria	Bacteria	381	2.0599999999999996e-101	NTclustered	gi\|2872563150\|gb\|CP176427.1\|	3385967	g6177	i0	99.522	162.531100478469	209	1	100	0	1	209	1409123	1409331	Mycobacterium sp. SMC-16 chromosome, complete genome	blastn	33969	381	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. SMC-16
25307249	25307249	PRJNA401346_P_NODE_8720_length_201_cov_0.914286_g8699_i0	PRJNA401346	8720	201	0.914286	1.83771486	Staphylococcus	1279	Bacteria	Bacteria	359	9.2e-95	NTclustered	gi\|2006240191\|gb\|CP071508.1\|	1283	g8699	i0	99	51.636815920398	200	2	99	0	2	201	1894593	1894792	Staphylococcus haemolyticus strain 7b chromosome, complete genome	blastn	10379	359	1	Bacteria	Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus haemolyticus

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