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

5 rows where analysis = "diamond", bioproject = "PRJNA1174234" and tax_kingdom = "Thermotogati"

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
6694096	6694096	PRJNA1174234_P_NODE_33606_length_244_cov_0.900585_g33410_i0	PRJNA1174234	33606	244	0.900585	2.1974274	uncultured Truepera sp.	543023	Bacteria	Bacteria	153	2.73e-45	NR	CAA9552189.1	543023	g33410	i0	93.8	1.99180327868852	81	5	99.6	0	1	243	69	149	CAA9552189.1 MAG: LSU ribosomal protein L6p (L9e) [uncultured Truepera sp.]	diamond	486	153	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
11244224	11244224	PRJNA1174234_P_NODE_29209_length_251_cov_0.865169_g29013_i0	PRJNA1174234	29209	251	0.865169	2.17157419	uncultured Truepera sp.	543023	Bacteria	Bacteria	140	1.02e-36	NR	CAA9557446.1	543023	g29013	i0	84.3	0.99203187250996006	83	13	99.2	0	249	1	507	589	CAA9557446.1 MAG: Heterodimeric efflux ABC transporter, permease/ATP-binding subunit 1 [uncultured Truepera sp.]	diamond	249	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27040594	27040594	PRJNA1174234_P_NODE_31962_length_247_cov_0.867816_g31766_i0	PRJNA1174234	31962	247	0.867816	2.14350552	uncultured Truepera sp.	543023	Bacteria	Bacteria	164	4.279999999999999e-48	NR	CAA9581748.1	543023	g31766	i0	95.1	0.995951417004049	82	4	99.6	0	247	2	190	271	CAA9581748.1 MAG: Pyrimidine-specific ribonucleoside hydrolase RihB [uncultured Truepera sp.]	diamond	246	164	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
27597017	27597017	PRJNA1174234_P_NODE_17484_length_330_cov_0.898833_g17288_i0	PRJNA1174234	17484	330	0.898833	2.9661489	Bacteria	2	Bacteria	Bacteria	116	1.02e-27	NR	WP_081895104.1	1495039	g17288	i0	63	67.0181818181818	92	33	82.7	1	330	58	356	447	WP_081895104.1 molecular chaperone DnaK [Mesoaciditoga lauensis]	diamond	22116	117	0.991452991452991	Bacteria	Thermotogati	Thermotogota	Thermotogae	Mesoaciditogales	Mesoaciditogaceae	Mesoaciditoga	Mesoaciditoga lauensis
30135038	30135038	PRJNA1174234_P_NODE_33912_length_244_cov_0.894737_g33716_i0	PRJNA1174234	33912	244	0.894737	2.18315828	Synergistaceae bacterium	2053624	Bacteria	Bacteria	46.6	0.00164	NR	MBR2207957.1	2053624	g33716	i0	32.9	1.72131147540984	73	46	89.8	1	7	225	379	448	MBR2207957.1 ankyrin repeat domain-containing protein [Synergistaceae bacterium]	diamond	420	46.6	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae		Synergistaceae 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);;