metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA532380" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA532380" 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
2392929	2392929	PRJNA532380_P_NODE_13682_length_245_cov_1.229592_g13357_i0	PRJNA532380	13682	245	1.229592	3.0125004	Gardnerella	2701	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2235500528\|gb\|CP083177.1\|	2702	g13357	i0	100	229.951020408163	245	0	100	0	1	245	740765	740521	Gardnerella vaginalis strain JNFY1 chromosome, complete genome	blastn	56338	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
3054505	3054505	PRJNA532380_P_NODE_12983_length_252_cov_1.423645_g12658_i0	PRJNA532380	12983	252	1.423645	3.5875854	Kytococcus sedentarius	1276	Bacteria	Bacteria	438	1.5e-118	NTclustered	gi\|1986032635\|gb\|CP069495.1\|	1276	g12658	i0	98.016	161.686507936508	252	5	100	0	1	252	483559	483810	Kytococcus sedentarius strain FDAARGOS_1200 chromosome, complete genome	blastn	40745	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Kytococcaceae	Kytococcus	Kytococcus sedentarius
3055281	3055281	PRJNA532380_P_NODE_7823_length_340_cov_2.848797_g7498_i0	PRJNA532380	7823	340	2.848797	9.6859098	Cutibacterium granulosum	33011	Bacteria	Bacteria	623	5.429999999999999e-174	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g7498	i0	99.706	262.079411764706	340	1	100	0	1	340	487444	487105	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	89107	623	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
6221003	6221003	PRJNA532380_P_NODE_11605_length_270_cov_0.954751_g11280_i0	PRJNA532380	11605	270	0.954751	2.5778277	Gardnerella	2701	Bacteria	Bacteria	488	1.5899999999999995e-133	NTclustered	gi\|470485651\|ref\|NR_076711.1\|	2702	g11280	i0	99.259	288.988888888889	270	2	100	0	1	270	1672	1403	Gardnerella vaginalis strain 409-05 23S ribosomal RNA gene, complete sequence	blastn	78027	488	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
8156577	8156577	PRJNA532380_P_NODE_18867_length_207_cov_1.778481_g18542_i0	PRJNA532380	18867	207	1.778481	3.68145567	Rothia mucilaginosa	43675	Bacteria	Bacteria	366	5.699999999999998e-97	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g18542	i0	98.551	238.63768115942	207	3	100	0	1	207	653737	653531	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	49398	366	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8157038	8157038	PRJNA532380_P_NODE_34027_length_152_cov_2.213592_g33702_i0	PRJNA532380	34027	152	2.213592	3.36465984	Propionimicrobium sp. PCR01-08-3	3052086	Bacteria	Bacteria	259	6.82e-65	NTclustered	gi\|2521516302\|gb\|CP127390.1\|	3052086	g33702	i0	97.368	355.756578947368	152	4	100	0	1	152	1748847	1748998	Propionimicrobium sp. PCR01-08-3 chromosome, complete genome	blastn	54075	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionimicrobium	Propionimicrobium sp. PCR01-08-3
8157209	8157209	PRJNA532380_P_NODE_8507_length_324_cov_1.647273_g8182_i0	PRJNA532380	8507	324	1.647273	5.33716452	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	599	8.67e-167	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g8182	i0	100	405.179012345679	324	0	100	0	1	324	128673	128350	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	131278	599	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
9432114	9432114	PRJNA532380_P_NODE_22268_length_190_cov_1.475177_g21943_i0	PRJNA532380	22268	190	1.475177	2.8028363	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	324	3.13e-84	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g21943	i0	97.368	333.121052631579	190	5	100	0	1	190	552090	551901	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	63293	324	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
10045953	10045953	PRJNA532380_P_NODE_17468_length_215_cov_1.644578_g17143_i0	PRJNA532380	17468	215	1.644578	3.5358427	Kytococcus	57499	Bacteria	Bacteria	364	2.139999999999999e-96	NTclustered	gi\|1948607475\|gb\|CP066015.1\|	1276	g17143	i0	97.209	432.027906976744	215	6	100	0	1	215	312133	312347	Kytococcus sedentarius strain FDAARGOS_1061 chromosome, complete genome	blastn	92886	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Kytococcaceae	Kytococcus	Kytococcus sedentarius
10045983	10045983	PRJNA532380_P_NODE_31028_length_165_cov_0.896552_g30703_i0	PRJNA532380	31028	165	0.896552	1.4793108	root	1	Root_unresolved	Root_unresolved	305	9.59e-79	NTclustered	gi\|2095693438\|gb\|OK148636.1\|	1679	g30703	i0	100	126.012121212121	165	0	100	0	1	165	632	468	Bifidobacterium longum subsp. longum strain K8 16S ribosomal RNA gene, partial sequence	blastn	20792	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
11982490	11982490	PRJNA532380_P_NODE_20650_length_198_cov_1.046980_g20325_i0	PRJNA532380	20650	198	1.04698	2.0730204	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	350	5.44e-92	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g20325	i0	98.485	294.641414141414	198	3	100	0	1	198	552876	553073	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	58339	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
11982839	11982839	PRJNA532380_P_NODE_32570_length_163_cov_0.912281_g32245_i0	PRJNA532380	32570	163	0.912281	1.48701803	Glutamicibacter arilaitensis	256701	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|307743277\|emb\|FQ311875.1\|	861360	g32245	i0	99.387	69.0981595092025	163	1	100	0	1	163	1142952	1142790	Arthrobacter arilaitensis RE117 chromosome, complete sequence	blastn	11263	296	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter arilaitensis
12596438	12596438	PRJNA532380_P_NODE_2570_length_661_cov_4.988562_g2286_i0	PRJNA532380	2570	661	4.988562	32.97439482	Glutamicibacter	1742989	Bacteria	Bacteria	1074	0	NTclustered	gi\|470491473\|ref\|NR_077040.1\|	256701	g2286	i0	95.934	373.027231467474	664	24	100	1	1	661	676	13	Arthrobacter arilaitensis strain Re117 23S ribosomal RNA gene, complete sequence	blastn	246571	1074	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter arilaitensis
12596455	12596455	PRJNA532380_P_NODE_33770_length_158_cov_2.385321_g33445_i0	PRJNA532380	33770	158	2.385321	3.76880718	Acidothermus	28048	Bacteria	Bacteria	248	1.55e-61	NTclustered	gi\|470481168\|ref\|NR_076458.1\|	28049	g33445	i0	94.937	298.683544303797	158	8	100	0	1	158	86	243	Acidothermus cellulolyticus strain 11B 23S ribosomal RNA gene, complete sequence	blastn	47192	248	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Acidothermales	Acidothermaceae	Acidothermus	Acidothermus cellulolyticus
13871346	13871346	PRJNA532380_P_NODE_4771_length_462_cov_1.791768_g4446_i0	PRJNA532380	4771	462	1.791768	8.27796816	Actinomycetes	1760	Bacteria	Bacteria	433	1.37e-116	NTclustered	gi\|470481168\|ref\|NR_076458.1\|	28049	g4446	i0	87.435	528.002164502165	382	40	82	7	1	379	1985	1609	Acidothermus cellulolyticus strain 11B 23S ribosomal RNA gene, complete sequence	blastn	243937	433	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Acidothermales	Acidothermaceae	Acidothermus	Acidothermus cellulolyticus
15145560	15145560	PRJNA532380_P_NODE_732_length_1211_cov_3.560241_g280_i1	PRJNA532380	732	1211	3.560241	43.11451851	Glutamicibacter	1742989	Bacteria	Bacteria	1890	0	NTclustered	gi\|470491473\|ref\|NR_077040.1\|	256701	g280	i1	94.901	428.099091659785	1216	49	99	12	1	1210	2044	836	Arthrobacter arilaitensis strain Re117 23S ribosomal RNA gene, complete sequence	blastn	518428	1890	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Glutamicibacter	Glutamicibacter arilaitensis
16420263	16420263	PRJNA532380_P_NODE_33473_length_162_cov_0.920354_g33148_i0	PRJNA532380	33473	162	0.920354	1.49097348	Cutibacterium	1912216	Bacteria	Bacteria	300	4.36e-77	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g33148	i0	100	51	162	0	100	0	1	162	877190	877029	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8262	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16420281	16420281	PRJNA532380_P_NODE_8313_length_328_cov_1.813620_g7988_i0	PRJNA532380	8313	328	1.81362	5.9486736	Dermacoccus	57495	Bacteria	Bacteria	593	4.0899999999999983e-165	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g7988	i0	99.39	215.719512195122	328	1	100	1	1	328	127778	128104	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	70756	593	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
17081473	17081473	PRJNA532380_P_NODE_33354_length_162_cov_0.920354_g33029_i0	PRJNA532380	33354	162	0.920354	1.49097348	Cutibacterium acnes	1747	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|2493035247\|gb\|CP114009.1\|	1747	g33029	i0	99.383	60.2037037037037	162	1	100	0	1	162	367466	367305	Cutibacterium acnes strain CBS-BPNBT19223 chromosome, complete genome	blastn	9753	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17695428	17695428	PRJNA532380_P_NODE_30354_length_165_cov_2.370690_g30029_i0	PRJNA532380	30354	165	2.37069	3.9116385	Corynebacterium	1716	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|1403442131\|emb\|LS483404.1\|	1724	g30029	i0	98.788	389.133333333333	165	2	100	0	1	165	282376	282540	Corynebacterium renale strain NCTC11140 genome assembly, chromosome: 1	blastn	64207	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium renale
18355119	18355119	PRJNA532380_P_NODE_18995_length_207_cov_0.892405_g18670_i0	PRJNA532380	18995	207	0.892405	1.84727835	Micromonospora sp. WMMD964	3016091	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|2474592735\|gb\|CP120860.1\|	3016091	g18670	i0	100	0.135265700483092	28	0	14	0	155	182	6345298	6345271	Micromonospora sp. WMMD964 chromosome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. WMMD964
18969001	18969001	PRJNA532380_P_NODE_30355_length_165_cov_2.318966_g30030_i0	PRJNA532380	30355	165	2.318966	3.8262939	Nakamurella	53460	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1527182123\|gb\|CP034170.1\|	1902245	g30030	i0	100	415.036363636364	165	0	100	0	1	165	252587	252423	Nakamurella antarctica strain S14-144 chromosome, complete genome	blastn	68481	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Nakamurellales	Nakamurellaceae	Nakamurella	Nakamurella antarctica
19629918	19629918	PRJNA532380_P_NODE_25856_length_175_cov_0.928571_g25531_i0	PRJNA532380	25856	175	0.928571	1.62499925	Cutibacterium granulosum	33011	Bacteria	Bacteria	307	2.8500000000000004e-79	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g25531	i0	98.837	250.125714285714	172	2	100	0	1	172	485632	485803	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	43772	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
19629948	19629948	PRJNA532380_P_NODE_26816_length_171_cov_0.811475_g26491_i0	PRJNA532380	26816	171	0.811475	1.38762225	Nocardioides okcheonensis	2894081	Bacteria	Bacteria	305	9.96e-79	NTclustered	gi\|2156608594\|gb\|CP087710.1\|	2894081	g26491	i0	98.83	271.608187134503	171	2	100	0	1	171	745845	745675	Nocardioides okcheonensis strain MMS20-HV4-12 chromosome, complete genome	blastn	46445	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides okcheonensis
20243911	20243911	PRJNA532380_P_NODE_18616_length_209_cov_0.943750_g18291_i0	PRJNA532380	18616	209	0.94375	1.9724375	Bifidobacterium	1678	Bacteria	Bacteria	370	4.45e-98	NTclustered	gi\|1917234788\|gb\|CP062943.1\|	1679	g18291	i0	98.565	276	209	3	100	0	1	209	244512	244304	Bifidobacterium longum subsp. longum strain KCTC 5915 chromosome	blastn	57684	370	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Bifidobacterium	Bifidobacterium longum
21519457	21519457	PRJNA532380_P_NODE_11337_length_273_cov_1.598214_g11012_i0	PRJNA532380	11337	273	1.598214	4.36312422	Corynebacterium	1716	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g11012	i0	98.535	358.842490842491	273	4	100	0	1	273	3868	3596	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	97964	483	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
23455781	23455781	PRJNA532380_P_NODE_16199_length_224_cov_1.485714_g15874_i0	PRJNA532380	16199	224	1.485714	3.32799936	Nocardioides sp. zg-1228	2763008	Bacteria	Bacteria	398	2.2199999999999997e-106	NTclustered	gi\|1995570698\|gb\|CP070961.1\|	2763008	g15874	i0	98.661	313.357142857143	224	3	100	0	1	224	1509849	1509626	Nocardioides sp. zg-1228 chromosome, complete genome	blastn	70192	398	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. zg-1228
24069442	24069442	PRJNA532380_P_NODE_33719_length_159_cov_3.136364_g33394_i0	PRJNA532380	33719	159	3.136364	4.98681876	Corynebacterium	1716	Bacteria	Bacteria	259	7.23e-65	NTclustered	gi\|2531251647\|gb\|CP046606.1\|	144183	g33394	i0	96.25	360.006289308176	160	3	99	3	2	159	648653	648811	Corynebacterium afermentans subsp. afermentans strain DSM 44280 chromosome, complete genome	blastn	57241	261	0.992337164750958	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
24729617	24729617	PRJNA532380_P_NODE_17460_length_215_cov_1.819277_g17135_i0	PRJNA532380	17460	215	1.819277	3.91144555	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g17135	i0	100	620.018604651163	215	0	100	0	1	215	1215382	1215168	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	133304	398	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
24730172	24730172	PRJNA532380_P_NODE_6000_length_399_cov_3.797143_g5675_i0	PRJNA532380	6000	399	3.797143	15.15060057	Micrococcus porci	2856555	Bacteria	Bacteria	508	1.89e-139	NTclustered	gi\|2099415156\|gb\|CP083691.1\|	2856555	g5675	i0	97.324	258.827067669173	299	8	75	0	101	399	3104	3402	Micrococcus porci strain KD337-16 chromosome, complete genome	blastn	103272	508	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus porci

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