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

25 rows where analysis = "blastn", bioproject = "PRJNA694770" 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
1181196	1181196	PRJNA694770_P_NODE_78021_length_251_cov_0.865169_g77727_i0	PRJNA694770	78021	251	0.865169	2.17157419	Thermus	270	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2701837056\|dbj\|AP031332.1\|	274	g77727	i0	100	98.4661354581673	251	0	100	0	1	251	221310	221060	Thermus thermophilus TF27 DNA, complete genome	blastn	24715	464	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus thermophilus
1951518	1951518	PRJNA694770_P_NODE_81282_length_250_cov_0.870056_g80988_i0	PRJNA694770	81282	250	0.870056	2.17514	Deinococcus proteolyticus	55148	Bacteria	Bacteria	152	2.17e-32	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g80988	i0	78.512	5.536	242	45	95	7	2	239	1851963	1851725	Deinococcus proteolyticus MRP, complete genome	blastn	1384	152	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
1951841	1951841	PRJNA694770_P_NODE_92942_length_244_cov_0.900585_g92648_i0	PRJNA694770	92942	244	0.900585	2.1974274	Deinococcus ficus	317577	Bacteria	Bacteria	440	4.019999999999999e-119	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g92648	i0	99.18	1.60655737704918	244	2	100	0	1	244	1390060	1389817	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	392	440	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
3226181	3226181	PRJNA694770_P_NODE_68603_length_266_cov_1.595855_g68309_i0	PRJNA694770	68603	266	1.595855	4.2449743	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	193	1.37e-44	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g68309	i0	80.077	0.981203007518797	261	50	98	2	1	260	1988149	1988408	Thermus sp. NEB1569 chromosome, complete genome	blastn	261	193	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
3732440	3732440	PRJNA694770_P_NODE_46843_length_306_cov_1.017167_g46549_i0	PRJNA694770	46843	306	1.017167	3.11253102	Deinococcus	1298	Bacteria	Bacteria	538	1.8e-148	NTclustered	gi\|470488003\|ref\|NR_076846.1\|	55148	g46549	i0	98.371	208.506535947712	307	4	100	1	1	306	1440	1746	Deinococcus proteolyticus strain MRP 23S ribosomal RNA gene, complete sequence	blastn	63803	538	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
5779250	5779250	PRJNA694770_P_NODE_89005_length_246_cov_0.890173_g88711_i0	PRJNA694770	89005	246	0.890173	2.18982558	Deinococcus ficus	317577	Bacteria	Bacteria	394	3.2e-105	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g88711	i0	95.528	1.84959349593496	246	11	100	0	1	246	42079	41834	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	455	394	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
9604256	9604256	PRJNA694770_P_NODE_90088_length_246_cov_0.890173_g89794_i0	PRJNA694770	90088	246	0.890173	2.18982558	Deinococcus soli (ex Cha et al. 2016)	1309411	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|821341785\|gb\|CP011389.1\|	1309411	g89794	i0	100	5.94308943089431	246	0	100	0	1	246	1041827	1041582	'Deinococcus soli' Cha et al. 2014 strain N5, complete genome	blastn	1462	455	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus soli (ex Cha et al. 2016)
10878538	10878538	PRJNA694770_P_NODE_43969_length_314_cov_1.597510_g43675_i0	PRJNA694770	43969	314	1.59751	5.0161814	Deinococcus aetherius	200252	Bacteria	Bacteria	459	1.48e-124	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g43675	i0	92.994	185.646496815287	314	22	100	0	1	314	82620	82933	Deinococcus aetherius ST0316 DNA, complete genome	blastn	58293	459	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
12153874	12153874	PRJNA694770_P_NODE_52090_length_291_cov_1.967890_g51796_i0	PRJNA694770	52090	291	1.96789	5.7265599	Acetomicrobium mobile	97477	Bacteria	Bacteria	87.9	7.39e-13	NTclustered	gi\|390619527\|gb\|CP003198.1\|	891968	g51796	i0	98	17.8178694158076	50	1	17	0	1	50	523217	523266	Acetomicrobium mobile DSM 13181 chromosome, complete genome	blastn	5185	87.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Acetomicrobiaceae	Acetomicrobium	Acetomicrobium mobile
12154762	12154762	PRJNA694770_P_NODE_83630_length_249_cov_0.875000_g83336_i0	PRJNA694770	83630	249	0.875	2.17875	Deinococcus ficus	317577	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g83336	i0	97.189	1	249	7	100	0	1	249	2213475	2213723	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	249	422	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
13428737	13428737	PRJNA694770_P_NODE_60931_length_278_cov_1.502439_g60637_i0	PRJNA694770	60931	278	1.502439	4.17678042	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	217	8.569999999999999e-52	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g60637	i0	86.979	0.690647482014389	192	25	69	0	87	278	493977	493786	Deinococcus sp. NW-56 chromosome, complete genome	blastn	192	217	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
13429117	13429117	PRJNA694770_P_NODE_74611_length_256_cov_1.683060_g74317_i0	PRJNA694770	74611	256	1.68306	4.3086336	Deinococcus ficus	317577	Bacteria	Bacteria	435	1.98e-117	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g74317	i0	97.266	1.82421875	256	7	100	0	1	256	326294	326549	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	467	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
13429676	13429676	PRJNA694770_P_NODE_95091_length_243_cov_0.905882_g94797_i0	PRJNA694770	95091	243	0.905882	2.20129326	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g94797	i0	100	10.4444444444444	243	0	100	0	1	243	1978658	1978416	Thermus sp. NEB1569 chromosome, complete genome	blastn	2538	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
13933903	13933903	PRJNA694770_P_NODE_14851_length_486_cov_1.043584_g14557_i0	PRJNA694770	14851	486	1.043584	5.07181824	Deinococcus	1298	Bacteria	Bacteria	721	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g14557	i0	93.958	206.730452674897	480	23	98	4	12	486	424454	423976	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	100471	721	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
17252089	17252089	PRJNA694770_P_NODE_33414_length_349_cov_2.032609_g33120_i0	PRJNA694770	33414	349	2.032609	7.09380541	Deinococcus proteolyticus	55148	Bacteria	Bacteria	399	1.0199999999999998e-106	NTclustered	gi\|324314064\|gb\|CP002536.1\|	693977	g33120	i0	87.429	219.885386819484	350	40	100	4	1	349	171217	171563	Deinococcus proteolyticus MRP, complete genome	blastn	76740	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
17252550	17252550	PRJNA694770_P_NODE_50774_length_295_cov_1.202703_g50480_i0	PRJNA694770	50774	295	1.202703	3.54797385	Deinococcus sp. VB343	3385567	Bacteria	Bacteria	320	6.8e-83	NTclustered	gi\|2905214251\|gb\|CP179946.1\|	3385567	g50480	i0	89.37	5.11525423728814	254	27	86	0	41	294	121484	121231	Deinococcus sp. VB343 chromosome 2, complete sequence	blastn	1509	320	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB343
17252944	17252944	PRJNA694770_P_NODE_64394_length_273_cov_1.210000_g64100_i0	PRJNA694770	64394	273	1.21	3.3033	Deinococcus ficus	317577	Bacteria	Bacteria	477	3.489999999999999e-130	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g64100	i0	98.168	2.4029304029304	273	5	100	0	1	273	73381	73653	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	656	477	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18526965	18526965	PRJNA694770_P_NODE_62895_length_275_cov_1.524752_g62601_i0	PRJNA694770	62895	275	1.524752	4.193068	Deinococcus ficus	317577	Bacteria	Bacteria	464	2.7399999999999998e-126	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g62601	i0	97.091	1	275	8	100	0	1	275	676488	676762	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	275	464	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
18527201	18527201	PRJNA694770_P_NODE_71675_length_261_cov_1.638298_g71381_i0	PRJNA694770	71675	261	1.638298	4.27595778	Deinococcus aetherius	200252	Bacteria	Bacteria	405	1.59e-108	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g71381	i0	94.961	11.8582375478927	258	13	99	0	4	261	1984136	1983879	Deinococcus aetherius ST0316 DNA, complete genome	blastn	3095	405	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
18527680	18527680	PRJNA694770_P_NODE_89795_length_246_cov_0.890173_g89501_i0	PRJNA694770	89795	246	0.890173	2.18982558	Deinococcus wulumuqiensis	980427	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1819263661\|gb\|CP049358.1\|	1288484	g89501	i0	99.593	16.3983739837398	246	1	100	0	1	246	22113	22358	Deinococcus wulumuqiensis R12 plasmid unnamed1, complete sequence	blastn	4034	449	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
19801409	19801409	PRJNA694770_P_NODE_4536_length_928_cov_2.261988_g4284_i0	PRJNA694770	4536	928	2.261988	20.99124864	Deinococcus sonorensis	309891	Bacteria	Bacteria	183	3.19e-41	NTclustered	gi\|2745306230\|gb\|CP158296.1\|	694439	g4284	i0	78.873	18.1961206896552	284	51	30	8	617	897	207771	207494	Deinococcus sonorensis KR-87 plasmid pDson04, complete sequence	blastn	16886	183	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sonorensis
19802088	19802088	PRJNA694770_P_NODE_70016_length_264_cov_1.356021_g69722_i0	PRJNA694770	70016	264	1.356021	3.57989544	Deinococcus peraridilitoris	432329	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|429128598\|gb\|CP003382.1\|	937777	g69722	i0	94.444	0.136363636363636	36	0	14	2	24	59	951817	951850	Deinococcus peraridilitoris DSM 19664, complete genome	blastn	36	54.7	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
23628024	23628024	PRJNA694770_P_NODE_72719_length_259_cov_1.655914_g72425_i0	PRJNA694770	72719	259	1.655914	4.28881726	Deinococcus proteolyticus	55148	Bacteria	Bacteria	207	4.76e-49	NTclustered	gi\|324316040\|gb\|CP002537.1\|	693977	g72425	i0	81.154	1.003861003861	260	47	100	2	1	259	33021	33279	Deinococcus proteolyticus MRP plasmid pDEIPR01, complete sequence	blastn	260	207	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus proteolyticus
23628208	23628208	PRJNA694770_P_NODE_79739_length_250_cov_1.689266_g79445_i0	PRJNA694770	79739	250	1.689266	4.223165	Deinococcus aetherius	200252	Bacteria	Bacteria	158	4.66e-34	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g79445	i0	88.636	19.708	132	11	52	4	120	250	2203409	2203537	Deinococcus aetherius ST0316 DNA, complete genome	blastn	4927	158	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
24901197	24901197	PRJNA694770_P_NODE_58420_length_282_cov_1.215311_g58126_i0	PRJNA694770	58420	282	1.215311	3.42717702	Deinococcus ficus	317577	Bacteria	Bacteria	392	1.35e-104	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g58126	i0	91.608	9.96808510638298	286	20	100	2	1	282	281999	281714	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	2811	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus

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