metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA207343" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA207343" 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
1641569	1641569	PRJNA207343_S_NODE_11582_length_150_cov_3.646018_g11045_i0	PRJNA207343	11582	150	3.646018	5.469027	Rothia mucilaginosa	43675	Bacteria	Bacteria	261	1.86e-65	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g11045	i0	100	155.913333333333	141	0	94	0	10	150	652485	652345	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	23387	261	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
3606286	3606286	PRJNA207343_S_NODE_10263_length_164_cov_5.062992_g9726_i0	PRJNA207343	10263	164	5.062992	8.30330688	Cutibacterium	1912216	Bacteria	Bacteria	259	7.52e-65	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9726	i0	100	274.274390243902	140	0	87	0	13	152	56036	55897	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	44981	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5470118	5470118	PRJNA207343_S_NODE_11005_length_156_cov_2.638655_g10468_i0	PRJNA207343	11005	156	2.638655	4.1163018	Nocardioidaceae bacterium	1871072	Bacteria	Bacteria	259	7.05e-65	NTclustered	gi\|2047721342\|gb\|CP076053.1\|	1871072	g10468	i0	96.795	294.660256410256	156	3	99	2	1	155	2064221	2064067	Nocardioidaceae bacterium strain TYQ2 chromosome, complete genome	blastn	45967	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae		Nocardioidaceae bacterium
7433857	7433857	PRJNA207343_S_NODE_5946_length_264_cov_378.013216_g5409_i0	PRJNA207343	5946	264	378.013216	997.95489024	root	1	Root_unresolved	Root_unresolved	466	7.27e-127	NTclustered	gi\|2741131258\|gb\|PP892574.1\|	1667	g5409	i0	100	98.3181818181818	252	0	95	0	1	252	316	65	Arthrobacter sp. strain Y29 16S ribosomal RNA gene, partial sequence	blastn	25956	466	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter sp.
7433928	7433928	PRJNA207343_S_NODE_9666_length_172_cov_738.607407_g9129_i0	PRJNA207343	9666	172	738.607407	1270.40474004	Cutibacterium	1912216	Bacteria	Bacteria	257	2.85e-64	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9129	i0	95.625	246.174418604651	160	7	93	0	1	160	57138	57297	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	42342	257	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8708571	8708571	PRJNA207343_S_NODE_2587_length_559_cov_174.226054_g370_i3	PRJNA207343	2587	559	174.226054	973.92364186	Micrococcaceae	1268	Bacteria	Bacteria	730	0	NTclustered	gi\|2666964057\|dbj\|AP029193.1\|	1671	g370	i3	92.731	426.98747763864	509	32	91	5	1	506	809850	810356	Pseudarthrobacter oxydans JCM 2521 DNA, complete genome	blastn	238686	730	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
9295081	9295081	PRJNA207343_S_NODE_7848_length_205_cov_3.404762_g7311_i0	PRJNA207343	7848	205	3.404762	6.9797621	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	302	1.61e-77	NTclustered	gi\|1986709282\|gb\|CP069791.1\|	38304	g7311	i0	100	292.429268292683	163	0	83	0	34	196	1791101	1791263	Corynebacterium tuberculostearicum strain FDAARGOS_1198 chromosome	blastn	59948	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
9983922	9983922	PRJNA207343_S_NODE_10868_length_157_cov_17.500000_g10331_i0	PRJNA207343	10868	157	17.5	27.475	Georgenia	154116	Bacteria	Bacteria	243	7.159999999999999e-60	NTclustered	gi\|1683936015\|gb\|CP040899.1\|	2585135	g10331	i0	97.857	233.872611464968	140	3	89	0	15	154	182390	182529	Georgenia wutianyii strain Z294 chromosome, complete genome	blastn	36718	243	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Bogoriellaceae	Georgenia	Georgenia wutianyii
10570831	10570831	PRJNA207343_S_NODE_11109_length_155_cov_2.279661_g10572_i0	PRJNA207343	11109	155	2.279661	3.53347455	Pseudarthrobacter sp. NS4	2973976	Bacteria	Bacteria	263	5.41e-66	NTclustered	gi\|2290429330\|gb\|CP103288.1\|	2973976	g10572	i0	98.658	436.645161290323	149	0	96	2	7	155	1141887	1141741	Pseudarthrobacter sp. NS4 chromosome, complete genome	blastn	67680	263	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter sp. NS4
12534459	12534459	PRJNA207343_S_NODE_10850_length_158_cov_1.173554_g10313_i0	PRJNA207343	10850	158	1.173554	1.85421532	Cutibacterium	1912216	Bacteria	Bacteria	268	1.1899999999999998e-67	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10313	i0	99.329	97.120253164557	149	0	94	1	2	150	1673124	1673271	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	15345	268	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15083395	15083395	PRJNA207343_S_NODE_11492_length_151_cov_3.333333_g10955_i0	PRJNA207343	11492	151	3.333333	5.03333283	Arthrobacter	1663	Bacteria	Bacteria	215	1.49e-51	NTclustered	gi\|2446098017\|gb\|CP117869.1\|	37921	g10955	i0	95.522	201.423841059603	134	6	89	0	7	140	518273	518406	Arthrobacter agilis strain TMP24 chromosome, complete genome	blastn	30415	215	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter agilis
16358350	16358350	PRJNA207343_S_NODE_4633_length_338_cov_338.342193_g4096_i0	PRJNA207343	4633	338	338.342193	1143.59661234	Cutibacterium	1912216	Bacteria	Bacteria	518	2.62e-142	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4096	i0	95.666	259.733727810651	323	13	97	1	10	332	56848	57169	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	87790	518	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
17633497	17633497	PRJNA207343_S_NODE_2314_length_604_cov_13.234568_g1831_i0	PRJNA207343	2314	604	13.234568	79.93679072	Cutibacterium	1912216	Bacteria	Bacteria	1092	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1831	i0	99.338	265.468543046358	604	3	99	1	2	604	55937	55334	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	160343	1092	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18907413	18907413	PRJNA207343_S_NODE_5855_length_268_cov_299.904762_g5318_i0	PRJNA207343	5855	268	299.904762	803.74476216	Micrococcaceae	1268	Bacteria	Bacteria	473	4.419999999999999e-129	NTclustered	gi\|983654104\|gb\|KT441086.1\|	1665	g5318	i0	100	102.208955223881	256	0	96	0	2	257	760	505	Arthrobacter globiformis strain IARI-CRK 14 16S ribosomal RNA gene, partial sequence	blastn	27392	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter globiformis
18907467	18907467	PRJNA207343_S_NODE_9075_length_181_cov_1049.819444_g8538_i0	PRJNA207343	9075	181	1049.819444	1900.17319364	Bacteria	2	Bacteria	Bacteria	82.4	1.96e-11	NTclustered	gi\|1860780513\|gb\|MT658006.1\|	1271	g8538	i0	100	24.8895027624309	44	0	24	0	1	44	194	237	Micrococcus sp. strain CC15 16S ribosomal RNA gene, partial sequence	blastn	4505	82.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus sp.
21457582	21457582	PRJNA207343_S_NODE_10717_length_159_cov_3.122951_g10180_i0	PRJNA207343	10717	159	3.122951	4.96549209	Cutibacterium	1912216	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10180	i0	100	106.408805031447	159	0	100	0	1	159	1672832	1672990	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	16919	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21457630	21457630	PRJNA207343_S_NODE_2797_length_527_cov_187.657143_g370_i4	PRJNA207343	2797	527	187.657143	988.95314361	Micrococcaceae	1268	Bacteria	Bacteria	859	0	NTclustered	gi\|2666964057\|dbj\|AP029193.1\|	1671	g370	i4	96.887	465.700189753321	514	14	97	2	16	527	810363	809850	Pseudarthrobacter oxydans JCM 2521 DNA, complete genome	blastn	245424	859	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans
22043576	22043576	PRJNA207343_S_NODE_7778_length_207_cov_3.541176_g7241_i0	PRJNA207343	7778	207	3.541176	7.33023432	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	302	1.63e-77	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g7241	i0	93.564	293.565217391304	202	13	98	0	6	207	552048	551847	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	60768	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
22732633	22732633	PRJNA207343_S_NODE_2078_length_649_cov_151.302288_g370_i2	PRJNA207343	2078	649	151.302288	981.95184912	Cutibacterium	1912216	Bacteria	Bacteria	937	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g370	i2	93.146	257.647149460709	642	38	99	6	1	640	56190	56827	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	167213	937	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24007792	24007792	PRJNA207343_S_NODE_10079_length_167_cov_3.084615_g9542_i0	PRJNA207343	10079	167	3.084615	5.15130705	Cutibacterium	1912216	Bacteria	Bacteria	270	3.5499999999999993e-68	NTclustered	gi\|966533409\|gb\|CP012350.1\|	1747	g9542	i0	98.684	183.077844311377	152	2	91	0	16	167	607311	607160	Cutibacterium acnes strain PA_30_2_L1 chromosome, complete genome	blastn	30574	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25282008	25282008	PRJNA207343_S_NODE_5260_length_298_cov_9.490421_g4723_i0	PRJNA207343	5260	298	9.490421	28.28145458	Cutibacterium	1912216	Bacteria	Bacteria	492	1.3799999999999996e-134	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4723	i0	98.561	252.11744966443	278	4	94	0	11	288	56293	56570	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	75131	492	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);;