metadata: contig_metadata: 34 rows where analysis = "blastn", bioproject = "PRJNA657860" and tax

34 rows where analysis = "blastn", bioproject = "PRJNA657860" 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
625431	625431	PRJNA657860_P_NODE_1981_length_218_cov_1.359116_g1925_i0	PRJNA657860	1981	218	1.359116	2.96287288	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	390	3.6e-104	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g1925	i0	99.078	252.371559633028	217	2	99	0	2	218	885924	885708	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	55017	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
1901621	1901621	PRJNA657860_P_NODE_2342_length_196_cov_4.182390_g2286_i0	PRJNA657860	2342	196	4.18239	8.1974844	Corynebacterium incognita	2754725	Bacteria	Bacteria	259	9.31e-65	NTclustered	gi\|1891050950\|gb\|CP059404.1\|	2754725	g2286	i0	90.722	169.780612244898	194	18	99	0	1	194	788770	788577	Corynebacterium incognita strain Marseille-Q3630 chromosome	blastn	33277	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium incognita
1901622	1901622	PRJNA657860_P_NODE_2482_length_190_cov_1.156863_g2426_i0	PRJNA657860	2482	190	1.156863	2.1980397	Frankia casuarinae	106370	Bacteria	Bacteria	224	3.2699999999999995e-54	NTclustered	gi\|86565586\|gb\|CP000249.1\|	106370	g2426	i0	90.964	107.857894736842	166	15	87	0	4	169	3749448	3749613	Frankia casuarinae strain CcI3, complete genome	blastn	20493	224	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Frankiales	Frankiaceae	Frankia	Frankia casuarinae
2436591	2436591	PRJNA657860_P_NODE_262_length_706_cov_18.718984_g217_i0	PRJNA657860	262	706	18.718984	132.15602704	Cutibacterium	1912216	Bacteria	Bacteria	1304	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g217	i0	100	263.237960339943	706	0	100	0	1	706	55312	56017	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	185846	1304	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3176311	3176311	PRJNA657860_P_NODE_2123_length_208_cov_1.812865_g2067_i0	PRJNA657860	2123	208	1.812865	3.7707592	Dactylosporangium sp. AC04546	2862460	Bacteria	Bacteria	137	4.89e-28	NTclustered	gi\|2666884590\|gb\|CP139171.1\|	2862460	g2067	i0	90.385	32.2451923076923	104	10	50	0	105	208	5343918	5343815	Dactylosporangium sp. AC04546 chromosome, complete genome	blastn	6707	137	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Dactylosporangium	Dactylosporangium sp. AC04546
4453351	4453351	PRJNA657860_P_NODE_2144_length_207_cov_1.476471_g2088_i0	PRJNA657860	2144	207	1.476471	3.05629497	Actinomyces sp. oral taxon 171	706438	Bacteria	Bacteria	375	9.46e-100	NTclustered	gi\|1663027349\|gb\|CP040005.1\|	706439	g2088	i0	99.515	195.690821256039	206	1	99	0	1	206	983737	983942	Actinomyces sp. oral taxon 171 str. F0337 chromosome, complete genome	blastn	40508	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces sp. oral taxon 171
4989693	4989693	PRJNA657860_P_NODE_2784_length_178_cov_1.106383_g2728_i0	PRJNA657860	2784	178	1.106383	1.96936174	Micrococcus	1269	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g2728	i0	100	89.2921348314607	178	0	100	0	1	178	1806113	1806290	Micrococcus luteus strain V017 chromosome, complete genome	blastn	15894	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
5728872	5728872	PRJNA657860_P_NODE_1205_length_301_cov_4.784091_g1149_i0	PRJNA657860	1205	301	4.784091	14.40011391	Actinomyces oris	544580	Bacteria	Bacteria	462	1.09e-125	NTclustered	gi\|2430736086\|gb\|CP116225.1\|	544580	g1149	i0	94.371	381.033222591362	302	16	100	1	1	301	356848	357149	Actinomyces oris strain WVU627 plasmid unnamed1, complete sequence	blastn	114691	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
5728886	5728886	PRJNA657860_P_NODE_205_length_832_cov_8.654088_g164_i0	PRJNA657860	205	832	8.654088	72.00201216	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	1400	0	NTclustered	gi\|1954924873\|gb\|CP067012.1\|	1979527	g164	i0	97.119	395.596153846154	833	19	100	5	1	832	597288	598116	Corynebacterium kefirresidentii strain FDAARGOS_1055 chromosome, complete genome	blastn	329136	1400	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
6265218	6265218	PRJNA657860_P_NODE_325_length_629_cov_37.371622_g273_i0	PRJNA657860	325	629	37.371622	235.06750238	Nocardia	1817	Bacteria	Bacteria	950	0	NTclustered	gi\|2917112321\|gb\|CP146079.1\|	248551	g273	i0	94.763	342.230524642289	611	31	97	1	20	629	1054486	1053876	Nocardia testacea strain CS1 chromosome, complete genome	blastn	215263	950	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia testacea
7539306	7539306	PRJNA657860_P_NODE_3766_length_151_cov_1.087719_g3710_i0	PRJNA657860	3766	151	1.087719	1.64245569	Micrococcus	1269	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g3710	i0	100	27	151	0	100	0	1	151	874452	874602	Micrococcus luteus strain V017 chromosome, complete genome	blastn	4077	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
8814361	8814361	PRJNA657860_P_NODE_2067_length_211_cov_3.471264_g2011_i0	PRJNA657860	2067	211	3.471264	7.32436704	Corynebacterium	1716	Bacteria	Bacteria	316	5.95e-82	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g2011	i0	93.81	349.84834123222703	210	13	99	0	2	211	291745	291536	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	73818	316	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
9553995	9553995	PRJNA657860_P_NODE_1548_length_259_cov_1.657658_g1492_i0	PRJNA657860	1548	259	1.657658	4.29333422	Tessaracoccus flavus	1610493	Bacteria	Bacteria	211	3.68e-50	NTclustered	gi\|1146008008\|gb\|CP019605.1\|	1610493	g1492	i0	82.4	69.6100386100386	250	37	96	5	12	259	2048566	2048810	Tessaracoccus flavus strain RP1 chromosome, complete genome	blastn	18029	211	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus flavus
10090013	10090013	PRJNA657860_P_NODE_3548_length_156_cov_1.378151_g3492_i0	PRJNA657860	3548	156	1.378151	2.14991556	Janibacter	53457	Bacteria	Bacteria	261	1.96e-65	NTclustered	gi\|1916684862\|gb\|CP062789.1\|	857417	g3492	i0	96.815	105.551282051282	157	4	100	1	1	156	2967488	2967332	Janibacter indicus strain TT2 chromosome, complete genome	blastn	16466	261	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter indicus
11364836	11364836	PRJNA657860_P_NODE_3149_length_166_cov_1.209302_g3093_i0	PRJNA657860	3149	166	1.209302	2.00744132	Micrococcus	1269	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2873038046\|gb\|CP176570.1\|	1270	g3093	i0	99.398	30.3313253012048	166	1	100	0	1	166	504425	504260	Micrococcus luteus strain SZ.RS01 chromosome, complete genome	blastn	5035	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11364840	11364840	PRJNA657860_P_NODE_769_length_378_cov_2.131965_g713_i0	PRJNA657860	769	378	2.131965	8.0588277	Micrococcus	1269	Bacteria	Bacteria	699	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g713	i0	100	80.1402116402116	378	0	100	0	1	378	963589	963212	Micrococcus luteus strain V017 chromosome, complete genome	blastn	30293	699	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11364841	11364841	PRJNA657860_P_NODE_829_length_363_cov_5.125767_g773_i0	PRJNA657860	829	363	5.125767	18.60653421	Micrococcus	1269	Bacteria	Bacteria	671	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g773	i0	100	99.4325068870523	363	0	100	0	1	363	759949	759587	Micrococcus luteus strain V017 chromosome, complete genome	blastn	36094	671	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
12104798	12104798	PRJNA657860_P_NODE_2410_length_193_cov_0.987179_g2354_i0	PRJNA657860	2410	193	0.987179	1.90525547	Micrococcus yunnanensis	566027	Bacteria	Bacteria	357	3.1499999999999996e-94	NTclustered	gi\|2506638323\|gb\|CP125290.1\|	566027	g2354	i0	100	33.5440414507772	193	0	100	0	1	193	1812070	1812262	Micrococcus yunnanensis strain TJPT4 chromosome, complete genome	blastn	6474	357	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus yunnanensis
12104814	12104814	PRJNA657860_P_NODE_3590_length_155_cov_1.415254_g3534_i0	PRJNA657860	3590	155	1.415254	2.1936437	Janibacter sp. CX7	2963431	Bacteria	Bacteria	237	3.2800000000000004e-58	NTclustered	gi\|2274439729\|gb\|CP101464.1\|	2963431	g3534	i0	94.194	221.541935483871	155	9	100	0	1	155	1864971	1865125	Janibacter sp. CX7 chromosome, complete genome	blastn	34339	237	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter sp. CX7
13379550	13379550	PRJNA657860_P_NODE_2451_length_191_cov_1.779221_g2395_i0	PRJNA657860	2451	191	1.779221	3.39831211	Mycolicibacterium rutilum	370526	Bacteria	Bacteria	315	1.9e-81	NTclustered	gi\|1093265958\|emb\|LT629971.1\|	370526	g2395	i0	96.335	122.125654450262	191	7	100	0	1	191	4311426	4311616	Mycobacterium rutilum strain DSM 45405 genome assembly, chromosome: I	blastn	23326	315	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium rutilum
13379555	13379555	PRJNA657860_P_NODE_2891_length_174_cov_1.832117_g2835_i0	PRJNA657860	2891	174	1.832117	3.18788358	Corynebacterium haemomassiliense	2754726	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2831275068\|gb\|CP170998.1\|	2754726	g2835	i0	100	367.32183908046	174	0	100	0	1	174	122017	121844	Corynebacterium haemomassiliense strain WGS1525 chromosome, complete genome	blastn	63914	322	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium haemomassiliense
13915398	13915398	PRJNA657860_P_NODE_11_length_2163_cov_66.892756_g4_i2	PRJNA657860	11	2163	66.892756	1446.89031228	Micrococcus	1269	Bacteria	Bacteria	3037	0	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g4	i2	92.051	252.392048081368	2189	129	100	37	1	2163	2259024	2261193	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	545924	3037	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
13915399	13915399	PRJNA657860_P_NODE_1331_length_283_cov_1.715447_g1275_i0	PRJNA657860	1331	283	1.715447	4.85471501	Pseudonocardiaceae	2070	Bacteria	Bacteria	359	1.37e-94	NTclustered	gi\|2871294017\|gb\|CP176065.1\|	2652442	g1275	i0	89.825	283.060070671378	285	22	99	7	3	283	209932	209651	Amycolatopsis sp. VS8301801F10 chromosome, complete genome	blastn	80106	361	0.994459833795014	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. VS8301801F10
13915400	13915400	PRJNA657860_P_NODE_3171_length_165_cov_1.835938_g3115_i0	PRJNA657860	3171	165	1.835938	3.0292977	Actinomycetes	1760	Bacteria	Bacteria	230	5.939999999999998e-56	NTclustered	gi\|1052686253\|emb\|LT607754.1\|	47865	g3115	i0	95.172	272.933333333333	145	7	88	0	6	150	2118315	2118171	Micromonospora inositola strain DSM 43819 genome assembly, chromosome: I	blastn	45034	230	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora inositola
17203452	17203452	PRJNA657860_P_NODE_714_length_397_cov_1.622222_g658_i0	PRJNA657860	714	397	1.622222	6.44022134	Luteimicrobium xylanilyticum	1133546	Bacteria	Bacteria	65.8	4.88e-6	NTclustered	gi\|1771323152\|gb\|CP045529.1\|	1133546	g658	i0	91.667	1.48362720403023	48	2	12	1	147	194	970436	970481	Luteimicrobium xylanilyticum strain HY-24 chromosome, complete genome	blastn	589	65.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales		Luteimicrobium	Luteimicrobium xylanilyticum
19012931	19012931	PRJNA657860_P_NODE_3495_length_157_cov_2.008333_g3439_i0	PRJNA657860	3495	157	2.008333	3.15308281	Actinomyces	1654	Bacteria	Bacteria	276	7.06e-70	NTclustered	gi\|1828319996\|gb\|MT280231.1\|	1655	g3439	i0	98.71	100.700636942675	155	2	99	0	1	155	552	706	Actinomyces naeslundii strain KCOM 3097 (=JS204) 16S ribosomal RNA gene, partial sequence	blastn	15810	276	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
20287736	20287736	PRJNA657860_P_NODE_3736_length_152_cov_0.878261_g3680_i0	PRJNA657860	3736	152	0.878261	1.33495672	Micrococcus	1269	Bacteria	Bacteria	279	5.24e-71	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g3680	i0	100	27.8223684210526	151	0	99	0	2	152	1527321	1527471	Micrococcus luteus strain V017 chromosome, complete genome	blastn	4229	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
21027984	21027984	PRJNA657860_P_NODE_2217_length_203_cov_1.385542_g2161_i0	PRJNA657860	2217	203	1.385542	2.81265026	Rothia kristinae	37923	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1943322775\|gb\|CP065738.1\|	37923	g2161	i0	100	233.995073891626	203	0	100	0	1	203	985251	985049	Rothia kristinae strain FDAARGOS_864 chromosome, complete genome	blastn	47501	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia kristinae
21027998	21027998	PRJNA657860_P_NODE_357_length_601_cov_2.985816_g304_i0	PRJNA657860	357	601	2.985816	17.94475416	Arachnia propionica	1750	Bacteria	Bacteria	985	0	NTclustered	gi\|2694707911\|gb\|CP146373.1\|	1750	g304	i0	98.736	261.753743760399	554	7	92	0	48	601	44775	45328	Arachnia propionica strain NBRC 14587 chromosome, complete genome	blastn	157314	985	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Arachnia	Arachnia propionica
21563361	21563361	PRJNA657860_P_NODE_337_length_618_cov_2.786575_g284_i0	PRJNA657860	337	618	2.786575	17.2210335	Streptomyces	1883	Bacteria	Bacteria	60.2	3.66e-4	NTclustered	gi\|2655642090\|gb\|CP108863.1\|	1895	g284	i0	94.872	3.03883495145631	39	0	6	2	351	388	3060669	3060632	Streptomyces avidinii strain NBC_00832 chromosome, complete genome	blastn	1878	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces avidinii
24113342	24113342	PRJNA657860_P_NODE_2339_length_197_cov_0.950000_g2283_i0	PRJNA657860	2339	197	0.95	1.8715	Cutibacterium	1912216	Bacteria	Bacteria	285	1.55e-72	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2283	i0	93.684	229.43654822335	190	12	99	0	8	197	58644	58455	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	45199	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24113344	24113344	PRJNA657860_P_NODE_319_length_633_cov_13.733221_g267_i0	PRJNA657860	319	633	13.733221	86.93128893	Cutibacterium	1912216	Bacteria	Bacteria	1068	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g267	i0	97.156	271.320695102686	633	17	100	1	1	633	56613	55982	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	171746	1068	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24851700	24851700	PRJNA657860_P_NODE_2780_length_178_cov_1.205674_g2724_i0	PRJNA657860	2780	178	1.205674	2.14609972	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	279	6.35e-71	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g2724	i0	94.944	403.022471910112	178	9	100	0	1	178	81252	81429	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	71738	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
25387852	25387852	PRJNA657860_P_NODE_3480_length_158_cov_0.966942_g3424_i0	PRJNA657860	3480	158	0.966942	1.52776836	Kocuria	57493	Bacteria	Bacteria	292	7.07e-75	NTclustered	gi\|2239096029\|gb\|CP097204.1\|	72000	g3424	i0	100	59.5949367088608	158	0	100	0	1	158	898132	898289	Kocuria rhizophila strain Noodlococcus chromosome, complete genome	blastn	9416	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rhizophila

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