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

25 rows where analysis = "blastn", bioproject = "PRJNA934472" 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
911049	911049	PRJNA934472_P_NODE_28941_length_275_cov_2.024752_g28563_i0	PRJNA934472	28941	275	2.024752	5.568068	Deinococcus metallilatus	1211322	Bacteria	Bacteria	350	8e-92	NTclustered	gi\|1609450927\|gb\|CP038511.1\|	1211322	g28563	i0	89.892	4.15272727272727	277	20	99	6	1	273	97586	97314	Deinococcus metallilatus strain MA1002 plasmid unnamed2	blastn	1142	350	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus metallilatus
1255610	1255610	PRJNA934472_P_NODE_9521_length_459_cov_2.911917_g9144_i0	PRJNA934472	9521	459	2.911917	13.36569903	Thermus	270	Bacteria	Bacteria	837	0	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g9144	i0	99.564	151.17211328976	459	2	100	0	1	459	1320	1778	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	69388	837	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
2186642	2186642	PRJNA934472_P_NODE_39682_length_232_cov_2.358491_g39304_i0	PRJNA934472	39682	232	2.358491	5.47169912	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	333	6.619999999999999e-87	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g39304	i0	92.672	381.280172413793	232	16	100	1	1	232	57760	57530	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	88457	333	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
3461625	3461625	PRJNA934472_P_NODE_14183_length_380_cov_1.794788_g13806_i0	PRJNA934472	14183	380	1.794788	6.8201944	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	542	1.76e-149	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g13806	i0	92.428	215.947368421053	383	23	100	5	1	380	544937	544558	Deinococcus sp. NW-56 chromosome, complete genome	blastn	82060	542	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
3807480	3807480	PRJNA934472_P_NODE_10823_length_432_cov_3.938719_g10446_i0	PRJNA934472	10823	432	3.938719	17.01526608	Truepera	332248	Bacteria	Bacteria	560	5.6e-155	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g10446	i0	90.069	249.453703703704	433	41	100	2	1	432	475	44	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	107764	560	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
7289389	7289389	PRJNA934472_P_NODE_40546_length_199_cov_5.873016_g40168_i0	PRJNA934472	40546	199	5.873016	11.68730184	Trueperaceae bacterium	2026798	Bacteria	Bacteria	224	3.4599999999999996e-54	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g40168	i0	87.129	2.0251256281407	202	20	100	5	1	199	8201	8003	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	403	224	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
10184179	10184179	PRJNA934472_P_NODE_22168_length_310_cov_3.628692_g21790_i0	PRJNA934472	22168	310	3.628692	11.2489452	Deinococcus	1298	Bacteria	Bacteria	228	4.4799999999999984e-55	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g21790	i0	94.04	181.603225806452	151	8	97	1	1	150	644	794	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	56297	228	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
10184226	10184226	PRJNA934472_P_NODE_29928_length_271_cov_2.459596_g29550_i0	PRJNA934472	29928	271	2.459596	6.66550516	Deinococcus	1298	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|161513486\|emb\|AM292065.1\|	1299	g29550	i0	99.631	112.151291512915	271	1	100	0	1	271	748	478	Deinococcus radiodurans partial 16S rRNA gene, isolate zf-69-II	blastn	30393	496	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
11459244	11459244	PRJNA934472_P_NODE_17729_length_343_cov_6.422222_g17352_i0	PRJNA934472	17729	343	6.422222	22.02822146	Deinococcus	1298	Bacteria	Bacteria	390	6.049999999999999e-104	NTclustered	gi\|2281898870\|dbj\|AP026562.1\|	200252	g17352	i0	87.611	303.157434402332	339	39	99	3	6	343	299517	299181	Deinococcus aetherius ST0316 plasmid pDAETH-2 DNA, complete genome	blastn	103983	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
13664483	13664483	PRJNA934472_P_NODE_22251_length_310_cov_1.721519_g21873_i0	PRJNA934472	22251	310	1.721519	5.3367089	Thermus sp. NEB1569	2918899	Bacteria	Bacteria	562	1.08e-155	NTclustered	gi\|2199052145\|gb\|CP092445.1\|	2918899	g21873	i0	99.355	148	310	2	100	0	1	310	410298	409989	Thermus sp. NEB1569 chromosome, complete genome	blastn	45880	562	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. NEB1569
13664899	13664899	PRJNA934472_P_NODE_5491_length_588_cov_3.660194_g5180_i0	PRJNA934472	5491	588	3.660194	21.52194072	Deinococcus ficus	317577	Bacteria	Bacteria	909	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g5180	i0	96.085	208.068027210884	562	14	95	6	29	586	2342709	2342152	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	122344	909	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
14009594	14009594	PRJNA934472_P_NODE_35371_length_250_cov_2.231638_g34993_i0	PRJNA934472	35371	250	2.231638	5.579095	Bacteria	2	Bacteria	Bacteria	231	2.7099999999999996e-56	NTclustered	gi\|470478007\|ref\|NR_076423.1\|	68909	g34993	i0	86.385	168.24	213	28	85	1	37	249	1182	971	Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence	blastn	42060	231	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus geothermalis
14939022	14939022	PRJNA934472_P_NODE_31672_length_264_cov_2.178010_g31294_i0	PRJNA934472	31672	264	2.17801	5.7499464	Cloacibacillus evryensis	508460	Bacteria	Bacteria	411	3.4499999999999996e-110	NTclustered	gi\|2831313556\|gb\|CP171104.1\|	508460	g31294	i0	94.717	448.503787878788	265	13	100	1	1	264	117458	117722	Cloacibacillus evryensis strain WGS1925 chromosome, complete genome	blastn	118405	411	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Cloacibacillus	Cloacibacillus evryensis
16214210	16214210	PRJNA934472_P_NODE_36433_length_247_cov_2.649425_g36055_i0	PRJNA934472	36433	247	2.649425	6.54407975	Deinococcus aquaticus	328692	Bacteria	Bacteria	261	3.41e-65	NTclustered	gi\|2444120906\|gb\|CP115165.1\|	328692	g36055	i0	85.944	162.842105263158	249	29	99	6	1	246	715950	716195	Deinococcus aquaticus strain PB-314 chromosome, complete genome	blastn	40222	261	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aquaticus
16214357	16214357	PRJNA934472_P_NODE_8313_length_489_cov_6.692308_g7936_i0	PRJNA934472	8313	489	6.692308	32.72538612	uncultured Truepera sp.	543023	Bacteria	Bacteria	887	0	NTclustered	gi\|389547087\|gb\|JQ402015.1\|	543023	g7936	i0	99.387	97.8711656441718	489	3	100	0	1	489	1	489	Uncultured Truepera sp. clone CNY_02272 16S ribosomal RNA gene, partial sequence	blastn	47859	887	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	uncultured Truepera sp.
17489383	17489383	PRJNA934472_P_NODE_31034_length_267_cov_1.283505_g30656_i0	PRJNA934472	31034	267	1.283505	3.42695835	Deinococcus aetherius	200252	Bacteria	Bacteria	411	3.5e-110	NTclustered	gi\|2281894955\|dbj\|AP026560.1\|	200252	g30656	i0	94.403	113	268	14	100	1	1	267	2935599	2935332	Deinococcus aetherius ST0316 DNA, complete genome	blastn	30171	411	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus aetherius
19106989	19106989	PRJNA934472_P_NODE_39875_length_230_cov_2.082803_g39497_i0	PRJNA934472	39875	230	2.082803	4.7904469	Thermus	270	Bacteria	Bacteria	425	1.05e-114	NTclustered	gi\|470468782\|ref\|NR_076136.1\|	37636	g39497	i0	100	144.452173913043	230	0	100	0	1	230	1014	1243	Thermus scotoductus strain SA-01 23S ribosomal RNA gene, complete sequence	blastn	33224	425	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus scotoductus
20037360	20037360	PRJNA934472_P_NODE_12776_length_399_cov_2.165644_g12399_i0	PRJNA934472	12776	399	2.165644	8.64091956	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	427	5.44e-115	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g12399	i0	86.701	332.238095238095	391	44	97	6	12	399	73366	73751	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	132563	427	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
20037374	20037374	PRJNA934472_P_NODE_13676_length_386_cov_3.853035_g13299_i0	PRJNA934472	13676	386	3.853035	14.8727151	Deinococcus ficus	317577	Bacteria	Bacteria	708	0	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g13299	i0	99.741	197.178756476684	386	1	100	0	1	386	2342603	2342988	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	76111	708	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
21313425	21313425	PRJNA934472_P_NODE_897_length_1329_cov_5.894108_g752_i0	PRJNA934472	897	1329	5.894108	78.33269532	Deinococcus sp. NW-56	2080419	Bacteria	Bacteria	2041	0	NTclustered	gi\|1339790003\|gb\|CP026516.1\|	2080419	g752	i0	96.317	185.306245297216	1249	34	94	7	80	1327	543105	544342	Deinococcus sp. NW-56 chromosome, complete genome	blastn	246272	2041	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. NW-56
21657793	21657793	PRJNA934472_P_NODE_22517_length_308_cov_4.212766_g22139_i0	PRJNA934472	22517	308	4.212766	12.97531928	Thermanaerovibrio	81461	Bacteria	Bacteria	128	4.64e-25	NTclustered	gi\|470485441\|ref\|NR_076701.1\|	81462	g22139	i0	76.613	3.22077922077922	248	48	79	10	3	245	1357	1599	Thermanaerovibrio acidaminovorans strain Su883 23S ribosomal RNA gene, complete sequence	blastn	992	128	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Synergistaceae	Thermanaerovibrio	Thermanaerovibrio acidaminovorans
22933332	22933332	PRJNA934472_P_NODE_21018_length_318_cov_1.738776_g20641_i0	PRJNA934472	21018	318	1.738776	5.52930768	Deinococcus	1298	Bacteria	Bacteria	462	1.16e-125	NTclustered	gi\|545345307\|gb\|KF508539.1\|	158789	g20641	i0	92.901	101.827044025157	324	14	100	6	1	318	161	481	Uncultured Deinococcus sp. clone 8263 16S ribosomal RNA gene, partial sequence	blastn	32381	464	0.995689655172414	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	uncultured Deinococcus sp.
22933353	22933353	PRJNA934472_P_NODE_2458_length_857_cov_5.960459_g2202_i0	PRJNA934472	2458	857	5.960459	51.08113363	Truepera	332248	Bacteria	Bacteria	1229	0	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g2202	i0	92.549	169.241540256709	859	61	100	3	1	857	2107	1250	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	145040	1229	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
24207161	24207161	PRJNA934472_P_NODE_37559_length_244_cov_2.269006_g37181_i0	PRJNA934472	37559	244	2.269006	5.53637464	Deinococcus	1298	Bacteria	Bacteria	366	6.92e-97	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g37181	i0	94.872	192.05737704918	234	12	96	0	11	244	70075	69842	Deinococcus swuensis strain DY59, complete genome	blastn	46862	366	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
25482162	25482162	PRJNA934472_P_NODE_38800_length_241_cov_1.380952_g38422_i0	PRJNA934472	38800	241	1.380952	3.32809432	Thermus	270	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|2359345130\|gb\|CP102606.1\|	2849039	g38422	i0	98.755	143.414937759336	241	3	100	0	1	241	596714	596474	Thermus sp. PS18 chromosome, complete genome	blastn	34563	429	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Thermales	Thermaceae	Thermus	Thermus sp. PS18

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