metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1248471" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1248471" 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
2904442	2904442	PRJNA1248471_S_NODE_2163_length_324_cov_1.810909_g2063_i0	PRJNA1248471	2163	324	1.810909	5.86734516	Mycobacterium haemophilum	29311	Bacteria	Bacteria	577	4.0599999999999986e-160	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g2063	i0	98.765	100.021604938272	324	4	100	0	1	324	3007592	3007269	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	32407	577	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
4180760	4180760	PRJNA1248471_S_NODE_14644_length_181_cov_1.515152_g14544_i0	PRJNA1248471	14644	181	1.515152	2.74242512	Cutibacterium acnes	1747	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|365740656\|gb\|CP003196.1\|	1114967	g14544	i0	100	51	181	0	100	0	1	181	832989	833169	Propionibacterium acnes TypeIA2 P.acn17, complete genome	blastn	9231	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4880051	4880051	PRJNA1248471_S_NODE_1104_length_380_cov_1.903323_g1019_i0	PRJNA1248471	1104	380	1.903323	7.2326274	Corynebacterium	1716	Bacteria	Bacteria	121	9.79e-23	NTclustered	gi\|675824235\|gb\|CP009215.1\|	401472	g1019	i0	100	11.0973684210526	65	0	17	0	316	380	2227488	2227424	Corynebacterium ureicelerivorans strain IMMIB RIV-2301, complete genome	blastn	4217	121	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium ureicelerivorans
6731325	6731325	PRJNA1248471_S_NODE_14606_length_181_cov_1.931818_g14506_i0	PRJNA1248471	14606	181	1.931818	3.49659058	Mycobacterium haemophilum	29311	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g14506	i0	100	2.5524861878453	181	0	100	0	1	181	1155307	1155487	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	462	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
9980032	9980032	PRJNA1248471_S_NODE_1428_length_358_cov_1.812298_g1328_i0	PRJNA1248471	1428	358	1.812298	6.48802684	Cutibacterium	1912216	Bacteria	Bacteria	651	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1328	i0	99.441	97.340782122905	358	2	100	0	1	358	88567	88924	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	34848	651	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9980056	9980056	PRJNA1248471_S_NODE_688_length_439_cov_3.733333_g610_i0	PRJNA1248471	688	439	3.733333	16.38933187	Cutibacterium	1912216	Bacteria	Bacteria	749	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g610	i0	99.277	273.842824601367	415	2	94	1	1	414	55880	56294	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	120217	749	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10557835	10557835	PRJNA1248471_S_NODE_9709_length_205_cov_0.980769_g9609_i0	PRJNA1248471	9709	205	0.980769	2.01057645	Corynebacterium dentalis	2014528	Bacteria	Bacteria	324	3.44e-84	NTclustered	gi\|2831254150\|gb\|CP170996.1\|	2014528	g9609	i0	95.122	398.268292682927	205	10	100	0	1	205	4363	4159	Corynebacterium dentalis strain WGS1543 chromosome, complete genome	blastn	81645	324	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium dentalis
11255304	11255304	PRJNA1248471_S_NODE_2189_length_323_cov_3.047445_g2089_i0	PRJNA1248471	2189	323	3.047445	9.84324735	root	1	Root_unresolved	Root_unresolved	573	5.229999999999999e-159	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2089	i0	100	49.9071207430341	310	0	96	0	14	323	417422	417113	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16120	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
13107614	13107614	PRJNA1248471_S_NODE_951_length_397_cov_2.304598_g868_i0	PRJNA1248471	951	397	2.304598	9.14925406	Nesterenkonia sp. NBAIMH1	2600320	Bacteria	Bacteria	545	1.4299999999999995e-150	NTclustered	gi\|1720287724\|gb\|CP042335.1\|	2600320	g868	i0	92.327	129.705289672544	391	18	97	12	7	391	190307	189923	Nesterenkonia sp. NBAIMH1 chromosome, complete genome	blastn	51493	545	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Nesterenkonia	Nesterenkonia sp. NBAIMH1
14382743	14382743	PRJNA1248471_S_NODE_1832_length_340_cov_1.721649_g1732_i0	PRJNA1248471	1832	340	1.721649	5.8536066	Mycobacterium haemophilum	29311	Bacteria	Bacteria	623	5.429999999999999e-174	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g1732	i0	99.706	99.4088235294118	340	1	100	0	1	340	4089754	4090093	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	33799	623	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
14382808	14382808	PRJNA1248471_S_NODE_2832_length_306_cov_2.408560_g2732_i0	PRJNA1248471	2832	306	2.40856	7.3701936	Corynebacterium doosanense	1121358	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|697777148\|gb\|CP006764.1\|	558173	g2732	i0	99.346	391.777777777778	306	2	100	0	1	306	770865	770560	Corynebacterium doosanense CAU 212 = DSM 45436, complete genome	blastn	119884	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium doosanense
15079585	15079585	PRJNA1248471_S_NODE_16932_length_172_cov_1.349593_g16832_i0	PRJNA1248471	16932	172	1.349593	2.32129996	Mycobacterium	1763	Bacteria	Bacteria	291	2.81e-74	NTclustered	gi\|1176909929\|gb\|CP019888.1\|	1768	g16832	i0	97.11	100.139534883721	173	3	100	2	1	172	1424471	1424300	Mycobacterium kansasii strain 9MK chromosome	blastn	17224	291	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium kansasii
15079598	15079598	PRJNA1248471_S_NODE_2712_length_309_cov_1.796154_g2612_i0	PRJNA1248471	2712	309	1.796154	5.55011586	Cutibacterium	1912216	Bacteria	Bacteria	532	8.45e-147	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2612	i0	99.658	248.569579288026	292	0	94	1	19	309	56317	56608	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	76808	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15079617	15079617	PRJNA1248471_S_NODE_7912_length_216_cov_3.796407_g7812_i0	PRJNA1248471	7912	216	3.796407	8.20023912	root	1	Root_unresolved	Root_unresolved	394	2.75e-105	NTclustered	gi\|1434131788\|gb\|MH669264.1\|	1818	g7812	i0	99.537	107.018518518519	216	1	100	0	1	216	245	30	Nocardia globerula strain H88 16S ribosomal RNA gene, partial sequence	blastn	23116	394	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Nocardia	Nocardia globerula
16354438	16354438	PRJNA1248471_S_NODE_253_length_597_cov_6.439781_g232_i0	PRJNA1248471	253	597	6.439781	38.44549257	Cutibacterium	1912216	Bacteria	Bacteria	1020	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g232	i0	100	255.298157453936	552	0	99	0	46	597	55350	55901	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	152413	1020	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16354455	16354455	PRJNA1248471_S_NODE_633_length_448_cov_4.689223_g559_i0	PRJNA1248471	633	448	4.689223	21.00771904	Renibacterium	1645	Bacteria	Bacteria	734	0	NTclustered	gi\|1435054918\|gb\|CP029236.1\|	1646	g559	i0	98.554	390.180803571429	415	6	93	0	34	448	368652	368238	Renibacterium salmoninarum strain H2 chromosome, complete genome	blastn	174801	734	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Renibacterium	Renibacterium salmoninarum
18903478	18903478	PRJNA1248471_S_NODE_12535_length_192_cov_2.692308_g12435_i0	PRJNA1248471	12535	192	2.692308	5.16923136	Cutibacterium	1912216	Bacteria	Bacteria	350	5.24e-92	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g12435	i0	99.479	52.8958333333333	192	1	100	0	1	192	1060287	1060478	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10156	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18903516	18903516	PRJNA1248471_S_NODE_815_length_416_cov_207.730245_g735_i0	PRJNA1248471	815	416	207.730245	864.1578192	Renibacterium	1645	Bacteria	Bacteria	455	2.6100000000000003e-123	NTclustered	gi\|1435054918\|gb\|CP029236.1\|	1646	g735	i0	95.76	312.711538461538	283	10	68	1	91	373	367341	367061	Renibacterium salmoninarum strain H2 chromosome, complete genome	blastn	130088	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Renibacterium	Renibacterium salmoninarum
19479667	19479667	PRJNA1248471_S_NODE_2236_length_321_cov_3.121324_g2136_i0	PRJNA1248471	2236	321	3.121324	10.01945004	Mycobacterium haemophilum	29311	Bacteria	Bacteria	551	2.439999999999999e-152	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g2136	i0	98.413	97.5700934579439	315	1	97	1	1	311	3005939	3006253	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	31320	551	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
19479718	19479718	PRJNA1248471_S_NODE_6616_length_232_cov_1.934426_g6516_i0	PRJNA1248471	6616	232	1.934426	4.48786832	Nocardioides scoriae	642780	Bacteria	Bacteria	412	8.26e-111	NTclustered	gi\|1085860874\|emb\|LT629757.1\|	642780	g6516	i0	98.707	218.241379310345	232	3	100	0	1	232	1193230	1192999	Marmoricola scoriae strain DSM 22127 genome assembly, chromosome: I	blastn	50632	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides scoriae
19479725	19479725	PRJNA1248471_S_NODE_7036_length_227_cov_2.067416_g6936_i0	PRJNA1248471	7036	227	2.067416	4.69303432	Mycobacterium haemophilum	29311	Bacteria	Bacteria	420	4.81e-113	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g6936	i0	100	99.9559471365639	227	0	100	0	1	227	3008243	3008017	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	22690	420	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum
22030267	22030267	PRJNA1248471_S_NODE_10638_length_201_cov_2.223684_g10538_i0	PRJNA1248471	10638	201	2.223684	4.46960484	Corynebacterium dentalis	2014528	Bacteria	Bacteria	287	4.399999999999999e-73	NTclustered	gi\|2831254150\|gb\|CP170996.1\|	2014528	g10538	i0	92.537	347.567164179104	201	14	100	1	1	201	2937	3136	Corynebacterium dentalis strain WGS1543 chromosome, complete genome	blastn	69861	287	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium dentalis
22728837	22728837	PRJNA1248471_S_NODE_15338_length_178_cov_1.581395_g15238_i0	PRJNA1248471	15338	178	1.581395	2.8148831	Cutibacterium	1912216	Bacteria	Bacteria	303	3.77e-78	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g15238	i0	100	49.6797752808989	164	0	92	0	15	178	1369007	1368844	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	8843	303	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23305908	23305908	PRJNA1248471_S_NODE_13859_length_185_cov_1.382353_g13759_i0	PRJNA1248471	13859	185	1.382353	2.55735305	Mycobacterium haemophilum	29311	Bacteria	Bacteria	333	5.039999999999999e-87	NTclustered	gi\|944205708\|gb\|CP011883.2\|	1202450	g13759	i0	99.454	98.3567567567568	183	1	99	0	1	183	3416951	3417133	Mycobacterium haemophilum DSM 44634 strain ATCC 29548 chromosome, complete genome	blastn	18196	333	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium haemophilum

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