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

13 rows where bioproject = "PRJNA904835" 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
1247526	1247526	PRJNA904835_P_NODE_51001_length_251_cov_0.865169_g50745_i0	PRJNA904835	51001	251	0.865169	2.17157419	Amycolatopsis	1813	Bacteria	Bacteria	147	1.01e-30	NTclustered	gi\|2326010688\|gb\|CP100416.1\|	33910	g50745	i0	77.959	84.1354581673307	245	47	97	7	2	244	7700068	7700307	Amycolatopsis mediterranei strain ISP5501 chromosome	blastn	21118	147	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis mediterranei
1247557	1247557	PRJNA904835_P_NODE_55821_length_245_cov_0.895349_g55565_i0	PRJNA904835	55821	245	0.895349	2.19360505	Rhodococcus	1827	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2258906618\|dbj\|AP018733.1\|	1833	g55565	i0	100	412.379591836735	245	0	100	0	1	245	4075433	4075189	Rhodococcus erythropolis JCM 2895 DNA, complete genome	blastn	101033	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Rhodococcus	Rhodococcus erythropolis
16549946	16549946	PRJNA904835_P_NODE_44993_length_276_cov_1.246305_g44737_i0	PRJNA904835	44993	276	1.246305	3.4398018	Cutibacterium	1912216	Bacteria	Bacteria	494	3.51e-135	NTclustered	gi\|966542502\|gb\|CP012354.1\|	1747	g44737	i0	98.913	50.9492753623188	276	3	100	0	1	276	1067285	1067010	Cutibacterium acnes strain PA_12_1_L1 chromosome, complete genome	blastn	14062	494	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23835703	23835703	PRJNA904835_P_NODE_51059_length_251_cov_0.865169_g50803_i0	PRJNA904835	51059	251	0.865169	2.17157419	Corynebacterium afermentans	38286	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|2531253808\|gb\|CP046530.1\|	144184	g50803	i0	99.203	386.745019920319	251	2	100	0	1	251	640353	640103	Corynebacterium afermentans subsp. lipophilum strain DSM 44282 chromosome, complete genome	blastn	97073	453	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium afermentans
27561200	27561200	PRJNA904835_P_NODE_53604_length_248_cov_0.851429_g53348_i0	PRJNA904835	53604	248	0.851429	2.11154392	Corynebacterium parakroppenstedtii	2828363	Bacteria	Bacteria	85.9	4.03e-19	NR	WP_236882360.1	2828363	g53348	i0	97.7	0.520161290322581	43	1	52	0	3	131	106	148	WP_236882360.1 hypothetical protein, partial [Corynebacterium parakroppenstedtii]	diamond	129	85.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium parakroppenstedtii
27884682	27884682	PRJNA904835_P_NODE_19345_length_461_cov_1.623711_g19090_i0	PRJNA904835	19345	461	1.623711	7.48530771	root	1	Root_unresolved	Root_unresolved	134	1.2499999999999999e-34	NR	WP_390550186.1	1942	g19090	i0	48.4	12.6572668112798	122	62	79.4	1	460	95	251	371	WP_390550186.1 actin, cytoplasmic 2 [Streptomyces goshikiensis]	diamond	5835	135	0.992592592592593	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces goshikiensis
28705762	28705762	PRJNA904835_P_NODE_39627_length_301_cov_1.688596_g39371_i0	PRJNA904835	39627	301	1.688596	5.08267396	root	1	Root_unresolved	Root_unresolved	45.4	0.00825	NR	MCW2567567.1	1785	g39371	i0	38.3	5.7109634551495	47	29	46.8	0	228	88	365	411	MCW2567567.1 alkyl hydroperoxide reductase [Mycobacterium sp.]	diamond	1719	45.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacterium	Mycobacterium sp.
28855772	28855772	PRJNA904835_P_NODE_26288_length_387_cov_0.980892_g26032_i0	PRJNA904835	26288	387	0.980892	3.79605204	Streptomyces	1883	Bacteria	Bacteria	47.4	0.00142	NR	WP_370594859.1	1883	g26032	i0	52.2	0.697674418604651	46	19	33.3	2	386	258	36	81	WP_370594859.1 MULTISPECIES: fascin domain-containing protein [Streptomyces]	diamond	270	47.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
29108668	29108668	PRJNA904835_P_NODE_35408_length_324_cov_2.163347_g35152_i0	PRJNA904835	35408	324	2.163347	7.00924428	Corynebacterium parakroppenstedtii	2828363	Bacteria	Bacteria	210	2.67e-66	NR	WP_236882348.1	2828363	g35152	i0	100	0.990740740740741	107	0	99.1	0	322	2	29	135	WP_236882348.1 hypothetical protein, partial [Corynebacterium parakroppenstedtii]	diamond	321	210	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium parakroppenstedtii
29298016	29298016	PRJNA904835_P_NODE_39529_length_302_cov_1.122271_g39273_i0	PRJNA904835	39529	302	1.122271	3.38925842	Buchananella hordeovulneris	52770	Bacteria	Bacteria	43.5	0.0404	NR	MDO4791949.1	52770	g39273	i0	34.6	0.804635761589404	81	49	80.5	1	9	251	532	608	MDO4791949.1 ComEC/Rec2 family competence protein [Buchananella hordeovulneris]	diamond	243	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Buchananella	Buchananella hordeovulneris
29771420	29771420	PRJNA904835_P_NODE_11991_length_609_cov_10.070896_g11746_i0	PRJNA904835	11991	609	10.070896	61.33175664	Rugosimonospora acidiphila	556531	Bacteria	Bacteria	154	6.53e-45	NR	WP_345639472.1	556531	g11746	i0	97.5	0.394088669950739	80	2	39.4	0	297	536	1	80	WP_345639472.1 hypothetical protein, partial [Rugosimonospora acidiphila]	diamond	240	154	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Rugosimonospora	Rugosimonospora acidiphila
29929701	29929701	PRJNA904835_P_NODE_43711_length_282_cov_1.105263_g43455_i0	PRJNA904835	43711	282	1.105263	3.11684166	Streptomyces sp. NRRL F-5727	1463871	Bacteria	Bacteria	45.1	0.009	NR	WP_051716732.1	1463871	g43455	i0	47.1	1.08510638297872	51	25	54.3	1	25	177	322	370	WP_051716732.1 MATE family efflux transporter [Streptomyces sp. NRRL F-5727]	diamond	306	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. NRRL F-5727
30340769	30340769	PRJNA904835_P_NODE_13912_length_560_cov_1.139630_g13660_i0	PRJNA904835	13912	560	1.13963	6.381928	Corynebacterium pseudokroppenstedtii	2804917	Bacteria	Bacteria	122	1.57e-29	NR	WP_236883204.1	2804917	g13660	i0	52.3	0.707142857142857	132	52	67.5	4	21	398	23	149	WP_236883204.1 retrotransposon gag family protein, partial [Corynebacterium pseudokroppenstedtii]	diamond	396	122	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium pseudokroppenstedtii

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