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

14 rows where bioproject = "PRJNA885753" 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
5965012	5965012	PRJNA885753_S_NODE_2305_length_301_cov_2.508772_g2287_i0	PRJNA885753	2305	301	2.508772	7.55140372	Corynebacterium comes	2675218	Bacteria	Bacteria	551	2.2699999999999992e-152	NTclustered	gi\|1782155183\|gb\|CP046453.1\|	2675218	g2287	i0	99.668	441.12292358804	301	1	100	0	1	301	701989	702289	Corynebacterium comes strain 2019 chromosome, complete genome	blastn	132778	551	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium comes
8514600	8514600	PRJNA885753_S_NODE_1527_length_353_cov_1.657143_g1509_i0	PRJNA885753	1527	353	1.657143	5.84971479	Corynebacterium humireducens	1223514	Bacteria	Bacteria	597	3.42e-166	NTclustered	gi\|748228406\|gb\|CP005286.1\|	1223515	g1509	i0	97.167	401.640226628895	353	10	100	0	1	353	626527	626879	Corynebacterium humireducens NBRC 106098 = DSM 45392, complete genome	blastn	141779	597	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium humireducens
10169934	10169934	PRJNA885753_S_NODE_1668_length_341_cov_1.518657_g1650_i0	PRJNA885753	1668	341	1.518657	5.17862037	Mycobacteriaceae	1762	Bacteria	Bacteria	599	9.18e-167	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g1650	i0	100	157.067448680352	324	0	95	0	1	324	1313057	1313380	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	53560	599	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
13615350	13615350	PRJNA885753_S_NODE_3931_length_249_cov_1.170455_g3913_i0	PRJNA885753	3931	249	1.170455	2.91443295	Tessaracoccus timonensis	2161816	Bacteria	Bacteria	414	2.49e-111	NTclustered	gi\|1379009977\|emb\|LT996886.1\|	2161816	g3913	i0	97.917	190.144578313253	240	4	96	1	1	240	1995234	1994996	Tessaracoccus sp. Marseille-P5995 genome assembly, chromosome: contig00001	blastn	47346	414	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Tessaracoccus	Tessaracoccus timonensis
13995211	13995211	PRJNA885753_S_NODE_1011_length_420_cov_1.974063_g993_i0	PRJNA885753	1011	420	1.974063	8.2910646	Mycobacteriaceae	1762	Bacteria	Bacteria	776	0	NTclustered	gi\|2118065613\|gb\|CP084713.1\|	319706	g993	i0	100	190.278571428571	420	0	100	0	1	420	1313064	1312645	Mycolicibacterium phocaicum strain RL-HY01 chromosome, complete genome	blastn	79917	776	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium phocaicum
16164458	16164458	PRJNA885753_S_NODE_3053_length_269_cov_2.020408_g3035_i0	PRJNA885753	3053	269	2.020408	5.43489752	Corynebacterium humireducens	1223514	Bacteria	Bacteria	401	2.1199999999999993e-107	NTclustered	gi\|748228406\|gb\|CP005286.1\|	1223515	g3035	i0	93.704	330.230483271375	270	14	100	3	1	269	1274788	1275055	Corynebacterium humireducens NBRC 106098 = DSM 45392, complete genome	blastn	88832	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium humireducens
17439921	17439921	PRJNA885753_S_NODE_4214_length_246_cov_0.901734_g4196_i0	PRJNA885753	4214	246	0.901734	2.21826564	Capillimicrobium parvum	2884022	Bacteria	Bacteria	398	2.4799999999999997e-106	NTclustered	gi\|2164499877\|gb\|CP087164.1\|	2884022	g4196	i0	95.951	100.772357723577	247	6	100	4	1	246	2764372	2764129	Capillimicrobium parvum strain 0166_1 chromosome, complete genome	blastn	24790	398	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Capillimicrobiaceae	Capillimicrobium	Capillimicrobium parvum
18713087	18713087	PRJNA885753_S_NODE_1475_length_358_cov_1.905263_g1457_i0	PRJNA885753	1475	358	1.905263	6.82084154	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	651	0	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g1457	i0	99.441	390.18156424581	358	2	100	0	1	358	81648	81291	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	139685	651	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
19092810	19092810	PRJNA885753_S_NODE_515_length_585_cov_4.412109_g499_i0	PRJNA885753	515	585	4.412109	25.81083765	root	1	Root_unresolved	Root_unresolved	809	0	NTclustered	gi\|119433766\|gb\|EF032505.1\|	2017	g499	i0	100	69.4410256410256	438	0	75	0	85	522	69444	69007	Streptoalloteichus hindustanus strain ATCC 31158 tallysomycin biosynthetic gene cluster, complete sequence	blastn	40623	813	0.995079950799508	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Streptoalloteichus	Streptoalloteichus hindustanus
21263686	21263686	PRJNA885753_S_NODE_2297_length_302_cov_0.903930_g2279_i0	PRJNA885753	2297	302	0.90393	2.7298686	Corynebacterium sp. SCR221107	3017361	Bacteria	Bacteria	553	6.32e-153	NTclustered	gi\|2428482000\|gb\|CP115670.1\|	3017361	g2279	i0	99.669	386.890728476821	302	1	100	0	1	302	886042	885741	Corynebacterium sp. SCR221107 chromosome, complete genome	blastn	116841	553	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium sp. SCR221107
23813918	23813918	PRJNA885753_S_NODE_2679_length_284_cov_1.644550_g2661_i0	PRJNA885753	2679	284	1.64455	4.670522	Mycolicibacterium aubagnense	319707	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|1806292234\|dbj\|AP022577.1\|	319707	g2661	i0	100	161.62676056338	281	0	99	0	4	284	947176	946896	Mycolicibacterium aubagnense JCM 15296 DNA, complete genome	blastn	45902	520	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium aubagnense
24192874	24192874	PRJNA885753_S_NODE_3379_length_260_cov_0.791444_g3361_i0	PRJNA885753	3379	260	0.791444	2.0577544	Micrococcales	85006	Bacteria	Bacteria	331	2.72e-86	NTclustered	gi\|2442350572\|gb\|CP110680.1\|	1708	g3361	i0	89.961	279.269230769231	259	23	99	3	1	259	3280406	3280661	Cellulomonas fimi strain Clb-11 chromosome, complete genome	blastn	72610	331	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Cellulomonas	Cellulomonas fimi
27529382	27529382	PRJNA885753_S_NODE_3423_length_258_cov_1.264865_g3405_i0	PRJNA885753	3423	258	1.264865	3.2633517	Nocardioidaceae bacterium	1871072	Bacteria	Bacteria	116	6.26e-28	NR	HSE71576.1	1871072	g3405	i0	69.8	1	86	25	98.8	1	257	3	369	454	HSE71576.1 phytase [Nocardioidaceae bacterium]	diamond	258	116	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae		Nocardioidaceae bacterium
32046998	32046998	PRJNA885753_S_NODE_4458_length_243_cov_0.917647_g4440_i0	PRJNA885753	4458	243	0.917647	2.22988221	Propionibacterium sp.	1977903	Bacteria	Bacteria	175	5.4e-50	NR	NLA29123.1	1977903	g4440	i0	100	0.987654320987654	80	0	98.8	0	2	241	140	219	NLA29123.1 GMC family oxidoreductase [Propionibacterium sp.]	diamond	240	175	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propionibacterium	Propionibacterium sp.

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