metadata: contig_metadata: 13 rows where bioproject = "PRJNA602115" and tax

13 rows where bioproject = "PRJNA602115" 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
2418174	2418174	PRJNA602115_P_NODE_11122_length_203_cov_0.901408_g11097_i0	PRJNA602115	11122	203	0.901408	1.82985824	Cutibacterium	1912216	Bacteria	Bacteria	375	9.24e-100	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g11097	i0	100	51	203	0	100	0	1	203	1187493	1187695	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	10353	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418177	2418177	PRJNA602115_P_NODE_2142_length_408_cov_1.023055_g2117_i0	PRJNA602115	2142	408	1.023055	4.1740644	Cutibacterium	1912216	Bacteria	Bacteria	754	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2117	i0	100	300.303921568627	408	0	100	0	1	408	55601	56008	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	122524	754	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
2418179	2418179	PRJNA602115_P_NODE_2782_length_362_cov_1.684385_g2757_i0	PRJNA602115	2782	362	1.684385	6.0974737	Mycobacteriaceae	1762	Bacteria	Bacteria	664	0	NTclustered	gi\|1935556990\|gb\|CP062008.1\|	1226753	g2757	i0	99.724	187.055248618785	362	1	100	0	1	362	1387858	1387497	Mycolicibacterium mucogenicum DSM 44124 chromosome, complete genome	blastn	67714	669	0.992526158445441	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum
8229093	8229093	PRJNA602115_P_NODE_9887_length_206_cov_0.882759_g9862_i0	PRJNA602115	9887	206	0.882759	1.81848354	Williamsia herbipolensis	1603258	Bacteria	Bacteria	335	1.5999999999999997e-87	NTclustered	gi\|2658946156\|gb\|CP108021.1\|	1603258	g9862	i0	96.117	325.417475728155	206	7	100	1	1	206	3888	3684	Williamsia herbipolensis strain NBC_00319 chromosome, complete genome	blastn	67036	335	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia herbipolensis
9504244	9504244	PRJNA602115_P_NODE_9228_length_208_cov_0.870748_g9203_i0	PRJNA602115	9228	208	0.870748	1.81115584	Geodermatophilaceae bacterium NBWT11	2596920	Bacteria	Bacteria	219	1.7e-52	NTclustered	gi\|1891431189\|gb\|CP043652.1\|	2596920	g9203	i0	88.043	78.7596153846154	184	22	88	0	25	208	121409	121592	Geodermatophilaceae bacterium NBWT11 chromosome, complete genome	blastn	16382	219	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Geodermatophilales	Geodermatophilaceae		Geodermatophilaceae bacterium NBWT11
12621920	12621920	PRJNA602115_P_NODE_8770_length_209_cov_0.864865_g8745_i0	PRJNA602115	8770	209	0.864865	1.80756785	Actinomycetes	1760	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1021079766\|dbj\|AP017424.1\|	39478	g8745	i0	100	0.267942583732057	28	0	13	0	68	95	68121	68148	Streptomyces laurentii DNA, complete genome, strain: ATCC 31255	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces laurentii
17153300	17153300	PRJNA602115_P_NODE_10214_length_205_cov_0.888889_g10189_i0	PRJNA602115	10214	205	0.888889	1.82222245	Mycolicibacterium aubagnense	319707	Bacteria	Bacteria	350	5.669999999999999e-92	NTclustered	gi\|1806292234\|dbj\|AP022577.1\|	319707	g10189	i0	97.549	5.97073170731707	204	5	99	0	1	204	3328729	3328932	Mycolicibacterium aubagnense JCM 15296 DNA, complete genome	blastn	1224	350	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aubagnense
24801907	24801907	PRJNA602115_P_NODE_3500_length_327_cov_0.778195_g3475_i0	PRJNA602115	3500	327	0.778195	2.54469765	Corynebacterium matruchotii	43768	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1540233514\|emb\|LR134504.1\|	43768	g3475	i0	100	0.171253822629969	28	0	9	0	151	178	2042681	2042708	Corynebacterium matruchotii strain NCTC10206 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium matruchotii
25369198	25369198	PRJNA602115_P_NODE_4000_length_309_cov_1.161290_g3975_i0	PRJNA602115	4000	309	1.16129	3.5883861	Mycobacteriaceae	1762	Bacteria	Bacteria	449	8.76e-122	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g3975	i0	92.903	155.145631067961	310	20	100	2	1	309	1313246	1312938	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	47940	449	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
28943430	28943430	PRJNA602115_P_NODE_11188_length_203_cov_0.901408_g11163_i0	PRJNA602115	11188	203	0.901408	1.82985824	Streptomyces sp. NBC_	1931	Bacteria	Bacteria	43.1	0.0159	NR	WP_329376215.1	2903833	g11163	i0	51.4	1.0935960591133	37	16	51.7	1	48	152	69	105	WP_329376215.1 mannosyltransferase family protein [Streptomyces sp. NBC_01351]	diamond	222	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NBC_01351
30333196	30333196	PRJNA602115_P_NODE_7932_length_223_cov_1.185185_g7907_i0	PRJNA602115	7932	223	1.185185	2.64296255	unclassified Micromonospora	2617518	Bacteria	Bacteria	48.1	3.28e-4	NR	WP_377583842.1	2617518	g7907	i0	44.8	0.780269058295964	58	26	71.3	2	42	200	169	225	WP_377583842.1 MULTISPECIES: winged helix-turn-helix domain-containing protein [unclassified Micromonospora]	diamond	174	48.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Micromonospora
30616960	30616960	PRJNA602115_P_NODE_8793_length_209_cov_0.864865_g8768_i0	PRJNA602115	8793	209	0.864865	1.80756785	Streptomyces sp. Ag82_O1-15	1938855	Bacteria	Bacteria	42	0.0445	NR	WP_095850585.1	1938855	g8768	i0	38.7	0.889952153110048	62	35	87.6	2	2	184	384	443	WP_095850585.1 MBL fold metallo-hydrolase [Streptomyces sp. Ag82_O1-15]	diamond	186	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Ag82_O1-15
31312207	31312207	PRJNA602115_P_NODE_7895_length_224_cov_0.975460_g7870_i0	PRJNA602115	7895	224	0.97546	2.1850304	Williamsia serinedens	391736	Bacteria	Bacteria	71.2	1.77e-14	NR	MCP2159627.1	391736	g7870	i0	92.3	0.522321428571429	39	3	52.2	0	119	3	1	39	MCP2159627.1 hypothetical protein [Williamsia serinedens]	diamond	117	71.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Williamsia	Williamsia serinedens

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