metadata: contig_metadata: 17 rows where bioproject = "PRJNA560029" and tax

17 rows where bioproject = "PRJNA560029" 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
4958540	4958540	PRJNA560029_S_NODE_34124_length_245_cov_0.895349_g33900_i0	PRJNA560029	34124	245	0.895349	2.19360505	Cutibacterium	1912216	Bacteria	Bacteria	364	2.5e-96	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g33900	i0	100	40.3551020408163	197	0	80	0	49	245	599640	599444	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	9887	364	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
8783331	8783331	PRJNA560029_S_NODE_23427_length_286_cov_5.173709_g23203_i0	PRJNA560029	23427	286	5.173709	14.79680774	Cutibacterium	1912216	Bacteria	Bacteria	529	1e-145	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g23203	i0	100	63.7867132867133	286	0	100	0	1	286	2511957	2512242	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	18243	529	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9472509	9472509	PRJNA560029_S_NODE_23408_length_286_cov_9.450704_g23184_i0	PRJNA560029	23408	286	9.450704	27.02901344	Streptomyces caniscabiei	2746961	Bacteria	Bacteria	63.9	1.22e-5	NTclustered	gi\|2459819783\|gb\|CP119182.1\|	2746961	g23184	i0	97.297	0.227272727272727	37	1	13	0	250	286	5222481	5222517	Streptomyces caniscabiei strain ID03-3A chromosome, complete genome	blastn	65	63.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces caniscabiei
10748270	10748270	PRJNA560029_S_NODE_24409_length_282_cov_2.550239_g24185_i0	PRJNA560029	24409	282	2.550239	7.19167398	Mycobacteroides chelonae	1774	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2452106090\|gb\|CP118919.1\|	1774	g24185	i0	100	0.308510638297872	29	0	10	0	3	31	2438638	2438610	Mycobacteroides chelonae strain MCHL-2035 chromosome, complete genome	blastn	87	54.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycobacteroides	Mycobacteroides chelonae
12023413	12023413	PRJNA560029_S_NODE_9850_length_368_cov_4.169492_g9626_i0	PRJNA560029	9850	368	4.169492	15.34373056	Brevibacterium casei	33889	Bacteria	Bacteria	680	0	NTclustered	gi\|1958263390\|gb\|CP068173.1\|	33889	g9626	i0	100	8.92934782608696	368	0	100	0	1	368	423891	424258	Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome	blastn	3286	680	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
13884288	13884288	PRJNA560029_S_NODE_31211_length_254_cov_1.458564_g30987_i0	PRJNA560029	31211	254	1.458564	3.70475256	Cutibacterium	1912216	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g30987	i0	100	277.992125984252	254	0	100	0	1	254	57794	58047	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	70610	470	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
18395699	18395699	PRJNA560029_S_NODE_18555_length_310_cov_2.021097_g18331_i0	PRJNA560029	18555	310	2.021097	6.2654007	Brevibacterium casei	33889	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|1958263390\|gb\|CP068173.1\|	33889	g18331	i0	100	289.432258064516	310	0	100	0	1	310	173081	172772	Brevibacterium casei strain FDAARGOS_1100 chromosome, complete genome	blastn	89724	573	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium casei
20256961	20256961	PRJNA560029_S_NODE_14856_length_331_cov_4.682171_g14632_i0	PRJNA560029	14856	331	4.682171	15.49798601	Cutibacterium	1912216	Bacteria	Bacteria	612	1.14e-170	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g14632	i0	100	276.876132930514	331	0	100	0	1	331	55858	55528	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	91646	612	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
23496068	23496068	PRJNA560029_S_NODE_12319_length_348_cov_4.578182_g12095_i0	PRJNA560029	12319	348	4.578182	15.93207336	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	621	1.9999999999999997e-173	NTclustered	gi\|1723592958\|emb\|LR584267.1\|	1528099	g12095	i0	98.851	291.23275862069	348	4	100	0	1	348	553604	553257	Lawsonella clevelandensis isolate USB-603019 genome assembly, chromosome: 1	blastn	101349	621	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
23496480	23496480	PRJNA560029_S_NODE_31679_length_252_cov_2.268156_g31455_i0	PRJNA560029	31679	252	2.268156	5.71575312	Actinomycetospora lemnae	3019891	Bacteria	Bacteria	77.8	1.6e-14	NR	WP_274203450.1	3019891	g31455	i0	84.6	0.94047619047619	39	6	46.4	0	227	111	5	43	WP_274203450.1 sarcosine oxidase subunit beta family protein [Actinomycetospora lemnae]	diamond	237	77.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinomycetospora	Actinomycetospora lemnae
24769915	24769915	PRJNA560029_S_NODE_10380_length_364_cov_1.766323_g10156_i0	PRJNA560029	10380	364	1.766323	6.42941572	Janibacter limosus	53458	Bacteria	Bacteria	381	3.879999999999999e-101	NTclustered	gi\|2552390073\|gb\|CP087977.2\|	53458	g10156	i0	85.754	0.983516483516483	358	51	98	0	7	364	1812585	1812942	Janibacter limosus strain P1(28)-3 chromosome, complete genome	blastn	358	381	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Intrasporangiaceae	Janibacter	Janibacter limosus
28531866	28531866	PRJNA560029_S_NODE_6927_length_401_cov_4.807927_g6703_i0	PRJNA560029	6927	401	4.807927	19.27978727	Microlunatus sp.	39595	Bacteria	Bacteria	50.1	5.22e-4	NR	HET9649394.1	39595	g6703	i0	32.6	0.965087281795511	129	75	87.5	4	372	22	204	332	HET9649394.1 ABC transporter permease [Microlunatus sp.]	diamond	387	50.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Microlunatus	Microlunatus sp.
29226580	29226580	PRJNA560029_S_NODE_20569_length_300_cov_1.788546_g20345_i0	PRJNA560029	20569	300	1.788546	5.365638	Brachybacterium	43668	Bacteria	Bacteria	202	2.42e-62	NR	WP_193866173.1	43668	g20345	i0	98	0.99	99	2	99	0	298	2	239	337	WP_193866173.1 MULTISPECIES: HAD-IIA family hydrolase [Brachybacterium]	diamond	297	202	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Dermabacteraceae	Brachybacterium
30141749	30141749	PRJNA560029_S_NODE_9312_length_373_cov_5.050000_g9088_i0	PRJNA560029	9312	373	5.05	18.8365	Scrofimicrobium appendicitidis	3079930	Bacteria	Bacteria	63.2	7.2e-10	NR	XBW08714.1	3079930	g9088	i0	32	0.780160857908847	97	65	77.2	1	312	25	11	107	XBW08714.1 GNAT family N-acetyltransferase [Scrofimicrobium appendicitidis]	diamond	291	63.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Scrofimicrobium	Scrofimicrobium appendicitidis
30805696	30805696	PRJNA560029_S_NODE_23994_length_284_cov_1.872038_g23770_i0	PRJNA560029	23994	284	1.872038	5.31658792	Atopobiaceae bacterium	2485926	Bacteria	Bacteria	48.9	4.02e-4	NR	MCH3968418.1	2485926	g23770	i0	31	0.887323943661972	84	58	88.7	0	280	29	77	160	MCH3968418.1 L,D-transpeptidase/peptidoglycan binding protein [Atopobiaceae bacterium]	diamond	252	48.9	1	Bacteria	Bacillati	Actinomycetota	Coriobacteriia	Coriobacteriales	Atopobiaceae		Atopobiaceae bacterium
31754071	31754071	PRJNA560029_S_NODE_14837_length_331_cov_7.550388_g14613_i0	PRJNA560029	14837	331	7.550388	24.99178428	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	56.6	1.42e-6	NR	HEY4611321.1	2497619	g14613	i0	39.4	0.942598187311178	104	58	92.4	3	17	322	669	769	HEY4611321.1 HAD-IC family P-type ATPase [Ilumatobacteraceae bacterium]	diamond	312	56.6	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
31926227	31926227	PRJNA560029_S_NODE_3697_length_476_cov_6.856079_g3474_i0	PRJNA560029	3697	476	6.856079	32.63493604	Bacteria	2	Bacteria	Bacteria	82.4	6.75e-15	NR	WP_307234788.1	137267	g3474	i0	46.4	3.51050420168067	84	38	52.9	1	3	254	793	869	WP_307234788.1 bifunctional acetaldehyde-CoA/alcohol dehydrogenase [Catenuloplanes indicus]	diamond	1671	83.2	0.990384615384615	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Catenuloplanes	Catenuloplanes indicus

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