metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1108009" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1108009" 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
212645	212645	PRJNA1108009_P_NODE_10841_length_408_cov_1.149254_g10523_i0	PRJNA1108009	10841	408	1.149254	4.68895632	Streptomyces sp. NBC_00582	2975783	Bacteria	Bacteria	270	9.929999999999999e-68	NTclustered	gi\|2667469075\|gb\|CP107772.1\|	2975783	g10523	i0	80.508	81.2892156862745	354	67	87	2	2	354	6485806	6486158	Streptomyces sp. NBC_00582 chromosome, complete genome	blastn	33166	270	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_00582
1020392	1020392	PRJNA1108009_P_NODE_19801_length_289_cov_1.212963_g19483_i0	PRJNA1108009	19801	289	1.212963	3.50546307	Slackia	84108	Bacteria	Bacteria	230	1.1499999999999995e-55	NTclustered	gi\|1540039184\|emb\|LR134379.1\|	84110	g19483	i0	81.185	16.2525951557093	287	52	99	2	1	286	1823537	1823822	Slackia heliotrinireducens strain NCTC11029 genome assembly, chromosome: 1	blastn	4697	230	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Slackia	Slackia heliotrinireducens
1487624	1487624	PRJNA1108009_P_NODE_20622_length_283_cov_0.838095_g20304_i0	PRJNA1108009	20622	283	0.838095	2.37180885	Rothia amarae	169480	Bacteria	Bacteria	473	4.699999999999999e-129	NTclustered	gi\|1907852315\|gb\|CP061538.1\|	169480	g20304	i0	97.153	285.116607773852	281	7	99	1	1	281	1624196	1623917	Rothia amarae strain KJZ-9 chromosome, complete genome	blastn	80688	473	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	Rothia amarae
1487668	1487668	PRJNA1108009_P_NODE_22462_length_268_cov_1.128205_g22144_i0	PRJNA1108009	22462	268	1.128205	3.0235894	Corynebacterium tuberculostearicum	38304	Bacteria	Bacteria	451	2.07e-122	NTclustered	gi\|2869797333\|gb\|CP175765.1\|	38304	g22144	i0	98.069	344.179104477612	259	5	97	0	10	268	3841	3583	Corynebacterium tuberculostearicum strain YSMAA5_1_F11 chromosome, complete genome	blastn	92240	451	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
2296032	2296032	PRJNA1108009_P_NODE_9962_length_429_cov_1.744382_g9644_i0	PRJNA1108009	9962	429	1.744382	7.48339878	Dietzia	37914	Bacteria	Bacteria	787	0	NTclustered	gi\|2732846652\|gb\|CP155437.1\|	322509	g9644	i0	99.767	271.39627039627	429	1	100	0	1	429	1619246	1619674	Dietzia kunjamensis strain BIM B-2035 chromosome, complete genome	blastn	116429	787	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia kunjamensis
4039996	4039996	PRJNA1108009_P_NODE_31704_length_241_cov_0.916667_g31386_i0	PRJNA1108009	31704	241	0.916667	2.20916747	Gordonibacter urolithinfaciens	1335613	Bacteria	Bacteria	121	5.86e-23	NTclustered	gi\|1241780685\|emb\|LT900217.1\|	1335613	g31386	i0	81.013	24.1535269709544	158	25	65	5	2	157	389198	389352	Gordonibacter urolithinfaciens strain DSM 27213T genome assembly, chromosome: I	blastn	5821	121	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Gordonibacter	Gordonibacter urolithinfaciens
5315654	5315654	PRJNA1108009_P_NODE_14265_length_349_cov_2.398551_g13947_i0	PRJNA1108009	14265	349	2.398551	8.37094299	Micromonospora sp. NBC_00898	2975981	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2655240975\|gb\|CP108775.1\|	2975981	g13947	i0	100	0.0830945558739255	29	0	8	0	292	320	2883848	2883876	Micromonospora sp. NBC_00898 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. NBC_00898
6123557	6123557	PRJNA1108009_P_NODE_32065_length_227_cov_2.220779_g31747_i0	PRJNA1108009	32065	227	2.220779	5.04116833	Brachybacterium	43668	Bacteria	Bacteria	414	2.2399999999999998e-111	NTclustered	gi\|2708453573\|gb\|CP149573.1\|	3023517	g31747	i0	99.561	238.356828193833	228	0	100	1	1	227	3497	3270	Brachybacterium sp. GPGPB12 chromosome, complete genome	blastn	54107	414	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp. GPGPB12
6123597	6123597	PRJNA1108009_P_NODE_9245_length_448_cov_1.245333_g8927_i0	PRJNA1108009	9245	448	1.245333	5.57909184	Brachybacterium	43668	Bacteria	Bacteria	734	0	NTclustered	gi\|2645326228\|gb\|PP087390.1\|	1891286	g8927	i0	96.205	343.582589285714	448	17	100	0	1	448	847	400	Brachybacterium sp. strain 39.12 23S ribosomal RNA gene, partial sequence	blastn	153925	734	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium	Brachybacterium sp.
7398315	7398315	PRJNA1108009_P_NODE_27846_length_247_cov_0.885057_g27528_i0	PRJNA1108009	27846	247	0.885057	2.18609079	Corynebacterium	1716	Bacteria	Bacteria	403	5.35e-108	NTclustered	gi\|2547420364\|gb\|CP073093.1\|	38304	g27528	i0	95.703	382.251012145749	256	2	100	2	1	247	291536	291791	Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome	blastn	94416	403	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium tuberculostearicum
7865614	7865614	PRJNA1108009_P_NODE_17647_length_310_cov_1.156118_g17329_i0	PRJNA1108009	17647	310	1.156118	3.5839658	Mycobacterium paraseoulense	590652	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1806479221\|dbj\|AP022619.1\|	590652	g17329	i0	92.308	0.125806451612903	39	1	12	2	93	129	5836154	5836192	Mycobacterium paraseoulense JCM 16952 DNA, nearly complete genome	blastn	39	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium paraseoulense
8673747	8673747	PRJNA1108009_P_NODE_4987_length_625_cov_3.079710_g4679_i0	PRJNA1108009	4987	625	3.07971	19.2481875	Cutibacterium	1912216	Bacteria	Bacteria	1155	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4679	i0	100	277.656	625	0	100	0	1	625	55434	56058	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	173535	1155	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
10416406	10416406	PRJNA1108009_P_NODE_22049_length_271_cov_1.404040_g21731_i0	PRJNA1108009	22049	271	1.40404	3.8049484	Cutibacterium equinum	3016342	Bacteria	Bacteria	211	3.87e-50	NTclustered	gi\|2431747661\|gb\|CP115668.1\|	3016342	g21731	i0	83.117	11.7416974169742	231	39	85	0	28	258	980051	980281	Cutibacterium equinum strain CBA3108 chromosome, complete genome	blastn	3182	211	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium equinum
10416576	10416576	PRJNA1108009_P_NODE_29169_length_245_cov_0.895349_g28851_i0	PRJNA1108009	29169	245	0.895349	2.19360505	Pseudonocardia alni	33907	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2476288951\|gb\|CP052771.1\|	33907	g28851	i0	100	301.832653061225	245	0	100	0	1	245	792552	792796	Pseudonocardia alni strain Shahu chromosome, complete genome	blastn	73949	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Pseudonocardia	Pseudonocardia alni
11691889	11691889	PRJNA1108009_P_NODE_31430_length_241_cov_0.916667_g31112_i0	PRJNA1108009	31430	241	0.916667	2.20916747	Nocardioides dongkuii	2760089	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1886976265\|gb\|CP059903.1\|	2760089	g31112	i0	100	0.120331950207469	29	0	12	0	144	172	1257694	1257722	Nocardioides dongkuii strain S-713 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides dongkuii
12966682	12966682	PRJNA1108009_P_NODE_16691_length_320_cov_1.421053_g16373_i0	PRJNA1108009	16691	320	1.421053	4.5473696	Streptomyces virginiae	1961	Bacteria	Bacteria	233	9.99e-57	NTclustered	gi\|2687121656\|gb\|CP145515.1\|	1961	g16373	i0	81.625	90.778125	283	50	88	2	1	282	3200074	3200355	Streptomyces virginiae strain THA-960 chromosome, complete genome	blastn	29049	233	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces virginiae
12967027	12967027	PRJNA1108009_P_NODE_30571_length_243_cov_0.905882_g30253_i0	PRJNA1108009	30571	243	0.905882	2.20129326	Streptomyces cyanogenus	80860	Bacteria	Bacteria	60.2	1.31e-4	NTclustered	gi\|2015360468\|gb\|CP071839.1\|	80860	g30253	i0	100	0.246913580246914	32	0	13	0	162	193	5088423	5088392	Streptomyces cyanogenus strain S136 chromosome, complete genome	blastn	60	60.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cyanogenus
13773765	13773765	PRJNA1108009_P_NODE_20271_length_285_cov_1.547170_g19953_i0	PRJNA1108009	20271	285	1.54717	4.4094345	Geodermatophilaceae	85030	Bacteria	Bacteria	424	4.84e-114	NTclustered	gi\|2063288892\|gb\|CP077800.1\|	2851567	g19953	i0	93.684	473.424561403509	285	15	100	3	1	285	3891	4172	Modestobacter sp. L9-4 chromosome, complete genome	blastn	134926	425	0.997647058823529	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae	Modestobacter	Modestobacter sp. L9-4
15515744	15515744	PRJNA1108009_P_NODE_28773_length_245_cov_0.895349_g28455_i0	PRJNA1108009	28773	245	0.895349	2.19360505	Streptomyces sp. TG1A-60	3129111	Bacteria	Bacteria	163	9.79e-36	NTclustered	gi\|2699388876\|gb\|CP147520.1\|	3129111	g28455	i0	80.176	123.114285714286	227	37	91	7	11	233	2425560	2425782	Streptomyces sp. TG1A-60 chromosome, complete genome	blastn	30163	163	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. TG1A-60
16790097	16790097	PRJNA1108009_P_NODE_22054_length_271_cov_1.338384_g21736_i0	PRJNA1108009	22054	271	1.338384	3.62702064	Streptomyces ficellus	1977088	Bacteria	Bacteria	117	8.69e-22	NTclustered	gi\|1783148108\|gb\|CP034279.1\|	1977088	g21736	i0	93.59	30.6752767527675	78	5	29	0	7	84	5019123	5019200	Streptomyces ficellus strain NRRL 8067 chromosome, complete genome	blastn	8313	117	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces ficellus
22697423	22697423	PRJNA1108009_P_NODE_17378_length_313_cov_0.825000_g17060_i0	PRJNA1108009	17378	313	0.825	2.58225	Rhodococcus	1827	Bacteria	Bacteria	453	6.87e-123	NTclustered	gi\|1913894921\|gb\|CP027557.1\|	1829	g17060	i0	95.139	362.306709265176	288	12	92	2	1	288	312835	313120	Rhodococcus rhodochrous strain BX2 chromosome, complete genome	blastn	113402	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus rhodochrous
23165183	23165183	PRJNA1108009_P_NODE_18879_length_298_cov_0.915556_g18561_i0	PRJNA1108009	18879	298	0.915556	2.72835688	Microbacterium elymi	2909587	Bacteria	Bacteria	540	4.85e-149	NTclustered	gi\|2283971508\|gb\|CP091139.2\|	2909587	g18561	i0	99.329	244.026845637584	298	2	100	0	1	298	987662	987365	Microbacterium elymi strain KUDC0405 chromosome, complete genome	blastn	72720	540	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium elymi
23165446	23165446	PRJNA1108009_P_NODE_29199_length_245_cov_0.895349_g28881_i0	PRJNA1108009	29199	245	0.895349	2.19360505	Rhodococcus sp. p52	935199	Bacteria	Bacteria	255	1.57e-63	NTclustered	gi\|1052533669\|gb\|CP016819.1\|	935199	g28881	i0	86.076	94.6285714285714	237	33	97	0	4	240	1853707	1853943	Rhodococcus sp. p52, complete genome	blastn	23184	255	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus sp. p52

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