metadata: contig_metadata: 30 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax

30 rows where analysis = "blastn", bioproject = "PRJNA1035005" 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
1443825	1443825	PRJNA1035005_P_NODE_76542_length_245_cov_0.906977_g76136_i0	PRJNA1035005	76542	245	0.906977	2.22209365	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	121	5.98e-23	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g76136	i0	81.875	36.4326530612245	160	13	70	11	44	195	616109	616260	Thermus sp. NEB1569 chromosome, complete genome	blastn	8926	121	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
2719210	2719210	PRJNA1035005_P_NODE_29743_length_283_cov_1.252381_g29337_i0	PRJNA1035005	29743	283	1.252381	3.54423823	Deinococcus maricopensis	309887	Bacteria	Bacteria	196	1.14e-45	NTclustered	gi\|319753907\|gb\|CP002454.1\|	709986	g29337	i0	79.859	2.98586572438163	283	46	98	10	7	283	436130	436407	Deinococcus maricopensis DSM 21211, complete genome	blastn	845	196	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus maricopensis
3995302	3995302	PRJNA1035005_P_NODE_31544_length_280_cov_1.966184_g31138_i0	PRJNA1035005	31544	280	1.966184	5.5053152	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	501	2.13e-137	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g31138	i0	98.929	351.214285714286	280	3	100	0	1	280	2705874	2706153	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	98340	501	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
5271690	5271690	PRJNA1035005_P_NODE_4045_length_531_cov_2.224891_g3647_i0	PRJNA1035005	4045	531	2.224891	11.81417121	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	791	0	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g3647	i0	93.633	195.039548022599	534	26	100	8	1	531	74900	74372	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	103566	791	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
5271994	5271994	PRJNA1035005_P_NODE_78565_length_244_cov_1.409357_g78159_i0	PRJNA1035005	78565	244	1.409357	3.43883108	Thermus sp. PS18	2849039	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g78159	i0	98.77	51.5614754098361	244	3	100	0	1	244	2366706	2366463	Thermus sp. PS18 chromosome, complete genome	blastn	12581	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
6546691	6546691	PRJNA1035005_P_NODE_12346_length_342_cov_1.133829_g11941_i0	PRJNA1035005	12346	342	1.133829	3.87769518	Deinococcus sp. AJ005	2652443	Bacteria	Bacteria	610	4.25e-170	NTclustered	gi\|1761809830\|gb\|CP044990.1\|	2652443	g11941	i0	98.83	202.432748538012	342	4	100	0	1	342	97930	98271	Deinococcus sp. AJ005 chromosome, complete genome	blastn	69232	610	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AJ005
6546873	6546873	PRJNA1035005_P_NODE_35126_length_276_cov_1.246305_g34720_i0	PRJNA1035005	35126	276	1.246305	3.4398018	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	449	7.699999999999998e-122	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g34720	i0	96.014	261.278985507246	276	11	100	0	1	276	545475	545200	Deinococcus sp. NW-56 chromosome, complete genome	blastn	72113	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6547048	6547048	PRJNA1035005_P_NODE_59466_length_251_cov_0.876404_g59060_i0	PRJNA1035005	59466	251	0.876404	2.19977404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g59060	i0	99.602	47.406374501992	251	1	100	0	1	251	1671178	1670928	Thermus sp. NEB1569 chromosome, complete genome	blastn	11899	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
6547217	6547217	PRJNA1035005_P_NODE_79026_length_244_cov_0.912281_g78620_i0	PRJNA1035005	79026	244	0.912281	2.22596564	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	108	4.63e-19	NTclustered	gi\|1339790004\|gb\|CP026517.1\|	2080419	g78620	i0	88.043	0.795081967213115	92	10	37	1	148	238	52964	52873	Deinococcus sp. NW-56 plasmid unnamed1, complete sequence	blastn	194	108	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
6547283	6547283	PRJNA1035005_P_NODE_88626_length_232_cov_2.119497_g88220_i0	PRJNA1035005	88626	232	2.119497	4.91723304	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	418	1.7799999999999995e-112	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g88220	i0	99.138	5.83620689655172	232	2	100	0	1	232	631324	631555	Thermus sp. NEB1569 chromosome, complete genome	blastn	1354	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
7821774	7821774	PRJNA1035005_P_NODE_82267_length_243_cov_0.917647_g81861_i0	PRJNA1035005	82267	243	0.917647	2.22988221	Deinococcus grandis	57498	Bacteria	Bacteria	366	6.89e-97	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g81861	i0	93.827	78.7407407407407	243	15	100	0	1	243	1150434	1150676	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	19134	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
8660968	8660968	PRJNA1035005_P_NODE_35407_length_275_cov_2.064356_g35001_i0	PRJNA1035005	35407	275	2.064356	5.676979	Deinococcus	1298	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2113091292\|gb\|OK502043.1\|	47478	g35001	i0	100	102.003636363636	275	0	100	0	1	275	184	458	Deinococcus sp. strain L37141 16S ribosomal RNA gene, partial sequence	blastn	28051	508	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
8660983	8660983	PRJNA1035005_P_NODE_39927_length_269_cov_3.387755_g39521_i0	PRJNA1035005	39927	269	3.387755	9.11306095	Thermus	270	Bacteria	Bacteria	470	5.74e-128	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g39521	i0	98.148	6.00371747211896	270	3	100	2	1	269	748321	748589	Thermus scotoductus SA-01, complete genome	blastn	1615	470	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
8661081	8661081	PRJNA1035005_P_NODE_70627_length_247_cov_0.896552_g70221_i0	PRJNA1035005	70627	247	0.896552	2.21448344	Thermus	270	Bacteria	Bacteria	401	1.9199999999999992e-107	NTclustered	gi\|1519238714\|emb\|LR027517.1\|	274	g70221	i0	95.951	35.9352226720648	247	10	100	0	1	247	197583	197829	Thermus thermophilus isolate TTHNAR1 genome assembly, chromosome: 1	blastn	8876	401	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
9096495	9096495	PRJNA1035005_P_NODE_49788_length_257_cov_1.695652_g49382_i0	PRJNA1035005	49788	257	1.695652	4.35782564	Deinococcus radiomollis	468916	Bacteria	Bacteria	270	5.93e-68	NTclustered	gi\|2865409981\|gb\|CP129906.1\|	468916	g49382	i0	86.345	76.9922178988327	249	32	96	2	9	256	1541036	1540789	Deinococcus radiomollis strain PO-04-20-132 chromosome, complete genome	blastn	19787	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiomollis
9096567	9096567	PRJNA1035005_P_NODE_59508_length_251_cov_0.876404_g59102_i0	PRJNA1035005	59508	251	0.876404	2.19977404	Deinococcus aetherius	200252	Bacteria	Bacteria	320	5.65e-83	NTclustered	gi\|2281898193\|dbj\|AP026561.1\|	200252	g59102	i0	89.641	12.0916334661355	251	26	100	0	1	251	335534	335784	Deinococcus aetherius ST0316 plasmid pDAETH-1 DNA, complete genome	blastn	3035	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
9096577	9096577	PRJNA1035005_P_NODE_60768_length_251_cov_0.876404_g60362_i0	PRJNA1035005	60768	251	0.876404	2.19977404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g60362	i0	98.008	11.8326693227092	251	5	100	0	1	251	2032840	2032590	Thermus sp. NEB1569 chromosome, complete genome	blastn	2970	436	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
11211079	11211079	PRJNA1035005_P_NODE_19569_length_301_cov_3.456140_g19163_i0	PRJNA1035005	19569	301	3.45614	10.4029814	Thermus	270	Bacteria	Bacteria	281	3.28e-71	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g19163	i0	100	9.49169435215947	152	0	100	0	1	152	1934526	1934375	Thermus scotoductus SA-01, complete genome	blastn	2857	281	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
12922706	12922706	PRJNA1035005_P_NODE_59591_length_251_cov_0.876404_g59185_i0	PRJNA1035005	59591	251	0.876404	2.19977404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g59185	i0	99.602	6	251	1	100	0	1	251	1915770	1915520	Thermus sp. NEB1569 chromosome, complete genome	blastn	1506	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
14197618	14197618	PRJNA1035005_P_NODE_57932_length_252_cov_0.871508_g57526_i0	PRJNA1035005	57932	252	0.871508	2.19620016	Thermus scotoductus	37636	Bacteria	Bacteria	449	6.94e-122	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g57526	i0	98.81	6.09920634920635	252	3	100	0	1	252	1779318	1779067	Thermus scotoductus SA-01, complete genome	blastn	1537	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
15471726	15471726	PRJNA1035005_P_NODE_45333_length_263_cov_1.205263_g44927_i0	PRJNA1035005	45333	263	1.205263	3.16984169	Thermus scotoductus	37636	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g44927	i0	100	5.91634980988593	263	0	100	0	1	263	1724238	1723976	Thermus scotoductus SA-01, complete genome	blastn	1556	486	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
15471843	15471843	PRJNA1035005_P_NODE_60113_length_251_cov_0.876404_g59707_i0	PRJNA1035005	60113	251	0.876404	2.19977404	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g59707	i0	99.602	111.661354581673	251	1	100	0	1	251	271867	271617	Thermus sp. NEB1569 chromosome, complete genome	blastn	28027	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
16745841	16745841	PRJNA1035005_P_NODE_4214_length_521_cov_1.392857_g3816_i0	PRJNA1035005	4214	521	1.392857	7.25678497	Thermus aquaticus	271	Bacteria	Bacteria	612	1.8699999999999993e-170	NTclustered	gi\|939575972\|gb\|CP010822.1\|	498848	g3816	i0	88.077	28.0383877159309	520	57	99	5	1	518	1009357	1009873	Thermus aquaticus Y51MC23, complete genome	blastn	14608	612	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus aquaticus
18021075	18021075	PRJNA1035005_P_NODE_86815_length_240_cov_2.676647_g86409_i0	PRJNA1035005	86815	240	2.676647	6.4239528	Thermus thermophilus	274	Bacteria	Bacteria	433	6.599999999999997e-117	NTclustered	gi\|383510738\|gb\|CP003254.1\|	798128	g86409	i0	99.167	9.01666666666667	240	2	100	0	1	240	1578	1339	Thermus thermophilus JL-18 plasmid pTTJL1802, complete sequence	blastn	2164	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
18859380	18859380	PRJNA1035005_P_NODE_16035_length_317_cov_1.438525_g15629_i0	PRJNA1035005	16035	317	1.438525	4.56012425	Thermaceae	188786	Bacteria	Bacteria	560	3.99e-155	NTclustered	gi\|2440484278\|gb\|CP046617.1\|	88190	g15629	i0	100	73.6277602523659	303	0	96	0	15	317	2037909	2038211	Thermus antranikianii strain JCM 19900 chromosome, complete genome	blastn	23340	562	0.99644128113879	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
19294733	19294733	PRJNA1035005_P_NODE_53676_length_253_cov_0.866667_g53270_i0	PRJNA1035005	53676	253	0.866667	2.19266751	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g53270	i0	96.97	0.130434782608696	33	1	13	0	211	243	12407	12375	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
20570224	20570224	PRJNA1035005_P_NODE_69717_length_247_cov_1.660920_g69311_i0	PRJNA1035005	69717	247	1.66092	4.1024724	Thermus scotoductus	37636	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g69311	i0	99.19	9.92712550607287	247	2	100	0	1	247	501919	502165	Thermus scotoductus SA-01, complete genome	blastn	2452	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
21845929	21845929	PRJNA1035005_P_NODE_61338_length_250_cov_1.740113_g60932_i0	PRJNA1035005	61338	250	1.740113	4.3502825	Thermus scotoductus	37636	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g60932	i0	98.4	12.488	250	4	100	0	1	250	2176895	2176646	Thermus scotoductus SA-01, complete genome	blastn	3122	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
21845986	21845986	PRJNA1035005_P_NODE_71558_length_247_cov_0.896552_g71152_i0	PRJNA1035005	71558	247	0.896552	2.21448344	Thermus sp. PS18	2849039	Bacteria	Bacteria	420	5.31e-113	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g71152	i0	97.2	6.07287449392713	250	4	100	3	1	247	2278623	2278374	Thermus sp. PS18 chromosome, complete genome	blastn	1500	420	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18
23121207	23121207	PRJNA1035005_P_NODE_56019_length_252_cov_1.385475_g55613_i0	PRJNA1035005	56019	252	1.385475	3.491397	Thermus scotoductus	37636	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|320149275\|gb\|CP001962.1\|	743525	g55613	i0	100	5.90476190476191	252	0	100	0	1	252	1649245	1648994	Thermus scotoductus SA-01, complete genome	blastn	1488	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus

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