metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA721440" 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
3261470	3261470	PRJNA721440_S_NODE_5183_length_262_cov_2.985915_g5057_i0	PRJNA721440	5183	262	2.985915	7.8230973	Aeromicrobium erythreum	2041	Bacteria	Bacteria	429	9.449999999999999e-116	NTclustered	gi\|973193275\|gb\|CP011502.1\|	2041	g5057	i0	96.198	163.309160305344	263	8	100	2	1	262	958063	957802	Aeromicrobium erythreum strain AR18 chromosome, complete genome	blastn	42787	429	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium erythreum
3745375	3745375	PRJNA721440_S_NODE_13803_length_182_cov_1.022556_g13677_i0	PRJNA721440	13803	182	1.022556	1.86105192	Cutibacterium	1912216	Bacteria	Bacteria	329	6.39e-86	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g13677	i0	99.448	271.763736263736	181	1	99	0	2	182	55703	55883	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	49461	329	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3745384	3745384	PRJNA721440_S_NODE_21783_length_153_cov_2.788462_g21657_i0	PRJNA721440	21783	153	2.788462	4.26634686	Kytococcus	57499	Bacteria	Bacteria	250	4.14e-62	NTclustered	gi\|1948607475\|gb\|CP066015.1\|	1276	g21657	i0	96.078	221.124183006536	153	6	100	0	1	153	312563	312715	Kytococcus sedentarius strain FDAARGOS_1061 chromosome, complete genome	blastn	33832	250	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Kytococcaceae	Kytococcus	Kytococcus sedentarius
3745388	3745388	PRJNA721440_S_NODE_5423_length_257_cov_21.908654_g5297_i0	PRJNA721440	5423	257	21.908654	56.30524078	Micrococcus	1269	Bacteria	Bacteria	259	1.28e-64	NTclustered	gi\|2274423316\|gb\|CP101465.1\|	1270	g5297	i0	99.301	150.105058365759	143	1	56	0	2	144	364317	364459	Micrococcus luteus strain DNA1 chromosome, complete genome	blastn	38577	259	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
5021911	5021911	PRJNA721440_S_NODE_13284_length_184_cov_3.125926_g13158_i0	PRJNA721440	13284	184	3.125926	5.75170384	Nocardiaceae	85025	Bacteria	Bacteria	335	1.3899999999999996e-87	NTclustered	gi\|1707199879\|gb\|CP041647.1\|	43767	g13158	i0	99.457	327.125	184	1	100	0	1	184	926260	926443	Prescottella equi strain WY chromosome, complete genome	blastn	60191	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Prescottella	Prescottella equi
5813719	5813719	PRJNA721440_S_NODE_2705_length_342_cov_2.843003_g2579_i0	PRJNA721440	2705	342	2.843003	9.72307026	Aeromicrobium erythreum	2041	Bacteria	Bacteria	586	7.17e-163	NTclustered	gi\|973193275\|gb\|CP011502.1\|	2041	g2579	i0	97.661	427.318713450292	342	6	99	2	2	342	959036	958696	Aeromicrobium erythreum strain AR18 chromosome, complete genome	blastn	146143	586	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Aeromicrobium	Aeromicrobium erythreum
8846613	8846613	PRJNA721440_S_NODE_16047_length_172_cov_1.894309_g15921_i0	PRJNA721440	16047	172	1.894309	3.25821148	Rothia	32207	Bacteria	Bacteria	311	2.16e-80	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g15921	i0	100	272.03488372093	168	0	98	0	1	168	1003110	1002943	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	46790	311	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
10914180	10914180	PRJNA721440_S_NODE_22049_length_152_cov_2.126214_g21923_i0	PRJNA721440	22049	152	2.126214	3.23184528	Rothia amarae	169480	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g21923	i0	100	276.065789473684	152	0	100	0	1	152	1622385	1622536	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	41962	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
13947471	13947471	PRJNA721440_S_NODE_18591_length_165_cov_1.025862_g18465_i0	PRJNA721440	18591	165	1.025862	1.6926723	Rothia	32207	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g18465	i0	100	411.806060606061	165	0	100	0	1	165	652992	653156	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	67948	305	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
15222181	15222181	PRJNA721440_S_NODE_1072_length_506_cov_4.426696_g948_i0	PRJNA721440	1072	506	4.426696	22.39908176	Micrococcus	1269	Bacteria	Bacteria	918	0	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g948	i0	99.407	367.108695652174	506	3	100	0	1	506	346118	346623	Micrococcus luteus strain V017 chromosome, complete genome	blastn	185757	918	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
15222182	15222182	PRJNA721440_S_NODE_10812_length_199_cov_2.340000_g10686_i0	PRJNA721440	10812	199	2.34	4.6566	Micrococcus	1269	Bacteria	Bacteria	326	9.22e-85	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g10686	i0	100	354.281407035176	176	0	88	0	1	176	348365	348540	Micrococcus luteus strain V017 chromosome, complete genome	blastn	70502	326	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
16012692	16012692	PRJNA721440_S_NODE_8353_length_218_cov_5.360947_g8227_i0	PRJNA721440	8353	218	5.360947	11.68686446	Alloscardovia omnicolens	419015	Bacteria	Bacteria	69.4	1.91e-7	NTclustered	gi\|2766231342\|gb\|CP159991.1\|	419015	g8227	i0	100	0.169724770642202	37	0	17	0	1	37	623064	623100	Alloscardovia omnicolens strain AN1009 chromosome	blastn	37	69.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Bifidobacteriales	Bifidobacteriaceae	Alloscardovia	Alloscardovia omnicolens
21112758	21112758	PRJNA721440_S_NODE_2457_length_357_cov_3.568182_g2331_i0	PRJNA721440	2457	357	3.568182	12.73840974	Corynebacterium matruchotii	43768	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g2331	i0	100	0.168067226890756	30	0	8	0	74	103	2042710	2042681	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	60	56.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
22871152	22871152	PRJNA721440_S_NODE_5598_length_254_cov_5.107317_g5472_i0	PRJNA721440	5598	254	5.107317	12.97258518	Micrococcus	1269	Bacteria	Bacteria	451	1.95e-122	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g5472	i0	98.814	308.952755905512	253	3	99	0	2	254	345709	345457	Micrococcus luteus strain V017 chromosome, complete genome	blastn	78474	453	0.995584988962472	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
23663197	23663197	PRJNA721440_S_NODE_20279_length_160_cov_3.099099_g20153_i0	PRJNA721440	20279	160	3.099099	4.9585584	Rothia terrae	396015	Bacteria	Bacteria	279	5.59e-71	NTclustered	gi\|1907834973\|gb\|CP061539.1\|	396015	g20153	i0	98.125	225.9375	160	3	100	0	1	160	1733456	1733297	Rothia terrae strain KJZ-14 chromosome, complete genome	blastn	36150	279	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia terrae
24145180	24145180	PRJNA721440_S_NODE_9259_length_210_cov_3.037267_g9133_i0	PRJNA721440	9259	210	3.037267	6.3782607	Cutibacterium	1912216	Bacteria	Bacteria	388	1.24e-103	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g9133	i0	100	269.252380952381	210	0	100	0	1	210	58170	58379	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	56543	388	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);;