metadata: contig_metadata: 18 rows where bioproject = "PRJNA734348", tax_clade = "FCB group" and tax

18 rows where bioproject = "PRJNA734348", tax_clade = "FCB group" 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
10125475	10125475	PRJNA734348_P_NODE_128048_length_242_cov_0.911243_g127350_i0	PRJNA734348	128048	242	0.911243	2.20520806	Rubrivirga	1434037	Bacteria	Bacteria	202	2.0499999999999998e-47	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g127350	i0	81.893	99.4669421487603	243	41	99	3	2	242	2465771	2466012	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	24071	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
12197877	12197877	PRJNA734348_P_NODE_58110_length_281_cov_2.557692_g57413_i0	PRJNA734348	58110	281	2.557692	7.18711452	Rhodothermales bacterium	2306054	Bacteria	Bacteria	147	8.08e-43	NR	MBE2186048.1	2306054	g57413	i0	73.1	0.99288256227758	93	25	99.3	0	3	281	63	155	MBE2186048.1 elongation factor P [Rhodothermales bacterium]	diamond	279	147	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
13470923	13470923	PRJNA734348_P_NODE_123031_length_243_cov_1.529412_g122333_i0	PRJNA734348	123031	243	1.529412	3.71647116	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	195	3.4399999999999997e-45	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g122333	i0	83.028	25.1522633744856	218	33	89	4	4	219	2083496	2083281	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	6112	195	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
14745803	14745803	PRJNA734348_P_NODE_10812_length_706_cov_1.382306_g10178_i0	PRJNA734348	10812	706	1.382306	9.75908036	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	968	0	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g10178	i0	92.794	216.171388101983	680	32	96	4	27	706	1308742	1308080	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	152617	968	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
15226030	15226030	PRJNA734348_P_NODE_74952_length_265_cov_1.572917_g74254_i0	PRJNA734348	74952	265	1.572917	4.16823005	Rhodothermales	1853224	Bacteria	Bacteria	294	3.64e-75	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g74254	i0	86.94	111.283018867925	268	28	100	6	1	265	3095284	3095547	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	29490	296	0.993243243243243	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
16019536	16019536	PRJNA734348_P_NODE_114693_length_245_cov_1.738372_g113995_i0	PRJNA734348	114693	245	1.738372	4.2590114	Rhodothermales bacterium	2306054	Bacteria	Bacteria	112	1.03e-26	NR	HYE58200.1	2306054	g113995	i0	65.5	2.05714285714286	84	26	99.2	1	243	1	342	425	HYE58200.1 alpha-amylase family glycosyl hydrolase [Rhodothermales bacterium]	diamond	504	112	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
16019859	16019859	PRJNA734348_P_NODE_132253_length_241_cov_0.916667_g131555_i0	PRJNA734348	132253	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	74.3	1.66e-13	NR	WP_012845039.1	29549	g131555	i0	50	2.98755186721992	80	40	99.6	0	241	2	134	213	WP_012845039.1 M23 family metallopeptidase [Rhodothermus marinus]	diamond	720	74.7	0.994645247657296	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
16499821	16499821	PRJNA734348_P_NODE_109913_length_246_cov_3.352601_g109215_i0	PRJNA734348	109913	246	3.352601	8.24739846	Rhodothermales	1853224	Bacteria	Bacteria	189	1.62e-43	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g109215	i0	80.723	8.60975609756098	249	42	100	6	1	246	4650755	4650510	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	2118	189	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
17295343	17295343	PRJNA734348_P_NODE_131134_length_241_cov_1.761905_g130436_i0	PRJNA734348	131134	241	1.761905	4.24619105	Rhodothermales bacterium	2306054	Bacteria	Bacteria	143	9.71e-38	NR	MBE2187401.1	2306054	g130436	i0	91.1	0.983402489626556	79	7	98.3	0	1	237	257	335	MBE2187401.1 DNA primase [Rhodothermales bacterium]	diamond	237	143	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
21599524	21599524	PRJNA734348_P_NODE_5237_length_1156_cov_3.706371_g4794_i0	PRJNA734348	5237	1156	3.706371	42.84564876	Rhodothermales	1853224	Bacteria	Bacteria	1347	0	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g4794	i0	87.778	330.730968858131	1170	120	100	21	1	1156	2905650	2906810	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	382325	1347	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
22874971	22874971	PRJNA734348_P_NODE_78358_length_262_cov_1.544974_g77660_i0	PRJNA734348	78358	262	1.544974	4.04783188	Rhodothermales bacterium	2306054	Bacteria	Bacteria	155	1.22e-45	NR	MBE2186457.1	2306054	g77660	i0	84.9	0.984732824427481	86	13	98.5	0	259	2	1	86	MBE2186457.1 LON peptidase substrate-binding domain-containing protein [Rhodothermales bacterium]	diamond	258	155	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
24944785	24944785	PRJNA734348_P_NODE_46260_length_296_cov_4.417040_g45563_i0	PRJNA734348	46260	296	4.41704	13.0744384	Rhodothermales bacterium	2306054	Bacteria	Bacteria	189	4.299999999999999e-56	NR	MBE2186143.1	2306054	g45563	i0	87.4	1.04391891891892	103	8	99.3	1	296	3	14	116	MBE2186143.1 3-isopropylmalate dehydratase large subunit [Rhodothermales bacterium]	diamond	309	189	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
27905017	27905017	PRJNA734348_P_NODE_127265_length_242_cov_1.455621_g126567_i0	PRJNA734348	127265	242	1.455621	3.52260282	Rhodothermales bacterium	2306054	Bacteria	Bacteria	89	9.64e-19	NR	HEX7071637.1	2306054	g126567	i0	51.3	2.90082644628099	78	38	96.7	0	8	241	177	254	HEX7071637.1 hypothetical protein [Rhodothermales bacterium]	diamond	702	89	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28442189	28442189	PRJNA734348_P_NODE_127846_length_242_cov_0.911243_g127148_i0	PRJNA734348	127846	242	0.911243	2.20520806	Rhodothermales bacterium	2306054	Bacteria	Bacteria	115	1e-27	NR	HYE58953.1	2306054	g127148	i0	63.8	0.991735537190083	80	29	99.2	0	2	241	440	519	HYE58953.1 single-stranded-DNA-specific exonuclease RecJ [Rhodothermales bacterium]	diamond	240	115	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28537008	28537008	PRJNA734348_P_NODE_41427_length_310_cov_2.713080_g40731_i0	PRJNA734348	41427	310	2.71308	8.410548	Rhodothermales bacterium	2306054	Bacteria	Bacteria	169	2.32e-49	NR	MBE2185484.1	2306054	g40731	i0	75.9	1.04516129032258	108	19	97.7	1	305	3	140	247	MBE2185484.1 GMP synthase [Rhodothermales bacterium]	diamond	324	169	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28726215	28726215	PRJNA734348_P_NODE_32947_length_339_cov_2.428571_g32251_i0	PRJNA734348	32947	339	2.428571	8.23285569	Rubrivirga sp. SAORIC476	1961794	Bacteria	Bacteria	80.5	6.23e-15	NR	WP_095513182.1	1961794	g32251	i0	44.2	1.2212389380531	138	46	99.1	2	337	2	107	239	WP_095513182.1 beta strand repeat-containing protein [Rubrivirga sp. SAORIC476]	diamond	414	80.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. SAORIC476
30494888	30494888	PRJNA734348_P_NODE_144733_length_226_cov_2.013072_g144035_i0	PRJNA734348	144733	226	2.013072	4.54954272	Rhodothermales bacterium	2306054	Bacteria	Bacteria	60.8	3.87e-9	NR	MDX1548334.1	2306054	g144035	i0	47.8	0.915929203539823	69	28	91.6	1	216	10	9	69	MDX1548334.1 alpha/beta fold hydrolase [Rhodothermales bacterium]	diamond	207	60.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32391994	32391994	PRJNA734348_P_NODE_141219_length_230_cov_3.496815_g140521_i0	PRJNA734348	141219	230	3.496815	8.0426745	Rhodothermales bacterium	2306054	Bacteria	Bacteria	91.3	2.28e-19	NR	MBE2187625.1	2306054	g140521	i0	87	0.704347826086957	54	7	70.4	0	2	163	252	305	MBE2187625.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Rhodothermales bacterium]	diamond	162	91.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;