metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA893346" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA893346" 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
3419060	3419060	PRJNA893346_P_NODE_31943_length_259_cov_1.241935_g31453_i0	PRJNA893346	31943	259	1.241935	3.21661165	uncultured Acidimicrobiaceae bacterium	410722	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2874254072\|emb\|OY970155.1\|	410722	g31453	i0	100	0.108108108108108	28	0	11	0	186	213	4655162	4655189	MAG: uncultured Acidimicrobiaceae bacterium isolate MFD10071.bin.2.24 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Acidimicrobiaceae		uncultured Acidimicrobiaceae bacterium
3419187	3419187	PRJNA893346_P_NODE_37783_length_244_cov_0.900585_g37293_i0	PRJNA893346	37783	244	0.900585	2.1974274	Nocardioides sp. zg-1228	2763008	Bacteria	Bacteria	327	3.27e-85	NTclustered	gi\|1995570698\|gb\|CP070961.1\|	2763008	g37293	i0	90.947	19.4508196721311	243	22	99	0	1	243	3660054	3659812	Nocardioides sp. zg-1228 chromosome, complete genome	blastn	4746	327	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. zg-1228
3419323	3419323	PRJNA893346_P_NODE_7463_length_585_cov_1.353516_g6989_i0	PRJNA893346	7463	585	1.353516	7.9180686	Subtercola sp. PAMC28395	2846775	Bacteria	Bacteria	63.9	2.67e-5	NTclustered	gi\|2053520473\|gb\|CP076547.1\|	2846775	g6989	i0	93.182	0.0752136752136752	44	2	8	1	312	355	374296	374338	Subtercola sp. PAMC28395 chromosome, complete genome	blastn	44	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Subtercola	Subtercola sp. PAMC28395
5071323	5071323	PRJNA893346_P_NODE_23384_length_316_cov_2.349794_g22894_i0	PRJNA893346	23384	316	2.349794	7.42534904	Cutibacterium	1912216	Bacteria	Bacteria	339	2.0299999999999997e-88	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g22894	i0	100	285.316455696203	183	0	100	0	134	316	56031	55849	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	90160	339	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5971232	5971232	PRJNA893346_P_NODE_18545_length_359_cov_1.076923_g18056_i0	PRJNA893346	18545	359	1.076923	3.86615357	Embleya sp. NBC_00888	2975960	Bacteria	Bacteria	67.6	1.21e-6	NTclustered	gi\|2655411662\|gb\|CP108785.1\|	2975960	g18056	i0	79.412	0.440111420612813	102	15	27	5	201	296	4388768	4388667	Embleya sp. NBC_00888 plasmid unnamed1, complete sequence	blastn	158	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Embleya	Embleya sp. NBC_00888
6347266	6347266	PRJNA893346_P_NODE_13905_length_418_cov_2.188406_g13418_i0	PRJNA893346	13905	418	2.188406	9.14753708	Bacteria	2	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1387115530\|gb\|CP015453.1\|	139021	g13418	i0	100	0.267942583732057	28	0	7	0	188	215	3187090	3187063	Dietzia psychralcaliphila strain ILA-1 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia psychralcaliphila
6347269	6347269	PRJNA893346_P_NODE_14545_length_408_cov_2.194030_g14057_i0	PRJNA893346	14545	408	2.19403	8.9516424	Gordonia	2053	Bacteria	Bacteria	660	0	NTclustered	gi\|2714308933\|gb\|CP136139.1\|	410332	g14057	i0	95.833	337.272058823529	408	17	100	0	1	408	93332	93739	Gordonia malaquae strain A448 chromosome	blastn	137607	660	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia malaquae
9795840	9795840	PRJNA893346_P_NODE_16688_length_379_cov_2.444444_g16200_i0	PRJNA893346	16688	379	2.444444	9.26444276	Streptomyces sp. NBC_01190	2903767	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2654779599\|gb\|CP108580.1\|	2903767	g16200	i0	100	0.0765171503957784	29	0	8	0	279	307	3989328	3989356	Streptomyces sp. NBC_01190 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01190
9796026	9796026	PRJNA893346_P_NODE_23848_length_313_cov_0.962500_g23358_i0	PRJNA893346	23848	313	0.9625	3.012625	Rubrobacter radiotolerans	42256	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|627776062\|gb\|CP007514.1\|	42256	g23358	i0	100	0.0926517571884984	29	0	9	0	165	193	598765	598793	Rubrobacter radiotolerans strain RSPS-4, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Rubrobacteria	Rubrobacterales	Rubrobacteraceae	Rubrobacter	Rubrobacter radiotolerans
11447049	11447049	PRJNA893346_P_NODE_5969_length_659_cov_3.440273_g5505_i0	PRJNA893346	5969	659	3.440273	22.67139907	Cutibacterium	1912216	Bacteria	Bacteria	1179	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5505	i0	98.938	276.36722306525	659	7	100	0	1	659	56773	57431	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	182126	1179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
12347188	12347188	PRJNA893346_P_NODE_24970_length_304_cov_1.519481_g24480_i0	PRJNA893346	24970	304	1.519481	4.61922224	Streptomyces sp. NBC_00988	2903704	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2655351745\|gb\|CP108730.1\|	2903704	g24480	i0	100	0.0953947368421053	29	0	10	0	207	235	694019	693991	Streptomyces sp. NBC_00988 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00988
14896218	14896218	PRJNA893346_P_NODE_27552_length_287_cov_1.079439_g27062_i0	PRJNA893346	27552	287	1.079439	3.09798993	Agromyces sp. MMS24-JH15	3243765	Bacteria	Bacteria	152	2.5399999999999996e-32	NTclustered	gi\|2836090395\|gb\|CP171358.1\|	3243765	g27062	i0	80.095	0.735191637630662	211	36	72	5	47	254	2668820	2668613	Agromyces sp. MMS24-JH15 chromosome, complete genome	blastn	211	152	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces sp. MMS24-JH15
18719796	18719796	PRJNA893346_P_NODE_32035_length_258_cov_1.664865_g31545_i0	PRJNA893346	32035	258	1.664865	4.2953517	Gordonia alkanivorans	84096	Bacteria	Bacteria	418	2.0099999999999995e-112	NTclustered	gi\|1552508818\|gb\|CP027114.1\|	84096	g31545	i0	96.471	323.065891472868	255	6	98	2	5	258	3772725	3772977	Gordonia alkanivorans strain YC-RL2 chromosome, complete genome	blastn	83351	418	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Gordoniaceae	Gordonia	Gordonia alkanivorans
20369590	20369590	PRJNA893346_P_NODE_14736_length_405_cov_3.644578_g14248_i0	PRJNA893346	14736	405	3.644578	14.7605409	Cutibacterium	1912216	Bacteria	Bacteria	632	1.0899999999999998e-176	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g14248	i0	100	240.481481481481	342	0	100	0	1	342	55345	55686	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	97395	632	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21645405	21645405	PRJNA893346_P_NODE_12297_length_446_cov_4.265416_g11812_i0	PRJNA893346	12297	446	4.265416	19.02375536	Cutibacterium	1912216	Bacteria	Bacteria	758	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11812	i0	99.758	270.19730941704	413	1	100	0	34	446	56554	56142	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	120508	758	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22545074	22545074	PRJNA893346_P_NODE_27618_length_286_cov_4.474178_g27128_i0	PRJNA893346	27618	286	4.474178	12.79614908	Cutibacterium acnes	1747	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|2493032747\|gb\|CP114008.1\|	1747	g27128	i0	100	279.912587412587	286	0	100	0	1	286	626226	625941	Cutibacterium acnes strain CBS-BPNBT19227 chromosome, complete genome	blastn	80055	529	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22920879	22920879	PRJNA893346_P_NODE_27338_length_288_cov_1.432558_g26848_i0	PRJNA893346	27338	288	1.432558	4.12576704	Micrococcus	1269	Bacteria	Bacteria	527	3.63e-145	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g26848	i0	99.653	208.270833333333	288	1	100	0	1	288	345887	345600	Micrococcus luteus strain V017 chromosome, complete genome	blastn	59982	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25094372	25094372	PRJNA893346_P_NODE_33440_length_251_cov_0.865169_g32950_i0	PRJNA893346	33440	251	0.865169	2.17157419	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g32950	i0	100	0.111553784860558	28	0	11	0	151	178	995425	995398	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36

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