metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA397065" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA397065" 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
411979	411979	PRJNA397065_S_NODE_17741_length_164_cov_3.370370_g17491_i0	PRJNA397065	17741	164	3.37037	5.5274068	Cutibacterium granulosum	33011	Bacteria	Bacteria	292	7.41e-75	NTclustered	gi\|2438329814\|dbj\|AP026710.1\|	33011	g17491	i0	98.78	163.621951219512	164	2	100	0	1	164	486149	485986	Cutibacterium granulosum TP-CG7 DNA, complete genome	blastn	26834	292	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum
1079535	1079535	PRJNA397065_S_NODE_18541_length_159_cov_1.307692_g18291_i0	PRJNA397065	18541	159	1.307692	2.07923028	Micrococcus	1269	Bacteria	Bacteria	281	1.54e-71	NTclustered	gi\|2105355783\|gb\|CP084109.1\|	1270	g18291	i0	98.734	319.85534591195	158	2	99	0	1	158	2490686	2490529	Micrococcus luteus strain anQ-m1 chromosome, complete genome	blastn	50857	281	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
1079619	1079619	PRJNA397065_S_NODE_2881_length_669_cov_30.267187_g2664_i0	PRJNA397065	2881	669	30.267187	202.48748103	Cutibacterium	1912216	Bacteria	Bacteria	1158	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2664	i0	98.06	272.251121076233	670	6	100	6	1	669	55359	56022	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	182136	1158	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2355100	2355100	PRJNA397065_S_NODE_5002_length_445_cov_5629.963942_g4754_i0	PRJNA397065	5002	445	5629.963942	25053.3395419	Cutibacterium	1912216	Bacteria	Bacteria	564	4.47e-156	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4754	i0	93.931	258.521348314607	379	14	85	7	69	445	56263	55892	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	115042	564	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4239006	4239006	PRJNA397065_S_NODE_12184_length_221_cov_9.286458_g11934_i0	PRJNA397065	12184	221	9.286458	20.52307218	Kocuria palustris	71999	Bacteria	Bacteria	377	2.85e-100	NTclustered	gi\|923033569\|gb\|CP012507.1\|	71999	g11934	i0	97.309	261.018099547511	223	4	100	1	1	221	219038	219260	Kocuria palustris strain MU14/1, complete genome	blastn	57685	377	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria palustris
4907392	4907392	PRJNA397065_S_NODE_15084_length_186_cov_4.719745_g14834_i0	PRJNA397065	15084	186	4.719745	8.7787257	Cutibacterium	1912216	Bacteria	Bacteria	344	2.34e-90	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g14834	i0	100	123.956989247312	186	0	100	0	1	186	1444175	1443990	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	23056	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
6182488	6182488	PRJNA397065_S_NODE_15845_length_179_cov_12.646667_g15595_i0	PRJNA397065	15845	179	12.646667	22.63753393	Rothia	32207	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g15595	i0	100	282.972067039106	179	0	100	0	1	179	651320	651142	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	50652	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
8065288	8065288	PRJNA397065_S_NODE_11347_length_234_cov_3.282927_g11097_i0	PRJNA397065	11347	234	3.282927	7.68204918	Nocardioides sp. S5	2017486	Bacteria	Bacteria	309	1.13e-79	NTclustered	gi\|1999037722\|gb\|CP022296.1\|	2017486	g11097	i0	90.598	274.542735042735	234	20	99	2	2	234	1842001	1842233	Nocardioides sp. S5 chromosome, complete genome	blastn	64243	309	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. S5
8065442	8065442	PRJNA397065_S_NODE_7487_length_326_cov_5.787879_g7237_i0	PRJNA397065	7487	326	5.787879	18.868485539999998	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	479	1.1899999999999996e-130	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g7237	i0	93.75	376.898773006135	320	18	98	2	5	324	553028	553345	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	122869	479	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
10007696	10007696	PRJNA397065_S_NODE_3188_length_624_cov_10.952941_g2959_i0	PRJNA397065	3188	624	10.952941	68.34635184	Corynebacterium	1716	Bacteria	Bacteria	841	0	NTclustered	gi\|2869804070\|gb\|CP175770.1\|	38304	g2959	i0	91.599	363.251602564103	619	36	98	14	3	616	2351668	2352275	Corynebacterium tuberculostearicum strain YSMAA5_1_B12 chromosome, complete genome	blastn	226669	845	0.995266272189349	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
11282440	11282440	PRJNA397065_S_NODE_11189_length_236_cov_34.333333_g10939_i0	PRJNA397065	11189	236	34.333333	81.02666588	Micrococcus	1269	Bacteria	Bacteria	285	1.92e-72	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g10939	i0	99.363	163.868644067797	157	1	67	0	1	157	345559	345715	Micrococcus luteus strain V017 chromosome, complete genome	blastn	38673	285	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11283035	11283035	PRJNA397065_S_NODE_7709_length_318_cov_114.844291_g7459_i0	PRJNA397065	7709	318	114.844291	365.20484538	Micrococcaceae	1268	Bacteria	Bacteria	532	8.729999999999998e-147	NTclustered	gi\|1131742428\|dbj\|LC209194.1\|	1270	g7459	i0	97.143	99.0660377358491	315	9	99	0	4	318	728	414	Micrococcus luteus gene for 16S ribosomal RNA, partial sequence, strain: OX	blastn	31503	532	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11283044	11283044	PRJNA397065_S_NODE_7929_length_311_cov_8.996454_g7679_i0	PRJNA397065	7929	311	8.996454	27.97897194	Corynebacterium	1716	Bacteria	Bacteria	475	1.4599999999999995e-129	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g7679	i0	94.212	365.038585209003	311	18	100	0	1	311	760250	759940	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	113527	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
11890907	11890907	PRJNA397065_S_NODE_7630_length_321_cov_16.424658_g7380_i0	PRJNA397065	7630	321	16.424658	52.72315218	Dermacoccus nishinomiyaensis	1274	Bacteria	Bacteria	470	7.02e-128	NTclustered	gi\|1966870119\|gb\|CP068484.1\|	1274	g7380	i0	93.168	277.143302180685	322	19	100	3	1	321	128582	128263	Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome	blastn	88963	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermacoccaceae	Dermacoccus	Dermacoccus nishinomiyaensis
11890908	11890908	PRJNA397065_S_NODE_7710_length_318_cov_16.795848_g7460_i0	PRJNA397065	7710	318	16.795848	53.41079664	Micrococcus luteus	1270	Bacteria	Bacteria	481	3.21e-131	NTclustered	gi\|2274423316\|gb\|CP101465.1\|	1270	g7460	i0	94.025	285.827044025157	318	18	100	1	1	318	363236	362920	Micrococcus luteus strain DNA1 chromosome, complete genome	blastn	90893	481	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
14440983	14440983	PRJNA397065_S_NODE_6212_length_378_cov_6087.954155_g5963_i0	PRJNA397065	6212	378	6087.954155	23012.4667059	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	551	2.9099999999999986e-152	NTclustered	gi\|407954700\|dbj\|AB587877.1\|	159447	g5963	i0	96.687	132.177248677249	332	10	88	1	47	378	987	657	Uncultured Corynebacterium sp. gene for 16S ribosomal RNA, partial sequence, clone: HS-G5	blastn	49963	551	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
15107126	15107126	PRJNA397065_S_NODE_15292_length_184_cov_7.819355_g15042_i0	PRJNA397065	15292	184	7.819355	14.3876132	Corynebacterium	1716	Bacteria	Bacteria	307	3.0300000000000004e-79	NTclustered	gi\|2550471320\|gb\|CP100376.1\|	38284	g15042	i0	96.757	372.836956521739	185	4	100	2	1	184	2342487	2342304	Corynebacterium accolens strain CA7 chromosome	blastn	68602	307	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
15107365	15107365	PRJNA397065_S_NODE_3212_length_621_cov_26.829392_g2664_i1	PRJNA397065	3212	621	26.829392	166.61052432	Cutibacterium	1912216	Bacteria	Bacteria	898	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2664	i1	93.248	309.705314009662	622	22	99	16	10	621	55411	56022	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	192327	898	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
15107455	15107455	PRJNA397065_S_NODE_5472_length_417_cov_5492.012887_g5223_i0	PRJNA397065	5472	417	5492.012887	22901.69373879	Actinomycetes	1760	Bacteria	Bacteria	621	2.44e-173	NTclustered	gi\|2514698871\|gb\|CP126964.1\|	98671	g5223	i0	97.275	182.10551558753	367	9	88	1	1	366	448980	448614	Pseudoglutamicibacter albus strain UMB0715 chromosome, complete genome	blastn	75938	621	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudoglutamicibacter	Pseudoglutamicibacter albus
15714798	15714798	PRJNA397065_S_NODE_8033_length_308_cov_8.928315_g7783_i0	PRJNA397065	8033	308	8.928315	27.4992102	Nocardioides houyundeii	2045452	Bacteria	Bacteria	564	2.99e-156	NTclustered	gi\|1321370352\|gb\|CP025581.1\|	2045452	g7783	i0	99.675	255.012987012987	308	1	100	0	1	308	999059	999366	Nocardioides houyundeii strain 78 chromosome, complete genome	blastn	78544	564	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides houyundeii
21481012	21481012	PRJNA397065_S_NODE_13757_length_200_cov_4.111111_g13507_i0	PRJNA397065	13757	200	4.111111	8.222222	Micrococcus	1269	Bacteria	Bacteria	302	1.56e-77	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g13507	i0	94	326.505	200	11	100	1	1	200	347280	347478	Micrococcus luteus strain V017 chromosome, complete genome	blastn	65301	302	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
21481206	21481206	PRJNA397065_S_NODE_18557_length_159_cov_1.038462_g18307_i0	PRJNA397065	18557	159	1.038462	1.65115458	Cutibacterium	1912216	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g18307	i0	100	127.830188679245	159	0	100	0	1	159	2320252	2320410	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	20325	294	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
21481494	21481494	PRJNA397065_S_NODE_7537_length_324_cov_88.484746_g7287_i0	PRJNA397065	7537	324	88.484746	286.69057704	Cutibacterium	1912216	Bacteria	Bacteria	588	1.88e-163	NTclustered	gi\|326485708\|gb\|JF289273.1\|	1747	g7287	i0	99.385	99.2993827160494	325	1	100	1	1	324	311	635	Propionibacterium acnes strain 1271-10 16S ribosomal RNA gene, partial sequence	blastn	32173	588	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
24030966	24030966	PRJNA397065_S_NODE_11179_length_237_cov_1.860577_g10929_i0	PRJNA397065	11179	237	1.860577	4.40956749	Rothia	32207	Bacteria	Bacteria	438	1.4e-118	NTclustered	gi\|1247210625\|gb\|CP023510.1\|	43675	g10929	i0	100	216.898734177215	237	0	100	0	1	237	653643	653879	Rothia mucilaginosa strain FDAARGOS_369 chromosome, complete genome	blastn	51405	438	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia mucilaginosa
24031294	24031294	PRJNA397065_S_NODE_19139_length_154_cov_13.816000_g18889_i0	PRJNA397065	19139	154	13.816	21.27664	Actinomycetes	1760	Bacteria	Bacteria	220	3.27e-53	NTclustered	gi\|2283191586\|gb\|CP102197.1\|	1660	g18889	i0	92.763	195.707792207792	152	11	99	0	1	152	7938	7787	Schaalia odontolytica strain KHUD_008 chromosome, complete genome	blastn	30139	220	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Schaalia	Schaalia odontolytica
25305386	25305386	PRJNA397065_S_NODE_11080_length_238_cov_20.751196_g10830_i0	PRJNA397065	11080	238	20.751196	49.38784648	Cutibacterium	1912216	Bacteria	Bacteria	440	3.899999999999999e-119	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g10830	i0	100	243.915966386555	238	0	100	0	1	238	58502	58265	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	58052	440	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);;