metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA853194" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA853194" 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
840711	840711	PRJNA853194_S_NODE_57621_length_288_cov_1.386047_g56530_i0	PRJNA853194	57621	288	1.386047	3.99181536	Micromonospora sp. B006	2201999	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|1450453732\|gb\|CP030865.1\|	2201999	g56530	i0	100	0.0972222222222222	28	0	10	0	18	45	2839752	2839725	Micromonospora sp. B006 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora	Micromonospora sp. B006
1234517	1234517	PRJNA853194_S_NODE_64961_length_272_cov_1.889447_g63870_i0	PRJNA853194	64961	272	1.889447	5.13929584	Cutibacterium	1912216	Bacteria	Bacteria	475	1.2499999999999999e-129	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g63870	i0	98.162	260.834558823529	272	5	100	0	1	272	55522	55793	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	70947	475	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2116127	2116127	PRJNA853194_S_NODE_58922_length_285_cov_1.556604_g57831_i0	PRJNA853194	58922	285	1.556604	4.4363214	Micrococcus terreus	574650	Bacteria	Bacteria	455	1.72e-123	NTclustered	gi\|2606505334\|gb\|CP136963.1\|	574650	g57831	i0	95.439	348.410526315789	285	13	100	0	1	285	1206030	1206314	Micrococcus terreus strain UMB0712 chromosome, complete genome	blastn	99297	455	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus terreus
2510028	2510028	PRJNA853194_S_NODE_29302_length_385_cov_1.750000_g28211_i0	PRJNA853194	29302	385	1.75	6.7375	Cutibacterium	1912216	Bacteria	Bacteria	673	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g28211	i0	98.182	271.187012987013	385	7	100	0	1	385	56108	56492	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	104407	678	0.992625368731563	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
3786465	3786465	PRJNA853194_S_NODE_65843_length_270_cov_3.126904_g64752_i0	PRJNA853194	65843	270	3.126904	8.4426408	Microbacterium	33882	Bacteria	Bacteria	412	9.85e-111	NTclustered	gi\|2421836332\|dbj\|AP027141.1\|	344163	g64752	i0	94.403	152.840740740741	268	15	99	0	1	268	1041403	1041670	Microbacterium terricola KV-448 DNA, complete genome	blastn	41267	412	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium terricola
4669316	4669316	PRJNA853194_S_NODE_66924_length_268_cov_2.210256_g65833_i0	PRJNA853194	66924	268	2.210256	5.92348608	Microbacterium limosum	3079935	Bacteria	Bacteria	490	4.39e-134	NTclustered	gi\|2609663758\|gb\|CP137080.1\|	3079935	g65833	i0	99.627	173.981343283582	268	1	100	0	1	268	816988	817255	Microbacterium limosum strain Y20 chromosome, complete genome	blastn	46627	490	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium limosum
8493886	8493886	PRJNA853194_S_NODE_71587_length_259_cov_3.564516_g70496_i0	PRJNA853194	71587	259	3.564516	9.23209644	Streptomyces sp. NBC_01744	2975927	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2652825344\|gb\|CP109148.1\|	2975927	g70496	i0	100	0.108108108108108	28	0	11	0	101	128	6608833	6608860	Streptomyces sp. NBC_01744 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01744
9768637	9768637	PRJNA853194_S_NODE_52148_length_301_cov_2.921053_g51057_i0	PRJNA853194	52148	301	2.921053	8.79236953	Curtobacterium flaccumfaciens	2035	Bacteria	Bacteria	67.6	1e-6	NTclustered	gi\|2699815311\|gb\|CP147772.1\|	138532	g51057	i0	97.436	0.578073089700997	39	1	13	0	40	78	1468796	1468758	Curtobacterium flaccumfaciens pv. flaccumfaciens strain ARGTr 5-2 chromosome, complete genome	blastn	174	67.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Curtobacterium	Curtobacterium flaccumfaciens
13988270	13988270	PRJNA853194_S_NODE_11_length_4751_cov_29.085720_g7_i0	PRJNA853194	11	4751	29.08572	1381.8625572	root	1	Root_unresolved	Root_unresolved	8691	0	NTclustered	gi\|1851830967\|gb\|CP050522.1\|	1902	g7	i0	99.958	97.1283940223111	4712	2	99	0	1	4712	4166864	4162153	Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome	blastn	461457	8691	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
13988320	13988320	PRJNA853194_S_NODE_40371_length_337_cov_2.681818_g39280_i0	PRJNA853194	40371	337	2.681818	9.03772666	Microbacterium	33882	Bacteria	Bacteria	612	1.16e-170	NTclustered	gi\|1532072101\|gb\|CP034245.1\|	2483401	g39280	i0	99.407	164.06824925816	337	2	100	0	1	337	2274416	2274752	Microbacterium sp. 10M-3C3 chromosome, complete genome	blastn	55291	612	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium sp. 10M-3C3
17812066	17812066	PRJNA853194_S_NODE_80894_length_246_cov_1.242775_g79803_i0	PRJNA853194	80894	246	1.242775	3.0572265	root	1	Root_unresolved	Root_unresolved	348	2.53e-91	NTclustered	gi\|1851830967\|gb\|CP050522.1\|	1902	g79803	i0	92.245	99.5934959349593	245	19	99	0	1	245	4168319	4168563	Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome	blastn	24500	348	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
19086032	19086032	PRJNA853194_S_NODE_44075_length_325_cov_1.615079_g42984_i0	PRJNA853194	44075	325	1.615079	5.24900675	root	1	Root_unresolved	Root_unresolved	597	3.1299999999999987e-166	NTclustered	gi\|1851830967\|gb\|CP050522.1\|	1902	g42984	i0	100	99.5938461538462	323	0	99	0	1	323	4161764	4161442	Streptomyces coelicolor strain M1154/pAMX4/pGP1416 chromosome, complete genome	blastn	32368	597	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces coelicolor
25461113	25461113	PRJNA853194_S_NODE_22000_length_431_cov_1.687151_g20909_i0	PRJNA853194	22000	431	1.687151	7.27162081	Microbacterium	33882	Bacteria	Bacteria	780	0	NTclustered	gi\|1137412343\|gb\|CP018762.1\|	36805	g20909	i0	99.304	162.554524361949	431	3	100	0	1	431	2342208	2341778	Microbacterium aurum strain KACC 15219 chromosome, complete genome	blastn	70061	785	0.993630573248408	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium aurum
25461229	25461229	PRJNA853194_S_NODE_79200_length_248_cov_1.074286_g78109_i0	PRJNA853194	79200	248	1.074286	2.66422928	Dietzia	37914	Bacteria	Bacteria	278	3.4e-70	NTclustered	gi\|1783245866\|gb\|CP046567.1\|	912801	g78109	i0	87.398	2.49193548387097	246	25	99	2	3	248	606954	607193	Dietzia sp. DQ12-45-1b chromosome, complete genome	blastn	618	278	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Dietziaceae	Dietzia	Dietzia sp. DQ12-45-1b

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