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

5 rows where bioproject = "PRJNA773247", 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
7127398	7127398	PRJNA773247_P_NODE_10986_length_469_cov_1.398990_g10903_i0	PRJNA773247	10986	469	1.39899	6.5612631	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	196	1.3e-56	NR	HEX9950667.1	2838334	g10903	i0	64.7	0.997867803837953	156	55	99.8	0	1	468	154	309	HEX9950667.1 histidine kinase [Rubricoccaceae bacterium]	diamond	468	196	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
8402168	8402168	PRJNA773247_P_NODE_307_length_3030_cov_7.805884_g299_i0	PRJNA773247	307	3030	7.805884	236.5182852	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	1716	0	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g299	i0	80.969	28.8023102310231	2249	357	73	59	1	2206	516992	514772	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	87271	1716	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
12228620	12228620	PRJNA773247_P_NODE_27430_length_265_cov_5.083333_g27346_i0	PRJNA773247	27430	265	5.083333	13.47083245	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g27346	i0	100	0.105660377358491	28	0	11	0	31	58	1721256	1721229	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
13502467	13502467	PRJNA773247_P_NODE_16791_length_357_cov_2.404930_g16707_i0	PRJNA773247	16791	357	2.40493	8.5856001	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	126	7.379999999999999e-31	NR	HEX9952180.1	2838334	g16707	i0	76.2	1.40336134453782	84	20	70.6	0	12	263	1199	1282	HEX9952180.1 T9SS type A sorting domain-containing protein [Rubricoccaceae bacterium]	diamond	501	126	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
17327047	17327047	PRJNA773247_P_NODE_13134_length_417_cov_7.616279_g13051_i0	PRJNA773247	13134	417	7.616279	31.75988343	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	77.8	1.42e-13	NR	HEX8298805.1	2838334	g13051	i0	55	0.575539568345324	80	35	56.8	1	78	314	420	499	HEX8298805.1 phage portal protein [Rubricoccaceae bacterium]	diamond	240	77.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae 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);;