metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA658591" 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
27555107	27555107	PRJNA658591_S_NODE_5764_length_197_cov_1.108108_g5701_i0	PRJNA658591	5764	197	1.108108	2.18297276	Leifsonia sp. Leaf264	1736314	Bacteria	Bacteria	44.3	0.0059	NR	WP_055905398.1	1736314	g5701	i0	38.5	0.989847715736041	65	35	99	1	1	195	191	250	WP_055905398.1 hypothetical protein [Leifsonia sp. Leaf264]	diamond	195	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Leifsonia	Leifsonia sp. Leaf264
28186560	28186560	PRJNA658591_S_NODE_6246_length_191_cov_1.077465_g6183_i0	PRJNA658591	6246	191	1.077465	2.05795815	Actinotalea sp. JY-7885	2758576	Bacteria	Bacteria	42.4	0.0255	NR	WP_188037768.1	2758576	g6183	i0	41.8	0.863874345549738	55	27	81.7	3	35	190	196	248	WP_188037768.1 hypothetical protein, partial [Actinotalea sp. JY-7885]	diamond	165	42.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Cellulomonadaceae	Actinotalea	Actinotalea sp. JY-7885
29291845	29291845	PRJNA658591_S_NODE_6529_length_188_cov_1.122302_g6466_i0	PRJNA658591	6529	188	1.122302	2.10992776	Actinocrispum sp. NPDC	1891916	Bacteria	Bacteria	60.5	9.95e-9	NR	WP_364762316.1	3154835	g6466	i0	60.7	0.893617021276596	56	22	89.4	0	184	17	414	469	WP_364762316.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Actinocrispum sp. NPDC049592]	diamond	168	60.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Pseudonocardiales	Pseudonocardiaceae	Actinocrispum	Actinocrispum sp. NPDC049592
29904145	29904145	PRJNA658591_S_NODE_4191_length_221_cov_3.720930_g4128_i0	PRJNA658591	4191	221	3.72093	8.2232553	Micrococcales	85006	Bacteria	Bacteria	66.2	1.23e-10	NR	WP_307102463.1	1665	g4128	i0	62.5	4.6289592760181	48	18	65.2	0	78	221	3	50	WP_307102463.1 NAD(P)-dependent alcohol dehydrogenase [Arthrobacter globiformis]	diamond	1023	66.6	0.993993993993994	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Micrococcaceae	Arthrobacter	Arthrobacter globiformis
30851831	30851831	PRJNA658591_S_NODE_2474_length_272_cov_1.488789_g2411_i0	PRJNA658591	2474	272	1.488789	4.04950608	Bacteria	2	Bacteria	Bacteria	91.3	4.58e-19	NR	HEY3021937.1	2586742	g2411	i0	47.6	3.68382352941176	84	44	92.6	0	21	272	575	658	HEY3021937.1 hypothetical protein [Solirubrobacteraceae bacterium]	diamond	1002	91.7	0.995637949836423	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae 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);;