metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA641707" and tax_phylum = "Rhodothermota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
614264	614264	PRJNA641707_P_NODE_253481_length_181_cov_1.545455_g250818_i0	PRJNA641707	253481	181	1.545455	2.79727355	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	147	6.859999999999999e-31	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g250818	i0	82.022	6.25966850828729	178	26	97	6	6	180	1863752	1863578	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1133	147	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
1157087	1157087	PRJNA641707_P_NODE_237281_length_187_cov_7.891304_g234618_i0	PRJNA641707	237281	187	7.891304	14.75673848	Rhodothermales	1853224	Bacteria	Bacteria	220	4.15e-53	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g234618	i0	92.258	211.122994652406	155	12	83	0	29	183	2906429	2906275	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	39480	220	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
1889471	1889471	PRJNA641707_P_NODE_208842_length_195_cov_22.561644_g206179_i0	PRJNA641707	208842	195	22.561644	43.9952058	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	111	2.74e-20	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g206179	i0	88.889	7.59487179487179	90	10	46	0	6	95	1657508	1657419	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1481	111	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
1889782	1889782	PRJNA641707_P_NODE_221722_length_192_cov_67.790210_g219059_i0	PRJNA641707	221722	192	67.79021	130.1572032	Rhodothermales bacterium	2306054	Bacteria	Bacteria	296	6.92e-76	NTclustered	gi\|2893358395\|emb\|OZ220686.1\|	2306054	g219059	i0	95.187	378.5	187	9	97	0	6	192	1666565	1666379	MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1	blastn	72672	296	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
3167570	3167570	PRJNA641707_P_NODE_52543_length_296_cov_13.040486_g49884_i0	PRJNA641707	52543	296	13.040486	38.59983856	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	337	6.78e-88	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g49884	i0	87.847	88.8581081081081	288	34	97	1	3	289	805766	805479	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	26302	337	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
4985335	4985335	PRJNA641707_P_NODE_24004_length_444_cov_37.415190_g21437_i0	PRJNA641707	24004	444	37.41519	166.1234436	Rubrivirga	1434037	Bacteria	Bacteria	462	1.6699999999999998e-125	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g21437	i0	86.009	211.871621621622	436	55	98	6	12	444	805349	805781	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	94071	462	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
8269746	8269746	PRJNA641707_P_NODE_42627_length_333_cov_9.348592_g39983_i0	PRJNA641707	42627	333	9.348592	31.13081136	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	420	7.47e-113	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g39983	i0	89.759	229.930930930931	332	29	99	5	5	333	1309242	1308913	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	76567	420	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
9540726	9540726	PRJNA641707_P_NODE_164128_length_205_cov_6.641026_g161465_i0	PRJNA641707	164128	205	6.641026	13.6141033	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	148	2.22e-31	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g161465	i0	80.905	1.94146341463415	199	28	96	8	3	198	3829832	3829641	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	398	148	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
9542412	9542412	PRJNA641707_P_NODE_236568_length_187_cov_18.869565_g233905_i0	PRJNA641707	236568	187	18.869565	35.28608655	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	202	1.4999999999999996e-47	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g233905	i0	87.861	2.24064171122995	173	19	92	2	12	183	1535217	1535046	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	419	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
10816841	10816841	PRJNA641707_P_NODE_182269_length_200_cov_2.715232_g179606_i0	PRJNA641707	182269	200	2.715232	5.430464	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	121	4.7e-23	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g179606	i0	89.474	14.93	95	10	48	0	9	103	4070050	4069956	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	2986	121	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
13367993	13367993	PRJNA641707_P_NODE_234151_length_188_cov_12.446043_g231488_i0	PRJNA641707	234151	188	12.446043	23.39856084	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	111	2.62e-20	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g231488	i0	89.888	1.53191489361702	89	5	46	2	102	188	1313158	1313072	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	288	111	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
13368125	13368125	PRJNA641707_P_NODE_240071_length_186_cov_6.569343_g237408_i0	PRJNA641707	240071	186	6.569343	12.21897798	Rhodothermus marinus	29549	Bacteria	Bacteria	71.3	4.39e-8	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g237408	i0	85.507	0.370967741935484	69	8	37	2	119	186	2507092	2507025	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	69	71.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
13368376	13368376	PRJNA641707_P_NODE_251791_length_181_cov_8.575758_g249128_i0	PRJNA641707	251791	181	8.575758	15.52212198	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	130	6.9e-26	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g249128	i0	82.581	0.856353591160221	155	19	83	6	25	175	2589174	2589024	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	155	130	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
13911998	13911998	PRJNA641707_P_NODE_55331_length_287_cov_189.138655_g52670_i0	PRJNA641707	55331	287	189.138655	542.82793985	Pseudomonadati	3379134	Bacteria	Bacteria	187	6.9699999999999984e-43	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g52670	i0	82.87	186.331010452962	216	29	74	7	6	217	2736	2947	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	53477	187	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
14643862	14643862	PRJNA641707_P_NODE_283852_length_169_cov_2.725000_g281189_i0	PRJNA641707	283852	169	2.725	4.60525	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	78.7	2.33e-10	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g281189	i0	89.062	1.14792899408284	64	5	37	2	102	164	1614702	1614640	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	194	78.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
15914881	15914881	PRJNA641707_P_NODE_154673_length_228_cov_2.770950_g152010_i0	PRJNA641707	154673	228	2.77095	6.317766	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	180	8.94e-41	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g152010	i0	87.342	198.236842105263	158	19	69	1	53	210	3833052	3832896	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	45198	180	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
17195622	17195622	PRJNA641707_P_NODE_97874_length_246_cov_4.517766_g95211_i0	PRJNA641707	97874	246	4.517766	11.11370436	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	150	7.659999999999999e-32	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g95211	i0	94.792	34.869918699187	96	5	39	0	6	101	4229836	4229931	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	8578	150	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
19737823	19737823	PRJNA641707_P_NODE_109796_length_246_cov_2.908629_g107133_i0	PRJNA641707	109796	246	2.908629	7.15522734	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	87.9	6.09e-13	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g107133	i0	82.653	0.752032520325203	98	17	40	0	4	101	4231554	4231457	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	185	87.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
19738949	19738949	PRJNA641707_P_NODE_16016_length_541_cov_40.581301_g13642_i0	PRJNA641707	16016	541	40.581301	219.54483841	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	407	9.849999999999998e-109	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g13642	i0	95.331	309.286506469501	257	10	92	2	6	261	3833139	3832884	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	167324	407	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
20284335	20284335	PRJNA641707_P_NODE_46456_length_318_cov_3.412639_g43804_i0	PRJNA641707	46456	318	3.412639	10.85219202	Rhodothermales	1853224	Bacteria	Bacteria	451	2.51e-122	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g43804	i0	92.652	308.427672955975	313	23	98	0	1	313	2906002	2906314	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	98080	451	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
21019799	21019799	PRJNA641707_P_NODE_85317_length_246_cov_6.659898_g82654_i0	PRJNA641707	85317	246	6.659898	16.38334908	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	75	4.74e-9	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g82654	i0	84.932	0.59349593495935	73	11	30	0	1	73	1123681	1123609	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	146	75	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
21020065	21020065	PRJNA641707_P_NODE_96897_length_246_cov_4.654822_g94234_i0	PRJNA641707	96897	246	4.654822	11.45086212	Rhodothermales bacterium	2306054	Bacteria	Bacteria	158	4.58e-34	NTclustered	gi\|2891482048\|emb\|OZ219799.1\|	2306054	g94234	i0	93.396	189.170731707317	106	7	43	0	136	241	479055	478950	MAG: Rhodothermales bacterium isolate da3e7c24-c5f3-4507-9669-19e8aa5a93cb genome assembly, chromosome: 1	blastn	46536	158	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
23563950	23563950	PRJNA641707_P_NODE_124279_length_245_cov_4.306122_g121616_i0	PRJNA641707	124279	245	4.306122	10.5499989	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	145	3.5499999999999996e-30	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g121616	i0	93.75	47.1265306122449	96	6	72	0	147	242	1513339	1513434	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	11546	145	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
23566228	23566228	PRJNA641707_P_NODE_223879_length_192_cov_5.650350_g221216_i0	PRJNA641707	223879	192	5.65035	10.848672	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	69.4	1.64e-7	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g221216	i0	80.851	1.13020833333333	94	12	47	4	101	191	2896569	2896659	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	217	69.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
23569050	23569050	PRJNA641707_P_NODE_39039_length_348_cov_8.374582_g36399_i0	PRJNA641707	39039	348	8.374582	29.14354536	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	525	1.6199999999999995e-144	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g36399	i0	94.444	96.5804597701149	342	18	98	1	8	348	3831624	3831965	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	33610	525	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
23569813	23569813	PRJNA641707_P_NODE_71359_length_248_cov_3.301508_g68696_i0	PRJNA641707	71359	248	3.301508	8.18773984	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	122	1.69e-23	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g68696	i0	94.872	0.314516129032258	78	4	31	0	168	245	1118690	1118767	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	78	122	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
24109587	24109587	PRJNA641707_P_NODE_328519_length_155_cov_2.547170_g325856_i0	PRJNA641707	328519	155	2.54717	3.9481135	Rhodothermales	1853224	Bacteria	Bacteria	182	1.56e-41	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g325856	i0	89.189	3.06451612903226	148	12	94	3	2	147	2962940	2963085	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	475	182	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
24842973	24842973	PRJNA641707_P_NODE_51920_length_298_cov_13.983936_g49262_i0	PRJNA641707	51920	298	13.983936	41.67212928	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	156	2.05e-33	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g49262	i0	83.832	6.50335570469799	167	24	88	3	133	298	3806232	3806396	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1938	156	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25384502	25384502	PRJNA641707_P_NODE_6940_length_808_cov_169.623188_g5293_i0	PRJNA641707	6940	808	169.623188	1370.55535904	Rhodothermales	1853224	Bacteria	Bacteria	734	0	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g5293	i0	83.924	203.404702970297	790	103	96	19	35	808	2904961	2905742	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	164351	734	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA

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