metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax_phylum = "Thermomicrobiota"

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
2199603	2199603	PRJNA944406_P_NODE_16982_length_314_cov_3.004149_g16023_i0	PRJNA944406	16982	314	3.004149	9.43302786	uncultured Thermomicrobia bacterium	384764	Bacteria	Bacteria	468	2.46e-127	NTclustered	gi\|333034894\|gb\|JF706686.1\|	384764	g16023	i0	93.671	99.2101910828026	316	15	100	5	1	314	1375	1063	Uncultured Thermomicrobia bacterium clone w1-23 16S ribosomal RNA gene, partial sequence	blastn	31152	468	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia				uncultured Thermomicrobia bacterium
2535210	2535210	PRJNA944406_P_NODE_61422_length_252_cov_1.720670_g60463_i0	PRJNA944406	61422	252	1.72067	4.3360884	Thermomicrobium	499	Bacteria	Bacteria	246	9.77e-61	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g60463	i0	89.637	388.956349206349	193	20	77	0	60	252	2855	2663	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	98017	246	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
5087693	5087693	PRJNA944406_P_NODE_28964_length_283_cov_1.304762_g28005_i0	PRJNA944406	28964	283	1.304762	3.69247646	Sphaerobacter	2056	Bacteria	Bacteria	154	6.96e-33	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g28005	i0	83.152	120.932862190813	184	15	60	10	3	172	91	272	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	34224	154	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
6363406	6363406	PRJNA944406_P_NODE_17005_length_314_cov_1.871369_g16046_i0	PRJNA944406	17005	314	1.871369	5.87609866	Sphaerobacter	2056	Bacteria	Bacteria	196	1.28e-45	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g16046	i0	81.569	115.248407643312	255	32	78	11	71	314	297	47	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	36188	196	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
6363511	6363511	PRJNA944406_P_NODE_4645_length_609_cov_1.897388_g3715_i0	PRJNA944406	4645	609	1.897388	11.55509292	Sphaerobacter	2056	Bacteria	Bacteria	460	8.46e-125	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g3715	i0	82.998	185.532019704434	547	55	89	25	2	540	764	1280	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	112989	462	0.995670995670996	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8577610	8577610	PRJNA944406_P_NODE_55987_length_257_cov_2.255435_g55028_i0	PRJNA944406	55987	257	2.255435	5.79646795	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	152	2.24e-32	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g55028	i0	82.955	69.6108949416342	176	22	68	6	41	216	581478	581311	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	17890	152	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8912280	8912280	PRJNA944406_P_NODE_45567_length_267_cov_1.587629_g44608_i0	PRJNA944406	45567	267	1.587629	4.23896943	Bacteria	2	Bacteria	Bacteria	233	8.13e-57	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g44608	i0	84.362	252.104868913858	243	33	90	3	21	259	973	1214	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	67312	235	0.991489361702128	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8912368	8912368	PRJNA944406_P_NODE_70987_length_250_cov_0.870056_g70028_i0	PRJNA944406	70987	250	0.870056	2.17514	Sphaerobacter	2056	Bacteria	Bacteria	244	3.48e-60	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g70028	i0	84.585	216.828	253	32	99	7	1	249	1109	860	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	54207	244	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
11463242	11463242	PRJNA944406_P_NODE_349_length_1919_cov_11.359697_g194_i0	PRJNA944406	349	1919	11.359697	217.99258543	Sphaerobacter	2056	Bacteria	Bacteria	1225	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g194	i0	78.966	151.478895257947	1935	306	98	81	32	1909	2	1892	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	290688	1225	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
11463372	11463372	PRJNA944406_P_NODE_8049_length_441_cov_2.429348_g7092_i0	PRJNA944406	8049	441	2.429348	10.71342468	Sphaerobacter	2056	Bacteria	Bacteria	302	3.83e-77	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g7092	i0	80.094	60.2380952380952	427	68	95	13	4	422	593	176	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	26565	302	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
12738990	12738990	PRJNA944406_P_NODE_8750_length_421_cov_1.149425_g7793_i0	PRJNA944406	8750	421	1.149425	4.83907925	Bacteria	2	Bacteria	Bacteria	363	1.6499999999999994e-95	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g7793	i0	82.436	141.09026128266	427	63	99	9	1	418	2002	2425	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	59399	363	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
14952495	14952495	PRJNA944406_P_NODE_44512_length_268_cov_1.579487_g43553_i0	PRJNA944406	44512	268	1.579487	4.23302516	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	496	9.429999999999999e-136	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g43553	i0	100	1	268	0	100	0	1	268	780959	780692	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	268	496	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
15287273	15287273	PRJNA944406_P_NODE_1372_length_1177_cov_2.577899_g856_i0	PRJNA944406	1372	1177	2.577899	30.34187123	Sphaerobacter	2056	Bacteria	Bacteria	815	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g856	i0	79.597	129.514018691589	1191	201	99	34	1	1168	1193	22	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	152438	815	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
16227006	16227006	PRJNA944406_P_NODE_102133_length_242_cov_1.733728_g101174_i0	PRJNA944406	102133	242	1.733728	4.19562176	Thermomicrobium roseum	500	Bacteria	Bacteria	158	4.49e-34	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g101174	i0	81.915	51.4586776859504	188	32	77	2	1	187	1625021	1624835	Thermomicrobium roseum DSM 5159, complete genome	blastn	12453	158	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
17836794	17836794	PRJNA944406_P_NODE_28874_length_283_cov_1.376190_g27915_i0	PRJNA944406	28874	283	1.37619	3.8946177	Bacteria	2	Bacteria	Bacteria	198	3.1699999999999993e-46	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g27915	i0	81.6	36.7067137809187	250	37	87	9	39	283	1267	1512	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	10388	198	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
17836876	17836876	PRJNA944406_P_NODE_474_length_1740_cov_3.844031_g258_i0	PRJNA944406	474	1740	3.844031	66.8861394	Sphaerobacter	2056	Bacteria	Bacteria	1188	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g258	i0	81.279	329.736206896552	1533	230	87	49	233	1740	443	1943	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	573741	1188	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
17836913	17836913	PRJNA944406_P_NODE_55794_length_258_cov_1.248649_g54835_i0	PRJNA944406	55794	258	1.248649	3.22151442	Pseudomonadati	3379134	Bacteria	Bacteria	272	1.6599999999999999e-68	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g54835	i0	87.137	1033.12015503876	241	30	93	1	1	240	2626	2866	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	266545	272	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
17837053	17837053	PRJNA944406_P_NODE_9774_length_398_cov_1.578462_g8815_i0	PRJNA944406	9774	398	1.578462	6.28227876	Sphaerobacter	2056	Bacteria	Bacteria	204	9.94e-48	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g8815	i0	81.102	15.2638190954774	254	48	64	0	130	383	2965	2712	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	6075	204	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
19110662	19110662	PRJNA944406_P_NODE_10035_length_393_cov_3.000000_g9076_i0	PRJNA944406	10035	393	3	11.79	Sphaerobacter	2056	Bacteria	Bacteria	171	9.95e-38	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g9076	i0	76.369	115.36641221374	347	65	87	13	47	386	173	509	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	45339	171	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
19110774	19110774	PRJNA944406_P_NODE_25135_length_287_cov_1.060748_g24176_i0	PRJNA944406	25135	287	1.060748	3.04434676	Sphaerobacter	2056	Bacteria	Bacteria	147	1.18e-30	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g24176	i0	79.828	126.226480836237	233	22	74	14	75	287	275	48	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	36227	147	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
19110827	19110827	PRJNA944406_P_NODE_41535_length_271_cov_1.500000_g40576_i0	PRJNA944406	41535	271	1.5	4.065	Sphaerobacter	2056	Bacteria	Bacteria	285	2.25e-72	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g40576	i0	89.224	288.210332103321	232	20	85	5	38	266	1248	1019	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	78105	285	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
21661560	21661560	PRJNA944406_P_NODE_1077_length_1310_cov_1.885206_g653_i0	PRJNA944406	1077	1310	1.885206	24.6961986	Sphaerobacter	2056	Bacteria	Bacteria	1103	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g653	i0	83.623	425.186259541985	1209	162	91	31	93	1282	343	1534	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	556994	1103	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
22937115	22937115	PRJNA944406_P_NODE_17978_length_309_cov_1.351695_g17019_i0	PRJNA944406	17978	309	1.351695	4.17673755	Sphaerobacter	2056	Bacteria	Bacteria	148	3.5799999999999995e-31	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g17019	i0	80.976	18.8122977346278	205	23	62	8	118	308	267	65	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	5813	148	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
24210977	24210977	PRJNA944406_P_NODE_27259_length_284_cov_2.677725_g26300_i0	PRJNA944406	27259	284	2.677725	7.604739	Sphaerobacter	2056	Bacteria	Bacteria	172	1.93e-38	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g26300	i0	80.159	111.419014084507	252	33	84	10	1	238	50	298	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	31643	172	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25485944	25485944	PRJNA944406_P_NODE_14780_length_333_cov_2.034615_g13821_i0	PRJNA944406	14780	333	2.034615	6.77526795	Sphaerobacter	2056	Bacteria	Bacteria	126	1.82e-24	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g13821	i0	93.103	16.3633633633634	87	5	26	1	247	333	268	183	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	5449	126	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
25486051	25486051	PRJNA944406_P_NODE_4360_length_633_cov_1.601786_g3442_i0	PRJNA944406	4360	633	1.601786	10.13930538	Sphaerobacter	2056	Bacteria	Bacteria	387	1.52e-102	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g3442	i0	78.281	43.5150078988942	640	112	99	23	5	633	1234	1857	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	27545	387	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus

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