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

5 rows where analysis = "diamond", bioproject = "PRJNA1136957" 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
26721759	26721759	PRJNA1136957_S_NODE_15341_length_222_cov_1.460123_g15244_i0	PRJNA1136957	15341	222	1.460123	3.24147306	unclassified Streptomyces	2593676	Bacteria	Bacteria	43.1	0.02	NR	WP_241842784.1	2593676	g15244	i0	46.9	0.662162162162162	49	24	63.5	1	199	59	26	74	WP_241842784.1 MULTISPECIES: hypothetical protein [unclassified Streptomyces]	diamond	147	43.1	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces
29438374	29438374	PRJNA1136957_S_NODE_20350_length_195_cov_0.897059_g20253_i0	PRJNA1136957	20350	195	0.897059	1.74926505	Kitasatospora indigofera	67307	Bacteria	Bacteria	44.7	0.0042	NR	WP_355657059.1	67307	g20253	i0	33.3	0.969230769230769	63	41	96.9	1	7	195	49	110	WP_355657059.1 acyl-CoA thioesterase/bile acid-CoA:amino acid N-acyltransferase family protein [Kitasatospora indigofera]	diamond	189	44.7	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Kitasatospora	Kitasatospora indigofera
29881018	29881018	PRJNA1136957_S_NODE_2671_length_436_cov_2.442971_g2574_i0	PRJNA1136957	2671	436	2.442971	10.65135356	Streptomyces sp. Rer75	2750011	Bacteria	Bacteria	43.5	0.0313	NR	QLH27388.1	2750011	g2574	i0	42.1	0.784403669724771	57	31	37.8	1	281	117	53	109	QLH27388.1 MFS transporter [Streptomyces sp. Rer75]	diamond	342	43.5	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces sp. Rer75
31418225	31418225	PRJNA1136957_S_NODE_13516_length_235_cov_1.039773_g13419_i0	PRJNA1136957	13516	235	1.039773	2.44346655	Streptomyces	1883	Bacteria	Bacteria	80.5	1.72e-15	NR	WP_250402383.1	67285	g13419	i0	52.9	5.47659574468085	70	33	89.4	0	1	210	628	697	WP_250402383.1 neutral/alkaline ceramidase [Streptomyces cellostaticus]	diamond	1287	81.3	0.990159901599016	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces cellostaticus
31461085	31461085	PRJNA1136957_S_NODE_8916_length_283_cov_1.691964_g8819_i0	PRJNA1136957	8916	283	1.691964	4.78825812	Acidimicrobiales bacterium	2201156	Bacteria	Bacteria	62.8	1.72e-9	NR	MET0160153.1	2201156	g8819	i0	56.5	0.657243816254417	62	20	65.7	1	282	97	129	183	MET0160153.1 oligoribonuclease [Acidimicrobiales bacterium]	diamond	186	62.8	1	Bacteria	Bacillati	Actinomycetota	Acidimicrobiia	Acidimicrobiales			Acidimicrobiales 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);;