metadata: contig_metadata: 11 rows where bioproject = "PRJNA782551" and tax

11 rows where 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
9692007	9692007	PRJNA782551_P_NODE_13208_length_269_cov_1.566327_g13086_i0	PRJNA782551	13208	269	1.566327	4.21341963	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	414	2.73e-111	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g13086	i0	94.424	163.189591078067	269	15	100	0	1	269	543461	543193	Deinococcus sp. NW-56 chromosome, complete genome	blastn	43898	414	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13517541	13517541	PRJNA782551_P_NODE_25051_length_241_cov_0.916667_g24929_i0	PRJNA782551	25051	241	0.916667	2.20916747	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2905214251\|gb\|CP179946.1\|	3385567	g24929	i0	99.17	2	241	2	100	0	1	241	361952	362192	Deinococcus sp. VB343 chromosome 2, complete sequence	blastn	482	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
19890519	19890519	PRJNA782551_P_NODE_20636_length_246_cov_0.890173_g20514_i0	PRJNA782551	20636	246	0.890173	2.18982558	Deinococcus grandis	57498	Bacteria	Bacteria	420	5.29e-113	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g20514	i0	97.551	25.109756097561	245	6	99	0	2	246	1747305	1747061	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	6177	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
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
21614815	21614815	PRJNA782551_P_NODE_7657_length_338_cov_0.879245_g7535_i0	PRJNA782551	7657	338	0.879245	2.9718481	Deinococcus	1298	Bacteria	Bacteria	569	7.119999999999998e-158	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g7535	i0	98.75	202.056213017751	320	4	98	0	19	338	424023	423704	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	68295	569	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24990129	24990129	PRJNA782551_P_NODE_18260_length_248_cov_1.348571_g18138_i0	PRJNA782551	18260	248	1.348571	3.34445608	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	292	1.21e-74	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g18138	i0	98.204	44.8064516129032	167	3	67	0	1	167	196504	196338	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	11112	292	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
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);;