metadata: contig_metadata: 24 rows where bioproject = "PRJNA1188114" and tax

24 rows where bioproject = "PRJNA1188114" 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
1594621	1594621	PRJNA1188114_P_NODE_10982_length_171_cov_1.672131_g10930_i0	PRJNA1188114	10982	171	1.672131	2.85934401	Deinococcus radiophilus	32062	Bacteria	Bacteria	171	3.79e-38	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g10930	i0	87.248	5.34502923976608	149	19	88	0	23	171	1413066	1413214	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	914	171	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
3592553	3592553	PRJNA1188114_P_NODE_12923_length_167_cov_0.864407_g12871_i0	PRJNA1188114	12923	167	0.864407	1.44355969	Deinococcus	1298	Bacteria	Bacteria	278	2.12e-70	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g12871	i0	96.97	103.353293413174	165	5	99	0	1	165	2255371	2255207	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	17260	278	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
7419969	7419969	PRJNA1188114_P_NODE_14666_length_165_cov_0.879310_g14614_i0	PRJNA1188114	14666	165	0.87931	1.4508615	Thermus	270	Bacteria	Bacteria	222	9.939999999999999e-54	NTclustered	gi\|1886399087\|gb\|CP053287.1\|	274	g14614	i0	90.909	43.9030303030303	165	15	100	0	1	165	830620	830456	Thermus thermophilus strain HB27c chromosome	blastn	7244	222	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9247903	9247903	PRJNA1188114_P_NODE_17508_length_163_cov_0.894737_g17456_i0	PRJNA1188114	17508	163	0.894737	1.45842131	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	296	5.68e-76	NTclustered	gi\|1819263924\|gb\|CP049359.1\|	1288484	g17456	i0	99.387	19	163	1	100	0	1	163	13556	13718	Deinococcus wulumuqiensis R12 plasmid unnamed2, complete sequence	blastn	3097	296	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
10523759	10523759	PRJNA1188114_P_NODE_7249_length_186_cov_2.211679_g7197_i0	PRJNA1188114	7249	186	2.211679	4.11372294	Deinococcus gobiensis	502394	Bacteria	Bacteria	183	5.4e-42	NTclustered	gi\|380002081\|gb\|CP002193.1\|	745776	g7197	i0	98.095	1.56989247311828	105	2	56	0	82	186	32381	32485	Deinococcus gobiensis I-0 plasmid P2, complete sequence	blastn	292	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
11798660	11798660	PRJNA1188114_P_NODE_7710_length_185_cov_1.051471_g7658_i0	PRJNA1188114	7710	185	1.051471	1.94522135	Deinococcus geothermalis	68909	Bacteria	Bacteria	243	8.73e-60	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g7658	i0	90.27	1	185	18	100	0	1	185	1230336	1230520	Deinococcus geothermalis DSM 11300, complete genome	blastn	185	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
13073570	13073570	PRJNA1188114_P_NODE_16691_length_163_cov_0.894737_g16639_i0	PRJNA1188114	16691	163	0.894737	1.45842131	Deinococcus metallilatus	1211322	Bacteria	Bacteria	252	1.25e-62	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g16639	i0	94.479	9.87116564417178	163	9	100	0	1	163	1948714	1948876	Deinococcus metallilatus strain MA1002 chromosome	blastn	1609	252	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
15069832	15069832	PRJNA1188114_P_NODE_5152_length_203_cov_1.019481_g5100_i0	PRJNA1188114	5152	203	1.019481	2.06954643	Deinococcus	1298	Bacteria	Bacteria	163	7.83e-36	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g5100	i0	90.909	1.78817733990148	121	11	60	0	1	121	1298284	1298404	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	363	163	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
18171577	18171577	PRJNA1188114_P_NODE_15175_length_165_cov_0.879310_g15123_i0	PRJNA1188114	15175	165	0.87931	1.4508615	Deinococcus taeanensis	2737050	Bacteria	Bacteria	104	3.76e-18	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g15123	i0	78.882	0.975757575757576	161	28	96	3	7	164	345172	345015	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	161	104	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
19446030	19446030	PRJNA1188114_P_NODE_18916_length_161_cov_1.821429_g18864_i0	PRJNA1188114	18916	161	1.821429	2.93250069	Deinococcus radiophilus	32062	Bacteria	Bacteria	165	1.65e-36	NTclustered	gi\|2152123021\|gb\|CP086380.1\|	32062	g18864	i0	85.443	25.8757763975155	158	23	98	0	3	160	2091777	2091934	Deinococcus radiophilus strain ATCC 27603 chromosome, complete genome	blastn	4166	165	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiophilus
20721318	20721318	PRJNA1188114_P_NODE_11537_length_169_cov_1.375000_g11485_i0	PRJNA1188114	11537	169	1.375	2.32375	Deinococcus aetherius	200252	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g11485	i0	94.286	0.207100591715976	35	1	21	1	54	88	154381	154348	Deinococcus aetherius ST0316 DNA, complete genome	blastn	35	52.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
20721372	20721372	PRJNA1188114_P_NODE_18797_length_162_cov_0.893805_g18745_i0	PRJNA1188114	18797	162	0.893805	1.4479641	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g18745	i0	99.383	174.672839506173	162	1	100	0	1	162	1109312	1109473	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	28297	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21996707	21996707	PRJNA1188114_P_NODE_16778_length_163_cov_0.894737_g16726_i0	PRJNA1188114	16778	163	0.894737	1.45842131	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	107	1.5999999999999998e-25	NR	WP_177183115.1	856736	g16726	i0	100	0.993865030674847	54	0	99.4	0	163	2	130	183	WP_177183115.1 hypothetical protein [Deinococcus reticulitermitis]	diamond	162	107	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
24545950	24545950	PRJNA1188114_P_NODE_10900_length_171_cov_2.565574_g10848_i0	PRJNA1188114	10900	171	2.565574	4.38713154	Deinococcus fonticola	2528713	Bacteria	Bacteria	92.8	2.92e-20	NR	WP_135229957.1	2528713	g10848	i0	76.8	0.982456140350877	56	13	98.2	0	169	2	182	237	WP_135229957.1 Rqc2 family fibronectin-binding protein [Deinococcus fonticola]	diamond	168	92.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
24546097	24546097	PRJNA1188114_P_NODE_8180_length_183_cov_1.291045_g8128_i0	PRJNA1188114	8180	183	1.291045	2.36261235	Deinococcus fonticola	2528713	Bacteria	Bacteria	115	1.37e-28	NR	WP_135228607.1	2528713	g8128	i0	90.2	1	61	6	100	0	183	1	210	270	WP_135228607.1 SLC13 family permease [Deinococcus fonticola]	diamond	183	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus fonticola
25268318	25268318	PRJNA1188114_P_NODE_4380_length_214_cov_2.872727_g4328_i0	PRJNA1188114	4380	214	2.872727	6.14763578	Bacteria	2	Bacteria	Bacteria	140	1.0400000000000001e-36	NR	1TAQ_A	271	g4328	i0	100	3.98130841121495	71	0	99.5	0	214	2	688	758	1TAQ_A Chain A, TAQ DNA POLYMERASE [Thermus aquaticus]	diamond	852	140	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
27420259	27420259	PRJNA1188114_P_NODE_13983_length_166_cov_0.871795_g13931_i0	PRJNA1188114	13983	166	0.871795	1.4471797	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	85.9	7.99e-18	NR	WP_177183124.1	856736	g13931	i0	90.7	0.975903614457831	54	5	97.6	0	3	164	1150	1203	WP_177183124.1 alpha-2-macroglobulin family protein [Deinococcus reticulitermitis]	diamond	162	85.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
28051451	28051451	PRJNA1188114_P_NODE_20005_length_161_cov_0.910714_g19953_i0	PRJNA1188114	20005	161	0.910714	1.46624954	Deinococcus yavapaiensis	309889	Bacteria	Bacteria	95.9	2.32e-21	NR	WP_110885893.1	309889	g19953	i0	82.7	0.968944099378882	52	9	96.9	0	159	4	107	158	WP_110885893.1 insulinase family protein [Deinococcus yavapaiensis]	diamond	156	95.9	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yavapaiensis
28828134	28828134	PRJNA1188114_P_NODE_15368_length_164_cov_1.573913_g15316_i0	PRJNA1188114	15368	164	1.573913	2.58121732	Deinococcus	1298	Bacteria	Bacteria	55.5	4.01e-7	NR	WP_189641900.1	394230	g15316	i0	72.5	1.46341463414634	40	7	73.2	1	44	163	15	50	WP_189641900.1 ferrochelatase [Deinococcus piscis]	diamond	240	55.8	0.99462365591397806	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
29629813	29629813	PRJNA1188114_P_NODE_10750_length_172_cov_1.658537_g10698_i0	PRJNA1188114	10750	172	1.658537	2.85268364	Deinococcus piscis	394230	Bacteria	Bacteria	115	4.56e-30	NR	GHG08658.1	394230	g10698	i0	94.6	0.976744186046512	56	3	97.7	0	172	5	189	244	GHG08658.1 hypothetical protein GCM10017783_21530 [Deinococcus piscis]	diamond	168	115	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus piscis
30483147	30483147	PRJNA1188114_P_NODE_16173_length_164_cov_0.886957_g16121_i0	PRJNA1188114	16173	164	0.886957	1.45460948	Deinococcus enclensis	1049582	Bacteria	Bacteria	114	7.87e-28	NR	WP_307467739.1	1049582	g16121	i0	98.1	0.98780487804878	54	1	98.8	0	163	2	273	326	WP_307467739.1 methylation-associated defense system ATP-binding protein MAD8 [Deinococcus enclensis]	diamond	162	114	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus enclensis
31209329	31209329	PRJNA1188114_P_NODE_13375_length_166_cov_0.871795_g13323_i0	PRJNA1188114	13375	166	0.871795	1.4471797	Truepera radiovictrix	332249	Bacteria	Bacteria	70.1	2.48e-12	NR	WP_013178049.1	332249	g13323	i0	71.7	0.957831325301205	53	15	95.8	0	159	1	61	113	WP_013178049.1 lysylphosphatidylglycerol synthase transmembrane domain-containing protein [Truepera radiovictrix]	diamond	159	70.1	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
31873970	31873970	PRJNA1188114_P_NODE_19257_length_161_cov_0.910714_g19205_i0	PRJNA1188114	19257	161	0.910714	1.46624954	Deinococcus reticulitermitis	856736	Bacteria	Bacteria	99.8	1.0300000000000001e-22	NR	WP_092265518.1	856736	g19205	i0	90.6	0.987577639751553	53	5	98.8	0	3	161	331	383	WP_092265518.1 S-layer homology domain-containing protein [Deinococcus reticulitermitis]	diamond	159	99.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus reticulitermitis
32063774	32063774	PRJNA1188114_P_NODE_17218_length_163_cov_0.894737_g17166_i0	PRJNA1188114	17218	163	0.894737	1.45842131	Deinococcus antarcticus	1298767	Bacteria	Bacteria	113	1.89e-27	NR	WP_380075880.1	1298767	g17166	i0	98.1	0.975460122699387	53	1	97.5	0	5	163	512	564	WP_380075880.1 FAD-dependent oxidoreductase [Deinococcus antarcticus]	diamond	159	113	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus

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