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

17 rows where bioproject = "PRJNA998413" 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
3529756	3529756	PRJNA998413_S_NODE_12743_length_211_cov_0.905405_g12712_i0	PRJNA998413	12743	211	0.905405	1.91040455	Micrococcus luteus	1270	Bacteria	Bacteria	390	3.459999999999999e-104	NTclustered	gi\|1785977953\|gb\|CP043849.1\|	1270	g12712	i0	100	27.1279620853081	211	0	100	0	1	211	458760	458970	Micrococcus luteus strain NCCP 15687 chromosome, complete genome	blastn	5724	390	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
6378097	6378097	PRJNA998413_S_NODE_465_length_569_cov_6.138340_g435_i0	PRJNA998413	465	569	6.13834	34.9271546	Microbacterium	33882	Bacteria	Bacteria	1003	0	NTclustered	gi\|470475773\|ref\|NR_076300.1\|	2033	g435	i0	99.636	190.214411247803	549	2	96	0	1	549	551	3	Microbacterium testaceum strain StLB037 23S ribosomal RNA gene, complete sequence	blastn	108232	1003	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium testaceum
6378107	6378107	PRJNA998413_S_NODE_9125_length_229_cov_1.210843_g9094_i0	PRJNA998413	9125	229	1.210843	2.77283047	Micrococcus	1269	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1796953946\|gb\|CP041689.1\|	1270	g9094	i0	100	311	229	0	100	0	1	229	115763	115991	Micrococcus luteus strain 10240 chromosome, complete genome	blastn	71219	424	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
7652016	7652016	PRJNA998413_S_NODE_1746_length_378_cov_2.612698_g1715_i0	PRJNA998413	1746	378	2.612698	9.87599844	Cutibacterium	1912216	Bacteria	Bacteria	664	0	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g1715	i0	98.67	275.473544973545	376	2	99	3	1	375	55876	55503	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	104129	665	0.998496240601504	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
9907327	9907327	PRJNA998413_S_NODE_268_length_680_cov_9.434360_g240_i0	PRJNA998413	268	680	9.43436	64.153648	Microbacterium proteolyticum	1572644	Bacteria	Bacteria	1256	0	NTclustered	gi\|2482566189\|gb\|CP121274.1\|	1572644	g240	i0	100	179.944117647059	680	0	100	0	1	680	2451456	2452135	Microbacterium proteolyticum strain ustc chromosome, complete genome	blastn	122362	1256	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium proteolyticum
9907400	9907400	PRJNA998413_S_NODE_7908_length_239_cov_1.903409_g7877_i0	PRJNA998413	7908	239	1.903409	4.54914751	Corynebacterium haemomassiliense	2754726	Bacteria	Bacteria	420	5.11e-113	NTclustered	gi\|2831275068\|gb\|CP170998.1\|	2754726	g7877	i0	98.326	412.861924686192	239	4	100	0	1	239	1441437	1441199	Corynebacterium haemomassiliense strain WGS1525 chromosome, complete genome	blastn	98674	420	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium haemomassiliense
11477737	11477737	PRJNA998413_S_NODE_10329_length_220_cov_1.324841_g10298_i0	PRJNA998413	10329	220	1.324841	2.9146502	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	144	1.0899999999999998e-41	NR	PYC99494.1	57043	g10298	i0	98.6	0.995454545454545	73	1	99.5	0	220	2	82	154	PYC99494.1 hypothetical protein B4U78_016800, partial [Microbacterium esteraromaticum]	diamond	219	144	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
12753293	12753293	PRJNA998413_S_NODE_9430_length_226_cov_2.680982_g9399_i0	PRJNA998413	9430	226	2.680982	6.05901932	Micrococcus	1269	Bacteria	Bacteria	375	1.05e-99	NTclustered	gi\|1891023613\|gb\|CP058971.1\|	1270	g9399	i0	100	274.048672566372	203	0	90	0	2	204	345667	345465	Micrococcus luteus strain V017 chromosome, complete genome	blastn	61935	375	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
17557081	17557081	PRJNA998413_S_NODE_7154_length_247_cov_0.896739_g7123_i0	PRJNA998413	7154	247	0.896739	2.21494533	Corynebacterium striatum	43770	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|1285331014\|gb\|CP024932.1\|	43770	g7123	i0	95.951	343.959514170041	247	10	100	0	1	247	12097	12343	Corynebacterium striatum strain 216 chromosome, complete genome	blastn	84958	401	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium striatum
17851645	17851645	PRJNA998413_S_NODE_2974_length_321_cov_3.662791_g2943_i0	PRJNA998413	2974	321	3.662791	11.75755911	Micrococcus	1269	Bacteria	Bacteria	593	3.9899999999999986e-165	NTclustered	gi\|1949953231\|gb\|CP066288.1\|	1270	g2943	i0	100	268.965732087227	321	0	100	0	1	321	2260858	2260538	Micrococcus luteus strain FDAARGOS_1034 chromosome	blastn	86338	593	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Micrococcus	Micrococcus luteus
20400349	20400349	PRJNA998413_S_NODE_2276_length_346_cov_2.130742_g2245_i0	PRJNA998413	2276	346	2.130742	7.37236732	Cutibacterium	1912216	Bacteria	Bacteria	640	5.4999999999999996e-179	NTclustered	gi\|1446500593\|gb\|CP031442.1\|	1747	g2245	i0	100	294.950867052023	346	0	100	0	1	346	57239	56894	Cutibacterium acnes strain KCOM 1315 chromosome, complete genome	blastn	102053	640	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
25205209	25205209	PRJNA998413_S_NODE_10160_length_221_cov_1.696203_g10129_i0	PRJNA998413	10160	221	1.696203	3.74860863	Brevibacterium aurantiacum	273384	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|1066955208\|gb\|CP017150.1\|	273384	g10129	i0	100	309.289592760181	221	0	100	0	1	221	722367	722587	Brevibacterium aurantiacum strain SMQ-1335 chromosome, complete genome	blastn	68353	409	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Brevibacteriaceae	Brevibacterium	Brevibacterium aurantiacum
30247926	30247926	PRJNA998413_S_NODE_12392_length_212_cov_0.899329_g12361_i0	PRJNA998413	12392	212	0.899329	1.90657748	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	92	3.82e-22	NR	PYC99673.1	57043	g12361	i0	97.8	0.650943396226415	46	1	65.1	0	138	1	1	46	PYC99673.1 hypothetical protein B4U78_015020 [Microbacterium esteraromaticum]	diamond	138	92	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
31575291	31575291	PRJNA998413_S_NODE_7836_length_240_cov_1.135593_g7805_i0	PRJNA998413	7836	240	1.135593	2.7254232	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	58.9	1.76e-8	NR	PYC99674.1	57043	g7805	i0	39	0.7375	59	36	73.8	0	1	177	61	119	PYC99674.1 hypothetical protein B4U78_015025 [Microbacterium esteraromaticum]	diamond	177	58.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
31859650	31859650	PRJNA998413_S_NODE_13657_length_205_cov_3.302817_g13626_i0	PRJNA998413	13657	205	3.302817	6.77077485	Pseudarthrobacter sp. NPDC	1934409	Bacteria	Bacteria	55.8	5.23e-7	NR	WP_400609128.1	3364415	g13626	i0	69.7	1.50731707317073	33	10	48.3	0	3	101	637	669	WP_400609128.1 HNH endonuclease signature motif containing protein [Pseudarthrobacter sp. NPDC092424]	diamond	309	55.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Pseudarthrobacter	Pseudarthrobacter sp. NPDC092424
32530326	32530326	PRJNA998413_S_NODE_12619_length_211_cov_1.101351_g12588_i0	PRJNA998413	12619	211	1.101351	2.32385061	Bacillati	1783272	Bacteria	Bacteria	152	9.58e-44	NR	PYC99595.1	57043	g12588	i0	98.6	1.99052132701422	70	1	99.5	0	211	2	44	113	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	420	152	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
32562028	32562028	PRJNA998413_S_NODE_6039_length_259_cov_1.709184_g6008_i0	PRJNA998413	6039	259	1.709184	4.42678656	Bacillati	1783272	Bacteria	Bacteria	145	1.6799999999999994e-42	NR	PYC99569.1	57043	g6008	i0	98.6	1.69111969111969	73	1	84.6	0	220	2	1	73	PYC99569.1 hypothetical protein B4U78_016165, partial [Microbacterium esteraromaticum]	diamond	438	146	0.993150684931507	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum

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