metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA753151" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA753151" and tax_phylum = "Actinomycetota"

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
729547	729547	PRJNA753151_S_NODE_154821_length_233_cov_5.678947_g152531_i0	PRJNA753151	154821	233	5.678947	13.23194651	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	409	1.07e-109	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g152531	i0	98.696	359.467811158798	230	3	99	0	1	230	553137	552908	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	83756	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
730011	730011	PRJNA753151_S_NODE_238701_length_184_cov_2.290780_g236411_i0	PRJNA753151	238701	184	2.29078	4.2150352	Streptomyces pactum	68249	Bacteria	Bacteria	121	4.24e-23	NTclustered	gi\|1148979828\|gb\|CP019724.1\|	68249	g236411	i0	86.916	58.1141304347826	107	14	58	0	4	110	8060363	8060257	Streptomyces pactum strain ACT12, complete genome	blastn	10693	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces pactum
5030170	5030170	PRJNA753151_S_NODE_220524_length_193_cov_2.400000_g218234_i0	PRJNA753151	220524	193	2.4	4.632	Rothia	32207	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g218234	i0	100	102.139896373057	193	0	100	0	1	193	653802	653610	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	19713	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
9658271	9658271	PRJNA753151_S_NODE_186888_length_212_cov_2.000000_g184598_i0	PRJNA753151	186888	212	2	4.24	Mycobacterium gallinarum	39689	Bacteria	Bacteria	163	8.25e-36	NTclustered	gi\|1806400554\|dbj\|AP022601.1\|	39689	g184598	i0	87.324	1.87735849056604	142	18	67	0	4	145	1985189	1985048	Mycobacterium gallinarum JCM 6399 DNA, nearly complete genome	blastn	398	163	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium gallinarum
11405669	11405669	PRJNA753151_S_NODE_147709_length_239_cov_1.418367_g145419_i0	PRJNA753151	147709	239	1.418367	3.38989713	Actinomycetes	1760	Bacteria	Bacteria	442	1.0899999999999994e-119	NTclustered	gi\|2871328653\|gb\|PQ778076.1\|	1720	g145419	i0	100	103.008368200837	239	0	100	0	1	239	344	106	Corynebacterium sp. strain LaCa142 16S ribosomal RNA gene, partial sequence	blastn	24619	442	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
12208887	12208887	PRJNA753151_S_NODE_12590_length_600_cov_9.570916_g10807_i0	PRJNA753151	12590	600	9.570916	57.425496	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	774	0	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g10807	i0	92.238	246.345	554	32	92	9	1	551	553128	553673	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	147807	774	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
12209487	12209487	PRJNA753151_S_NODE_232710_length_187_cov_1.875000_g230420_i0	PRJNA753151	232710	187	1.875	3.50625	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|1585470349\|emb\|LR031349.1\|	1528099	g230420	i0	100	271.320855614973	187	0	100	0	1	187	297	483	Lawsonella clevelandensis DNA containing 16S-23S intergenic spacer region, isolate ALS9 SC1	blastn	50737	346	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
13955824	13955824	PRJNA753151_S_NODE_1551_length_1388_cov_9.211896_g1289_i0	PRJNA753151	1551	1388	9.211896	127.86111648	Corynebacterium	1716	Bacteria	Bacteria	2217	0	NTclustered	gi\|2550468567\|gb\|CP100375.1\|	38284	g1289	i0	96.318	364.968299711816	1358	35	97	14	16	1363	2491838	2493190	Corynebacterium accolens strain CA8 chromosome	blastn	506576	2217	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
16032126	16032126	PRJNA753151_S_NODE_136113_length_248_cov_2.263415_g133823_i0	PRJNA753151	136113	248	2.263415	5.6132692	uncultured Solirubrobacterales bacterium	768556	Bacteria	Bacteria	261	3.42e-65	NTclustered	gi\|2874253818\|emb\|OY969802.1\|	768556	g133823	i0	85.657	83.1935483870968	251	32	100	4	1	248	849109	849358	MAG: uncultured Solirubrobacterales bacterium isolate MFD02840.bin.1.179 genome assembly, chromosome: 1	blastn	20632	261	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
16504809	16504809	PRJNA753151_S_NODE_207733_length_200_cov_1.719745_g205443_i0	PRJNA753151	207733	200	1.719745	3.43949	Corynebacterium	1716	Bacteria	Bacteria	344	2.56e-90	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g205443	i0	100	294.985	186	0	93	0	1	186	2491280	2491465	Corynebacterium accolens strain CA3 chromosome	blastn	58997	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
17308019	17308019	PRJNA753151_S_NODE_214994_length_196_cov_2.058824_g212704_i0	PRJNA753151	214994	196	2.058824	4.03529504	Corynebacterium coyleae	53374	Bacteria	Bacteria	357	3.2099999999999996e-94	NTclustered	gi\|2058472593\|gb\|CP077302.1\|	53374	g212704	i0	99.492	384.076530612245	197	0	100	1	1	196	501514	501710	Corynebacterium coyleae strain FDAARGOS 1425 chromosome, complete genome	blastn	75279	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium coyleae
20328357	20328357	PRJNA753151_S_NODE_250856_length_179_cov_1.323529_g248566_i0	PRJNA753151	250856	179	1.323529	2.36911691	Cutibacterium	1912216	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g248566	i0	100	50.7653631284916	179	0	100	0	1	179	668002	667824	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9087	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23682433	23682433	PRJNA753151_S_NODE_124679_length_258_cov_1.674419_g122389_i0	PRJNA753151	124679	258	1.674419	4.32000102	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	449	7.13e-122	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g122389	i0	98.062	527.693798449612	258	5	100	0	1	258	1215036	1215293	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	136145	449	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium

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