metadata: contig_metadata: 4 rows where bioproject = "PRJNA600413", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA600413", 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
14603815	14603815	PRJNA600413_P_NODE_71092_length_185_cov_4.088235_g70391_i0	PRJNA600413	71092	185	4.088235	7.56323475	Rhodothermus marinus	29549	Bacteria	Bacteria	91.6	3.35e-14	NTclustered	gi\|2844596544\|gb\|CP172416.1\|	29549	g70391	i0	86.047	3.10810810810811	86	10	46	2	101	185	3095311	3095395	Rhodothermus marinus strain ISCAR-493 chromosome	blastn	575	91.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
23525539	23525539	PRJNA600413_P_NODE_127959_length_164_cov_0.886957_g127258_i0	PRJNA600413	127959	164	0.886957	1.45460948	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	89.4	6.25e-20	NR	HYE96395.1	2838334	g127258	i0	81.5	0.98780487804878	54	10	98.8	0	163	2	132	185	HYE96395.1 SDR family NAD(P)-dependent oxidoreductase [Rubricoccaceae bacterium]	diamond	162	89.4	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
28216638	28216638	PRJNA600413_P_NODE_106406_length_167_cov_0.864407_g105705_i0	PRJNA600413	106406	167	0.864407	1.44355969	Rhodothermales bacterium	2306054	Bacteria	Bacteria	101	3.24e-23	NR	HYE57207.1	2306054	g105705	i0	80	0.988023952095808	55	11	98.8	0	166	2	658	712	HYE57207.1 TonB-dependent receptor [Rhodothermales bacterium]	diamond	165	101	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
31976441	31976441	PRJNA600413_P_NODE_123338_length_164_cov_1.643478_g122637_i0	PRJNA600413	123338	164	1.643478	2.69530392	Rubrivirga sp. SAORIC476	1961794	Bacteria	Bacteria	47	4.07e-4	NR	WP_095513182.1	1961794	g122637	i0	57.1	0.896341463414634	49	21	89.6	0	163	17	448	496	WP_095513182.1 beta strand repeat-containing protein [Rubrivirga sp. SAORIC476]	diamond	147	47	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. SAORIC476

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