metadata: contig_metadata: 18 rows where bioproject = "PRJNA1063685" and tax

18 rows where bioproject = "PRJNA1063685" 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
179596	179596	PRJNA1063685_S_NODE_34101_length_402_cov_1.863222_g33559_i0	PRJNA1063685	34101	402	1.863222	7.49015244	Deinococcus taeanensis	2737050	Bacteria	Bacteria	586	8.539999999999997e-163	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g33559	i0	93.052	194.228855721393	403	24	100	3	1	402	1470	1869	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	78080	586	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
4006182	4006182	PRJNA1063685_S_NODE_55544_length_296_cov_2.417040_g55001_i0	PRJNA1063685	55544	296	2.41704	7.1544384	Deinococcus ficus	317577	Bacteria	Bacteria	335	2.44e-87	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g55001	i0	88.38	163.885135135135	284	26	95	7	1	280	2343016	2342736	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	48510	335	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
5282355	5282355	PRJNA1063685_S_NODE_36525_length_387_cov_4.614650_g35982_i0	PRJNA1063685	36525	387	4.61465	17.8586955	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	342	1.96e-89	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g35982	i0	84.615	90.1653746770026	364	34	95	15	1	358	68268	68615	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	34894	342	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
5282496	5282496	PRJNA1063685_S_NODE_51385_length_313_cov_2.312500_g50842_i0	PRJNA1063685	51385	313	2.3125	7.238125	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	361	4.28e-95	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g50842	i0	88.449	1.93610223642173	303	30	96	3	12	313	2726524	2726226	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	606	361	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6557305	6557305	PRJNA1063685_S_NODE_16986_length_540_cov_3.019272_g16454_i0	PRJNA1063685	16986	540	3.019272	16.3040688	Trueperaceae bacterium	2026798	Bacteria	Bacteria	669	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g16454	i0	89.031	429.888888888889	547	51	99	5	1	538	8121	7575	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	232140	669	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
10382680	10382680	PRJNA1063685_S_NODE_17789_length_531_cov_38.733624_g17253_i0	PRJNA1063685	17789	531	38.733624	205.67554344	Deinococcus gobiensis	502394	Bacteria	Bacteria	928	0	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g17253	i0	99.606	193.551789077213	508	2	96	0	24	531	109591	110098	Deinococcus gobiensis I-0, complete genome	blastn	102776	928	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
10382962	10382962	PRJNA1063685_S_NODE_4769_length_740_cov_7.019490_g4343_i0	PRJNA1063685	4769	740	7.01949	51.944226	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	684	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g4343	i0	95.592	170.885135135135	431	11	100	7	1	428	543538	543113	Deinococcus sp. NW-56 chromosome, complete genome	blastn	126455	684	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
11215611	11215611	PRJNA1063685_S_NODE_829_length_1181_cov_22.564079_g8_i16	PRJNA1063685	829	1181	22.564079	266.48177299	Deinococcus	1298	Bacteria	Bacteria	1537	0	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g8	i16	90.722	411.920406435224	1164	93	98	14	24	1181	1	1155	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	486478	1548	0.992894056847545	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
11658028	11658028	PRJNA1063685_S_NODE_25030_length_466_cov_2.743003_g24490_i0	PRJNA1063685	25030	466	2.743003	12.78239398	uncultured Deinococcus sp.	158789	Bacteria	Bacteria	789	0	NTclustered	gi\|164453680\|gb\|EU341287.1\|	158789	g24490	i0	100	89.5343347639485	427	0	92	0	20	446	427	1	Uncultured Deinococcus sp. clone AV_8R-S-F11 16S ribosomal RNA gene, partial sequence	blastn	41723	789	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
18031390	18031390	PRJNA1063685_S_NODE_50395_length_317_cov_5.348361_g49852_i0	PRJNA1063685	50395	317	5.348361	16.95430437	Trueperaceae bacterium	2026798	Bacteria	Bacteria	396	1.1899999999999997e-105	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g49852	i0	92.701	424.195583596215	274	20	86	0	21	294	3599936	3599663	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	134470	396	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
18031438	18031438	PRJNA1063685_S_NODE_55895_length_295_cov_1.157658_g55352_i0	PRJNA1063685	55895	295	1.157658	3.4150911	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	303	6.85e-78	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g55352	i0	85.714	140.328813559322	294	35	99	6	1	293	543526	543239	Deinococcus sp. NW-56 chromosome, complete genome	blastn	41397	303	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
23131987	23131987	PRJNA1063685_S_NODE_5139_length_729_cov_5.092988_g4700_i0	PRJNA1063685	5139	729	5.092988	37.12788252	Deinococcus aquaticus	328692	Bacteria	Bacteria	704	0	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g4700	i0	97.129	225.949245541838	418	10	100	2	313	729	716417	716001	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	164717	704	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
23964610	23964610	PRJNA1063685_S_NODE_75539_length_236_cov_8.828221_g74996_i0	PRJNA1063685	75539	236	8.828221	20.83460156	Deinococcus	1298	Bacteria	Bacteria	394	3.05e-105	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g74996	i0	100	156.792372881356	213	0	90	0	24	236	1792231	1792019	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	37003	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
24405438	24405438	PRJNA1063685_S_NODE_2520_length_851_cov_20.982005_g2157_i0	PRJNA1063685	2520	851	20.982005	178.55686255	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	377	9.91e-127	NR	WP_085931722.1	432329	g2157	i0	71.6	0.90599294947121	257	73	90.6	0	830	60	148	404	WP_085931722.1 acyl-CoA dehydrogenase family protein [Deinococcus peraridilitoris]	diamond	771	377	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
24405661	24405661	PRJNA1063685_S_NODE_48980_length_323_cov_9.756000_g48437_i0	PRJNA1063685	48980	323	9.756	31.51188	Deinococcus gobiensis	502394	Bacteria	Bacteria	490	5.42e-134	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g48437	i0	96.309	191.05572755418	298	11	92	0	1	298	111893	111596	Deinococcus gobiensis I-0, complete genome	blastn	61711	490	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
24405668	24405668	PRJNA1063685_S_NODE_49540_length_321_cov_2.931452_g48997_i0	PRJNA1063685	49540	321	2.931452	9.40996092	Deinococcus aquaticus	328692	Bacteria	Bacteria	571	1.8699999999999993e-158	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g48997	i0	98.754	204.06230529595	321	4	100	0	1	321	715059	714739	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	65504	571	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
27320061	27320061	PRJNA1063685_S_NODE_19803_length_511_cov_12.796804_g19265_i0	PRJNA1063685	19803	511	12.796804	65.39166844	Deinococcus sp.	47478	Bacteria	Bacteria	161	3.94e-46	NR	MDO4263478.1	47478	g19265	i0	58	3.70450097847358	157	57	92.2	3	488	18	96	243	MDO4263478.1 DUF4388 domain-containing protein [Deinococcus sp.]	diamond	1893	161	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
32406725	32406725	PRJNA1063685_S_NODE_16899_length_541_cov_2.014957_g16367_i0	PRJNA1063685	16899	541	2.014957	10.90091737	Thermovirga lienii	336261	Bacteria	Bacteria	131	6.4e-35	NR	WP_334139740.1	336261	g16367	i0	51.2	1.40850277264325	127	60	70.4	1	435	55	6	130	WP_334139740.1 ribonuclease HI family protein [Thermovirga lienii]	diamond	762	131	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Thermovirgaceae	Thermovirga	Thermovirga lienii

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