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

5 rows where bioproject = "PRJNA1249042", 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
354409	354409	PRJNA1249042_S_NODE_48801_length_211_cov_3.583333_g48587_i0	PRJNA1249042	48801	211	3.583333	7.56083263	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	239	1.33e-58	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g48587	i0	87.264	98.4928909952607	212	24	99	3	3	211	806839	807050	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	20782	239	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
4181413	4181413	PRJNA1249042_S_NODE_14844_length_282_cov_2.995816_g14630_i0	PRJNA1249042	14844	282	2.995816	8.44820112	Rhodothermales bacterium	2306054	Bacteria	Bacteria	233	8.65e-57	NTclustered	gi\|2891482048\|emb\|OZ219799.1\|	2306054	g14630	i0	82.374	51.7482269503546	278	40	97	9	9	282	478810	478538	MAG: Rhodothermales bacterium isolate da3e7c24-c5f3-4507-9669-19e8aa5a93cb genome assembly, chromosome: 1	blastn	14593	233	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
5457530	5457530	PRJNA1249042_S_NODE_10165_length_307_cov_4.727273_g9951_i0	PRJNA1249042	10165	307	4.727273	14.51272811	Rhodothermales bacterium	2306054	Bacteria	Bacteria	137	3.2400000000000004e-36	NR	MDZ4699569.1	2306054	g9951	i0	84.9	1.84690553745928	93	14	90.9	0	306	28	357	449	MDZ4699569.1 type II secretion system F family protein [Rhodothermales bacterium]	diamond	567	137	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
6732138	6732138	PRJNA1249042_S_NODE_29786_length_242_cov_1.743719_g29572_i0	PRJNA1249042	29786	242	1.743719	4.21979998	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	333	6.949999999999999e-87	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g29572	i0	91.393	44.7396694214876	244	19	100	2	1	242	3831703	3831946	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	10827	333	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
8008130	8008130	PRJNA1249042_S_NODE_71447_length_186_cov_1.643357_g71233_i0	PRJNA1249042	71447	186	1.643357	3.05664402	Rhodothermales bacterium	2306054	Bacteria	Bacteria	243	8.79e-60	NTclustered	gi\|2893358427\|emb\|OZ220719.1\|	2306054	g71233	i0	90.374	215.897849462366	187	15	100	3	1	186	2487230	2487046	MAG: Rhodothermales bacterium isolate dfa80fe1-3418-4a7a-9107-99a60459722b genome assembly, chromosome: 1	blastn	40157	243	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);;