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

14 rows where analysis = "diamond", bioproject = "PRJNA706190" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
15219659	15219659	PRJNA706190_P_NODE_92352_length_162_cov_0.920354_g92216_i0	PRJNA706190	92352	162	0.920354	1.49097348	uncultured Kocuria sp.	259305	Bacteria	Bacteria	99.4	1.47e-22	NR	WP_298585297.1	259305	g92216	i0	92.6	2	54	4	100	0	162	1	71	124	WP_298585297.1 helicase-related protein [uncultured Kocuria sp.]	diamond	324	99.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Kocuria	uncultured Kocuria sp.
28167967	28167967	PRJNA706190_P_NODE_92405_length_162_cov_0.920354_g92269_i0	PRJNA706190	92405	162	0.920354	1.49097348	Actinomyces	1654	Bacteria	Bacteria	110	1.7700000000000002e-26	NR	WP_314927001.1	249061	g92269	i0	100	3	54	0	100	0	162	1	185	238	WP_314927001.1 beta-ketoacyl synthase N-terminal-like domain-containing protein [uncultured Actinomyces sp.]	diamond	486	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Actinomyces	uncultured Actinomyces sp.
29041599	29041599	PRJNA706190_P_NODE_33868_length_185_cov_1.235294_g33732_i0	PRJNA706190	33868	185	1.235294	2.2852939	Actinomycetota bacterium	2900548	Bacteria	Bacteria	113	3.85e-30	NR	MFM1767291.1	2900548	g33732	i0	91.8	1.97837837837838	61	5	98.9	0	3	185	26	86	MFM1767291.1 hypothetical protein [Actinomycetota bacterium]	diamond	366	113	1	Bacteria		Bacillati	Actinomycetota					Actinomycetota bacterium
30083308	30083308	PRJNA706190_P_NODE_18932_length_209_cov_1.562500_g18796_i0	PRJNA706190	18932	209	1.5625	3.265625	Scrofimicrobium canadense	2652290	Bacteria	Bacteria	42.4	0.0287	NR	WP_154542979.1	2652290	g18796	i0	37	0.77511961722488	54	34	77.5	0	40	201	154	207	WP_154542979.1 hypothetical protein [Scrofimicrobium canadense]	diamond	162	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Scrofimicrobium	Scrofimicrobium canadense
30441779	30441779	PRJNA706190_P_NODE_17153_length_213_cov_2.268293_g17017_i0	PRJNA706190	17153	213	2.268293	4.83146409	Bacteria	2	Bacteria	Bacteria	62.8	1.86e-9	NR	MFN8104210.1	2080302	g17017	i0	50.8	2.61971830985915	61	30	85.9	0	207	25	135	195	MFN8104210.1 EthD domain-containing protein [Acidimicrobiia bacterium]	diamond	558	63.2	0.993670886075949	Bacteria		Bacillati	Actinomycetota	Acidimicrobiia				Acidimicrobiia bacterium
30557185	30557185	PRJNA706190_P_NODE_23233_length_201_cov_1.026316_g23097_i0	PRJNA706190	23233	201	1.026316	2.06289516	Renibacterium sp.	1914289	Bacteria	Bacteria	89.4	8.17e-19	NR	MBQ1443515.1	1914289	g23097	i0	97.7	0.641791044776119	43	1	64.2	0	160	32	1	43	MBQ1443515.1 RHS repeat-associated core domain-containing protein [Renibacterium sp.]	diamond	129	89.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Renibacterium	Renibacterium sp.
30725940	30725940	PRJNA706190_P_NODE_6654_length_259_cov_1.014286_g6518_i0	PRJNA706190	6654	259	1.014286	2.62700074	Lawsonella	1847725	Bacteria	Bacteria	171	2.6399999999999993e-52	NR	PZP88504.1	1528099	g6518	i0	100	2.95366795366795	85	0	98.5	0	259	5	62	146	PZP88504.1 MAG: nucleotide exchange factor GrpE [Lawsonella clevelandensis]	diamond	765	171	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
30999828	30999828	PRJNA706190_P_NODE_56274_length_168_cov_0.873950_g56138_i0	PRJNA706190	56274	168	0.87395	1.468236	Streptomyces sp. AS58	1519489	Bacteria	Bacteria	40.4	0.0159	NR	KOV65627.1	1519489	g56138	i0	60	0.535714285714286	30	9	53.6	1	109	20	8	34	KOV65627.1 hypothetical protein ADL00_18660 [Streptomyces sp. AS58]	diamond	90	40.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. AS58
31326383	31326383	PRJNA706190_P_NODE_76095_length_165_cov_0.896552_g75959_i0	PRJNA706190	76095	165	0.896552	1.4793108	Aquiluna	529881	Bacteria	Bacteria	108	2.6600000000000003e-27	NR	MCF8524233.1	2053504	g75959	i0	94.3	3.90909090909091	53	3	96.4	0	163	5	177	229	MCF8524233.1 SDR family NAD(P)-dependent oxidoreductase [Aquiluna sp.]	diamond	645	108	1	Bacteria	Luna-1 subcluster	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Aquiluna	Aquiluna sp.
31474111	31474111	PRJNA706190_P_NODE_19956_length_207_cov_1.278481_g19820_i0	PRJNA706190	19956	207	1.278481	2.64645567	Lawsonella clevelandensis	1528099	Bacteria	Bacteria	68.2	2.47e-11	NR	WP_304136003.1	1528099	g19820	i0	96.8	0.91304347826087	63	2	91.3	0	17	205	519	581	WP_304136003.1 MDR family MFS transporter [Lawsonella clevelandensis]	diamond	189	68.2	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Lawsonellaceae	Lawsonella	Lawsonella clevelandensis
31695368	31695368	PRJNA706190_P_NODE_87617_length_163_cov_0.912281_g87481_i0	PRJNA706190	87617	163	0.912281	1.48701803	uncultured Rothia sp.	316088	Bacteria	Bacteria	110	2.41e-26	NR	WP_294454753.1	316088	g87481	i0	98.1	0.993865030674847	54	1	99.4	0	1	162	716	769	WP_294454753.1 phenylalanine--tRNA ligase subunit beta [uncultured Rothia sp.]	diamond	162	110	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Rothia	uncultured Rothia sp.
31737455	31737455	PRJNA706190_P_NODE_70197_length_166_cov_0.888889_g70061_i0	PRJNA706190	70197	166	0.888889	1.47555574	root	1	Root_unresolved	Root_unresolved	47.8	2.28e-5	NR	MES6300508.1	1747	g70061	i0	54.3	12.0361445783133	35	15	61.4	1	17	118	19	53	MES6300508.1 hypothetical protein [Cutibacterium acnes]	diamond	1998	47.8	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium acnes
32549880	32549880	PRJNA706190_P_NODE_87479_length_163_cov_0.912281_g87343_i0	PRJNA706190	87479	163	0.912281	1.48701803	Eggerthella lenta	84112	Bacteria	Bacteria	100	7.96e-24	NR	WP_233946983.1	84112	g87343	i0	92.5	0.975460122699387	53	4	97.5	0	3	161	283	335	WP_233946983.1 DNA polymerase, partial [Eggerthella lenta]	diamond	159	100	1	Bacteria		Bacillati	Actinomycetota	Coriobacteriia	Eggerthellales	Eggerthellaceae	Eggerthella	Eggerthella lenta
32643868	32643868	PRJNA706190_P_NODE_57000_length_168_cov_0.873950_g56864_i0	PRJNA706190	57000	168	0.87395	1.468236	Mycolicibacterium mucogenicum	56689	Bacteria	Bacteria	95.5	3.3100000000000003e-21	NR	WP_234785548.1	56689	g56864	i0	90.7	0.964285714285714	54	5	96.4	0	162	1	74	127	WP_234785548.1 hypothetical protein, partial [Mycolicibacterium mucogenicum]	diamond	162	95.5	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium mucogenicum

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