metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA551951" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA551951" and tax_phylum = "Deinococcota"

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
520625	520625	PRJNA551951_S_NODE_7181_length_307_cov_6.841912_g7063_i0	PRJNA551951	7181	307	6.841912	21.00466984	Thermus thermophilus	274	Bacteria	Bacteria	462	1.12e-125	NTclustered	gi\|2199643388\|dbj\|AP025617.1\|	274	g7063	i0	97.417	123.335504885993	271	7	88	0	15	285	215659	215389	Thermus thermophilus SNM7-6 DNA, complete genome	blastn	37864	462	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
1122833	1122833	PRJNA551951_S_NODE_14241_length_177_cov_5.880282_g14123_i0	PRJNA551951	14241	177	5.880282	10.40809914	Deinococcus	1298	Bacteria	Bacteria	121	4.039999999999999e-23	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g14123	i0	95.946	35.0225988700565	74	3	42	0	2	75	292955	292882	Deinococcus swuensis strain DY59, complete genome	blastn	6199	121	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
1796208	1796208	PRJNA551951_S_NODE_3122_length_529_cov_4.147773_g3013_i0	PRJNA551951	3122	529	4.147773	21.94171917	Allomeiothermus silvanus	52022	Bacteria	Bacteria	869	0	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g3013	i0	97.628	2.28922495274102	506	12	96	0	20	525	2778177	2777672	Meiothermus silvanus DSM 9946, complete genome	blastn	1211	869	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
4347608	4347608	PRJNA551951_S_NODE_10984_length_218_cov_41.841530_g10866_i0	PRJNA551951	10984	218	41.84153	91.2145354	Deinococcus taeanensis	2737050	Bacteria	Bacteria	291	3.75e-74	NTclustered	gi\|2105694697\|gb\|CP083456.1\|	2737050	g10866	i0	95.58	121.435779816514	181	8	83	0	38	218	1713	1533	Deinococcus taeanensis strain TS293 plasmid p_TS293_2, complete sequence	blastn	26473	291	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus taeanensis
5624390	5624390	PRJNA551951_S_NODE_16385_length_159_cov_1.935484_g16267_i0	PRJNA551951	16385	159	1.935484	3.07741956	Deinococcus grandis	57498	Bacteria	Bacteria	69.4	1.31e-7	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g16267	i0	100	1.9622641509434	37	0	23	0	119	155	20235	20271	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	312	69.4	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
7501021	7501021	PRJNA551951_S_NODE_16486_length_159_cov_0.959677_g16368_i0	PRJNA551951	16486	159	0.959677	1.52588643	Deinococcus	1298	Bacteria	Bacteria	261	2.01e-65	NTclustered	gi\|2155018471\|emb\|OV024757.1\|	1299	g16368	i0	96.226	19.8679245283019	159	6	100	0	1	159	1888680	1888522	Deinococcus radiodurans isolate DRR11 genome assembly, chromosome: 1	blastn	3159	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
8775766	8775766	PRJNA551951_S_NODE_11727_length_207_cov_32.750000_g11609_i0	PRJNA551951	11727	207	32.75	67.7925	Deinococcus	1298	Bacteria	Bacteria	344	2.67e-90	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g11609	i0	99.471	144.666666666667	189	1	91	0	5	193	1426	1614	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	29946	344	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
9449000	9449000	PRJNA551951_S_NODE_3368_length_506_cov_2.813163_g3256_i0	PRJNA551951	3368	506	2.813163	14.23460478	Allomeiothermus silvanus	52022	Bacteria	Bacteria	756	0	NTclustered	gi\|296848933\|gb\|CP002042.1\|	526227	g3256	i0	97.722	5.48418972332016	439	10	87	0	48	486	2776449	2776011	Meiothermus silvanus DSM 9946, complete genome	blastn	2775	756	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
10724692	10724692	PRJNA551951_S_NODE_15129_length_169_cov_1.768657_g15011_i0	PRJNA551951	15129	169	1.768657	2.98903033	Deinococcus metallilatus	1211322	Bacteria	Bacteria	180	6.2e-41	NTclustered	gi\|1609450927\|gb\|CP038511.1\|	1211322	g15011	i0	85.799	1	169	24	100	0	1	169	53022	52854	Deinococcus metallilatus strain MA1002 plasmid unnamed2	blastn	169	180	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
11999421	11999421	PRJNA551951_S_NODE_13370_length_186_cov_123.066225_g13252_i0	PRJNA551951	13370	186	123.066225	228.9031785	Deinococcus sp. KNUC1210	2917691	Bacteria	Bacteria	231	1.8999999999999996e-56	NTclustered	gi\|2197029603\|gb\|CP092190.1\|	2917691	g13252	i0	99.219	288.887096774194	128	1	69	0	25	152	1428162	1428035	Deinococcus sp. KNUC1210 chromosome, complete genome	blastn	53733	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. KNUC1210
12601823	12601823	PRJNA551951_S_NODE_12750_length_194_cov_2.333333_g12632_i0	PRJNA551951	12750	194	2.333333	4.52666602	Deinococcus	1298	Bacteria	Bacteria	244	2.57e-60	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g12632	i0	93.333	21.6185567010309	165	11	85	0	30	194	2569276	2569112	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	4194	244	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13274704	13274704	PRJNA551951_S_NODE_8891_length_261_cov_1.238938_g8773_i0	PRJNA551951	8891	261	1.238938	3.23362818	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	230	1.0199999999999998e-55	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g8773	i0	84.483	3.39846743295019	232	36	89	0	30	261	1812598	1812367	Deinococcus sp. NW-56 chromosome, complete genome	blastn	887	230	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13876775	13876775	PRJNA551951_S_NODE_11611_length_209_cov_4.655172_g11493_i0	PRJNA551951	11611	209	4.655172	9.72930948	Deinococcus	1298	Bacteria	Bacteria	353	4.489999999999999e-93	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g11493	i0	99.485	712.435406698565	194	1	93	0	1	194	1094	1287	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	148899	353	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
14549554	14549554	PRJNA551951_S_NODE_13792_length_182_cov_1.585034_g13674_i0	PRJNA551951	13792	182	1.585034	2.88476188	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	143	8.93e-30	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g13674	i0	85	7.61538461538461	140	21	77	0	37	176	1535103	1535242	Deinococcus sp. NW-56 chromosome, complete genome	blastn	1386	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
14549581	14549581	PRJNA551951_S_NODE_16252_length_160_cov_1.888000_g16134_i0	PRJNA551951	16252	160	1.888	3.0208	Deinococcus metallilatus	1211322	Bacteria	Bacteria	231	1.5899999999999998e-56	NTclustered	gi\|1609451317\|gb\|CP038512.1\|	1211322	g16134	i0	93.038	8.05	158	11	99	0	3	160	1183020	1183177	Deinococcus metallilatus strain MA1002 chromosome	blastn	1288	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
14549659	14549659	PRJNA551951_S_NODE_5172_length_387_cov_17.846591_g5054_i0	PRJNA551951	5172	387	17.846591	69.06630717	Deinococcus ficus	317577	Bacteria	Bacteria	534	3.01e-147	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g5054	i0	92.126	195.21188630491	381	27	98	2	1	379	2342422	2342801	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	75547	534	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
15151098	15151098	PRJNA551951_S_NODE_6252_length_339_cov_28.733553_g6134_i0	PRJNA551951	6252	339	28.733553	97.40674467	Deinococcus	1298	Bacteria	Bacteria	582	9.179999999999996e-162	NTclustered	gi\|2264081587\|gb\|CP094462.1\|	1299	g6134	i0	100	201.138643067847	315	0	93	0	25	339	880638	880324	Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence	blastn	68186	582	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
15823444	15823444	PRJNA551951_S_NODE_9373_length_250_cov_2.851163_g9255_i0	PRJNA551951	9373	250	2.851163	7.1279075	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	305	1.57e-78	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g9255	i0	93.627	19.172	204	13	82	0	24	227	2120875	2120672	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	4793	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17700813	17700813	PRJNA551951_S_NODE_14394_length_176_cov_1.950355_g14276_i0	PRJNA551951	14394	176	1.950355	3.4326248	Deinococcus	1298	Bacteria	Bacteria	230	6.39e-56	NTclustered	gi\|94554390\|gb\|CP000359.1\|	319795	g14276	i0	90.286	18.0284090909091	175	17	99	0	2	176	1375194	1375368	Deinococcus geothermalis DSM 11300, complete genome	blastn	3173	231	0.995670995670996	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
18974355	18974355	PRJNA551951_S_NODE_4155_length_443_cov_83.262255_g4040_i0	PRJNA551951	4155	443	83.262255	368.85178965	Deinococcus	1298	Bacteria	Bacteria	793	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g4040	i0	99.317	272.460496613995	439	1	99	2	1	438	70370	69933	Deinococcus swuensis strain DY59, complete genome	blastn	120700	793	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18974475	18974475	PRJNA551951_S_NODE_9195_length_253_cov_33.490826_g9077_i0	PRJNA551951	9195	253	33.490826	84.73178978	Deinococcus	1298	Bacteria	Bacteria	429	9.079999999999999e-116	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g9077	i0	98.755	434.110671936759	241	3	95	0	1	241	2148130	2147890	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	109830	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19646985	19646985	PRJNA551951_S_NODE_6996_length_313_cov_4.017986_g6878_i0	PRJNA551951	6996	313	4.017986	12.57629618	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	272	2.06e-68	NTclustered	gi\|1819261009\|gb\|CP049357.1\|	1288484	g6878	i0	84.483	15.7507987220447	290	30	93	6	24	313	690974	690700	Deinococcus wulumuqiensis R12 chromosome, complete genome	blastn	4930	272	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
20922682	20922682	PRJNA551951_S_NODE_14617_length_174_cov_1.151079_g14499_i0	PRJNA551951	14617	174	1.151079	2.00287746	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|1435319096\|gb\|CP031163.1\|	980427	g14499	i0	100	6	174	0	100	0	1	174	491228	491055	Deinococcus wulumuqiensis strain NEB 479 plasmid pDrdI, complete sequence	blastn	1044	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
22197428	22197428	PRJNA551951_S_NODE_1598_length_746_cov_59.202532_g1519_i0	PRJNA551951	1598	746	59.202532	441.65088872	Allomeiothermus silvanus	52022	Bacteria	Bacteria	270	1.9e-67	NTclustered	gi\|296852006\|gb\|CP002043.1\|	526227	g1519	i0	91.371	0.768096514745308	197	17	26	0	205	401	125279	125475	Meiothermus silvanus DSM 9946 plasmid pMESIL01, complete sequence	blastn	573	270	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Allomeiothermus	Allomeiothermus silvanus
22197509	22197509	PRJNA551951_S_NODE_5518_length_372_cov_78.756677_g5400_i0	PRJNA551951	5518	372	78.756677	292.97483844	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	518	2.9e-142	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g5400	i0	92.225	231.540322580645	373	18	100	7	1	372	544599	544237	Deinococcus sp. NW-56 chromosome, complete genome	blastn	86133	518	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
22800125	22800125	PRJNA551951_S_NODE_1858_length_697_cov_22.641994_g1775_i0	PRJNA551951	1858	697	22.641994	157.81469818	Deinococcus	1298	Bacteria	Bacteria	1088	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g1775	i0	94.85	287.381635581062	699	32	100	4	1	697	69334	70030	Deinococcus swuensis strain DY59, complete genome	blastn	200305	1088	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
23473120	23473120	PRJNA551951_S_NODE_8999_length_258_cov_7.937220_g8881_i0	PRJNA551951	8999	258	7.93722	20.4780276	Thermus antranikianii	88190	Bacteria	Bacteria	392	1.2199999999999997e-104	NTclustered	gi\|2049910225\|gb\|CP076325.1\|	88190	g8881	i0	96.996	5.37984496124031	233	7	90	0	8	240	2213833	2214065	MAG: Thermus antranikianii isolate RBS10-92 chromosome, complete genome	blastn	1388	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus antranikianii
25349254	25349254	PRJNA551951_S_NODE_1940_length_684_cov_36.254237_g1856_i0	PRJNA551951	1940	684	36.254237	247.97898108	Deinococcus	1298	Bacteria	Bacteria	1179	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g1856	i0	99.385	3.81286549707602	650	4	95	0	23	672	567777	568426	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	2608	1179	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis

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