metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
1802412	1802412	PRJNA556992_P_NODE_290882_length_290_cov_2.129032_g288693_i0	PRJNA556992	290882	290	2.129032	6.1741928	uncultured Sphaerobacter sp.	211440	Bacteria	Bacteria	479	1.0399999999999996e-130	NTclustered	gi\|389546711\|gb\|JQ401639.1\|	211440	g288693	i0	96.54	96.9586206896552	289	10	99	0	2	290	1	289	Uncultured Sphaerobacter sp. clone CNY_01802 16S ribosomal RNA gene, partial sequence	blastn	28118	479	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	uncultured Sphaerobacter sp.
2401902	2401902	PRJNA556992_P_NODE_49802_length_513_cov_8.231818_g47642_i0	PRJNA556992	49802	513	8.231818	42.22922634	Sphaerobacter	2056	Bacteria	Bacteria	298	5.84e-76	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g47642	i0	77.714	184.510721247563	525	91	98	18	1	505	561	43	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	94654	298	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
3079332	3079332	PRJNA556992_P_NODE_41223_length_552_cov_149.860125_g39076_i0	PRJNA556992	41223	552	149.860125	827.22789	uncultured Sphaerobacter sp.	211440	Bacteria	Bacteria	883	0	NTclustered	gi\|389546727\|gb\|JQ401655.1\|	211440	g39076	i0	95.978	96.7554347826087	547	16	99	4	1	545	543	1	Uncultured Sphaerobacter sp. clone CNY_01820 16S ribosomal RNA gene, partial sequence	blastn	53409	883	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	uncultured Sphaerobacter sp.
4355644	4355644	PRJNA556992_P_NODE_41224_length_552_cov_149.572025_g39077_i0	PRJNA556992	41224	552	149.572025	825.637578	uncultured Sphaerobacter sp.	211440	Bacteria	Bacteria	878	0	NTclustered	gi\|389546727\|gb\|JQ401655.1\|	211440	g39077	i0	95.795	96.7554347826087	547	17	99	4	8	552	1	543	Uncultured Sphaerobacter sp. clone CNY_01820 16S ribosomal RNA gene, partial sequence	blastn	53409	878	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	uncultured Sphaerobacter sp.
4358444	4358444	PRJNA556992_P_NODE_636544_length_256_cov_1.661202_g634355_i0	PRJNA556992	636544	256	1.661202	4.25267712	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	147	1.04e-30	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g634355	i0	77.432	14.4609375	257	50	99	8	4	256	1101621	1101369	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	3702	147	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
4361404	4361404	PRJNA556992_P_NODE_868344_length_242_cov_2.769231_g866154_i0	PRJNA556992	868344	242	2.769231	6.70153902	Thermomicrobium roseum	500	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|221157271\|gb\|CP001276.1\|	309801	g866154	i0	81.443	3.81404958677686	194	36	80	0	6	199	401480	401287	Thermomicrobium roseum DSM 5159 plasmid, complete sequence	blastn	923	159	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
4954676	4954676	PRJNA556992_P_NODE_51844_length_506_cov_2.327945_g49684_i0	PRJNA556992	51844	506	2.327945	11.7794017	Sphaerobacter	2056	Bacteria	Bacteria	270	1.26e-67	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g49684	i0	76.879	91.0237154150198	519	95	99	15	6	506	525	14	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	46058	270	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
5632332	5632332	PRJNA556992_P_NODE_41605_length_550_cov_136.385744_g39457_i0	PRJNA556992	41605	550	136.385744	750.121592	uncultured Sphaerobacter sp.	211440	Bacteria	Bacteria	926	0	NTclustered	gi\|389546727\|gb\|JQ401655.1\|	211440	g39457	i0	97.422	96.9527272727273	543	14	99	0	1	543	543	1	Uncultured Sphaerobacter sp. clone CNY_01820 16S ribosomal RNA gene, partial sequence	blastn	53324	926	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	uncultured Sphaerobacter sp.
6228927	6228927	PRJNA556992_P_NODE_18325_length_788_cov_22.422378_g16457_i0	PRJNA556992	18325	788	22.422378	176.68833864	Sphaerobacter	2056	Bacteria	Bacteria	350	2.5e-91	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g16457	i0	77.796	173.748730964467	617	103	76	24	41	635	10	614	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	136914	350	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
7503313	7503313	PRJNA556992_P_NODE_18326_length_788_cov_21.840559_g16458_i0	PRJNA556992	18326	788	21.840559	172.10360492	Sphaerobacter	2056	Bacteria	Bacteria	316	2.5399999999999992e-81	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g16458	i0	76.973	162.93654822335	621	101	76	26	41	635	10	614	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	128394	316	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
7503392	7503392	PRJNA556992_P_NODE_199926_length_327_cov_2.425197_g197738_i0	PRJNA556992	199926	327	2.425197	7.93039419	Sphaerobacter	2056	Bacteria	Bacteria	171	8.139999999999999e-38	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g197738	i0	76.716	137.085626911315	335	60	99	17	2	327	545	220	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	44827	171	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
7504066	7504066	PRJNA556992_P_NODE_35846_length_584_cov_11.054795_g33721_i0	PRJNA556992	35846	584	11.054795	64.5600028	Sphaerobacter	2056	Bacteria	Bacteria	285	5.23e-72	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g33721	i0	79.233	226.166095890411	443	67	74	24	1	431	185	614	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	132081	285	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
7504680	7504680	PRJNA556992_P_NODE_525826_length_265_cov_1.604167_g523637_i0	PRJNA556992	525826	265	1.604167	4.25104255	Sphaerobacter	2056	Bacteria	Bacteria	183	8.229999999999998e-42	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g523637	i0	86.286	77.7094339622642	175	17	64	4	96	265	1680	1852	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	20593	183	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
10055258	10055258	PRJNA556992_P_NODE_584808_length_260_cov_2.026738_g582619_i0	PRJNA556992	584808	260	2.026738	5.2695188	Thermomicrobium	499	Bacteria	Bacteria	241	4.71e-59	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g582619	i0	83.858	28.1	254	39	97	2	4	255	2713	2966	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	7306	241	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
13879423	13879423	PRJNA556992_P_NODE_2271_length_1968_cov_6.091821_g1804_i0	PRJNA556992	2271	1968	6.091821	119.88703728	Sphaerobacter	2056	Bacteria	Bacteria	1254	0	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g1804	i0	78.762	253.080284552846	2020	322	100	75	1	1968	1977	13	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	498062	1254	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
13879434	13879434	PRJNA556992_P_NODE_229151_length_312_cov_2.468619_g226963_i0	PRJNA556992	229151	312	2.468619	7.70209128	Sphaerobacter	2056	Bacteria	Bacteria	91.6	6.18e-14	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g226963	i0	85.556	52.3237179487179	90	9	28	4	3	90	227	314	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	16325	91.6	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
15155845	15155845	PRJNA556992_P_NODE_881012_length_242_cov_0.911243_g878822_i0	PRJNA556992	881012	242	0.911243	2.20520806	Pseudomonadati	3379134	Bacteria	Bacteria	121	5.889999999999999e-23	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g878822	i0	93.75	35.0454545454545	80	5	33	0	19	98	1909268	1909347	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	8481	121	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
16427710	16427710	PRJNA556992_P_NODE_144933_length_362_cov_1.927336_g142745_i0	PRJNA556992	144933	362	1.927336	6.97695632	Thermomicrobium	499	Bacteria	Bacteria	409	1.7699999999999997e-109	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g142745	i0	87.43	391.779005524862	358	41	99	4	6	362	2966	2612	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	141824	409	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
17703176	17703176	PRJNA556992_P_NODE_18274_length_789_cov_20.858939_g16408_i0	PRJNA556992	18274	789	20.858939	164.57702871	Sphaerobacter	2056	Bacteria	Bacteria	322	5.47e-83	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g16408	i0	77.097	173.645120405577	620	103	76	29	41	636	10	614	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	137006	322	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
18976743	18976743	PRJNA556992_P_NODE_217695_length_318_cov_1.257143_g215507_i0	PRJNA556992	217695	318	1.257143	3.99771474	Sphaerobacter	2056	Bacteria	Bacteria	276	1.62e-69	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g215507	i0	82.911	269.896226415094	316	45	98	7	2	314	453	762	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	85827	276	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
18978044	18978044	PRJNA556992_P_NODE_543155_length_263_cov_3.747368_g540966_i0	PRJNA556992	543155	263	3.747368	9.85557784	Thermomicrobium	499	Bacteria	Bacteria	195	3.77e-45	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g540966	i0	80.37	775.946768060836	270	41	100	11	1	263	909	645	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	204074	195	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
18978830	18978830	PRJNA556992_P_NODE_785315_length_247_cov_0.885057_g783125_i0	PRJNA556992	785315	247	0.885057	2.18609079	Sphaerobacter	2056	Bacteria	Bacteria	231	2.6699999999999997e-56	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g783125	i0	83.658	127.655870445344	257	30	99	4	1	245	14	270	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	31531	231	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
19654519	19654519	PRJNA556992_P_NODE_393216_length_277_cov_2.250000_g391027_i0	PRJNA556992	393216	277	2.25	6.2325	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	165	3.14e-36	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g391027	i0	79.537	1.79061371841155	259	32	87	15	1	241	1710959	1711214	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	496	165	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
21526438	21526438	PRJNA556992_P_NODE_1059777_length_222_cov_5.885906_g1057587_i0	PRJNA556992	1059777	222	5.885906	13.06671132	Thermomicrobium	499	Bacteria	Bacteria	222	1.42e-53	NTclustered	gi\|507148389\|ref\|NR_103192.1\|	500	g1057587	i0	85.333	29.972972972973	225	21	99	6	1	220	2713	2930	Thermomicrobium roseum strain DSM 5159 23S ribosomal RNA gene, complete sequence	blastn	6654	222	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
22208087	22208087	PRJNA556992_P_NODE_621558_length_257_cov_2.179348_g619369_i0	PRJNA556992	621558	257	2.179348	5.60092436	Thermomicrobium roseum	500	Bacteria	Bacteria	135	2.2600000000000003e-27	NTclustered	gi\|221155340\|gb\|CP001275.1\|	309801	g619369	i0	76.448	16.3696498054475	259	55	99	5	1	255	332356	332612	Thermomicrobium roseum DSM 5159, complete genome	blastn	4207	135	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Thermomicrobiales	Thermomicrobiaceae	Thermomicrobium	Thermomicrobium roseum
22802387	22802387	PRJNA556992_P_NODE_19238_length_770_cov_3.611191_g17332_i0	PRJNA556992	19238	770	3.611191	27.8061707	Sphaerobacter	2056	Bacteria	Bacteria	420	1.8399999999999998e-112	NTclustered	gi\|470485500\|ref\|NR_076704.1\|	2057	g17332	i0	77.793	51.7649350649351	725	132	92	25	34	743	732	22	Sphaerobacter thermophilus strain S 6022 23S ribosomal RNA gene, complete sequence	blastn	39859	420	1	Bacteria	Pseudomonadati	Thermomicrobiota	Thermomicrobia	Sphaerobacterales	Sphaerobacteraceae	Sphaerobacter	Sphaerobacter thermophilus
24761121	24761121	PRJNA556992_P_NODE_935800_length_237_cov_3.000000_g933610_i0	PRJNA556992	935800	237	3	7.11	Sphaerobacter thermophilus	2057	Bacteria	Bacteria	169	2.0199999999999997e-37	NTclustered	gi\|269785296\|gb\|CP001823.1\|	479434	g933610	i0	87.838	1.40928270042194	148	13	62	4	22	167	1711211	1711067	Sphaerobacter thermophilus DSM 20745 chromosome 1, complete sequence	blastn	334	169	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);;