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

23 rows where analysis = "blastn", bioproject = "PRJNA556992" 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
522259	522259	PRJNA556992_P_NODE_1044081_length_226_cov_2.588235_g1041891_i0	PRJNA556992	1044081	226	2.588235	5.8494111	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g1041891	i0	100	0.123893805309735	28	0	12	0	187	214	9619	9646	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
3082280	3082280	PRJNA556992_P_NODE_651123_length_255_cov_1.296703_g648934_i0	PRJNA556992	651123	255	1.296703	3.30659265	Rhodothermus marinus	29549	Bacteria	Bacteria	202	2.1699999999999998e-47	NTclustered	gi\|1778177540\|dbj\|AP019797.1\|	29549	g648934	i0	84.286	37.721568627451	210	29	82	4	4	211	211525	211732	Rhodothermus marinus AA3-38 DNA, complete genome	blastn	9619	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
5632059	5632059	PRJNA556992_P_NODE_394885_length_277_cov_1.838235_g392696_i0	PRJNA556992	394885	277	1.838235	5.09191095	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	143	1.47e-29	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g392696	i0	88.235	1.71841155234657	119	14	43	0	113	231	2175769	2175651	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	476	143	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
6912161	6912161	PRJNA556992_P_NODE_878786_length_242_cov_0.911243_g876596_i0	PRJNA556992	878786	242	0.911243	2.20520806	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	187	5.73e-43	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g876596	i0	82.11	14.4834710743802	218	39	90	0	1	218	1704833	1705050	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	3505	187	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
8180480	8180480	PRJNA556992_P_NODE_357907_length_281_cov_1.966346_g355718_i0	PRJNA556992	357907	281	1.966346	5.52543226	Rhodothermus marinus	29549	Bacteria	Bacteria	213	1.12e-50	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g355718	i0	80.565	28.7473309608541	283	49	99	6	1	280	829303	829024	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	8078	213	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
8777800	8777800	PRJNA556992_P_NODE_12407_length_949_cov_10.106164_g10774_i0	PRJNA556992	12407	949	10.106164	95.90749636	Rhodothermales	1853224	Bacteria	Bacteria	955	0	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g10774	i0	84.979	324.323498419389	972	112	100	24	1	949	2905802	2904842	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	307783	955	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
8779857	8779857	PRJNA556992_P_NODE_63767_length_469_cov_1.787879_g61595_i0	PRJNA556992	63767	469	1.787879	8.38515251	Rhodothermales	1853224	Bacteria	Bacteria	558	2.199999999999999e-154	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g61595	i0	87.984	238.690831556503	491	35	100	12	1	469	2906305	2906793	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	111946	558	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
9459967	9459967	PRJNA556992_P_NODE_660948_length_254_cov_1.701657_g658759_i0	PRJNA556992	660948	254	1.701657	4.32220878	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	102	2.26e-17	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g658759	i0	84.466	0.811023622047244	103	16	41	0	1	103	3774164	3774062	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	206	102	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
9460416	9460416	PRJNA556992_P_NODE_699528_length_251_cov_1.730337_g697339_i0	PRJNA556992	699528	251	1.730337	4.34314587	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	213	9.86e-51	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g697339	i0	83.772	3.58167330677291	228	33	90	4	26	251	914989	914764	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	899	213	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
10055241	10055241	PRJNA556992_P_NODE_57868_length_485_cov_5.973301_g55700_i0	PRJNA556992	57868	485	5.973301	28.97050985	Rhodothermales	1853224	Bacteria	Bacteria	494	6.54e-135	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g55700	i0	85.102	243.534020618557	490	65	99	8	1	484	2906814	2906327	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	118114	494	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
10735342	10735342	PRJNA556992_P_NODE_637629_length_256_cov_1.453552_g635440_i0	PRJNA556992	637629	256	1.453552	3.72109312	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	407	4.31e-109	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g635440	i0	95.331	604.61328125	257	11	100	1	1	256	3832171	3831915	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	154781	407	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
10738001	10738001	PRJNA556992_P_NODE_851849_length_243_cov_2.164706_g849659_i0	PRJNA556992	851849	243	2.164706	5.26023558	Rhodothermus marinus	29549	Bacteria	Bacteria	172	1.6099999999999996e-38	NTclustered	gi\|345111121\|gb\|CP003029.1\|	762570	g849659	i0	81.166	53.6625514403292	223	34	90	8	16	234	2556510	2556728	Rhodothermus marinus SG0.5JP17-172, complete genome	blastn	13040	172	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
11331317	11331317	PRJNA556992_P_NODE_986929_length_232_cov_2.333333_g984739_i0	PRJNA556992	986929	232	2.333333	5.41333256	Rhodothermus	29548	Bacteria	Bacteria	141	4.3e-29	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g984739	i0	78.423	8.31896551724138	241	34	100	16	1	232	2004463	2004232	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	1930	141	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
13287410	13287410	PRJNA556992_P_NODE_81171_length_432_cov_4.153203_g78990_i0	PRJNA556992	81171	432	4.153203	17.94183696	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	512	1.59e-140	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g78990	i0	88.018	401.238425925926	434	50	100	2	1	432	805789	805356	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	173335	512	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
15830093	15830093	PRJNA556992_P_NODE_327613_length_285_cov_1.410377_g325424_i0	PRJNA556992	327613	285	1.410377	4.01957445	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	145	4.2199999999999995e-30	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g325424	i0	77.912	0.873684210526316	249	44	85	11	1	243	845131	845374	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	249	145	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
15837474	15837474	PRJNA556992_P_NODE_919013_length_239_cov_2.319277_g916823_i0	PRJNA556992	919013	239	2.319277	5.54307203	Rhodothermales bacterium	2306054	Bacteria	Bacteria	320	5.33e-83	NTclustered	gi\|2621703415\|emb\|OY762508.1\|	2306054	g916823	i0	91.81	350.44769874477	232	15	96	4	7	236	2026372	2026601	MAG: Rhodothermales bacterium isolate 68d32973-4033-4094-87ac-516b823d41a0 genome assembly, chromosome: 1	blastn	83757	320	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
16427408	16427408	PRJNA556992_P_NODE_1138193_length_204_cov_4.961832_g1136002_i0	PRJNA556992	1138193	204	4.961832	10.12213728	Rubrivirga	1434037	Bacteria	Bacteria	185	1.6799999999999994e-42	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g1136002	i0	89.796	2.24019607843137	147	11	71	4	25	169	350319	350175	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	457	185	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
17107420	17107420	PRJNA556992_P_NODE_518234_length_265_cov_4.979167_g516045_i0	PRJNA556992	518234	265	4.979167	13.19479255	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	220	6.27e-53	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g516045	i0	83.065	2.6	248	36	92	6	21	265	1083014	1082770	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	689	220	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
17110937	17110937	PRJNA556992_P_NODE_80054_length_434_cov_3.448753_g77873_i0	PRJNA556992	80054	434	3.448753	14.96758802	Rhodothermaceae bacterium RA	1779382	Bacteria	Bacteria	505	2.68e-138	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g77873	i0	87.816	89.9354838709677	435	47	99	5	3	434	2905003	2905434	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	39032	505	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
19653251	19653251	PRJNA556992_P_NODE_300616_length_289_cov_1.125000_g298427_i0	PRJNA556992	300616	289	1.125	3.25125	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	193	1.51e-44	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g298427	i0	79.167	11.3356401384083	288	52	98	6	4	287	2257193	2257476	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	3276	193	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
19661636	19661636	PRJNA556992_P_NODE_969136_length_233_cov_7.950000_g966946_i0	PRJNA556992	969136	233	7.95	18.5235	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	152	1.9999999999999998e-32	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g966946	i0	79.535	2.59656652360515	215	42	92	2	19	232	3566450	3566663	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	605	152	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
22200360	22200360	PRJNA556992_P_NODE_112818_length_390_cov_4.022082_g110632_i0	PRJNA556992	112818	390	4.022082	15.6861198	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	512	1.42e-140	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g110632	i0	90.909	261.276923076923	385	29	97	3	11	390	1307922	1308305	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	101898	512	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
23476509	23476509	PRJNA556992_P_NODE_123979_length_379_cov_7.035948_g121792_i0	PRJNA556992	123979	379	7.035948	26.66624292	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	446	1.42e-120	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g121792	i0	88.95	412.562005277045	362	38	95	2	1	361	1309419	1309059	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	156361	446	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium

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