metadata: contig_metadata: 10 rows where bioproject = "PRJNA859990" and tax

10 rows where bioproject = "PRJNA859990" and tax_phylum = "Deinococcota"

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
845968	845968	PRJNA859990_S_NODE_7701_length_360_cov_0.919861_g7440_i0	PRJNA859990	7701	360	0.919861	3.3114996	Deinococcus ficus	317577	Bacteria	Bacteria	608	1.609999999999999e-169	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g7440	i0	97.214	192.383333333333	359	10	99	0	1	359	2341435	2341793	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	69258	608	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
1236199	1236199	PRJNA859990_S_NODE_5221_length_427_cov_1.177966_g4960_i0	PRJNA859990	5221	427	1.177966	5.02991482	Deinococcus	1298	Bacteria	Bacteria	383	1.2899999999999998e-101	NTclustered	gi\|470487735\|ref\|NR_076834.1\|	309887	g4960	i0	83.693	190.983606557377	417	57	97	6	11	425	390	797	Deinococcus maricopensis strain LB-34 23S ribosomal RNA gene, complete sequence	blastn	81550	383	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
2121308	2121308	PRJNA859990_S_NODE_19002_length_248_cov_0.880000_g18741_i0	PRJNA859990	19002	248	0.88	2.1824	Deinococcus sp. VB142	3112952	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g18741	i0	99.194	3	248	2	100	0	1	248	525062	524815	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	744	448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
2121442	2121442	PRJNA859990_S_NODE_9902_length_322_cov_1.405622_g9641_i0	PRJNA859990	9902	322	1.405622	4.52610284	Deinococcus sp.	47478	Bacteria	Bacteria	462	1.18e-125	NTclustered	gi\|2498163271\|gb\|OQ891522.1\|	47478	g9641	i0	92.79	106.993788819876	319	23	99	0	1	319	838	520	Deinococcus sp. strain SCM215 16S ribosomal RNA gene, partial sequence	blastn	34452	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
7614132	7614132	PRJNA859990_S_NODE_20166_length_245_cov_1.180233_g19905_i0	PRJNA859990	20166	245	1.180233	2.89157085	Deinococcus	1298	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1735477873\|gb\|CP031501.1\|	1299	g19905	i0	100	204.718367346939	245	0	100	0	1	245	320769	320525	Deinococcus radiodurans strain R1 dM1 chromosome II, complete sequence	blastn	50156	453	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
9773943	9773943	PRJNA859990_S_NODE_18988_length_248_cov_0.891429_g18727_i0	PRJNA859990	18988	248	0.891429	2.21074392	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	331	2.57e-86	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g18727	i0	90.588	201.125	255	17	100	6	1	248	1427878	1428132	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	49879	331	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
13989842	13989842	PRJNA859990_S_NODE_12211_length_295_cov_0.945946_g11950_i0	PRJNA859990	12211	295	0.945946	2.7905407	Truepera	332248	Bacteria	Bacteria	427	3.8899999999999996e-115	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g11950	i0	93.706	832.752542372881	286	17	97	1	10	295	2931	2647	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	245662	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
17813650	17813650	PRJNA859990_S_NODE_4454_length_456_cov_2.451697_g4193_i0	PRJNA859990	4454	456	2.451697	11.17973832	Truepera	332248	Bacteria	Bacteria	560	5.94e-155	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g4193	i0	88.84	311.640350877193	457	49	100	2	1	456	485	30	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	142108	560	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
22913825	22913825	PRJNA859990_S_NODE_21378_length_243_cov_0.858824_g21117_i0	PRJNA859990	21378	243	0.858824	2.08694232	Deinococcus sp. Arct2-2	2568653	Bacteria	Bacteria	98.6	1.98e-22	NR	WP_136365375.1	2568653	g21117	i0	59.3	1	81	33	100	0	1	243	225	305	WP_136365375.1 sensor histidine kinase [Deinococcus sp. Arct2-2]	diamond	243	98.6	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. Arct2-2
23798096	23798096	PRJNA859990_S_NODE_19199_length_247_cov_2.413793_g18938_i0	PRJNA859990	19199	247	2.413793	5.96206871	Deinococcota bacterium DY0809b	3396280	Bacteria	Bacteria	204	5.819999999999998e-48	NTclustered	gi\|2904223141\|gb\|CP179936.1\|	3396280	g18938	i0	86.957	95.2955465587045	184	20	74	4	66	247	2006572	2006391	Deinococcota bacterium DY0809b chromosome, complete genome	blastn	23538	204	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium DY0809b

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