metadata: contig_metadata: 6 rows where bioproject = "PRJNA849172", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA849172", 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
837695	837695	PRJNA849172_P_NODE_88881_length_252_cov_2.770950_g88521_i0	PRJNA849172	88881	252	2.77095	6.982794	Rhodothermales bacterium	2306054	Bacteria	Bacteria	255	1.62e-63	NTclustered	gi\|2621703415\|emb\|OY762508.1\|	2306054	g88521	i0	84.921	175.984126984127	252	38	100	0	1	252	2025239	2024988	MAG: Rhodothermales bacterium isolate 68d32973-4033-4094-87ac-516b823d41a0 genome assembly, chromosome: 1	blastn	44348	255	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
8490281	8490281	PRJNA849172_P_NODE_80747_length_259_cov_2.102151_g80387_i0	PRJNA849172	80747	259	2.102151	5.44457109	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	224	4.72e-54	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g80387	i0	82.51	1.6988416988417	263	38	100	6	1	259	1195181	1194923	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	440	224	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8490449	8490449	PRJNA849172_P_NODE_86587_length_254_cov_1.723757_g86227_i0	PRJNA849172	86587	254	1.723757	4.37834278	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	200	7.78e-47	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g86227	i0	85.714	60.0748031496063	189	27	74	0	60	248	3448947	3449135	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	15259	200	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
17414380	17414380	PRJNA849172_P_NODE_37494_length_336_cov_9.167300_g37135_i0	PRJNA849172	37494	336	9.1673	30.802128	Rhodothermus marinus	29549	Bacteria	Bacteria	222	2.28e-53	NTclustered	gi\|1778174558\|dbj\|AP019796.1\|	29549	g37135	i0	79.167	41.8660714285714	336	59	99	10	6	336	2769501	2769830	Rhodothermus marinus AA2-13 DNA, complete genome	blastn	14067	222	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
27686989	27686989	PRJNA849172_P_NODE_141104_length_206_cov_5.751880_g140744_i0	PRJNA849172	141104	206	5.75188	11.8488728	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	87.8	1.99e-18	NR	HLT46222.1	2838334	g140744	i0	80	0.800970873786408	55	11	80.1	0	3	167	161	215	HLT46222.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	165	87.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
30718207	30718207	PRJNA849172_P_NODE_121334_length_231_cov_2.386076_g120974_i0	PRJNA849172	121334	231	2.386076	5.51183556	Rhodothermaceae bacterium	2026787	Bacteria	Bacteria	43.1	0.0243	NR	MBX2819939.1	2026787	g120974	i0	47.9	0.623376623376623	48	25	62.3	0	219	76	627	674	MBX2819939.1 serine/threonine-protein kinase [Rhodothermaceae bacterium]	diamond	144	43.1	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae 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);;