metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1192965" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1192965" 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
13074111	13074111	PRJNA1192965_P_NODE_4191_length_246_cov_0.890173_g4172_i0	PRJNA1192965	4191	246	0.890173	2.18982558	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	111	1.3500000000000002e-26	NR	MEA2126612.1	2586742	g4172	i0	76.3	1.96341463414634	80	19	97.6	0	242	3	29	108	MEA2126612.1 phospholipid/cholesterol/gamma-HCH transport system substrate-binding protein [Solirubrobacteraceae bacterium]	diamond	483	111	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
16897632	16897632	PRJNA1192965_P_NODE_3774_length_249_cov_0.875000_g3755_i0	PRJNA1192965	3774	249	0.875	2.17875	Humibacter sp.	1940291	Bacteria	Bacteria	79	7.14e-15	NR	HWU47516.1	1940291	g3755	i0	87.8	0.493975903614458	41	5	49.4	0	126	248	685	725	HWU47516.1 ATP-dependent DNA helicase [Humibacter sp.]	diamond	123	79	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micrococcales	Microbacteriaceae	Humibacter	Humibacter sp.
26629176	26629176	PRJNA1192965_P_NODE_2941_length_261_cov_1.638298_g2922_i0	PRJNA1192965	2941	261	1.638298	4.27595778	Streptomyces akebiae	2865673	Bacteria	Bacteria	41.6	0.0458	NR	WP_220644572.1	2865673	g2922	i0	35.8	0.609195402298851	53	30	56.3	1	38	184	55	107	WP_220644572.1 hypothetical protein [Streptomyces akebiae]	diamond	159	41.6	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Kitasatosporales	Streptomycetaceae	Streptomyces	Streptomyces akebiae
28903772	28903772	PRJNA1192965_P_NODE_5128_length_241_cov_0.916667_g5109_i0	PRJNA1192965	5128	241	0.916667	2.20916747	Solirubrobacteraceae bacterium	2586742	Bacteria	Bacteria	49.3	1.68e-4	NR	MEO8688348.1	2586742	g5109	i0	55.1	3.23651452282158	49	21	61	1	241	95	110	157	MEO8688348.1 universal stress protein [Solirubrobacteraceae bacterium]	diamond	780	49.3	1	Bacteria	Bacillati	Actinomycetota	Thermoleophilia	Solirubrobacterales	Solirubrobacteraceae		Solirubrobacteraceae bacterium
29724643	29724643	PRJNA1192965_P_NODE_5090_length_241_cov_0.916667_g5071_i0	PRJNA1192965	5090	241	0.916667	2.20916747	Trueperella pyogenes	1661	Bacteria	Bacteria	142	1.53e-40	NR	WP_048712052.1	1661	g5071	i0	97.4	1.91701244813278	77	2	95.9	0	10	240	1	77	WP_048712052.1 metal-dependent transcriptional regulator [Trueperella pyogenes]	diamond	462	142	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Actinomycetales	Actinomycetaceae	Trueperella	Trueperella pyogenes
31052099	31052099	PRJNA1192965_P_NODE_3655_length_249_cov_0.875000_g3636_i0	PRJNA1192965	3655	249	0.875	2.17875	Micromonosporaceae bacterium	1873464	Bacteria	Bacteria	44.3	0.0115	NR	MBX6748373.1	1873464	g3636	i0	44.2	0.518072289156627	43	24	51.8	0	23	151	127	169	MBX6748373.1 ABC transporter permease [Micromonosporaceae bacterium]	diamond	129	44.3	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Micromonosporales	Micromonosporaceae		Micromonosporaceae bacterium
32317321	32317321	PRJNA1192965_P_NODE_1759_length_315_cov_1.037190_g1740_i0	PRJNA1192965	1759	315	1.03719	3.2671485	Mycolicibacterium austroafricanum	39687	Bacteria	Bacteria	43.9	0.0319	NR	WP_222879370.1	39687	g1740	i0	41	0.580952380952381	61	36	58.1	0	279	97	187	247	WP_222879370.1 YgfZ/GcvT domain-containing protein [Mycolicibacterium austroafricanum]	diamond	183	43.9	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Mycobacteriaceae	Mycolicibacterium	Mycolicibacterium austroafricanum
32348885	32348885	PRJNA1192965_P_NODE_4319_length_245_cov_0.895349_g4300_i0	PRJNA1192965	4319	245	0.895349	2.19360505	Prescottella equi	43767	Bacteria	Bacteria	50.4	4.08e-5	NR	WP_084869264.1	43767	g4300	i0	55	0.489795918367347	40	17	49	1	2	121	157	195	WP_084869264.1 head-tail connector protein [Prescottella equi]	diamond	120	50.4	1	Bacteria	Bacillati	Actinomycetota	Actinomycetes	Mycobacteriales	Nocardiaceae	Prescottella	Prescottella equi

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