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

30 rows where analysis = "blastn", bioproject = "PRJNA450343" 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
439063	439063	PRJNA450343_P_NODE_12281_length_164_cov_0.886957_g12213_i0	PRJNA450343	12281	164	0.886957	1.45460948	Corynebacterium pyruviciproducens	598660	Bacteria	Bacteria	300	4.43e-77	NTclustered	gi\|2613058804\|gb\|CP136958.1\|	598660	g12213	i0	100	86.9939024390244	162	0	99	0	3	164	379445	379606	Corynebacterium pyruviciproducens strain UMB0763 chromosome, complete genome	blastn	14267	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pyruviciproducens
1092510	1092510	PRJNA450343_P_NODE_3601_length_281_cov_2.004310_g3533_i0	PRJNA450343	3601	281	2.00431	5.6321111	Corynebacterium	1716	Bacteria	Bacteria	396	1.04e-105	NTclustered	gi\|2075671402\|gb\|CP068278.1\|	1190508	g3533	i0	93.015	280.032028469751	272	17	96	2	11	281	210034	210304	Corynebacterium aquatimens strain CNCTC chromosome, complete genome	blastn	78689	396	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium aquatimens
1092522	1092522	PRJNA450343_P_NODE_9481_length_177_cov_1.484375_g9413_i0	PRJNA450343	9481	177	1.484375	2.62734375	Corynebacterium	1716	Bacteria	Bacteria	320	3.71e-83	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g9413	i0	99.432	360.022598870056	176	1	99	0	1	176	760212	760037	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	63724	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
3643526	3643526	PRJNA450343_P_NODE_3983_length_266_cov_2.428571_g3915_i0	PRJNA450343	3983	266	2.428571	6.45999886	Microlunatus	29404	Bacteria	Bacteria	462	9.48e-126	NTclustered	gi\|470475867\|ref\|NR_076305.1\|	29405	g3915	i0	98.113	228.176691729323	265	5	99	0	2	266	279	15	Microlunatus phosphovorus strain NM-1 23S ribosomal RNA gene, complete sequence	blastn	60695	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus phosphovorus
6195551	6195551	PRJNA450343_P_NODE_4165_length_260_cov_1.350711_g4097_i0	PRJNA450343	4165	260	1.350711	3.5118486	Dermacoccus	57495	Bacteria	Bacteria	387	5.72e-103	NTclustered	gi\|1730271953\|gb\|CP043031.1\|	322596	g4097	i0	93.511	194.6	262	13	100	4	1	260	1659300	1659041	Dermacoccus abyssi strain HZAU 226 chromosome, complete genome	blastn	50596	387	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus abyssi
6195556	6195556	PRJNA450343_P_NODE_8105_length_190_cov_1.439716_g8037_i0	PRJNA450343	8105	190	1.439716	2.7354604	Actinomycetes	1760	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|310696325\|gb\|HQ234267.1\|	43669	g8037	i0	100	100	190	0	100	0	1	190	501	690	Brachybacterium faecium strain QL-13 16S ribosomal RNA gene, partial sequence	blastn	19000	351	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium faecium
6195559	6195559	PRJNA450343_P_NODE_9825_length_174_cov_1.168000_g9757_i0	PRJNA450343	9825	174	1.168	2.03232	Rhodococcus	1827	Bacteria	Bacteria	265	1.73e-66	NTclustered	gi\|2659055393\|gb\|CP108043.1\|	2976004	g9757	i0	94.286	412.241379310345	175	7	100	3	1	174	866044	865872	Rhodococcus sp. NBC_00294 chromosome, complete genome	blastn	71730	267	0.99250936329588	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. NBC_00294
8092212	8092212	PRJNA450343_P_NODE_12427_length_164_cov_0.886957_g12359_i0	PRJNA450343	12427	164	0.886957	1.45460948	Actinomyces naeslundii	1655	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g12359	i0	98.78	2.01219512195122	164	2	100	0	1	164	1142421	1142258	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	330	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
8092235	8092235	PRJNA450343_P_NODE_2207_length_367_cov_3.871069_g2139_i0	PRJNA450343	2207	367	3.871069	14.20682323	Microlunatus sagamiharensis	546874	Bacteria	Bacteria	658	0	NTclustered	gi\|1086063565\|emb\|LT629799.1\|	546874	g2139	i0	99.178	257.245231607629	365	3	99	0	3	367	1045037	1044673	Friedmanniella sagamiharensis strain DSM 21743 genome assembly, chromosome: I	blastn	94409	658	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sagamiharensis
8745489	8745489	PRJNA450343_P_NODE_227_length_1140_cov_5.175069_g31_i1	PRJNA450343	227	1140	5.175069	58.9957866	Micrococcus	1269	Bacteria	Bacteria	1973	0	NTclustered	gi\|1666025147\|gb\|CP025616.2\|	1270	g31	i1	97.895	247.373684210526	1140	24	100	0	1	1140	1410004	1408865	Micrococcus luteus strain SGAir0127 chromosome, complete genome	blastn	282006	1978	0.99747219413549	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
10020724	10020724	PRJNA450343_P_NODE_7728_length_194_cov_1.510345_g7660_i0	PRJNA450343	7728	194	1.510345	2.9300693	Corynebacterium	1716	Bacteria	Bacteria	353	4.1e-93	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g7660	i0	99.485	357.90206185567	194	1	100	0	1	194	1254431	1254624	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	69433	353	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
11295636	11295636	PRJNA450343_P_NODE_5689_length_224_cov_0.994286_g5621_i0	PRJNA450343	5689	224	0.994286	2.22720064	Pseudonocardia	1847	Bacteria	Bacteria	339	1.36e-88	NTclustered	gi\|1464106963\|dbj\|AP018920.1\|	2074	g5621	i0	93.833	233.700892857143	227	11	100	3	1	224	645555	645781	Pseudonocardia autotrophica NBRC 12743 DNA, complete genome	blastn	52349	339	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia autotrophica
11917815	11917815	PRJNA450343_P_NODE_5490_length_227_cov_1.039326_g5422_i0	PRJNA450343	5490	227	1.039326	2.35927002	Pedococcus dokdonensis	443156	Bacteria	Bacteria	329	8.34e-86	NTclustered	gi\|1085742359\|emb\|LT629711.1\|	443156	g5422	i0	92.952	99.5462555066079	227	14	100	2	1	227	1366828	1367052	Phycicoccus dokdonensis strain DSM 22329 genome assembly, chromosome: I	blastn	22597	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Pedococcus	Pedococcus dokdonensis
12571394	12571394	PRJNA450343_P_NODE_1490_length_455_cov_2.894089_g1422_i0	PRJNA450343	1490	455	2.894089	13.16810495	Micrococcus	1269	Bacteria	Bacteria	819	0	NTclustered	gi\|2276865348\|gb\|CP101528.1\|	1270	g1422	i0	99.121	252.487912087912	455	4	100	0	1	455	1628927	1628473	Micrococcus luteus strain ML chromosome, complete genome	blastn	114882	819	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
12571408	12571408	PRJNA450343_P_NODE_9370_length_178_cov_1.565891_g9302_i0	PRJNA450343	9370	178	1.565891	2.78728598	Cutibacterium	1912216	Bacteria	Bacteria	180	6.62e-41	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9302	i0	100	55.5730337078652	97	0	100	0	82	178	2086774	2086678	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9892	180	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13192625	13192625	PRJNA450343_P_NODE_3911_length_269_cov_1.154545_g3843_i0	PRJNA450343	3911	269	1.154545	3.10572605	Mycolicibacterium phlei	1771	Bacteria	Bacteria	403	5.91e-108	NTclustered	gi\|1003466887\|gb\|CP014475.1\|	1771	g3843	i0	93.68	128.992565055762	269	17	100	0	1	269	2337268	2337536	Mycolicibacterium phlei strain CCUG 21000, complete genome	blastn	34699	403	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phlei
13846040	13846040	PRJNA450343_P_NODE_7051_length_202_cov_1.986928_g6983_i0	PRJNA450343	7051	202	1.986928	4.01359456	Streptomyces	1883	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|2413490837\|gb\|CP114036.1\|	2979468	g6983	i0	100	609.212871287129	202	0	100	0	1	202	1451175	1451376	Streptomyces sp. S465 chromosome, complete genome	blastn	123061	374	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. S465
14467678	14467678	PRJNA450343_P_NODE_13592_length_162_cov_0.858407_g13524_i0	PRJNA450343	13592	162	0.858407	1.39061934	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	265	1.5899999999999998e-66	NTclustered	gi\|2874253708\|emb\|OY969473.1\|	3039803	g13524	i0	96.855	34.9012345679012	159	3	98	2	1	158	1215288	1215131	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.21 genome assembly, chromosome: 1	blastn	5654	265	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
15120293	15120293	PRJNA450343_P_NODE_11712_length_165_cov_0.879310_g11644_i0	PRJNA450343	11712	165	0.87931	1.4508615	Cutibacterium	1912216	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2493032747\|gb\|CP114008.1\|	1747	g11644	i0	100	63.7878787878788	165	0	100	0	1	165	197172	197336	Cutibacterium acnes strain CBS-BPNBT19227 chromosome, complete genome	blastn	10525	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15120305	15120305	PRJNA450343_P_NODE_472_length_829_cov_4.484615_g31_i2	PRJNA450343	472	829	4.484615	37.17745835	Micrococcus	1269	Bacteria	Bacteria	1210	0	NTclustered	gi\|1666025147\|gb\|CP025616.2\|	1270	g31	i2	95.646	286.363088057901	758	26	91	6	75	829	1409251	1410004	Micrococcus luteus strain SGAir0127 chromosome, complete genome	blastn	237395	1216	0.995065789473684	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16395126	16395126	PRJNA450343_P_NODE_3493_length_286_cov_1.375527_g3425_i0	PRJNA450343	3493	286	1.375527	3.93400722	Microbacteriaceae	85023	Bacteria	Bacteria	446	1.04e-120	NTclustered	gi\|1181962694\|gb\|CP020715.1\|	1619308	g3425	i0	94.755	175.01048951049	286	15	100	0	1	286	1012577	1012292	Cnuibacter physcomitrellae strain XA(T), complete genome	blastn	50053	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Cnuibacter	Cnuibacter physcomitrellae
18943988	18943988	PRJNA450343_P_NODE_3515_length_285_cov_2.021186_g3447_i0	PRJNA450343	3515	285	2.021186	5.7603801	Microlunatus	29404	Bacteria	Bacteria	516	7.77e-142	NTclustered	gi\|2790585546\|gb\|PQ215974.1\|	29405	g3447	i0	99.298	100.017543859649	285	2	100	0	1	285	375	659	Microlunatus phosphovorus strain CW071 16S ribosomal RNA gene, partial sequence	blastn	28505	521	0.990403071017274	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus phosphovorus
18943998	18943998	PRJNA450343_P_NODE_9975_length_172_cov_1.430894_g9907_i0	PRJNA450343	9975	172	1.430894	2.46113768	root	1	Root_unresolved	Root_unresolved	307	2.79e-79	NTclustered	gi\|380858307\|gb\|JQ354975.1\|	2702	g9907	i0	98.837	107	172	2	100	0	1	172	524	695	Gardnerella vaginalis strain N160 16S ribosomal RNA gene, partial sequence	blastn	18404	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Gardnerella	Gardnerella vaginalis
19564866	19564866	PRJNA450343_P_NODE_4796_length_242_cov_2.466321_g4728_i0	PRJNA450343	4796	242	2.466321	5.96849682	uncultured Actinomycetota bacterium	3039803	Bacteria	Bacteria	370	5.3e-98	NTclustered	gi\|2874253874\|emb\|OY969929.1\|	3039803	g4728	i0	94.286	266.925619834711	245	8	100	4	1	242	2295820	2295579	MAG: uncultured Actinomycetota bacterium isolate MFD01275.bin.c.20 genome assembly, chromosome: 1	blastn	64596	370	1	Bacteria	Bacillati	Actinomycetota					uncultured Actinomycetota bacterium
20218717	20218717	PRJNA450343_P_NODE_496_length_808_cov_2.747036_g449_i0	PRJNA450343	496	808	2.747036	22.19605088	Cutibacterium	1912216	Bacteria	Bacteria	1413	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g449	i0	98.623	279.962871287129	799	9	99	2	11	808	55368	56165	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	226210	1413	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22769444	22769444	PRJNA450343_P_NODE_3418_length_289_cov_4.245833_g3350_i0	PRJNA450343	3418	289	4.245833	12.27045737	Micrococcus	1269	Bacteria	Bacteria	532	7.84e-147	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g3350	i0	100	403.297577854671	288	0	99	0	2	289	348533	348246	Micrococcus luteus strain V017 chromosome, complete genome	blastn	116553	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
24044352	24044352	PRJNA450343_P_NODE_1039_length_556_cov_3.928994_g973_i0	PRJNA450343	1039	556	3.928994	21.84520664	Cutibacterium	1912216	Bacteria	Bacteria	817	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g973	i0	93.357	286.451438848921	557	29	99	8	1	554	56190	56741	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	159267	817	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24044362	24044362	PRJNA450343_P_NODE_39_length_1984_cov_4.524031_g31_i0	PRJNA450343	39	1984	4.524031	89.75677504	Micrococcus	1269	Bacteria	Bacteria	2892	0	NTclustered	gi\|1666025147\|gb\|CP025616.2\|	1270	g31	i0	93.152	273.061995967742	1986	112	99	22	11	1984	1408031	1410004	Micrococcus luteus strain SGAir0127 chromosome, complete genome	blastn	541755	2898	0.997929606625259	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
25318712	25318712	PRJNA450343_P_NODE_2700_length_329_cov_5.014286_g2632_i0	PRJNA450343	2700	329	5.014286	16.49700094	Cutibacterium	1912216	Bacteria	Bacteria	556	5.38e-154	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2632	i0	98.119	320.781155015198	319	6	97	0	1	319	58052	57734	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	105537	556	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25318728	25318728	PRJNA450343_P_NODE_9180_length_180_cov_1.267176_g9112_i0	PRJNA450343	9180	180	1.267176	2.2809168	Cutibacterium	1912216	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9112	i0	100	52.9888888888889	180	0	100	0	1	180	994429	994608	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9538	333	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes

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