metadata: contig_metadata: 10 rows where bioproject = "PRJEB66218", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJEB66218", 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
131588	131588	PRJEB66218_P_NODE_159881_length_234_cov_1.734104_g157451_i0	PRJEB66218	159881	234	1.734104	4.05780336	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	263	8.89e-66	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g157451	i0	87.083	175.722222222222	240	21	100	9	1	234	1308447	1308682	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	41119	263	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
5236423	5236423	PRJEB66218_P_NODE_59205_length_429_cov_1.410326_g56785_i0	PRJEB66218	59205	429	1.410326	6.05029854	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	466	1.25e-126	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g56785	i0	86.343	193.888111888112	432	53	100	6	1	429	1308943	1309371	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	83178	466	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
10335107	10335107	PRJEB66218_P_NODE_188109_length_216_cov_1.638710_g185679_i0	PRJEB66218	188109	216	1.6387100000000001	3.5396136	Rhodothermales bacterium	2306054	Bacteria	Bacteria	252	1.75e-62	NTclustered	gi\|2621702557\|emb\|OY760427.1\|	2306054	g185679	i0	88.889	24.9814814814815	207	20	95	3	1	205	5502201	5501996	MAG: Rhodothermales bacterium isolate 1504ddc0-b432-43e2-af37-a45191a88aeb genome assembly, chromosome: 1	blastn	5396	252	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
19259907	19259907	PRJEB66218_P_NODE_76996_length_362_cov_1.614618_g74570_i0	PRJEB66218	76996	362	1.614618	5.84491716	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	614	3.489999999999999e-171	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g74570	i0	97.238	248.917127071823	362	10	100	0	1	362	806130	806491	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	90108	614	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
21396954	21396954	PRJEB66218_P_NODE_33357_length_626_cov_2.430088_g30990_i0	PRJEB66218	33357	626	2.430088	15.21235088	Rubrivirga	1434037	Bacteria	Bacteria	726	0	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g30990	i0	87.658	133.166134185304	632	69	100	9	1	626	806544	807172	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	83362	726	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
23083670	23083670	PRJEB66218_P_NODE_169639_length_227_cov_4.367470_g167209_i0	PRJEB66218	169639	227	4.36747	9.9141569	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	191	4.11e-44	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g167209	i0	82.174	229.233480176211	230	34	99	7	1	226	2529616	2529842	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	52036	191	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
28360386	28360386	PRJEB66218_P_NODE_246186_length_193_cov_2.689394_g243754_i0	PRJEB66218	246186	193	2.689394	5.19053042	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	46.2	5.04e-4	NR	MBX2820919.1	2026787	g243754	i0	36.4	1.0259067357513	66	39	97.9	3	193	5	29	94	MBX2820919.1 hypothetical protein [Rhodothermaceae bacterium]	diamond	198	46.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
28455353	28455353	PRJEB66218_P_NODE_114946_length_282_cov_1.176471_g112517_i0	PRJEB66218	114946	282	1.176471	3.31764822	Rhodothermales bacterium	2306054	Bacteria	Bacteria	46.6	0.00261	NR	NNF05114.1	2306054	g112517	i0	34.2	0.840425531914894	79	47	79.8	3	276	52	64	141	NNF05114.1 glycosyl hydrolase [Rhodothermales bacterium]	diamond	237	46.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
31614241	31614241	PRJEB66218_P_NODE_217876_length_207_cov_0.890411_g215446_i0	PRJEB66218	217876	207	0.890411	1.84315077	Rhodothermales bacterium	2306054	Bacteria	Bacteria	94.7	1.17e-20	NR	MBE2185581.1	2306054	g215446	i0	69.6	1	69	21	100	0	207	1	382	450	MBE2185581.1 hypothetical protein [Rhodothermales bacterium]	diamond	207	94.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32815245	32815245	PRJEB66218_P_NODE_198640_length_211_cov_0.866667_g196210_i0	PRJEB66218	198640	211	0.866667	1.82866737	Longimonas halophila	1469170	Bacteria	Bacteria	99	1.2699999999999999e-24	NR	WP_098061232.1	1469170	g196210	i0	62.3	0.981042654028436	69	25	98.1	1	209	3	12	79	WP_098061232.1 group I intron-associated PD-(D/E)XK endonuclease [Longimonas halophila]	diamond	207	99	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salisaetaceae	Longimonas	Longimonas halophila

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