metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA663960" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA663960" 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
10090637	10090637	PRJNA663960_S_NODE_23168_length_249_cov_7.089109_g22932_i0	PRJNA663960	23168	249	7.089109	17.65188141	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	139	1.05e-39	NR	PYC99494.1	57043	g22932	i0	90.7	0.903614457831325	75	7	90.4	0	248	24	68	142	PYC99494.1 hypothetical protein B4U78_016800, partial [Microbacterium esteraromaticum]	diamond	225	139	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
18480957	18480957	PRJNA663960_S_NODE_14455_length_298_cov_4.717131_g14219_i0	PRJNA663960	14455	298	4.717131	14.05705038	Microbacterium esteraromaticum	57043	Bacteria	Bacteria	96.7	5.229999999999999e-23	NR	PYC99569.1	57043	g14219	i0	89.1	0.644295302013423	64	7	64.4	0	1	192	80	143	PYC99569.1 hypothetical protein B4U78_016165, partial [Microbacterium esteraromaticum]	diamond	192	96.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
27112901	27112901	PRJNA663960_S_NODE_38142_length_197_cov_1.760000_g37906_i0	PRJNA663960	38142	197	1.76	3.4672	Streptomyces erythrochromogenes	285574	Bacteria	Bacteria	43.1	0.00818	NR	WP_381818666.1	285574	g37906	i0	66.7	0.456852791878173	30	8	42.6	1	1	84	45	74	WP_381818666.1 hypothetical protein [Streptomyces erythrochromogenes]	diamond	90	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces erythrochromogenes
28060517	28060517	PRJNA663960_S_NODE_19605_length_267_cov_3.368182_g19369_i0	PRJNA663960	19605	267	3.368182	8.99304594	Streptomyces sp. YIM B135	1931	Bacteria	Bacteria	43.5	0.0264	NR	WP_385997778.1	3366315	g19369	i0	36.1	0.685393258426966	61	36	65.2	1	60	233	104	164	WP_385997778.1 SpoIIE family protein phosphatase [Streptomyces sp. YIM B13508]	diamond	183	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. YIM B13508
28325223	28325223	PRJNA663960_S_NODE_8986_length_344_cov_4.932660_g8750_i0	PRJNA663960	8986	344	4.93266	16.9683504	Bacillati	1783272	Bacteria	Bacteria	237	2.22e-76	NR	PYC99595.1	57043	g8750	i0	99.1	1.98837209302326	114	1	99.4	0	2	343	20	133	PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum]	diamond	684	237	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Microbacterium	Microbacterium esteraromaticum
28502639	28502639	PRJNA663960_S_NODE_44167_length_183_cov_1.500000_g43931_i0	PRJNA663960	44167	183	1.5	2.745	Cutibacterium acnes	1747	Bacteria	Bacteria	49.3	7.96e-5	NR	MES6783892.1	1747	g43931	i0	48.1	0.852459016393443	52	14	85.2	1	163	8	32	70	MES6783892.1 reverse transcriptase family protein [Cutibacterium acnes]	diamond	156	49.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
29335713	29335713	PRJNA663960_S_NODE_7889_length_357_cov_7.290323_g7653_i0	PRJNA663960	7889	357	7.290323	26.02645311	root	1	Root_unresolved	Root_unresolved	44.7	0.0122	NR	MES9247268.1	1747	g7653	i0	50	2.85714285714286	48	23	39.5	1	214	354	64	111	MES9247268.1 hypothetical protein [Cutibacterium acnes]	diamond	1020	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
30788707	30788707	PRJNA663960_S_NODE_26314_length_236_cov_1.079365_g26078_i0	PRJNA663960	26314	236	1.079365	2.5473014	Actinomycetes	1760	Bacteria	Bacteria	43.5	0.0175	NR	WP_041624888.1	283811	g26078	i0	38.5	2.46610169491525	65	35	82.6	2	16	210	158	217	WP_041624888.1 DUF4185 domain-containing protein [Stackebrandtia nassauensis]	diamond	582	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Glycomycetales	Glycomycetaceae	Stackebrandtia	Stackebrandtia nassauensis
31230866	31230866	PRJNA663960_S_NODE_30135_length_221_cov_1.925287_g29899_i0	PRJNA663960	30135	221	1.925287	4.25488427	root	1	Root_unresolved	Root_unresolved	44.7	6.18e-4	NR	WP_219926459.1	1717	g29899	i0	55.3	1.0316742081448	38	17	51.6	0	114	1	19	56	WP_219926459.1 hypothetical protein, partial [Corynebacterium diphtheriae]	diamond	228	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium	Corynebacterium diphtheriae
31345509	31345509	PRJNA663960_S_NODE_39836_length_193_cov_1.397260_g39600_i0	PRJNA663960	39836	193	1.39726	2.6967118	Streptomyces sp. CB	1931	Bacteria	Bacteria	41.2	0.0465	NR	WP_073764522.1	1718985	g39600	i0	45.9	0.575129533678757	37	20	57.5	0	2	112	37	73	WP_073764522.1 winged helix-turn-helix domain-containing protein [Streptomyces sp. CB02923]	diamond	111	41.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. CB02923
31914746	31914746	PRJNA663960_S_NODE_10937_length_325_cov_3.643885_g10701_i0	PRJNA663960	10937	325	3.643885	11.84262625	Cutibacterium acnes	1747	Bacteria	Bacteria	46.2	0.00103	NR	MES9282514.1	1747	g10701	i0	63.9	0.664615384615385	36	13	33.2	0	302	195	49	84	MES9282514.1 hypothetical protein [Cutibacterium acnes]	diamond	216	46.2	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32136348	32136348	PRJNA663960_S_NODE_11818_length_318_cov_3.306273_g11582_i0	PRJNA663960	11818	318	3.306273	10.51394814	Corynebacterium	1716	Bacteria	Bacteria	43.9	0.0342	NR	WP_151843084.1	1716	g11582	i0	33.3	0.509433962264151	54	36	50.9	0	10	171	3	56	WP_151843084.1 MULTISPECIES: UDP-N-acetylmuramate--L-alanine ligase [Corynebacterium]	diamond	162	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Corynebacteriaceae	Corynebacterium
32452940	32452940	PRJNA663960_S_NODE_19439_length_268_cov_2.751131_g19203_i0	PRJNA663960	19439	268	2.751131	7.37303108	Microbacteriaceae bacterium	1873462	Bacteria	Bacteria	43.1	0.0363	NR	NBQ98386.1	1873462	g19203	i0	53.7	0.458955223880597	41	19	45.9	0	246	124	81	121	NBQ98386.1 hypothetical protein [Microbacteriaceae bacterium]	diamond	123	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae		Microbacteriaceae bacterium
32893888	32893888	PRJNA663960_S_NODE_47420_length_176_cov_1.581395_g47184_i0	PRJNA663960	47420	176	1.581395	2.7832552	Propionibacteriaceae bacterium	2021380	Bacteria	Bacteria	42	0.0283	NR	HBX82628.1	2021380	g47184	i0	50	0.920454545454545	54	25	90.3	2	168	10	316	368	HBX82628.1 DNA-binding protein [Propionibacteriaceae bacterium]	diamond	162	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae		Propionibacteriaceae bacterium

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