metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA782551" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA782551" 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
21614730	21614730	PRJNA782551_P_NODE_24697_length_241_cov_0.916667_g24575_i0	PRJNA782551	24697	241	0.916667	2.20916747	Deinococcus	1298	Bacteria	Bacteria	107	6.99e-26	NR	WP_345467008.1	1211323	g24575	i0	88.1	2.93775933609959	59	7	73.4	0	1	177	271	329	WP_345467008.1 branched-chain amino acid ABC transporter permease [Deinococcus carri]	diamond	708	108	0.990740740740741	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus carri
26800368	26800368	PRJNA782551_P_NODE_15781_length_251_cov_0.865169_g15659_i0	PRJNA782551	15781	251	0.865169	2.17157419	Trueperaceae bacterium	2026798	Bacteria	Bacteria	145	7.62e-40	NR	MBA2668235.1	2026798	g15659	i0	81.9	1.9840637450199201	83	15	99.2	0	250	2	96	178	MBA2668235.1 hypothetical protein [Trueperaceae bacterium]	diamond	498	145	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
29800796	29800796	PRJNA782551_P_NODE_18071_length_249_cov_0.875000_g17949_i0	PRJNA782551	18071	249	0.875	2.17875	Deinococcus taklimakanensis	536443	Bacteria	Bacteria	160	1.01e-44	NR	WP_386843703.1	536443	g17949	i0	98.8	0.987951807228916	82	1	98.8	0	2	247	32	113	WP_386843703.1 sensor domain-containing diguanylate cyclase [Deinococcus taklimakanensis]	diamond	246	160	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taklimakanensis
30906886	30906886	PRJNA782551_P_NODE_15854_length_251_cov_0.865169_g15732_i0	PRJNA782551	15854	251	0.865169	2.17157419	Deinococcus sp. Arct2-2	2568653	Bacteria	Bacteria	117	1.23e-31	NR	WP_240740828.1	2568653	g15732	i0	82.9	1.66135458167331	70	12	83.7	0	251	42	57	126	WP_240740828.1 IS630 transposase-related protein [Deinococcus sp. Arct2-2]	diamond	417	117	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Arct2-2
31855186	31855186	PRJNA782551_P_NODE_19137_length_247_cov_0.885057_g19015_i0	PRJNA782551	19137	247	0.885057	2.18609079	Deinococcus sp. YIM 77859	1540221	Bacteria	Bacteria	85.1	6.47e-18	NR	WP_081908931.1	1540221	g19015	i0	50.6	3.89878542510121	81	39	98.4	1	245	3	144	223	WP_081908931.1 LexA family transcriptional regulator [Deinococcus sp. YIM 77859]	diamond	963	85.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. YIM 77859
31886819	31886819	PRJNA782551_P_NODE_11417_length_283_cov_1.466667_g11295_i0	PRJNA782551	11417	283	1.466667	4.15066761	Deinococcus murrayi	68910	Bacteria	Bacteria	179	3.2299999999999998e-52	NR	WP_169726671.1	68910	g11295	i0	97.9	0.996466431095406	94	2	99.6	0	283	2	269	362	WP_169726671.1 type IV secretory system conjugative DNA transfer family protein, partial [Deinococcus murrayi]	diamond	282	179	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus murrayi

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