metadata: contig_metadata: 5 rows where bioproject = "PRJNA315314", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA315314", 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
9993391	9993391	PRJNA315314_S_NODE_16048_length_204_cov_4325.285714_g15727_i0	PRJNA315314	16048	204	4325.285714	8823.58285656	Rhodothermus	29548	Bacteria	Bacteria	185	1.6799999999999994e-42	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g15727	i0	87.5	368.838235294118	160	20	78	0	1	160	3095465	3095306	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	75243	185	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
10584518	10584518	PRJNA315314_S_NODE_12309_length_231_cov_980.450495_g11988_i0	PRJNA315314	12309	231	980.450495	2264.84064345	Rhodothermales bacterium	2306054	Bacteria	Bacteria	372	1.39e-98	NTclustered	gi\|2893358395\|emb\|OZ220686.1\|	2306054	g11988	i0	95.671	490.437229437229	231	10	100	0	1	231	1666455	1666225	MAG: Rhodothermales bacterium isolate 312d6c01-350c-491a-87ad-f3958f88b76c genome assembly, chromosome: 1	blastn	113291	372	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
21467116	21467116	PRJNA315314_S_NODE_28897_length_157_cov_3.546875_g28576_i0	PRJNA315314	28897	157	3.546875	5.56859375	Rhodothermales	1853224	Bacteria	Bacteria	202	1.22e-47	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g28576	i0	91.275	181.146496815287	149	12	95	1	1	149	2905450	2905303	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	28440	202	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
25291353	25291353	PRJNA315314_S_NODE_10540_length_249_cov_112.618182_g10219_i0	PRJNA315314	10540	249	112.618182	280.41927318	Rhodothermales	1853224	Bacteria	Bacteria	235	2.08e-57	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g10219	i0	84.711	153.767068273092	242	29	95	8	1	236	2905179	2904940	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	38288	235	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
32855361	32855361	PRJNA315314_S_NODE_20420_length_183_cov_2.519481_g20099_i0	PRJNA315314	20420	183	2.519481	4.61065023	Rhodothermales bacterium	2306054	Bacteria	Bacteria	45.1	0.00137	NR	MEX0747608.1	2306054	g20099	i0	39.3	2.65573770491803	56	34	91.8	0	181	14	80	135	MEX0747608.1 carboxymuconolactone decarboxylase family protein [Rhodothermales bacterium]	diamond	486	45.1	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);;