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

14 rows where analysis = "blastn", bioproject = "PRJEB6055" 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
992279	992279	PRJEB6055_S_NODE_1021_length_274_cov_2.719665_g997_i0	PRJEB6055	1021	274	2.719665	7.4518821	Corynebacterium	1716	Bacteria	Bacteria	324	4.83e-84	NTclustered	gi\|2550452893\|gb\|CP100374.1\|	38284	g997	i0	100	227.441605839416	175	0	64	0	100	274	2546169	2546343	Corynebacterium accolens strain CA9 chromosome, complete genome	blastn	62319	324	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
992284	992284	PRJEB6055_S_NODE_4401_length_168_cov_1.909774_g4377_i0	PRJEB6055	4401	168	1.909774	3.20842032	Actinomycetes	1760	Bacteria	Bacteria	217	4.73e-52	NTclustered	gi\|1035530577\|gb\|CP013979.1\|	453304	g4377	i0	91.72	432.255952380952	157	12	93	1	13	168	2766239	2766083	Agromyces aureus strain AR33 chromosome, complete genome	blastn	72619	219	0.990867579908676	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Agromyces	Agromyces aureus
1400009	1400009	PRJEB6055_S_NODE_1222_length_256_cov_4.095023_g1198_i0	PRJEB6055	1222	256	4.095023	10.48325888	Nocardioides sp. cx-173	2898796	Bacteria	Bacteria	420	5.54e-113	NTclustered	gi\|2161681380\|gb\|CP088262.1\|	2898796	g1198	i0	96.471	252.29296875	255	7	99	2	3	256	2066201	2065948	Nocardioides sp. cx-173 chromosome, complete genome	blastn	64587	420	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp. cx-173
1400032	1400032	PRJEB6055_S_NODE_582_length_322_cov_11864.574913_g558_i0	PRJEB6055	582	322	11864.574913	38203.93121986	Friedmanniella luteola	546871	Bacteria	Bacteria	396	1.21e-105	NTclustered	gi\|1085823321\|emb\|LT629749.1\|	546871	g558	i0	97.021	145.885093167702	235	7	73	0	31	265	1462199	1462433	Friedmanniella luteola strain DSM 21741 genome assembly, chromosome: I	blastn	46975	396	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Friedmanniella	Friedmanniella luteola
1400033	1400033	PRJEB6055_S_NODE_742_length_302_cov_9.940075_g718_i0	PRJEB6055	742	302	9.940075	30.0190265	uncultured Arthrobacter sp.	114050	Bacteria	Bacteria	531	2.9599999999999993e-146	NTclustered	gi\|254972631\|gb\|GQ329251.1\|	114050	g718	i0	98.344	114.986754966887	302	5	100	0	1	302	140	441	Uncultured Arthrobacter sp. clone P4s-190 16S ribosomal RNA gene, partial sequence	blastn	34726	531	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	uncultured Arthrobacter sp.
4820223	4820223	PRJEB6055_S_NODE_3604_length_180_cov_3.868966_g3580_i0	PRJEB6055	3604	180	3.868966	6.9641388	Corynebacterium	1716	Bacteria	Bacteria	239	1.09e-58	NTclustered	gi\|922844065\|gb\|CP006841.1\|	1408189	g3580	i0	98.519	311.75	135	2	75	0	46	180	1574387	1574521	Corynebacterium lactis RW2-5, complete genome	blastn	56115	239	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lactis
4820224	4820224	PRJEB6055_S_NODE_504_length_335_cov_18.000000_g480_i0	PRJEB6055	504	335	18	60.3	Corynebacterium	1716	Bacteria	Bacteria	579	1.1699999999999997e-160	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g480	i0	97.917	324.44776119403	336	4	100	3	1	335	2489882	2490215	Corynebacterium accolens strain CA3 chromosome	blastn	108690	579	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
9920472	9920472	PRJEB6055_S_NODE_5488_length_155_cov_3.708333_g5464_i0	PRJEB6055	5488	155	3.708333	5.74791615	Micrococcus	1269	Bacteria	Bacteria	243	7.05e-60	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g5464	i0	96.575	277.503225806452	146	5	94	0	1	146	345611	345466	Micrococcus luteus strain V017 chromosome, complete genome	blastn	43013	243	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
11195571	11195571	PRJEB6055_S_NODE_129_length_490_cov_3.916484_g107_i0	PRJEB6055	129	490	3.916484	19.1907716	Cutibacterium	1912216	Bacteria	Bacteria	883	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g107	i0	99.184	273.497959183673	490	4	100	0	1	490	56815	57304	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	134014	883	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18843893	18843893	PRJEB6055_S_NODE_295_length_391_cov_4.171348_g271_i0	PRJEB6055	295	391	4.171348	16.30997068	Corynebacterium	1716	Bacteria	Bacteria	566	1.0799999999999999e-156	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g271	i0	95	335.647058823529	360	17	92	1	1	360	2491067	2490709	Corynebacterium accolens strain CA3 chromosome	blastn	131238	566	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
21394344	21394344	PRJEB6055_S_NODE_1717_length_229_cov_2.943299_g1693_i0	PRJEB6055	1717	229	2.943299	6.74015471	Cutibacterium	1912216	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1693	i0	100	262.61135371179	229	0	100	0	1	229	55562	55790	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	60138	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
22669175	22669175	PRJEB6055_S_NODE_4138_length_172_cov_1.525547_g4114_i0	PRJEB6055	4138	172	1.525547	2.62394084	Intrasporangiaceae	85021	Bacteria	Bacteria	268	1.32e-67	NTclustered	gi\|2851121488\|gb\|CP084995.1\|	412689	g4114	i0	94.767	147.459302325581	172	9	100	0	1	172	1632821	1632650	Humibacillus xanthopallidus strain SLM-627 chromosome, complete genome	blastn	25363	268	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Humibacillus	Humibacillus xanthopallidus
22669178	22669178	PRJEB6055_S_NODE_818_length_294_cov_2.544402_g794_i0	PRJEB6055	818	294	2.544402	7.48054188	Micrococcales	85006	Bacteria	Bacteria	361	3.9899999999999996e-95	NTclustered	gi\|2851167701\|gb\|CP085209.1\|	367299	g794	i0	95.217	135.52380952381	230	8	78	3	35	262	2273330	2273558	Phycicoccus jejuensis strain QJJ-866 chromosome, complete genome	blastn	39844	361	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Phycicoccus	Phycicoccus jejuensis
24351375	24351375	PRJEB6055_S_NODE_2280_length_209_cov_4.005747_g2256_i0	PRJEB6055	2280	209	4.005747	8.37201123	Corynebacterium sp. LaCa97	3391431	Bacteria	Bacteria	368	1.5999999999999996e-97	NTclustered	gi\|2888564179\|gb\|CP177110.1\|	3391431	g2256	i0	98.565	357.272727272727	209	2	100	1	1	209	770197	769990	Corynebacterium sp. LaCa97 chromosome, complete genome	blastn	74670	368	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. LaCa97

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