metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA715462" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA715462" 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
1192284	1192284	PRJNA715462_P_NODE_52621_length_250_cov_0.870056_g51825_i0	PRJNA715462	52621	250	0.870056	2.17514	Truepera	332248	Bacteria	Bacteria	274	4.44e-69	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g51825	i0	86.4	3.636	250	34	100	0	1	250	716624	716375	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	909	274	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
1982087	1982087	PRJNA715462_P_NODE_46842_length_261_cov_1.175532_g46046_i0	PRJNA715462	46842	261	1.175532	3.06813852	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	449	7.22e-122	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g46046	i0	97.719	297.528735632184	263	3	100	3	1	261	1637802	1637541	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	77655	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
1982307	1982307	PRJNA715462_P_NODE_58722_length_247_cov_0.885057_g57926_i0	PRJNA715462	58722	247	0.885057	2.18609079	Thermus antranikianii	88190	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g57926	i0	99.19	43.1376518218623	247	2	100	0	1	247	720194	720440	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	10655	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
2467678	2467678	PRJNA715462_P_NODE_63662_length_244_cov_0.900585_g62866_i0	PRJNA715462	63662	244	0.900585	2.1974274	Truepera	332248	Bacteria	Bacteria	261	3.36e-65	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g62866	i0	86.42	31.6680327868852	243	27	98	5	1	240	3233998	3234237	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	7727	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
3743994	3743994	PRJNA715462_P_NODE_47743_length_258_cov_1.664865_g46947_i0	PRJNA715462	47743	258	1.664865	4.2953517	Deinococcus	1298	Bacteria	Bacteria	243	1.3e-59	NTclustered	gi\|2706840606\|gb\|CP149783.1\|	3112952	g46947	i0	99.254	12.2093023255814	134	1	52	0	1	134	238714	238847	Deinococcus sp. VB142 chromosome 2, complete sequence	blastn	3150	243	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
10910039	10910039	PRJNA715462_P_NODE_42869_length_272_cov_1.547739_g42073_i0	PRJNA715462	42869	272	1.547739	4.20985008	Deinococcus aquaticus	328692	Bacteria	Bacteria	387	6.02e-103	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g42073	i0	92.279	15.5808823529412	272	21	100	0	1	272	1870797	1871068	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	4238	387	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
11395844	11395844	PRJNA715462_P_NODE_38289_length_286_cov_1.347418_g37493_i0	PRJNA715462	38289	286	1.347418	3.85361548	Deinococcus	1298	Bacteria	Bacteria	390	4.929999999999999e-104	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g37493	i0	91.259	21.4020979020979	286	25	100	0	1	286	1428656	1428941	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	6121	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
12671869	12671869	PRJNA715462_P_NODE_45670_length_264_cov_1.429319_g44874_i0	PRJNA715462	45670	264	1.429319	3.77340216	Truepera	332248	Bacteria	Bacteria	135	2.3300000000000004e-27	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g44874	i0	79.208	1.5530303030303	202	36	75	6	43	241	2044691	2044889	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	410	135	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
13459608	13459608	PRJNA715462_P_NODE_38251_length_286_cov_1.446009_g37455_i0	PRJNA715462	38251	286	1.446009	4.13558574	Deinococcus aetherius	200252	Bacteria	Bacteria	412	1.0499999999999999e-110	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g37455	i0	92.933	11.5664335664336	283	20	99	0	2	284	1777511	1777229	Deinococcus aetherius ST0316 DNA, complete genome	blastn	3308	412	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
13946110	13946110	PRJNA715462_P_NODE_42451_length_273_cov_2.095000_g41655_i0	PRJNA715462	42451	273	2.095	5.71935	Truepera	332248	Bacteria	Bacteria	76.8	1.49e-9	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g41655	i0	92.453	0.388278388278388	53	4	19	0	26	78	576059	576007	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	106	76.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
16008486	16008486	PRJNA715462_P_NODE_38713_length_285_cov_1.150943_g37917_i0	PRJNA715462	38713	285	1.150943	3.28018755	Thermus thermophilus	274	Bacteria	Bacteria	418	2.2499999999999996e-112	NTclustered	gi\|2199618847\|dbj\|AP025606.1\|	274	g37917	i0	97.925	8.03859649122807	241	5	85	0	1	241	21581	21821	Thermus thermophilus SNM1-7 plasmid pTthSNM1-7d DNA, complete sequence	blastn	2291	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
16008889	16008889	PRJNA715462_P_NODE_58973_length_247_cov_0.885057_g58177_i0	PRJNA715462	58973	247	0.885057	2.18609079	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g58177	i0	100	6	247	0	100	0	1	247	1153150	1152904	Thermus sp. NEB1569 chromosome, complete genome	blastn	1482	457	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
16495226	16495226	PRJNA715462_P_NODE_58993_length_247_cov_0.885057_g58197_i0	PRJNA715462	58993	247	0.885057	2.18609079	Deinococcus	1298	Bacteria	Bacteria	237	5.74e-58	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g58197	i0	85.714	1.82591093117409	224	32	91	0	23	246	17640	17417	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	451	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
18558065	18558065	PRJNA715462_P_NODE_55335_length_249_cov_0.875000_g54539_i0	PRJNA715462	55335	249	0.875	2.17875	Meiothermus ruber	277	Bacteria	Bacteria	237	5.8e-58	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g54539	i0	83.984	2.37751004016064	256	32	100	7	1	249	455776	455523	Meiothermus ruber DSM 1279, complete genome	blastn	592	237	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
18558137	18558137	PRJNA715462_P_NODE_58755_length_247_cov_0.885057_g57959_i0	PRJNA715462	58755	247	0.885057	2.18609079	Deinococcus ficus	317577	Bacteria	Bacteria	84.2	7.92e-12	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g57959	i0	92.982	0.34412955465587	57	4	23	0	12	68	2666915	2666971	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	85	84.2	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
20318656	20318656	PRJNA715462_P_NODE_32336_length_312_cov_1.723849_g31540_i0	PRJNA715462	32336	312	1.723849	5.37840888	Deinococcus	1298	Bacteria	Bacteria	339	2e-88	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g31540	i0	86.478	185.5	318	31	100	9	1	312	1142	1453	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	57876	339	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
21108400	21108400	PRJNA715462_P_NODE_40817_length_278_cov_2.165854_g40021_i0	PRJNA715462	40817	278	2.165854	6.02107412	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	392	1.3299999999999997e-104	NTclustered	gi\|2905214251\|gb\|CP179946.1\|	3385567	g40021	i0	99.083	13.9892086330935	218	2	78	0	61	278	239367	239150	Deinococcus sp. VB343 chromosome 2, complete sequence	blastn	3889	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
21108896	21108896	PRJNA715462_P_NODE_65017_length_243_cov_0.905882_g64221_i0	PRJNA715462	65017	243	0.905882	2.20129326	Deinococcus irradiatisoli	2202254	Bacteria	Bacteria	200	7.39e-47	NTclustered	gi\|1392964945\|gb\|CP029494.1\|	2202254	g64221	i0	82.051	33.7160493827161	234	42	96	0	5	238	1439935	1439702	Deinococcus irradiatisoli strain 17bor-2 chromosome, complete genome	blastn	8193	200	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus irradiatisoli
22869705	22869705	PRJNA715462_P_NODE_30238_length_324_cov_1.840637_g29442_i0	PRJNA715462	30238	324	1.840637	5.96366388	Deinococcus	1298	Bacteria	Bacteria	466	9.17e-127	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g29442	i0	92.661	234.694444444444	327	18	100	6	1	324	2671656	2671333	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	76041	466	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
22869758	22869758	PRJNA715462_P_NODE_53818_length_249_cov_1.392045_g53022_i0	PRJNA715462	53818	249	1.392045	3.46619205	Meiothermus	65551	Bacteria	Bacteria	411	3.2299999999999996e-110	NTclustered	gi\|290469363\|gb\|CP001743.1\|	504728	g53022	i0	96.386	5.6425702811245	249	9	100	0	1	249	69576	69824	Meiothermus ruber DSM 1279, complete genome	blastn	1405	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Meiothermus	Meiothermus ruber
22869791	22869791	PRJNA715462_P_NODE_64538_length_243_cov_1.711765_g63742_i0	PRJNA715462	64538	243	1.711765	4.15958895	Truepera	332248	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g63742	i0	82.819	2.48559670781893	227	37	93	2	18	243	1478364	1478589	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	604	202	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24143937	24143937	PRJNA715462_P_NODE_67859_length_242_cov_0.875740_g67063_i0	PRJNA715462	67859	242	0.87574	2.1192908	Thermus	270	Bacteria	Bacteria	442	1.1099999999999995e-119	NTclustered	gi\|1886401075\|gb\|CP053288.1\|	274	g67063	i0	99.587	42.8099173553719	242	1	100	0	1	242	60391	60150	Thermus thermophilus strain HB27c plasmid pTT27, complete sequence	blastn	10360	442	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
24143942	24143942	PRJNA715462_P_NODE_69559_length_241_cov_0.916667_g68763_i0	PRJNA715462	69559	241	0.916667	2.20916747	Thermus	270	Bacteria	Bacteria	219	2.02e-52	NTclustered	gi\|2894814231\|gb\|CP178485.1\|	56957	g68763	i0	82.988	6	241	41	100	0	1	241	1838468	1838708	Thermus oshimai strain Blanco chromosome, complete genome	blastn	1446	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus oshimai
24933099	24933099	PRJNA715462_P_NODE_7560_length_825_cov_3.017287_g6850_i0	PRJNA715462	7560	825	3.017287	24.89261775	Marinitoga piezophila	149715	Bacteria	Bacteria	54.7	0.023	NTclustered	gi\|372100556\|gb\|CP003257.1\|	443254	g6850	i0	100	0.0351515151515151	29	0	4	0	291	319	1201997	1202025	Marinitoga piezophila KA3, complete genome	blastn	29	54.7	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Marinitoga	Marinitoga piezophila
25418838	25418838	PRJNA715462_P_NODE_54180_length_249_cov_0.875000_g53384_i0	PRJNA715462	54180	249	0.875	2.17875	Truepera	332248	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|2573973991\|gb\|CP133611.1\|	332249	g53384	i0	87.19	14.3052208835341	242	31	97	0	1	242	1973597	1973838	Truepera radiovictrix strain CIP 108686 chromosome, complete genome	blastn	3562	276	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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