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

29 rows where analysis = "blastn", bioproject = "PRJNA407087" 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
2357088	2357088	PRJNA407087_S_NODE_2602_length_391_cov_4.491713_g2141_i0	PRJNA407087	2602	391	4.491713	17.56259783	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g2141	i0	86.538	0.815856777493606	52	4	13	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
2357094	2357094	PRJNA407087_S_NODE_502_length_1075_cov_3.762906_g305_i0	PRJNA407087	502	1075	3.762906	40.4512395	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.03	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g305	i0	86.538	0.296744186046512	52	4	5	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
4242073	4242073	PRJNA407087_S_NODE_7804_length_173_cov_4.062500_g7341_i0	PRJNA407087	7804	173	4.0625	7.028125	Diaminobutyricimonas sp. LJ205	2683590	Bacteria	Bacteria	281	1.7e-71	NTclustered	gi\|1784272846\|gb\|CP046619.1\|	2683590	g7341	i0	98.734	146.404624277457	158	2	91	0	16	173	574656	574499	Diaminobutyricimonas sp. LJ205 chromosome, complete genome	blastn	25328	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Diaminobutyricimonas	Diaminobutyricimonas sp. LJ205
4909644	4909644	PRJNA407087_S_NODE_3564_length_305_cov_15.663043_g3101_i0	PRJNA407087	3564	305	15.663043	47.77228115	Cutibacterium	1912216	Bacteria	Bacteria	527	3.8799999999999996e-145	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g3101	i0	100	245.091803278689	285	0	95	0	1	285	56772	57056	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	74753	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4909649	4909649	PRJNA407087_S_NODE_7524_length_177_cov_4.783784_g7061_i0	PRJNA407087	7524	177	4.783784	8.46729768	Jatrophihabitans	1434010	Bacteria	Bacteria	278	2.27e-70	NTclustered	gi\|2241535527\|gb\|CP097332.1\|	2038343	g7061	i0	94.915	377.853107344633	177	9	100	0	1	177	1909789	1909613	Jatrophihabitans telluris strain N237 chromosome, complete genome	blastn	66880	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Jatrophihabitantales	Jatrophihabitantaceae	Jatrophihabitans	Jatrophihabitans telluris
5518740	5518740	PRJNA407087_S_NODE_6905_length_187_cov_4.544304_g6442_i0	PRJNA407087	6905	187	4.544304	8.49784848	Schaalia odontolytica	1660	Bacteria	Bacteria	326	8.54e-85	NTclustered	gi\|2283191586\|gb\|CP102197.1\|	1660	g6442	i0	98.378	292.770053475936	185	3	99	0	1	185	8520	8704	Schaalia odontolytica strain KHUD_008 chromosome, complete genome	blastn	54748	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
6184729	6184729	PRJNA407087_S_NODE_3185_length_337_cov_11.386364_g2722_i0	PRJNA407087	3185	337	11.386364	38.37204668	Corynebacterium	1716	Bacteria	Bacteria	588	1.96e-163	NTclustered	gi\|2550482033\|gb\|CP100379.1\|	38284	g2722	i0	98.22	355.813056379822	337	5	100	1	1	337	2461876	2462211	Corynebacterium accolens strain CA4 chromosome	blastn	119909	588	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
6792658	6792658	PRJNA407087_S_NODE_2106_length_453_cov_20.405660_g1648_i0	PRJNA407087	2106	453	20.40566	92.4376398	Streptomyces sp. NBC_00857	2975851	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|2655540414\|gb\|CP108829.1\|	2975851	g1648	i0	92.5	0.0883002207505519	40	3	9	0	214	253	2448830	2448791	Streptomyces sp. NBC_00857 chromosome, complete genome	blastn	40	58.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00857
7459588	7459588	PRJNA407087_S_NODE_3506_length_310_cov_34.946619_g3043_i0	PRJNA407087	3506	310	34.946619	108.3345189	Schaalia	2529408	Bacteria	Bacteria	562	1.08e-155	NTclustered	gi\|1829677389\|gb\|MT318512.1\|	1660	g3043	i0	99.355	102	310	2	100	0	1	310	474	783	Schaalia odontolytica strain KCOM 1817 (= ChDC B514) 16S ribosomal RNA gene, partial sequence	blastn	31620	562	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
8068240	8068240	PRJNA407087_S_NODE_1947_length_473_cov_7.804054_g1497_i0	PRJNA407087	1947	473	7.804054	36.91317542	Corynebacterium sp. LaCa191	3391426	Bacteria	Bacteria	839	0	NTclustered	gi\|2888556127\|gb\|CP177100.1\|	3391426	g1497	i0	98.734	359.758985200846	474	3	100	3	1	473	777401	777872	Corynebacterium sp. LaCa191 chromosome, complete genome	blastn	170166	839	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. LaCa191
8734490	8734490	PRJNA407087_S_NODE_507_length_1065_cov_16.976834_g289_i2	PRJNA407087	507	1065	16.976834	180.8032821	Corynebacterium	1716	Bacteria	Bacteria	1393	0	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g289	i2	90.278	341.880751173709	1080	84	100	15	1	1065	3382	2309	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	364103	1393	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
11284937	11284937	PRJNA407087_S_NODE_1289_length_619_cov_4.061017_g903_i0	PRJNA407087	1289	619	4.061017	25.13769523	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g903	i0	86.538	0.515347334410339	52	4	8	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
11893799	11893799	PRJNA407087_S_NODE_5090_length_231_cov_5.950495_g4627_i0	PRJNA407087	5090	231	5.950495	13.74564345	Cutibacterium granulosum	33011	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g4627	i0	100	269.779220779221	231	0	100	0	1	231	485856	486086	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	62319	427	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
13168727	13168727	PRJNA407087_S_NODE_5491_length_218_cov_3.481481_g5028_i0	PRJNA407087	5491	218	3.481481	7.58962858	Actinomyces massiliensis	461393	Bacteria	Bacteria	403	4.62e-108	NTclustered	gi\|2557556977\|gb\|CP128646.1\|	461393	g5028	i0	100	170.52752293578	218	0	100	0	1	218	1430133	1430350	Actinomyces massiliensis strain F0489 chromosome, complete genome	blastn	37175	403	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces massiliensis
13835172	13835172	PRJNA407087_S_NODE_8231_length_167_cov_8.391304_g7768_i0	PRJNA407087	8231	167	8.391304	14.01347768	Corynebacterium	1716	Bacteria	Bacteria	285	1.27e-72	NTclustered	gi\|2550482033\|gb\|CP100379.1\|	38284	g7768	i0	98.75	354.59880239521	160	2	96	0	1	160	2461583	2461424	Corynebacterium accolens strain CA4 chromosome	blastn	59218	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
14443904	14443904	PRJNA407087_S_NODE_7152_length_183_cov_2.506494_g6689_i0	PRJNA407087	7152	183	2.506494	4.58688402	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	270	3.949999999999999e-68	NTclustered	gi\|2874253667\|emb\|OY969101.1\|	3039803	g6689	i0	93.407	79.5737704918033	182	12	99	0	2	183	1724399	1724218	MAG: uncultured Actinomycetota bacterium isolate MFD04212.bin.c.6 genome assembly, chromosome: 1	blastn	14562	270	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
16384064	16384064	PRJNA407087_S_NODE_333_length_1303_cov_3.693878_g207_i0	PRJNA407087	333	1303	3.693878	48.13123034	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.037	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g207	i0	86.538	0.244819646968534	52	4	4	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
16384072	16384072	PRJNA407087_S_NODE_6873_length_188_cov_3.213836_g6410_i0	PRJNA407087	6873	188	3.213836	6.04201168	root	1	Root_unresolved	Root_unresolved	337	3.97e-88	NTclustered	gi\|285178672\|gb\|GU416788.1\|	2047	g6410	i0	98.936	100	188	2	100	0	1	188	206	19	Rothia dentocariosa clone IO009 16S ribosomal RNA gene, partial sequence	blastn	18800	337	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia dentocariosa
17659216	17659216	PRJNA407087_S_NODE_2514_length_400_cov_16.420485_g2053_i0	PRJNA407087	2514	400	16.420485	65.68194	Cutibacterium	1912216	Bacteria	Bacteria	739	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2053	i0	100	282.5425	400	0	100	0	1	400	56404	56803	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	113017	739	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17659217	17659217	PRJNA407087_S_NODE_254_length_1531_cov_3.645806_g168_i0	PRJNA407087	254	1531	3.645806	55.81728986	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.044	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g168	i0	86.538	0.208360548661006	52	4	3	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
18266567	18266567	PRJNA407087_S_NODE_5115_length_230_cov_7.517413_g4652_i0	PRJNA407087	5115	230	7.517413	17.2900499	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	361	3e-95	NTclustered	gi\|110754373\|gb\|DQ829060.1\|	152507	g4652	i0	97.619	83.7086956521739	210	5	91	0	3	212	210	1	Uncultured actinobacterium clone DOK_NOFERT_clone053 16S ribosomal RNA gene, partial sequence	blastn	19253	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
20207844	20207844	PRJNA407087_S_NODE_5296_length_223_cov_16.247423_g4833_i0	PRJNA407087	5296	223	16.247423	36.23175329	Cutibacterium	1912216	Bacteria	Bacteria	372	1.34e-98	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4833	i0	99.034	264.95067264574	207	2	94	0	1	207	57030	57236	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	59084	372	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
20816575	20816575	PRJNA407087_S_NODE_1557_length_542_cov_6.801170_g1138_i0	PRJNA407087	1557	542	6.80117	36.8623414	Mycolicibacterium sp. HK-90	3056937	Bacteria	Bacteria	54.7	0.015	NTclustered	gi\|2546278271\|gb\|CP129613.1\|	3056937	g1138	i0	94.444	0.0664206642066421	36	0	7	2	19	54	5682285	5682252	Mycolicibacterium sp. HK-90 chromosome, complete genome	blastn	36	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium sp. HK-90
20816607	20816607	PRJNA407087_S_NODE_4437_length_257_cov_30.508772_g3974_i0	PRJNA407087	4437	257	30.508772	78.40754404	Streptomyces sp. AM 4-1-1	3028710	Bacteria	Bacteria	148	2.8999999999999996e-31	NTclustered	gi\|2455060353\|gb\|CP119145.1\|	3028710	g3974	i0	86.667	50.2062256809339	135	16	52	2	124	257	3168577	3168710	Streptomyces sp. AM 4-1-1 chromosome, complete genome	blastn	12903	148	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. AM 4-1-1
21483380	21483380	PRJNA407087_S_NODE_477_length_1101_cov_22.085821_g289_i0	PRJNA407087	477	1101	22.085821	243.16488921	Cutibacterium	1912216	Bacteria	Bacteria	2004	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g289	i0	99.908	264.772933696639	1088	1	99	0	14	1101	55350	56437	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	291515	2004	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22091427	22091427	PRJNA407087_S_NODE_4938_length_236_cov_10.681159_g4475_i0	PRJNA407087	4938	236	10.681159	25.20753524	Cutibacterium granulosum	33011	Bacteria	Bacteria	392	1.0999999999999999e-104	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g4475	i0	96.624	283.572033898305	237	7	100	1	1	236	486833	487069	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	66923	392	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
22758599	22758599	PRJNA407087_S_NODE_478_length_1099_cov_17.285047_g289_i1	PRJNA407087	478	1099	17.285047	189.96266653	Cutibacterium	1912216	Bacteria	Bacteria	1576	0	NTclustered	gi\|2493038017\|gb\|CP114010.1\|	1747	g289	i1	92.896	270.663330300273	1098	56	99	19	14	1099	606880	607967	Cutibacterium acnes strain CBS-BPNBT19329 chromosome, complete genome	blastn	297459	1576	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24033380	24033380	PRJNA407087_S_NODE_779_length_847_cov_3.870416_g494_i0	PRJNA407087	779	847	3.870416	32.78242352	Glutamicibacter	1742989	Bacteria	Bacteria	54.7	0.024	NTclustered	gi\|1906898532\|gb\|CP059853.1\|	37929	g494	i0	86.538	0.376623376623377	52	4	6	3	34	83	666778	666728	Glutamicibacter nicotianae strain ZM05 chromosome, complete genome	blastn	319	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter nicotianae
24641381	24641381	PRJNA407087_S_NODE_4660_length_247_cov_17.293578_g4197_i0	PRJNA407087	4660	247	17.293578	42.71513766	Mycobacterium xenopi	1789	Bacteria	Bacteria	339	1.5299999999999998e-88	NTclustered	gi\|1787584700\|dbj\|AP022314.1\|	1789	g4197	i0	93.162	146.821862348178	234	10	97	5	1	233	2753374	2753602	Mycobacterium xenopi JCM 15661T DNA, complete genome	blastn	36265	339	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium xenopi

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