metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB27957" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB27957" 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
23411	23411	PRJEB27957_P_NODE_48341_length_235_cov_1.010753_g48231_i0	PRJEB27957	48341	235	1.010753	2.37526955	Corynebacterium gottingense	2041036	Bacteria	Bacteria	412	8.39e-111	NTclustered	gi\|2531310433\|gb\|CP047583.1\|	2041036	g48231	i0	98.298	421.187234042553	235	4	100	0	1	235	700293	700527	Corynebacterium gottingense strain DSM 108039 chromosome, complete genome	blastn	98979	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium gottingense
3849586	3849586	PRJEB27957_P_NODE_37484_length_259_cov_1.509524_g37374_i0	PRJEB27957	37484	259	1.509524	3.90966716	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	407	4.37e-109	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g37374	i0	94.981	289.660231660232	259	13	100	0	1	259	126554	126296	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	75022	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
4814672	4814672	PRJEB27957_P_NODE_57464_length_219_cov_2.982353_g57354_i0	PRJEB27957	57464	219	2.982353	6.53135307	Corynebacterium	1716	Bacteria	Bacteria	405	1.29e-108	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g57354	i0	100	354.283105022831	219	0	100	0	1	219	760179	759961	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	77588	405	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
5125853	5125853	PRJEB27957_P_NODE_9265_length_432_cov_1.127937_g9156_i0	PRJEB27957	9265	432	1.127937	4.87268784	Microbacterium azadirachtae	582680	Bacteria	Bacteria	688	0	NTclustered	gi\|2313714276\|gb\|CP099706.1\|	582680	g9156	i0	95.381	147.275462962963	433	19	100	1	1	432	1336293	1336725	Microbacterium azadirachtae strain CNUC13 chromosome, complete genome	blastn	63623	688	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium azadirachtae
6401539	6401539	PRJEB27957_P_NODE_49086_length_233_cov_1.836957_g48976_i0	PRJEB27957	49086	233	1.836957	4.28010981	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|1986709282\|gb\|CP069791.1\|	38304	g48976	i0	99.571	367.403433476395	233	1	100	0	1	233	925865	925633	Corynebacterium tuberculostearicum strain FDAARGOS_1198 chromosome	blastn	85605	425	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
7675691	7675691	PRJEB27957_P_NODE_78647_length_193_cov_1.125000_g78537_i0	PRJEB27957	78647	193	1.125	2.17125	Kocuria palustris	71999	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g78537	i0	100	331.186528497409	193	0	100	0	1	193	218514	218322	Kocuria palustris strain MU14/1, complete genome	blastn	63919	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
7675692	7675692	PRJEB27957_P_NODE_86727_length_184_cov_3.637037_g86617_i0	PRJEB27957	86727	184	3.637037	6.69214808	Corynebacterium minutissimum	38301	Bacteria	Bacteria	313	6.52e-81	NTclustered	gi\|1403572617\|emb\|LS483460.1\|	38301	g86617	i0	97.283	354.711956521739	184	5	100	0	1	184	492049	492232	Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1	blastn	65267	313	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium minutissimum
9914996	9914996	PRJEB27957_P_NODE_8148_length_452_cov_1.265509_g8039_i0	PRJEB27957	8148	452	1.265509	5.72010068	Streptomyces	1883	Bacteria	Bacteria	830	0	NTclustered	gi\|2413490837\|gb\|CP114036.1\|	2979468	g8039	i0	99.779	557.449115044248	452	1	100	0	1	452	1451927	1451476	Streptomyces sp. S465 chromosome, complete genome	blastn	251967	830	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. S465
10226153	10226153	PRJEB27957_P_NODE_125649_length_162_cov_0.920354_g125539_i0	PRJEB27957	125649	162	0.920354	1.49097348	Schaalia turicensis	131111	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|2073945028\|gb\|CP048928.1\|	131111	g125539	i0	100	15.6604938271605	162	0	100	0	1	162	506387	506548	Schaalia turicensis strain CT001 chromosome, complete genome	blastn	2537	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia turicensis
12465961	12465961	PRJEB27957_P_NODE_92610_length_179_cov_0.800000_g92500_i0	PRJEB27957	92610	179	0.8	1.432	root	1	Root_unresolved	Root_unresolved	331	1.74e-86	NTclustered	gi\|1435970435\|gb\|MH699149.1\|	1785	g92500	i0	100	100	179	0	100	0	1	179	271	93	Mycobacterium sp. strain MA94 16S ribosomal RNA gene, partial sequence	blastn	17900	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
14051528	14051528	PRJEB27957_P_NODE_122872_length_163_cov_0.912281_g122762_i0	PRJEB27957	122872	163	0.912281	1.48701803	Mycobacteroides chelonae	1774	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|1951304461\|gb\|CP050223.1\|	1774	g122762	i0	100	100.398773006135	163	0	100	0	1	163	275754	275916	Mycobacteroides chelonae strain Myco1 chromosome	blastn	16365	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides chelonae
16289513	16289513	PRJEB27957_P_NODE_78533_length_193_cov_1.444444_g78423_i0	PRJEB27957	78533	193	1.444444	2.78777692	Pseudonocardia	1847	Bacteria	Bacteria	340	3.17e-89	NTclustered	gi\|1464106963\|dbj\|AP018920.1\|	2074	g78423	i0	98.446	337.922279792746	193	3	100	0	1	193	645387	645579	Pseudonocardia autotrophica NBRC 12743 DNA, complete genome	blastn	65219	340	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia autotrophica
16600214	16600214	PRJEB27957_P_NODE_21254_length_322_cov_1.435897_g21144_i0	PRJEB27957	21254	322	1.435897	4.62358834	Streptomyces luomodiensis	3026192	Bacteria	Bacteria	595	1.1099999999999995e-165	NTclustered	gi\|2579357534\|gb\|CP117522.1\|	3026192	g21144	i0	100	651.88198757764	322	0	100	0	1	322	1560628	1560949	Streptomyces luomodiensis strain SCA4-21 chromosome, complete genome	blastn	209906	595	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces luomodiensis
16600242	16600242	PRJEB27957_P_NODE_71874_length_201_cov_0.901316_g71764_i0	PRJEB27957	71874	201	0.901316	1.81164516	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	361	2.5599999999999998e-95	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g71764	i0	99.005	364.094527363184	201	2	100	0	1	201	623191	623391	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	73183	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
19148892	19148892	PRJEB27957_P_NODE_176_length_1490_cov_3.672450_g26_i1	PRJEB27957	176	1490	3.67245	54.719505	Mycobacterium sp. DL440	2675523	Bacteria	Bacteria	2071	0	NTclustered	gi\|1823994838\|gb\|CP050191.1\|	2675523	g26	i1	91.939	136.05033557047	1501	88	100	17	1	1490	2496876	2498354	Mycobacterium sp. DL440 chromosome	blastn	202715	2071	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp. DL440
20424098	20424098	PRJEB27957_P_NODE_22917_length_313_cov_1.742424_g22807_i0	PRJEB27957	22917	313	1.742424	5.45378712	Corynebacterium amycolatum	43765	Bacteria	Bacteria	568	2.3499999999999998e-157	NTclustered	gi\|1958412166\|gb\|CP068169.1\|	43765	g22807	i0	99.363	423.338658146965	314	1	100	1	1	313	20167	20480	Corynebacterium amycolatum strain FDAARGOS_1107 chromosome, complete genome	blastn	132505	568	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium amycolatum
20424136	20424136	PRJEB27957_P_NODE_85337_length_186_cov_1.394161_g85227_i0	PRJEB27957	85337	186	1.394161	2.59313946	Amycolatopsis sp. CA-230715	2745196	Bacteria	Bacteria	176	9.04e-40	NTclustered	gi\|2049143295\|gb\|CP059997.1\|	2745196	g85227	i0	84.043	305.564516129032	188	24	100	6	1	186	143646	143463	Amycolatopsis sp. CA-230715 chromosome, complete genome	blastn	56835	176	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. CA-230715
21388998	21388998	PRJEB27957_P_NODE_8977_length_437_cov_1.110825_g8868_i0	PRJEB27957	8977	437	1.110825	4.85430525	Cutibacterium	1912216	Bacteria	Bacteria	760	0	NTclustered	gi\|966535676\|gb\|CP012351.1\|	1747	g8868	i0	97.95	294.610983981693	439	7	100	2	1	437	1523507	1523069	Cutibacterium acnes strain PA_21_1_L1 chromosome, complete genome	blastn	128745	760	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21700105	21700105	PRJEB27957_P_NODE_11478_length_402_cov_1.796034_g11369_i0	PRJEB27957	11478	402	1.796034	7.22005668	Yimella sp. cx-51	2770551	Bacteria	Bacteria	614	3.9199999999999996e-171	NTclustered	gi\|2019559805\|gb\|CP072113.1\|	2770551	g11369	i0	94.514	179.639303482587	401	17	99	5	1	399	687475	687872	Yimella sp. cx-51 chromosome, complete genome	blastn	72215	614	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Yimella	Yimella sp. cx-51
22975365	22975365	PRJEB27957_P_NODE_30459_length_281_cov_1.318966_g30349_i0	PRJEB27957	30459	281	1.318966	3.70629446	Streptomyces sp. HUAS ZL42	3231715	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2772092393\|gb\|CP160403.1\|	3231715	g30349	i0	94.444	0.128113879003559	36	0	13	2	122	157	6914163	6914196	Streptomyces sp. HUAS ZL42 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. HUAS ZL42
23939199	23939199	PRJEB27957_P_NODE_97699_length_174_cov_1.152000_g97589_i0	PRJEB27957	97699	174	1.152	2.00448	Cutibacterium	1912216	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g97589	i0	100	265.5	174	0	100	0	1	174	58173	58346	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	46197	322	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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