metadata: contig_metadata: 14 rows where bioproject = "PRJNA1082072" and tax

14 rows where bioproject = "PRJNA1082072" 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
1017107	1017107	PRJNA1082072_P_NODE_1901_length_262_cov_1.629630_g1894_i0	PRJNA1082072	1901	262	1.62963	4.2696306	Cutibacterium	1912216	Bacteria	Bacteria	401	2.0599999999999992e-107	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1894	i0	99.545	53.7442748091603	220	1	100	0	1	220	357240	357459	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	14081	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
4019747	4019747	PRJNA1082072_P_NODE_1844_length_266_cov_1.259067_g1837_i0	PRJNA1082072	1844	266	1.259067	3.34911822	Corynebacterium ureicelerivorans	401472	Bacteria	Bacteria	472	1.5799999999999998e-128	NTclustered	gi\|675824235\|gb\|CP009215.1\|	401472	g1837	i0	98.496	345.082706766917	266	3	100	1	1	266	625172	624908	Corynebacterium ureicelerivorans strain IMMIB RIV-2301, complete genome	blastn	91792	472	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium ureicelerivorans
4845271	4845271	PRJNA1082072_P_NODE_2064_length_251_cov_0.865169_g2057_i0	PRJNA1082072	2064	251	0.865169	2.17157419	Cutibacterium	1912216	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2057	i0	100	53	251	0	100	0	1	251	409447	409197	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	13303	464	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
5295976	5295976	PRJNA1082072_P_NODE_2885_length_242_cov_0.911243_g2878_i0	PRJNA1082072	2885	242	0.911243	2.20520806	Corynebacterium ureicelerivorans	401472	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|675824235\|gb\|CP009215.1\|	401472	g2878	i0	100	454.632231404959	242	0	100	0	1	242	627202	627443	Corynebacterium ureicelerivorans strain IMMIB RIV-2301, complete genome	blastn	110021	448	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium ureicelerivorans
9120809	9120809	PRJNA1082072_P_NODE_2928_length_241_cov_0.916667_g2921_i0	PRJNA1082072	2928	241	0.916667	2.20916747	Corynebacterium lujinxingii	2763010	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1899778044\|gb\|CP061032.1\|	2763010	g2921	i0	97.095	1.82157676348548	241	7	100	0	1	241	50694	50934	Corynebacterium lujinxingii strain zg-917 chromosome, complete genome	blastn	439	407	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium lujinxingii
23145361	23145361	PRJNA1082072_P_NODE_1799_length_269_cov_1.178571_g1792_i0	PRJNA1082072	1799	269	1.178571	3.17035599	Rhodococcoides fascians	1828	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2637134465\|gb\|CP140264.1\|	1828	g1792	i0	100	0.107806691449814	29	0	11	0	173	201	3320803	3320775	Rhodococcoides fascians strain GS01 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcoides	Rhodococcoides fascians
23969616	23969616	PRJNA1082072_P_NODE_2699_length_244_cov_0.900585_g2692_i0	PRJNA1082072	2699	244	0.900585	2.1974274	Kocuria	57493	Bacteria	Bacteria	446	8.639999999999999e-121	NTclustered	gi\|1678593041\|gb\|CP035103.1\|	1275	g2692	i0	99.59	350.545081967213	244	1	100	0	1	244	2499330	2499087	Kocuria rosea strain ATCC 186 chromosome, complete genome	blastn	85533	446	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	Kocuria rosea
27288721	27288721	PRJNA1082072_P_NODE_2043_length_251_cov_1.370787_g2036_i0	PRJNA1082072	2043	251	1.370787	3.44067537	Streptosporangium	2000	Bacteria	Bacteria	63.2	2.18e-9	NR	WP_362769229.1	2000	g2036	i0	49.4	1.9601593625498	83	36	96.8	3	1	243	85	163	WP_362769229.1 MULTISPECIES: hypothetical protein [Streptosporangium]	diamond	492	63.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium
27383660	27383660	PRJNA1082072_P_NODE_1643_length_278_cov_1.326829_g1636_i0	PRJNA1082072	1643	278	1.326829	3.68858462	Promicromonospora sp. NPDC	1873457	Bacteria	Bacteria	179	7.14e-50	NR	WP_397432854.1	3364407	g1636	i0	100	0.992805755395683	92	0	99.3	0	1	276	15	106	WP_397432854.1 FtsX-like permease family protein [Promicromonospora sp. NPDC052451]	diamond	276	179	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Promicromonosporaceae	Promicromonospora	Promicromonospora sp. NPDC052451
28172834	28172834	PRJNA1082072_P_NODE_1146_length_323_cov_1.924000_g1139_i0	PRJNA1082072	1146	323	1.924	6.21452	Sinosporangium siamense	1367973	Bacteria	Bacteria	75.9	1.11e-14	NR	WP_204030472.1	1367973	g1139	i0	34.6	0.96594427244582	104	66	96.6	1	10	321	6	107	WP_204030472.1 hypothetical protein, partial [Sinosporangium siamense]	diamond	312	75.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sinosporangium	Sinosporangium siamense
28520341	28520341	PRJNA1082072_P_NODE_1487_length_287_cov_1.121495_g1480_i0	PRJNA1082072	1487	287	1.121495	3.21869065	uncultured Corynebacterium sp.	159447	Bacteria	Bacteria	43.1	0.0456	NR	WP_366513535.1	159447	g1480	i0	33.3	0.909407665505226	87	49	90.9	2	19	279	143	220	WP_366513535.1 chromosomal replication initiator protein DnaA [uncultured Corynebacterium sp.]	diamond	261	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	uncultured Corynebacterium sp.
28732768	28732768	PRJNA1082072_P_NODE_1407_length_291_cov_1.688073_g1400_i0	PRJNA1082072	1407	291	1.688073	4.91229243	Bacillati	1783272	Bacteria	Bacteria	68.6	5.32e-12	NR	WP_204030472.1	1367973	g1400	i0	33	2.83505154639175	94	61	96.9	1	10	291	6	97	WP_204030472.1 hypothetical protein, partial [Sinosporangium siamense]	diamond	825	68.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Sinosporangium	Sinosporangium siamense
28890445	28890445	PRJNA1082072_P_NODE_1168_length_320_cov_1.246964_g1161_i0	PRJNA1082072	1168	320	1.246964	3.9902848	Myceligenerans	253183	Bacteria	Bacteria	61.6	2.07e-8	NR	WP_242637001.1	1230528	g1161	i0	37.8	2.26875	82	50	75.9	1	77	319	45	126	WP_242637001.1 family 43 glycosylhydrolase [Myceligenerans salitolerans]	diamond	726	61.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Promicromonosporaceae	Myceligenerans	Myceligenerans salitolerans
30825734	30825734	PRJNA1082072_P_NODE_2194_length_250_cov_0.870056_g2187_i0	PRJNA1082072	2194	250	0.870056	2.17514	Pseudarthrobacter oxydans	1671	Bacteria	Bacteria	51.2	3.33e-5	NR	WP_400621719.1	1671	g2187	i0	38.3	1.128	94	41	96	2	240	1	8	98	WP_400621719.1 hypothetical protein [Pseudarthrobacter oxydans]	diamond	282	51.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter oxydans

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