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

5 rows where bioproject = "PRJEB10140", 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
10215139	10215139	PRJEB10140_P_NODE_245789_length_169_cov_0.866667_g228480_i0	PRJEB10140	245789	169	0.866667	1.46466723	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	105	4.65e-25	NR	HEX9951676.1	2838334	g228480	i0	89.3	0.994082840236686	56	6	99.4	0	168	1	255	310	HEX9951676.1 phosphoglucomutase/phosphomannomutase family protein [Rubricoccaceae bacterium]	diamond	168	105	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27658643	27658643	PRJEB10140_P_NODE_171284_length_221_cov_2.104651_g153975_i0	PRJEB10140	171284	221	2.104651	4.65127871	Pseudomonadati	3379134	Bacteria	Bacteria	99	6.8e-23	NR	WP_012842652.1	29549	g153975	i0	65.8	5.90497737556561	73	25	99.1	0	219	1	132	204	WP_012842652.1 L-lactate dehydrogenase [Rhodothermus marinus]	diamond	1305	100	0.99	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
28801030	28801030	PRJEB10140_P_NODE_65648_length_559_cov_3.603922_g33225_i1	PRJEB10140	65648	559	3.603922	20.14592398	Rhodothermales bacterium	2306054	Bacteria	Bacteria	65.9	8.04e-10	NR	NNE45994.1	2306054	g33225	i1	27.7	0.89087656529517	166	106	86.9	4	557	72	4	159	NNE45994.1 SgcJ/EcaC family oxidoreductase [Rhodothermales bacterium]	diamond	498	65.9	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29022476	29022476	PRJEB10140_P_NODE_116728_length_313_cov_2.109848_g99422_i0	PRJEB10140	116728	313	2.109848	6.60382424	Rhodothermus sp.	2591385	Bacteria	Bacteria	46.2	0.0047	NR	MDQ7041814.1	2591385	g99422	i0	29.5	1.00638977635783	105	49	81.5	4	51	305	44	143	MDQ7041814.1 6-bladed beta-propeller [Rhodothermus sp.]	diamond	315	46.2	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus sp.
31707649	31707649	PRJEB10140_P_NODE_157237_length_237_cov_2.787234_g139929_i0	PRJEB10140	157237	237	2.787234	6.60574458	Rhodothermia bacterium	2497633	Bacteria	Bacteria	47	0.00113	NR	MBN8587230.1	2497633	g139929	i0	41.1	3	56	33	70.9	0	237	70	357	412	MBN8587230.1 ribonuclease R [Rhodothermia bacterium]	diamond	711	47	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia				Rhodothermia 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);;