metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1168532" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1168532" 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
1589845	1589845	PRJNA1168532_S_NODE_219762_length_207_cov_1.310976_g216819_i0	PRJNA1168532	219762	207	1.310976	2.71372032	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	355	1.23e-93	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g216819	i0	97.585	325.729468599034	207	5	100	0	1	207	552129	551923	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	67426	355	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
5418256	5418256	PRJNA1168532_S_NODE_256445_length_187_cov_1.437500_g253502_i0	PRJNA1168532	256445	187	1.4375	2.688125	uncultured Actinomycetes bacterium	152507	Bacteria	Bacteria	62.1	2.66e-5	NTclustered	gi\|530190787\|emb\|HG379975.1\|	152507	g253502	i0	93.182	0.235294117647059	44	0	22	3	114	154	68	25	Uncultured actinobacterium partial 16S rRNA gene, clone ET3Rk82	blastn	44	62.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes				uncultured Actinomycetes bacterium
8693203	8693203	PRJNA1168532_S_NODE_5047_length_1001_cov_3.054280_g4069_i0	PRJNA1168532	5047	1001	3.05428	30.5733428	Cutibacterium	1912216	Bacteria	Bacteria	1844	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g4069	i0	99.9	254.448551448551	1001	1	100	0	1	1001	55515	56515	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	254703	1844	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9968382	9968382	PRJNA1168532_S_NODE_347308_length_153_cov_1.572727_g344365_i0	PRJNA1168532	347308	153	1.572727	2.40627231	Corynebacterium	1716	Bacteria	Bacteria	283	4.0799999999999995e-72	NTclustered	gi\|2550484788\|gb\|CP100380.1\|	38284	g344365	i0	100	368	153	0	100	0	1	153	2492766	2492918	Corynebacterium accolens strain CA3 chromosome	blastn	56304	283	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium accolens
11793795	11793795	PRJNA1168532_S_NODE_288550_length_173_cov_1.261538_g285607_i0	PRJNA1168532	288550	173	1.261538	2.18246074	Corynebacterium kefirresidentii	1979527	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g285607	i0	100	355.71676300578	173	0	100	0	1	173	1846	1674	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	61539	320	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
12518935	12518935	PRJNA1168532_S_NODE_206770_length_215_cov_1.308140_g203827_i0	PRJNA1168532	206770	215	1.30814	2.812501	Micrococcus	1269	Bacteria	Bacteria	350	5.999999999999999e-92	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g203827	i0	96.244	312.158139534884	213	8	99	0	1	213	347478	347266	Micrococcus luteus strain V017 chromosome, complete genome	blastn	67114	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20166586	20166586	PRJNA1168532_S_NODE_110356_length_306_cov_1.844106_g107413_i0	PRJNA1168532	110356	306	1.844106	5.64296436	Corynebacterium	1716	Bacteria	Bacteria	555	1.7799999999999996e-153	NTclustered	gi\|2869817591\|gb\|CP175775.1\|	1979527	g107413	i0	99.346	339.052287581699	306	2	100	0	1	306	2773	3078	Corynebacterium kefirresidentii strain YSMAA3_1_H1 chromosome, complete genome	blastn	103750	555	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium kefirresidentii
22717158	22717158	PRJNA1168532_S_NODE_210058_length_213_cov_1.176471_g207115_i0	PRJNA1168532	210058	213	1.176471	2.50588323	Corynebacterium	1716	Bacteria	Bacteria	344	2.76e-90	NTclustered	gi\|2869858840\|gb\|CP175793.1\|	3383589	g207115	i0	100	319.201877934272	186	0	87	0	1	186	723712	723527	Corynebacterium sp. YSMAA1_1_D6 chromosome, complete genome	blastn	67990	344	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. YSMAA1_1_D6

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