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

5 rows where bioproject = "PRJNA770826", 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
9675250	9675250	PRJNA770826_P_NODE_10748_length_246_cov_1.177665_g10577_i0	PRJNA770826	10748	246	1.177665	2.8970559	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	108	4.68e-19	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g10577	i0	95.522	6.93089430894309	67	3	27	0	1	67	1396364	1396298	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	1705	108	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
17325221	17325221	PRJNA770826_P_NODE_22694_length_169_cov_1.300000_g22523_i0	PRJNA770826	22694	169	1.3	2.197	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	1.51e-19	NR	MBX2821336.1	2026787	g22523	i0	71.4	10.792899408284	56	16	99.4	0	1	168	424	479	MBX2821336.1 ATP-dependent zinc metalloprotease FtsH [Rhodothermaceae bacterium]	diamond	1824	90.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium
27937805	27937805	PRJNA770826_P_NODE_6745_length_320_cov_0.767528_g6574_i0	PRJNA770826	6745	320	0.767528	2.4560896	Rhodothermales bacterium	2306054	Bacteria	Bacteria	43.5	0.0479	NR	MEQ9104873.1	2306054	g6574	i0	34.3	0.628125	67	40	62.8	2	12	212	2	64	MEQ9104873.1 excinuclease ABC subunit UvrC [Rhodothermales bacterium]	diamond	201	43.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
28411409	28411409	PRJNA770826_P_NODE_25646_length_168_cov_0.873950_g25475_i0	PRJNA770826	25646	168	0.87395	1.468236	Rhodothermales bacterium	2306054	Bacteria	Bacteria	68.2	1.34e-11	NR	HMB93905.1	2306054	g25475	i0	65.5	0.982142857142857	55	19	98.2	0	2	166	16	70	HMB93905.1 3-phosphoglycerate dehydrogenase family protein [Rhodothermales bacterium]	diamond	165	68.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
32740160	32740160	PRJNA770826_P_NODE_33940_length_165_cov_0.896552_g33769_i0	PRJNA770826	33940	165	0.896552	1.4793108	Salinibacter sp. 1	2065818	Bacteria	Bacteria	72.4	4.31e-13	NR	WP_105010776.1	1923971	g33769	i0	64.8	0.981818181818182	54	19	98.2	0	163	2	86	139	WP_105010776.1 alkaline phosphatase [Salinibacter sp. 10B]	diamond	162	72.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Salinibacteraceae	Salinibacter	Salinibacter sp. 10B

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);;