metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJEB14175" and tax

18 rows where analysis = "blastn", bioproject = "PRJEB14175" 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
25502483	25502483	PRJEB14175_P_NODE_132689_length_300_cov_1.606695_g130422_i0	PRJEB14175	132689	300	1.606695	4.820085	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	270	7.08e-68	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g130422	i0	84.229	0.93	279	42	92	2	2	278	1146855	1146577	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	279	270	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25638613	25638613	PRJEB14175_P_NODE_137450_length_293_cov_2.676724_g135183_i0	PRJEB14175	137450	293	2.676724	7.84280132	Roseithermus sacchariphilus	2893045	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1417721500\|gb\|CP030158.1\|	2893045	g135183	i0	89.13	0.426621160409556	46	4	16	1	198	243	2720075	2720031	Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome	blastn	125	56.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Roseithermus	Roseithermus sacchariphilus
25640955	25640955	PRJEB14175_P_NODE_187954_length_238_cov_1.440678_g185687_i0	PRJEB14175	187954	238	1.440678	3.42881364	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	110	1.25e-19	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g185687	i0	84.685	2.45798319327731	111	15	46	2	107	216	3598593	3598702	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	585	110	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
25642648	25642648	PRJEB14175_P_NODE_227506_length_209_cov_0.864865_g225238_i0	PRJEB14175	227506	209	0.864865	1.80756785	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	178	2.9e-40	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g225238	i0	82.759	44.066985645933	203	31	96	3	1	201	3723516	3723316	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	9210	178	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
25775652	25775652	PRJEB14175_P_NODE_154779_length_271_cov_2.176190_g152512_i0	PRJEB14175	154779	271	2.17619	5.8974749	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	279	1.05e-70	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g152512	i0	87.552	2.15867158671587	241	30	89	0	24	264	2037101	2036861	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	585	279	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
25775908	25775908	PRJEB14175_P_NODE_159819_length_265_cov_3.436275_g157552_i0	PRJEB14175	159819	265	3.436275	9.10612875	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	189	1.7699999999999996e-43	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g157552	i0	93.023	5.49056603773585	129	9	49	0	128	256	1988919	1989047	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	1455	189	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
25779073	25779073	PRJEB14175_P_NODE_232891_length_208_cov_0.870748_g230623_i0	PRJEB14175	232891	208	0.870748	1.81115584	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	279	7.68e-71	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g230623	i0	91.96	88.6298076923077	199	16	96	0	10	208	3526669	3526471	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	18435	279	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25911081	25911081	PRJEB14175_P_NODE_140748_length_288_cov_8.343612_g138481_i0	PRJEB14175	140748	288	8.343612	24.02960256	Rhodothermus marinus	29549	Bacteria	Bacteria	449	8.090000000000001e-122	NTclustered	gi\|1778174558\|dbj\|AP019796.1\|	29549	g138481	i0	98.069	11.0972222222222	259	3	90	2	7	265	1975420	1975676	Rhodothermus marinus AA2-13 DNA, complete genome	blastn	3196	449	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
26055051	26055051	PRJEB14175_P_NODE_64589_length_460_cov_11.987469_g62332_i0	PRJEB14175	64589	460	11.987469	55.1423574	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	449	1.3499999999999999e-121	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g62332	i0	88.127	67.6978260869565	379	43	82	2	57	434	2860187	2860564	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	31141	449	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26153419	26153419	PRJEB14175_P_NODE_211117_length_220_cov_1.207547_g208850_i0	PRJEB14175	211117	220	1.207547	2.6566034	Rhodothermus	29548	Bacteria	Bacteria	86.1	1.92e-12	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g208850	i0	80	1.42272727272727	115	23	52	0	1	115	1935330	1935216	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	313	86.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
26183893	26183893	PRJEB14175_P_NODE_151342_length_275_cov_2.897196_g149075_i0	PRJEB14175	151342	275	2.897196	7.967289	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	274	4.95e-69	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g149075	i0	87.931	81.6872727272727	232	28	84	0	7	238	241648	241417	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	22464	274	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26184901	26184901	PRJEB14175_P_NODE_173134_length_251_cov_4.110526_g170867_i0	PRJEB14175	173134	251	4.110526	10.31742026	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	228	3.5199999999999986e-55	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g170867	i0	84.783	193.772908366534	230	32	91	3	24	251	1309162	1308934	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	48637	228	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
26319739	26319739	PRJEB14175_P_NODE_154343_length_271_cov_11.919048_g152076_i0	PRJEB14175	154343	271	11.919048	32.30062008	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	196	1.08e-45	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g152076	i0	93.846	121.892988929889	130	8	84	0	24	153	3832933	3833062	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	33033	196	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
26321012	26321012	PRJEB14175_P_NODE_182807_length_242_cov_2.828729_g180540_i0	PRJEB14175	182807	242	2.828729	6.84552418	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	235	2.02e-57	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g180540	i0	88.947	2.35537190082645	190	21	79	0	45	234	1513153	1513342	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	570	235	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
26321088	26321088	PRJEB14175_P_NODE_184551_length_241_cov_1.066667_g182284_i0	PRJEB14175	184551	241	1.066667	2.57066747	Rubrivirga sp. IMCC452	1885344	Bacteria	Bacteria	233	7.22e-57	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g182284	i0	84.232	4.00829875518672	241	36	99	2	2	241	599158	599397	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	966	233	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
26322530	26322530	PRJEB14175_P_NODE_217535_length_215_cov_2.311688_g215268_i0	PRJEB14175	217535	215	2.311688	4.9701292	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	261	2.89e-65	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g215268	i0	91.534	100.706976744186	189	16	90	0	23	211	2412587	2412399	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	21652	261	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26459602	26459602	PRJEB14175_P_NODE_235176_length_207_cov_0.876712_g232908_i0	PRJEB14175	235176	207	0.876712	1.81479384	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	254	4.63e-63	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g232908	i0	88.942	1.0048309178744	208	19	99	3	1	206	1100283	1100488	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	208	254	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
26563068	26563068	PRJEB14175_P_NODE_48520_length_535_cov_36.208861_g46291_i0	PRJEB14175	48520	535	36.208861	193.71740635	Rhodothermales	1853224	Bacteria	Bacteria	560	7.06e-155	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g46291	i0	86.628	493.390654205607	516	57	95	11	1	509	2906313	2906823	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	263964	560	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);;