metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA557895" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA557895" 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
1811332	1811332	PRJNA557895_P_NODE_10382_length_284_cov_0.855319_g10027_i0	PRJNA557895	10382	284	0.855319	2.42910596	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	424	4.82e-114	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g10027	i0	95.167	456.785211267606	269	12	96	1	1	269	886754	887021	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	129727	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
1811410	1811410	PRJNA557895_P_NODE_14382_length_243_cov_1.402062_g14027_i0	PRJNA557895	14382	243	1.402062	3.40701066	Actinomyces naeslundii	1655	Bacteria	Bacteria	377	3.18e-100	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g14027	i0	95.378	233.049382716049	238	10	98	1	1	238	296855	296619	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	56631	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
3087429	3087429	PRJNA557895_P_NODE_8743_length_304_cov_2.376471_g8388_i0	PRJNA557895	8743	304	2.376471	7.22447184	Actinomyces oris	544580	Bacteria	Bacteria	518	2.32e-142	NTclustered	gi\|2430736086\|gb\|CP116225.1\|	544580	g8388	i0	97.368	395.384868421053	304	8	100	0	1	304	357214	356911	Actinomyces oris strain WVU627 plasmid unnamed1, complete sequence	blastn	120197	518	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
5640084	5640084	PRJNA557895_P_NODE_33805_length_164_cov_1.278261_g33450_i0	PRJNA557895	33805	164	1.278261	2.09634804	Actinomyces sp. HMT 175	2789425	Bacteria	Bacteria	281	1.6000000000000001e-71	NTclustered	gi\|1957892420\|gb\|CP068012.1\|	2789425	g33450	i0	97.561	143.585365853659	164	4	100	0	1	164	939665	939502	Actinomyces sp. HMT 175 chromosome, complete genome	blastn	23548	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces sp. HMT 175
6231998	6231998	PRJNA557895_P_NODE_25525_length_183_cov_1.111940_g25170_i0	PRJNA557895	25525	183	1.11194	2.0348502	Actinomyces	1654	Bacteria	Bacteria	300	5.040000000000001e-77	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g25170	i0	96.175	250.125683060109	183	7	100	0	1	183	946564	946746	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	45773	300	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
7506383	7506383	PRJNA557895_P_NODE_25406_length_183_cov_1.522388_g25051_i0	PRJNA557895	25406	183	1.522388	2.78597004	Cutibacterium	1912216	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g25051	i0	100	277.289617486339	183	0	100	0	1	183	55955	55773	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	50744	339	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8188720	8188720	PRJNA557895_P_NODE_15167_length_236_cov_1.203209_g14812_i0	PRJNA557895	15167	236	1.203209	2.83957324	Cutibacterium avidum	33010	Bacteria	Bacteria	390	3.9499999999999996e-104	NTclustered	gi\|1059945062\|gb\|CP016954.1\|	33010	g14812	i0	96.624	293.279661016949	237	5	100	3	1	236	22049	22283	Cutibacterium avidum strain DPC 6544, complete genome	blastn	69214	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium avidum
10056916	10056916	PRJNA557895_P_NODE_38408_length_161_cov_0.910714_g38053_i0	PRJNA557895	38408	161	0.910714	1.46624954	Cutibacterium	1912216	Bacteria	Bacteria	172	9.84e-39	NTclustered	gi\|966544767\|gb\|CP012355.1\|	1747	g38053	i0	100	94.8509316770186	93	0	100	0	5	97	1773429	1773337	Cutibacterium acnes strain PA_15_1_R1 chromosome, complete genome	blastn	15271	172	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10740194	10740194	PRJNA557895_P_NODE_25209_length_184_cov_1.311111_g24854_i0	PRJNA557895	25209	184	1.311111	2.41244424	Microbacterium hominis	162426	Bacteria	Bacteria	209	8.8e-50	NTclustered	gi\|1314922424\|gb\|CP025299.1\|	162426	g24854	i0	87.363	24.0054347826087	182	23	99	0	2	183	2389637	2389456	Microbacterium hominis strain SJTG1 chromosome, complete genome	blastn	4417	209	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium hominis
12607367	12607367	PRJNA557895_P_NODE_8230_length_312_cov_1.920152_g7875_i0	PRJNA557895	8230	312	1.920152	5.99087424	Actinomyces	1654	Bacteria	Bacteria	527	3.9799999999999996e-145	NTclustered	gi\|1948661326\|gb\|CP066049.1\|	1655	g7875	i0	97.115	247.028846153846	312	9	100	0	1	312	295603	295292	Actinomyces naeslundii strain FDAARGOS_1037 chromosome, complete genome	blastn	77073	527	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces naeslundii
13290152	13290152	PRJNA557895_P_NODE_28731_length_170_cov_1.685950_g28376_i0	PRJNA557895	28731	170	1.68595	2.866115	Schaalia odontolytica	1660	Bacteria	Bacteria	309	7.64e-80	NTclustered	gi\|168485112\|gb\|EU306592.1\|	1660	g28376	i0	99.412	224.570588235294	170	1	100	0	1	170	533	702	Actinomyces odontolyticus 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	38177	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
13882210	13882210	PRJNA557895_P_NODE_11991_length_266_cov_4.248848_g11636_i0	PRJNA557895	11991	266	4.248848	11.30193568	Actinomyces	1654	Bacteria	Bacteria	492	1.2099999999999999e-134	NTclustered	gi\|2715064527\|dbj\|LC810199.1\|	1656	g11636	i0	100	108.003759398496	266	0	100	0	1	266	926	1191	Actinomyces viscosus D1rahul gene for 16S rRNA, partial sequence	blastn	28729	492	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces viscosus
13882267	13882267	PRJNA557895_P_NODE_28211_length_172_cov_2.560976_g27856_i0	PRJNA557895	28211	172	2.560976	4.40487872	Cutibacterium	1912216	Bacteria	Bacteria	318	1.2899999999999999e-82	NTclustered	gi\|1898669123\|emb\|LR588480.1\|	1747	g27856	i0	100	221.302325581395	172	0	100	0	1	172	169	340	Cutibacterium acnes partial 16S rRNA gene, isolate PD1MD	blastn	38064	318	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
16431063	16431063	PRJNA557895_P_NODE_23953_length_189_cov_1.457143_g23598_i0	PRJNA557895	23953	189	1.457143	2.75400027	Cutibacterium	1912216	Bacteria	Bacteria	350	5.14e-92	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g23598	i0	100	51.021164021164	189	0	100	0	1	189	1676029	1675841	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	9643	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18979664	18979664	PRJNA557895_P_NODE_12395_length_262_cov_1.737089_g12040_i0	PRJNA557895	12395	262	1.737089	4.55117318	Micrococcales	85006	Bacteria	Bacteria	462	9.319999999999999e-126	NTclustered	gi\|590121456\|emb\|HE716946.1\|	1274	g12040	i0	98.473	106	262	4	100	0	1	262	731	470	Dermacoccus nishinomiyaensis partial 16S rRNA gene, strain JPR-06	blastn	27772	462	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
19662308	19662308	PRJNA557895_P_NODE_22816_length_194_cov_1.406897_g22461_i0	PRJNA557895	22816	194	1.406897	2.72938018	Actinomyces oris	544580	Bacteria	Bacteria	320	4.16e-83	NTclustered	gi\|1948687139\|gb\|CP066060.1\|	544580	g22461	i0	96.392	135.226804123711	194	7	100	0	1	194	945391	945198	Actinomyces oris strain FDAARGOS_1051 chromosome, complete genome	blastn	26234	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces oris
19662335	19662335	PRJNA557895_P_NODE_23656_length_190_cov_3.156028_g23301_i0	PRJNA557895	23656	190	3.156028	5.9964532	Actinomyces viscosus	1656	Bacteria	Bacteria	351	1.4399999999999997e-92	NTclustered	gi\|168485113\|gb\|EU306593.1\|	1656	g23301	i0	100	303.989473684211	190	0	100	0	1	190	462	651	Actinomyces viscosus 16S-23S ribosomal RNA intergenic spacer, partial sequence	blastn	57758	351	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	Actinomyces viscosus
20254820	20254820	PRJNA557895_P_NODE_15876_length_231_cov_0.917582_g15521_i0	PRJNA557895	15876	231	0.917582	2.11961442	Micrococcus	1269	Bacteria	Bacteria	427	2.9399999999999998e-115	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g15521	i0	100	275.545454545455	231	0	100	0	1	231	2260557	2260787	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	63651	427	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20937819	20937819	PRJNA557895_P_NODE_12517_length_261_cov_1.259434_g12162_i0	PRJNA557895	12517	261	1.259434	3.28712274	Schaalia odontolytica	1660	Bacteria	Bacteria	460	3.3399999999999995e-125	NTclustered	gi\|1663040979\|gb\|CP040006.1\|	1660	g12162	i0	98.467	223.681992337165	261	4	100	0	1	261	1118040	1117780	Schaalia odontolytica strain XH001 chromosome, complete genome	blastn	58381	460	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
21530411	21530411	PRJNA557895_P_NODE_7797_length_320_cov_2.560886_g7442_i0	PRJNA557895	7797	320	2.560886	8.1948352	Cutibacterium	1912216	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g7442	i0	100	271.41875	320	0	100	0	1	320	56964	56645	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	86854	592	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);;