metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJDB3785" and tax

29 rows where analysis = "blastn", bioproject = "PRJDB3785" 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
981161	981161	PRJDB3785_S_NODE_22461_length_169_cov_1.233333_g22308_i0	PRJDB3785	22461	169	1.233333	2.08433277	Actinomycetes	1760	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|2441522911\|gb\|OQ406197.1\|	1720	g22308	i0	98.824	117.431952662722	170	1	100	1	1	169	599	430	Corynebacterium sp. strain Y32 16S ribosomal RNA gene, partial sequence	blastn	19846	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp.
981169	981169	PRJDB3785_S_NODE_5161_length_333_cov_2.014085_g5008_i0	PRJDB3785	5161	333	2.014085	6.70690305	Cutibacterium	1912216	Bacteria	Bacteria	616	8.87e-172	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g5008	i0	100	262.507507507508	333	0	100	0	1	333	56616	56284	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	87415	616	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2558545	2558545	PRJDB3785_S_NODE_11363_length_226_cov_1.056497_g11210_i0	PRJDB3785	11363	226	1.056497	2.38768322	Brevibacterium casei	33889	Bacteria	Bacteria	351	1.77e-92	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g11210	i0	94.69	355.469026548673	226	12	100	0	1	226	599515	599290	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	80336	351	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
3531803	3531803	PRJDB3785_S_NODE_1383_length_682_cov_1.892575_g1263_i0	PRJDB3785	1383	682	1.892575	12.9073615	Cutibacterium	1912216	Bacteria	Bacteria	1013	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1263	i0	93.935	299.605571847507	676	31	99	9	9	682	56270	55603	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	204331	1013	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3531810	3531810	PRJDB3785_S_NODE_20143_length_177_cov_1.328125_g19990_i0	PRJDB3785	20143	177	1.328125	2.35078125	Mycobacteriaceae	1762	Bacteria	Bacteria	278	2.27e-70	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g19990	i0	94.915	183.683615819209	177	9	100	0	1	177	1312757	1312933	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	32512	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
6084338	6084338	PRJDB3785_S_NODE_1865_length_585_cov_2.966418_g1727_i0	PRJDB3785	1865	585	2.966418	17.3535453	root	1	Root_unresolved	Root_unresolved	335	5.129999999999999e-87	NTclustered	gi\|2658163624\|gb\|CP107871.1\|	1961	g1727	i0	82.507	65.1538461538462	383	65	65	2	8	389	3921276	3920895	Streptomyces virginiae strain NBC 00488 chromosome, complete genome	blastn	38115	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
7660969	7660969	PRJDB3785_S_NODE_10007_length_239_cov_2.526316_g9854_i0	PRJDB3785	10007	239	2.526316	6.03789524	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	58.4	4.62e-4	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g9854	i0	92.5	0.167364016736402	40	3	17	0	190	229	2448791	2448830	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	40	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
8634288	8634288	PRJDB3785_S_NODE_26567_length_162_cov_0.902655_g26414_i0	PRJDB3785	26567	162	0.902655	1.4623011	Micrococcus	1269	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g26414	i0	100	330.734567901235	162	0	100	0	1	162	346566	346405	Micrococcus luteus strain V017 chromosome, complete genome	blastn	53579	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
8935706	8935706	PRJDB3785_S_NODE_13548_length_209_cov_1.556250_g13395_i0	PRJDB3785	13548	209	1.55625	3.2525625	Brevibacterium casei	33889	Bacteria	Bacteria	377	2.66e-100	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g13395	i0	100	373.995215311005	204	0	99	0	6	209	598452	598249	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	78165	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
9909335	9909335	PRJDB3785_S_NODE_20268_length_177_cov_0.796875_g20115_i0	PRJDB3785	20268	177	0.796875	1.41046875	Mycolicibacterium	1866885	Bacteria	Bacteria	320	3.71e-83	NTclustered	gi\|1806276632\|dbj\|AP022574.1\|	216929	g20115	i0	100	180.112994350282	173	0	98	0	1	173	2523055	2523227	Mycolicibacterium psychrotolerans JCM 13323 DNA, complete genome	blastn	31880	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium psychrotolerans
9909345	9909345	PRJDB3785_S_NODE_3888_length_388_cov_2.221239_g3735_i0	PRJDB3785	3888	388	2.221239	8.61840732	Brevibacterium	1696	Bacteria	Bacteria	717	0	NTclustered	gi\|2243216145\|gb\|ON573296.1\|	1701	g3735	i0	100	105	388	0	100	0	1	388	850	463	Brevibacterium sp. strain R14 16S ribosomal RNA gene, partial sequence	blastn	40740	717	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium sp.
10211590	10211590	PRJDB3785_S_NODE_13749_length_208_cov_1.188679_g13596_i0	PRJDB3785	13749	208	1.188679	2.47245232	Arthrobacter sp. PAMC 25486	1494608	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|723606223\|gb\|CP007595.1\|	1494608	g13596	i0	100	0.134615384615385	28	0	13	0	20	47	200914	200941	Arthrobacter sp. PAMC25486, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. PAMC 25486
10211627	10211627	PRJDB3785_S_NODE_16569_length_193_cov_0.881944_g16416_i0	PRJDB3785	16569	193	0.881944	1.70215192	Streptomyces sp. cg36	3238798	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2784064359\|gb\|CP163520.1\|	3238798	g16416	i0	100	0.145077720207254	28	0	15	0	83	110	995398	995425	Streptomyces sp. cg36 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. cg36
11486668	11486668	PRJDB3785_S_NODE_15450_length_198_cov_1.369128_g15297_i0	PRJDB3785	15450	198	1.369128	2.71087344	Actinomadura sp. NAK00032	2742128	Bacteria	Bacteria	75	3.66e-9	NTclustered	gi\|1860167784\|gb\|CP054932.1\|	2742128	g15297	i0	92.308	4.45959595959596	52	4	26	0	147	198	4940113	4940062	Actinomadura sp. NAK00032 chromosome, complete genome	blastn	883	75	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Thermomonosporaceae	Actinomadura	Actinomadura sp. NAK00032
11486729	11486729	PRJDB3785_S_NODE_19810_length_178_cov_1.961240_g19657_i0	PRJDB3785	19810	178	1.96124	3.4910072	Brevibacterium casei	33889	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1943100173\|gb\|CP065629.1\|	33889	g19657	i0	100	341.752808988764	178	0	100	0	1	178	598425	598602	Brevibacterium casei strain FDAARGOS_937 chromosome, complete genome	blastn	60832	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
11486734	11486734	PRJDB3785_S_NODE_20270_length_177_cov_0.726562_g20117_i0	PRJDB3785	20270	177	0.726562	1.28601474	Corynebacterium casei	160386	Bacteria	Bacteria	100	5.27e-17	NTclustered	gi\|582015241\|gb\|CP004350.1\|	1285583	g20117	i0	95.238	15.9378531073446	63	3	36	0	6	68	2410686	2410624	Corynebacterium casei LMG S-19264, complete genome	blastn	2821	100	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium casei
11486789	11486789	PRJDB3785_S_NODE_25150_length_164_cov_0.886957_g24997_i0	PRJDB3785	25150	164	0.886957	1.45460948	Kribbella flavida	182640	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|283807292\|gb\|CP001736.1\|	479435	g24997	i0	100	0.170731707317073	28	0	17	0	20	47	6850204	6850177	Kribbella flavida DSM 17836, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Kribbellaceae	Kribbella	Kribbella flavida
11486921	11486921	PRJDB3785_S_NODE_8250_length_262_cov_1.197183_g8097_i0	PRJDB3785	8250	262	1.197183	3.13661946	uncultured Solirubrobacterales bacterium	768556	Bacteria	Bacteria	233	7.949999999999999e-57	NTclustered	gi\|2874253935\|emb\|OY970260.1\|	768556	g8097	i0	83.203	98.675572519084	256	41	97	2	8	262	2811233	2811487	MAG: uncultured Solirubrobacterales bacterium isolate MFD10007.bin.c.5 genome assembly, chromosome: 1	blastn	25853	233	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales			uncultured Solirubrobacterales bacterium
14037019	14037019	PRJDB3785_S_NODE_8092_length_264_cov_1.674419_g7939_i0	PRJDB3785	8092	264	1.674419	4.42046616	Arthrobacter oryzae	409290	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2562553452\|gb\|CP132204.1\|	409290	g7939	i0	100	0.109848484848485	29	0	11	0	114	142	2465399	2465427	Arthrobacter oryzae strain AO2021 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter oryzae
15009048	15009048	PRJDB3785_S_NODE_24032_length_166_cov_0.871795_g23879_i0	PRJDB3785	24032	166	0.871795	1.4471797	Micrococcus	1269	Bacteria	Bacteria	252	1.28e-62	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g23879	i0	96.154	333.777108433735	156	3	95	3	1	154	347178	347332	Micrococcus luteus strain V017 chromosome, complete genome	blastn	55407	252	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16585826	16585826	PRJDB3785_S_NODE_8854_length_253_cov_1.931373_g8701_i0	PRJDB3785	8854	253	1.931373	4.88637369	Saccharothrix sp. 6-C	2781735	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1957912677\|gb\|CP064192.1\|	2781735	g8701	i0	100	0.118577075098814	30	0	12	0	66	95	9019042	9019013	Saccharothrix sp. 6-C chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Saccharothrix	Saccharothrix sp. 6-C
18832921	18832921	PRJDB3785_S_NODE_11255_length_227_cov_0.842697_g11102_i0	PRJDB3785	11255	227	0.842697	1.91292219	Pseudonocardia	1847	Bacteria	Bacteria	58.4	4.35e-4	NTclustered	gi\|1893041651\|gb\|CP060131.1\|	37331	g11102	i0	97.059	0.299559471365639	34	1	15	0	113	146	2691984	2692017	Pseudonocardia petroleophila strain CGMCC 4.1532 chromosome, complete genome	blastn	68	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia petroleophila
19134386	19134386	PRJDB3785_S_NODE_24676_length_165_cov_0.879310_g24523_i0	PRJDB3785	24676	165	0.87931	1.4508615	Tsukamurella tyrosinosolvens	57704	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1540130960\|emb\|LR134451.1\|	57704	g24523	i0	100	49.2909090909091	165	0	100	0	1	165	21974	21810	Tsukamurella tyrosinosolvens strain NCTC13231 genome assembly, plasmid: 9	blastn	8133	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella tyrosinosolvens
21383338	21383338	PRJDB3785_S_NODE_15597_length_197_cov_1.743243_g15444_i0	PRJDB3785	15597	197	1.743243	3.43418871	Cutibacterium	1912216	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g15444	i0	100	298.730964467005	197	0	100	0	1	197	56142	55946	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	58850	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22658179	22658179	PRJDB3785_S_NODE_18658_length_183_cov_1.141791_g18505_i0	PRJDB3785	18658	183	1.141791	2.08947753	Kocuria	57493	Bacteria	Bacteria	69.4	1.55e-7	NTclustered	gi\|1540116436\|emb\|LR134409.1\|	72000	g18505	i0	76.613	5.73224043715847	124	29	68	0	1	124	2087023	2086900	Kocuria rhizophila strain NCTC8340 genome assembly, chromosome: 1	blastn	1049	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila
22658180	22658180	PRJDB3785_S_NODE_20958_length_174_cov_1.488000_g20805_i0	PRJDB3785	20958	174	1.488	2.58912	Micromonospora	1873	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1269252475\|gb\|CP024052.1\|	2039870	g20805	i0	100	0.333333333333333	29	0	17	0	22	50	4773654	4773626	Micromonospora sp. WMMA2032 chromosome	blastn	58	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. WMMA2032
22658182	22658182	PRJDB3785_S_NODE_26038_length_163_cov_0.780702_g25885_i0	PRJDB3785	26038	163	0.780702	1.27254426	Mycobacteriales	85007	Bacteria	Bacteria	270	3.4499999999999993e-68	NTclustered	gi\|470486063\|ref\|NR_076733.1\|	2061	g25885	i0	96.894	329.19018404908	161	5	99	0	1	161	2232	2392	Tsukamurella paurometabola strain DSM 20162 23S ribosomal RNA gene, complete sequence	blastn	53658	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Tsukamurellaceae	Tsukamurella	Tsukamurella paurometabola
23933623	23933623	PRJDB3785_S_NODE_6519_length_295_cov_1.439024_g6366_i0	PRJDB3785	6519	295	1.439024	4.2451208	Cutibacterium	1912216	Bacteria	Bacteria	545	1.03e-150	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g6366	i0	100	243.718644067797	295	0	100	0	1	295	55336	55630	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	71897	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24234759	24234759	PRJDB3785_S_NODE_3920_length_387_cov_1.236686_g3767_i0	PRJDB3785	3920	387	1.236686	4.78597482	Arthrobacter sp. JZ12	2654190	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2643610450\|gb\|CP045246.1\|	2654190	g3767	i0	100	0.0723514211886305	28	0	7	0	271	298	2344935	2344962	Arthrobacter sp. JZ12 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp. JZ12

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