metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA704949" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA704949" 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
691803	691803	PRJNA704949_P_NODE_1732561_length_182_cov_2.263158_g1717222_i0	PRJNA704949	1732561	182	2.263158	4.11894756	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	62.1	2.57e-5	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1717222	i0	85.484	0.340659340659341	62	6	32	2	112	170	2590542	2590481	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	62	62.1	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
1975482	1975482	PRJNA704949_P_NODE_634622_length_340_cov_1.597938_g619297_i0	PRJNA704949	634622	340	1.597938	5.4329892	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	363	1.31e-95	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g619297	i0	85.882	100.555882352941	340	48	100	0	1	340	1668869	1669208	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	34189	363	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
1976012	1976012	PRJNA704949_P_NODE_691862_length_324_cov_1.643636_g676534_i0	PRJNA704949	691862	324	1.643636	5.32538064	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	246	1.3000000000000002e-60	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g676534	i0	83.271	30.320987654321	269	43	83	2	38	305	1032655	1032388	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	9824	246	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
2463047	2463047	PRJNA704949_P_NODE_1879882_length_172_cov_1.268293_g1864543_i0	PRJNA704949	1879882	172	1.268293	2.18146396	Bacteria	2	Bacteria	Bacteria	137	3.87e-28	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g1864543	i0	81.176	67.9011627906977	170	32	99	0	1	170	1430212	1430381	Thermomicrobium roseum DSM 5159, complete genome	blastn	11679	137	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
3242477	3242477	PRJNA704949_P_NODE_1673083_length_187_cov_1.297101_g1657744_i0	PRJNA704949	1673083	187	1.297101	2.42557887	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	106	1.21e-18	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1657744	i0	92	1.63636363636364	75	6	40	0	112	186	2051196	2051270	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	306	106	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
3243587	3243587	PRJNA704949_P_NODE_1806923_length_177_cov_1.328125_g1791584_i0	PRJNA704949	1806923	177	1.328125	2.35078125	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	145	2.4e-30	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1791584	i0	82.716	57.4067796610169	162	28	92	0	16	177	430683	430522	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	10161	145	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
4520283	4520283	PRJNA704949_P_NODE_1755824_length_181_cov_1.181818_g1740485_i0	PRJNA704949	1755824	181	1.181818	2.13909058	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	143	8.87e-30	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g1740485	i0	86.364	3.96132596685083	132	17	72	1	21	151	143830	143961	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	717	143	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
4529514	4529514	PRJNA704949_P_NODE_834564_length_290_cov_2.921162_g819230_i0	PRJNA704949	834564	290	2.921162	8.4713698	uncultured Thermomicrobium sp.	158795	Bacteria	Bacteria	514	2.85e-141	NTclustered	gi\|71844071\|gb\|DQ130040.1\|	158795	g819230	i0	98.621	98.9068965517241	290	4	100	0	1	290	503	214	Uncultured Thermomicrobium sp. clone GR108 16S ribosomal RNA gene, partial sequence	blastn	28683	514	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	uncultured Thermomicrobium sp.
8344900	8344900	PRJNA704949_P_NODE_1714327_length_184_cov_1.155556_g1698988_i0	PRJNA704949	1714327	184	1.155556	2.12622304	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	147	7.0000000000000015e-31	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1698988	i0	81.921	0.96195652173913	177	28	95	3	1	175	1768714	1768888	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	177	147	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
8352770	8352770	PRJNA704949_P_NODE_636647_length_339_cov_2.386207_g621322_i0	PRJNA704949	636647	339	2.386207	8.08924173	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	224	6.41e-54	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g621322	i0	79.624	65.3982300884956	319	59	93	6	3	318	1463132	1463447	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	22170	224	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
9621815	9621815	PRJNA704949_P_NODE_1912168_length_170_cov_1.289256_g1896829_i0	PRJNA704949	1912168	170	1.289256	2.1917352	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	110	8.32e-20	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1896829	i0	98.387	2.12941176470588	62	1	36	0	1	62	1273207	1273146	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	362	110	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
13449998	13449998	PRJNA704949_P_NODE_295111_length_494_cov_3.797753_g280329_i0	PRJNA704949	295111	494	3.797753	18.76089982	Thermomicrobium roseum	500	Bacteria	Bacteria	106	3.65e-18	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g280329	i0	92.105	2.61336032388664	76	5	15	1	404	479	754366	754292	Thermomicrobium roseum DSM 5159, complete genome	blastn	1291	106	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
13940010	13940010	PRJNA704949_P_NODE_1300451_length_221_cov_0.906977_g1285114_i0	PRJNA704949	1300451	221	0.906977	2.00441917	Pseudomonadati	3379134	Bacteria	Bacteria	182	2.39e-41	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1285114	i0	81.735	94.0542986425339	219	38	99	2	1	218	1564291	1564074	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	20786	182	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
14728367	14728367	PRJNA704949_P_NODE_626772_length_342_cov_2.102389_g611447_i0	PRJNA704949	626772	342	2.102389	7.19017038	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	134	1.12e-26	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g611447	i0	98.667	23.2836257309942	75	1	22	0	33	107	1771889	1771815	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	7963	134	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
15998694	15998694	PRJNA704949_P_NODE_273773_length_511_cov_3.043290_g259102_i0	PRJNA704949	273773	511	3.04329	15.5512119	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	241	9.94e-59	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g259102	i0	86.916	1.15068493150685	214	28	42	0	1	214	1768675	1768888	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	588	241	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
18542427	18542427	PRJNA704949_P_NODE_1583955_length_194_cov_1.075862_g1568616_i0	PRJNA704949	1583955	194	1.075862	2.08717228	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	152	1.5999999999999998e-32	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1568616	i0	89.431	31.5412371134021	123	9	62	4	1	121	2051587	2051707	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	6119	152	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
19820744	19820744	PRJNA704949_P_NODE_1984636_length_167_cov_1.762712_g1969297_i0	PRJNA704949	1984636	167	1.762712	2.94372904	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	126	8.14e-25	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1969297	i0	81.529	4.92814371257485	157	25	93	4	2	156	430894	431048	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	823	126	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
21103006	21103006	PRJNA704949_P_NODE_763557_length_306_cov_1.961089_g748226_i0	PRJNA704949	763557	306	1.961089	6.00093234	Thermomicrobium roseum	500	Bacteria	Bacteria	69.4	2.83e-7	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g748226	i0	100	4.23529411764706	37	0	12	0	106	142	249668	249704	Thermomicrobium roseum DSM 5159, complete genome	blastn	1296	69.4	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
21103383	21103383	PRJNA704949_P_NODE_807857_length_296_cov_1.894737_g792525_i0	PRJNA704949	807857	296	1.894737	5.60842152	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	235	2.54e-57	NTclustered	gi\|269787736\|gb\|CP001824.1\|	479434	g792525	i0	84.914	19.0135135135135	232	35	78	0	1	232	811949	812180	Sphaerobacter thermophilus DSM 20745 chromosome 2, complete sequence	blastn	5628	235	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
21592671	21592671	PRJNA704949_P_NODE_779117_length_303_cov_0.956693_g763786_i0	PRJNA704949	779117	303	0.956693	2.89877979	Thermomicrobia	189775	Bacteria	Bacteria	230	1.2099999999999995e-55	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g763786	i0	85.981	33.7854785478548	214	30	71	0	90	303	193640	193853	Thermomicrobium roseum DSM 5159, complete genome	blastn	10237	231	0.995670995670996	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
23646122	23646122	PRJNA704949_P_NODE_1883639_length_172_cov_1.138211_g1868300_i0	PRJNA704949	1883639	172	1.138211	1.95772292	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	141	2.99e-29	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g1868300	i0	88.696	15.2151162790698	115	13	67	0	45	159	458808	458694	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	2617	141	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);;