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

26 rows where analysis = "blastn", bioproject = "PRJNA704949" 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
689633	689633	PRJNA704949_P_NODE_1454661_length_205_cov_1.333333_g1439323_i0	PRJNA704949	1454661	205	1.333333	2.73333265	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	220	4.64e-53	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1439323	i0	86.408	2.96585365853659	206	22	99	5	1	203	176871	176669	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	608	220	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
690065	690065	PRJNA704949_P_NODE_1513401_length_200_cov_1.033113_g1498063_i0	PRJNA704949	1513401	200	1.033113	2.066226	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g1498063	i0	100	0.145	29	0	15	0	1	29	330137	330109	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	29	54.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
699158	699158	PRJNA704949_P_NODE_601881_length_350_cov_1.382060_g586558_i0	PRJNA704949	601881	350	1.38206	4.83721	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	257	6.530000000000001e-64	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g586558	i0	82.143	1.86	308	48	87	6	7	310	296421	296117	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	651	257	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
3252595	3252595	PRJNA704949_P_NODE_841663_length_289_cov_1.629167_g826329_i0	PRJNA704949	841663	289	1.629167	4.70829263	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	248	3.18e-61	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g826329	i0	85.246	42.5294117647059	244	33	84	3	48	289	1188152	1188394	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	12291	248	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
5794285	5794285	PRJNA704949_P_NODE_1594265_length_193_cov_1.444444_g1578926_i0	PRJNA704949	1594265	193	1.444444	2.78777692	Roseithermus sacchariphilus	2893045	Bacteria	Bacteria	126	9.67e-25	NTclustered	gi\|1417721500\|gb\|CP030158.1\|	2893045	g1578926	i0	80.226	1.51813471502591	177	27	90	8	21	193	336917	337089	Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome	blastn	293	126	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Roseithermus	Roseithermus sacchariphilus
7566188	7566188	PRJNA704949_P_NODE_2097206_length_164_cov_0.904348_g2081867_i0	PRJNA704949	2097206	164	0.904348	1.48313072	Rhodocaloribacter	2893090	Bacteria	Bacteria	65.8	1.76e-6	NTclustered	gi\|2893358454\|emb\|OZ220746.1\|	2306054	g2081867	i0	80	3.4390243902439	90	17	54	1	75	163	2076161	2076072	MAG: Rhodothermales bacterium isolate 9cc831bd-bc70-4893-94b0-cd5ea3f684b8 genome assembly, chromosome: 1	blastn	564	65.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
9625556	9625556	PRJNA704949_P_NODE_362988_length_450_cov_1.750623_g347965_i0	PRJNA704949	362988	450	1.750623	7.8778035	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	209	2.44e-49	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g347965	i0	83.19	39.7222222222222	232	35	51	4	27	256	3277190	3277419	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	17875	209	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
10901570	10901570	PRJNA704949_P_NODE_418069_length_421_cov_1.239247_g402927_i0	PRJNA704949	418069	421	1.239247	5.21722987	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	252	3.72e-62	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g402927	i0	78.436	2.81710213776722	422	66	96	20	16	421	540683	541095	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1186	252	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
11391569	11391569	PRJNA704949_P_NODE_1972149_length_168_cov_0.873950_g1956810_i0	PRJNA704949	1972149	168	0.87395	1.468236	Pseudomonadati	3379134	Bacteria	Bacteria	100	4.97e-17	NTclustered	gi\|1778174558\|dbj\|AP019796.1\|	29549	g1956810	i0	87.356	37.3154761904762	87	11	52	0	74	160	2768466	2768552	Rhodothermus marinus AA2-13 DNA, complete genome	blastn	6269	100	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
13444470	13444470	PRJNA704949_P_NODE_1594771_length_193_cov_1.395833_g1579432_i0	PRJNA704949	1594771	193	1.395833	2.69395769	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	159	9.529999999999999e-35	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1579432	i0	82.54	6.50777202072539	189	25	96	5	9	193	3450210	3450394	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1256	159	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
13454112	13454112	PRJNA704949_P_NODE_743551_length_311_cov_1.587786_g728222_i0	PRJNA704949	743551	311	1.587786	4.93801446	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	148	3.5999999999999996e-31	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g728222	i0	88	0.604501607717042	125	15	40	0	26	150	2644569	2644693	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	188	148	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
14716508	14716508	PRJNA704949_P_NODE_1195012_length_233_cov_1.130435_g1179675_i0	PRJNA704949	1195012	233	1.130435	2.63391355	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	237	5.36e-58	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g1179675	i0	87.745	3.31330472103004	204	23	87	2	7	208	3175770	3175567	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	772	237	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
14716799	14716799	PRJNA704949_P_NODE_1232252_length_228_cov_1.754190_g1216915_i0	PRJNA704949	1232252	228	1.75419	3.9995532	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	259	1.12e-64	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g1216915	i0	89.806	82.7017543859649	206	15	89	5	1	203	3594832	3595034	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	18856	259	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
16004638	16004638	PRJNA704949_P_NODE_931733_length_272_cov_1.219731_g916399_i0	PRJNA704949	931733	272	1.219731	3.31766832	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	254	6.37e-63	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g916399	i0	83.871	7.13602941176471	279	31	100	11	1	272	916565	916836	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	1941	254	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
17266549	17266549	PRJNA704949_P_NODE_1316994_length_219_cov_1.188235_g1301657_i0	PRJNA704949	1316994	219	1.188235	2.60223465	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	213	8.4e-51	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1301657	i0	84.834	0.963470319634703	211	32	96	0	7	217	4110679	4110889	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	211	213	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
17279836	17279836	PRJNA704949_P_NODE_906354_length_276_cov_2.290749_g891020_i0	PRJNA704949	906354	276	2.290749	6.32246724	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	340	4.84e-89	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g891020	i0	89.811	91.8260869565217	265	27	96	0	1	265	1809182	1809446	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	25344	340	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
18548698	18548698	PRJNA704949_P_NODE_360795_length_451_cov_2.325871_g345774_i0	PRJNA704949	360795	451	2.325871	10.48967821	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	222	3.15e-53	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g345774	i0	80.392	0.678492239467849	306	48	67	11	1	300	2925182	2925481	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	306	222	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
19814872	19814872	PRJNA704949_P_NODE_1244176_length_227_cov_1.168539_g1228839_i0	PRJNA704949	1244176	227	1.168539	2.65258353	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	161	3.22e-35	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g1228839	i0	86	30.7709251101322	150	21	66	0	42	191	2091082	2090933	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	6985	161	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
21089471	21089471	PRJNA704949_P_NODE_1128377_length_241_cov_2.166667_g1113041_i0	PRJNA704949	1128377	241	2.166667	5.22166747	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	171	5.74e-38	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g1113041	i0	82.234	60.8008298755187	197	35	82	0	24	220	2121893	2121697	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	14653	171	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
21091118	21091118	PRJNA704949_P_NODE_1329637_length_217_cov_2.053571_g1314300_i0	PRJNA704949	1329637	217	2.053571	4.45624907	Roseithermus sacchariphilus	2893045	Bacteria	Bacteria	99	2.43e-16	NTclustered	gi\|1417721500\|gb\|CP030158.1\|	2893045	g1314300	i0	86.813	0.71889400921659	91	8	41	4	21	109	3939780	3939868	Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome	blastn	156	99	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Roseithermus	Roseithermus sacchariphilus
21091685	21091685	PRJNA704949_P_NODE_1401297_length_210_cov_1.291925_g1385959_i0	PRJNA704949	1401297	210	1.291925	2.7130425	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	171	4.88e-38	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g1385959	i0	85.714	0.766666666666667	161	23	77	0	10	170	235709	235549	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	161	171	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
21095310	21095310	PRJNA704949_P_NODE_1857957_length_173_cov_2.096774_g1842618_i0	PRJNA704949	1857957	173	2.096774	3.62741902	Roseithermus sacchariphilus	2893045	Bacteria	Bacteria	124	3.04e-24	NTclustered	gi\|1417721500\|gb\|CP030158.1\|	2893045	g1842618	i0	85.593	1.46820809248555	118	17	68	0	54	171	249461	249344	Roseithermus sacchariphilus strain MEBiC09517 chromosome, complete genome	blastn	254	124	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Roseithermus	Roseithermus sacchariphilus
22365913	22365913	PRJNA704949_P_NODE_1334238_length_217_cov_1.238095_g1318901_i0	PRJNA704949	1334238	217	1.238095	2.68666615	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	89.8	1.46e-13	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g1318901	i0	80	0.912442396313364	125	22	58	2	15	139	1804027	1804148	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	198	89.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
22370525	22370525	PRJNA704949_P_NODE_1901958_length_170_cov_2.148760_g1886619_i0	PRJNA704949	1901958	170	2.14876	3.652892	Rhodothermus marinus	29549	Bacteria	Bacteria	128	2.3e-25	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g1886619	i0	87.5	10.8058823529412	112	12	65	2	55	165	2637756	2637646	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	1837	128	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
23642065	23642065	PRJNA704949_P_NODE_1381759_length_212_cov_1.276074_g1366421_i0	PRJNA704949	1381759	212	1.276074	2.70527688	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	113	8.430000000000001e-21	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1366421	i0	85.217	0.976415094339623	115	12	53	5	101	212	3805977	3806089	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	207	113	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
23649903	23649903	PRJNA704949_P_NODE_336939_length_466_cov_1.151079_g322002_i0	PRJNA704949	336939	466	1.151079	5.36402814	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	213	1.96e-50	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g322002	i0	82.773	1.02575107296137	238	41	51	0	229	466	1579274	1579511	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	478	213	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206

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