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

6 rows where bioproject = "PRJNA1144090", 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_species
26912235	26912235	PRJNA1144090_P_NODE_77522_length_286_cov_2.384977_g76987_i0	PRJNA1144090	77522	286	2.384977	6.82103422	Rhodothermales bacterium	2306054	Bacteria	Bacteria	129	1.47e-32	NR	HET6567637.1	2306054	g76987	i0	64.1	8.50699300699301	92	33	96.5	0	6	281	437	528	HET6567637.1 ATP-dependent zinc metalloprotease FtsH [Rhodothermales bacterium]	diamond	2433	129	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales		Rhodothermales bacterium
27165131	27165131	PRJNA1144090_P_NODE_22042_length_575_cov_2.902390_g21516_i0	PRJNA1144090	22042	575	2.90239	16.6887425	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	66.6	3.13e-9	NR	MDX1439244.1	2838334	g21516	i0	27.4	0.970434782608696	186	108	93.4	5	542	6	34	199	MDX1439244.1 T9SS type A sorting domain-containing protein [Rubricoccaceae bacterium]	diamond	558	66.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccaceae bacterium
28238860	28238860	PRJNA1144090_P_NODE_51606_length_355_cov_1.595745_g51071_i0	PRJNA1144090	51606	355	1.595745	5.66489475	Rhodothermales bacterium	2306054	Bacteria	Bacteria	93.6	1.82e-20	NR	MBE2187257.1	2306054	g51071	i0	41.8	0.929577464788732	110	63	93	1	332	3	17	125	MBE2187257.1 RCC1 repeat-containing protein [Rhodothermales bacterium]	diamond	330	93.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales		Rhodothermales bacterium
28322690	28322690	PRJNA1144090_P_NODE_38066_length_419_cov_3.335260_g37531_i0	PRJNA1144090	38066	419	3.33526	13.9747394	Pseudomonadati	3379134	Bacteria	Bacteria	54.3	8.13e-6	NR	MBT8399863.1	2497633	g37531	i0	32.3	7.82577565632458	130	84	91.6	3	393	10	45	172	MBT8399863.1 DUF1795 domain-containing protein [Rhodothermia bacterium]	diamond	3279	54.3	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia			Rhodothermia bacterium
28491792	28491792	PRJNA1144090_P_NODE_9587_length_913_cov_25.955952_g9164_i0	PRJNA1144090	9587	913	25.955952	236.97784176	Rhodothermales bacterium	2306054	Bacteria	Bacteria	123	2.43e-30	NR	MDZ4702209.1	2306054	g9164	i0	39	1.7447973713034	172	93	55.9	7	212	721	3	164	MDZ4702209.1 SET domain-containing methyltransferase [Rhodothermales bacterium]	diamond	1593	123	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales		Rhodothermales bacterium
30260364	30260364	PRJNA1144090_P_NODE_92852_length_260_cov_1.647059_g92317_i0	PRJNA1144090	92852	260	1.647059	4.2823534	Rhodothermales bacterium	2306054	Bacteria	Bacteria	42.4	0.0488	NR	MBE2187214.1	2306054	g92317	i0	45.1	0.588461538461538	51	23	58.8	1	3	155	152	197	MBE2187214.1 rhomboid family intramembrane serine protease [Rhodothermales bacterium]	diamond	153	42.4	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);;