metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA562549" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA562549" 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
1821468	1821468	PRJNA562549_P_NODE_32662_length_209_cov_0.878378_g32429_i0	PRJNA562549	32662	209	0.878378	1.83581002	Actinomycetota bacterium	2900548	Bacteria	Bacteria	117	1.7000000000000003e-28	NR	MBS1889877.1	2900548	g32429	i0	76.8	0.990430622009569	69	16	99	0	208	2	240	308	MBS1889877.1 hypothetical protein [Actinomycetota bacterium]	diamond	207	117	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
22222851	22222851	PRJNA562549_P_NODE_32638_length_209_cov_0.878378_g32405_i0	PRJNA562549	32638	209	0.878378	1.83581002	Bacteria	2	Bacteria	Bacteria	106	1.18e-25	NR	WP_123304045.1	56055	g32405	i0	69.6	3.96172248803828	69	21	99	0	209	3	133	201	WP_123304045.1 malate dehydrogenase [Bogoriella caseilytica]	diamond	828	106	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Bogoriellaceae	Bogoriella	Bogoriella caseilytica
27079158	27079158	PRJNA562549_P_NODE_31122_length_212_cov_0.993377_g30889_i0	PRJNA562549	31122	212	0.993377	2.10595924	Actinomycetota bacterium	2900548	Bacteria	Bacteria	44.7	0.00514	NR	MDQ1548034.1	2900548	g30889	i0	43.1	1.42924528301887	51	28	72.2	1	50	202	23	72	MDQ1548034.1 hypothetical protein [Actinomycetota bacterium]	diamond	303	44.7	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
27110564	27110564	PRJNA562549_P_NODE_24222_length_238_cov_1.819209_g23989_i0	PRJNA562549	24222	238	1.819209	4.32971742	Luedemannella flava	349316	Bacteria	Bacteria	43.9	0.00426	NR	MFC7480816.1	349316	g23989	i0	34.7	1.81512605042017	72	39	90.8	2	237	22	28	91	MFC7480816.1 hypothetical protein [Luedemannella flava]	diamond	432	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae	Luedemannella	Luedemannella flava
28310980	28310980	PRJNA562549_P_NODE_33886_length_207_cov_0.890411_g33653_i0	PRJNA562549	33886	207	0.890411	1.84315077	Propioniciclava sp.	2038686	Bacteria	Bacteria	68.9	1.37e-11	NR	WP_415103230.1	2038686	g33653	i0	58.5	0.942028985507246	65	24	94.2	2	1	195	491	552	WP_415103230.1 S-layer homology domain-containing protein [Propioniciclava sp.]	diamond	195	68.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Propioniciclava	Propioniciclava sp.
29068785	29068785	PRJNA562549_P_NODE_12588_length_323_cov_2.347328_g12355_i0	PRJNA562549	12588	323	2.347328	7.58186944	Amycolatopsis sp. lyj-23	2789283	Bacteria	Bacteria	45.1	0.0134	NR	WP_410591092.1	2789283	g12355	i0	38.3	0.891640866873065	47	29	43.7	0	250	110	81	127	WP_410591092.1 hypothetical protein [Amycolatopsis sp. lyj-23]	diamond	288	45.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Amycolatopsis	Amycolatopsis sp. lyj-23
29226782	29226782	PRJNA562549_P_NODE_35929_length_203_cov_0.915493_g35696_i0	PRJNA562549	35929	203	0.915493	1.85845079	Actinomycetota bacterium	2900548	Bacteria	Bacteria	115	7.419999999999999e-31	NR	MBS1889790.1	2900548	g35696	i0	83.1	0.960591133004926	65	11	96.1	0	203	9	97	161	MBS1889790.1 MC/SLC25 family protein [Actinomycetota bacterium]	diamond	195	115	1	Bacteria	Bacillati	Actinomycetota					Actinomycetota bacterium
29763142	29763142	PRJNA562549_P_NODE_34551_length_205_cov_2.277778_g34318_i0	PRJNA562549	34551	205	2.277778	4.6694449	Streptosporangium roseum	2001	Bacteria	Bacteria	42	0.0297	NR	WP_352036708.1	2001	g34318	i0	48.4	0.453658536585366	31	16	45.4	0	188	96	114	144	WP_352036708.1 hypothetical protein [Streptosporangium roseum]	diamond	93	42	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Streptosporangiales	Streptosporangiaceae	Streptosporangium	Streptosporangium roseum
31090161	31090161	PRJNA562549_P_NODE_15455_length_293_cov_1.607759_g15222_i0	PRJNA562549	15455	293	1.607759	4.71073387	Leucobacter sp. PH1c	1397278	Bacteria	Bacteria	62.8	6.16e-9	NR	WP_025134996.1	1397278	g15222	i0	39	0.839590443686007	82	47	80.9	2	260	24	400	481	WP_025134996.1 hypothetical protein [Leucobacter sp. PH1c]	diamond	246	62.8	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leucobacter	Leucobacter sp. PH1c
31501464	31501464	PRJNA562549_P_NODE_33816_length_207_cov_0.890411_g33583_i0	PRJNA562549	33816	207	0.890411	1.84315077	Ilumatobacteraceae bacterium	2497619	Bacteria	Bacteria	128	1.18e-33	NR	MBJ7460789.1	2497619	g33583	i0	98.5	0.985507246376812	68	1	98.6	0	3	206	209	276	MBJ7460789.1 ABC transporter substrate-binding protein [Ilumatobacteraceae bacterium]	diamond	204	128	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales	Ilumatobacteraceae		Ilumatobacteraceae bacterium
32387078	32387078	PRJNA562549_P_NODE_32119_length_210_cov_0.872483_g31886_i0	PRJNA562549	32119	210	0.872483	1.8322143	Cutibacterium granulosum	33011	Bacteria	Bacteria	118	1.38e-32	NR	PZP18157.1	33011	g31886	i0	98.2	0.814285714285714	57	1	81.4	0	39	209	1	57	PZP18157.1 MAG: hypothetical protein DI600_09895 [Cutibacterium granulosum]	diamond	171	118	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Propionibacteriaceae	Cutibacterium	Cutibacterium granulosum

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