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

6 rows where bioproject = "PRJNA900028", 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
874821	874821	PRJNA900028_P_NODE_15381_length_297_cov_1.330645_g14632_i0	PRJNA900028	15381	297	1.330645	3.95201565	Rhodothermales bacterium	2306054	Bacteria	Bacteria	119	2.6e-29	NR	MDX1546732.1	2306054	g14632	i0	68.3	2.3030303030303	82	26	82.8	0	3	248	250	331	MDX1546732.1 response regulator [Rhodothermales bacterium]	diamond	684	119	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
25102003	25102003	PRJNA900028_P_NODE_79660_length_185_cov_1.477941_g78911_i0	PRJNA900028	79660	185	1.477941	2.73419085	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	161	2.52e-35	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g78911	i0	83.06	1.8	183	25	97	5	1	180	3513428	3513249	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	333	161	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
26992294	26992294	PRJNA900028_P_NODE_138082_length_166_cov_0.871795_g137333_i0	PRJNA900028	138082	166	0.871795	1.4471797	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	105	7.830000000000001e-26	NR	HEX8297584.1	2838334	g137333	i0	90.9	0.993975903614458	55	5	99.4	0	165	1	116	170	HEX8297584.1 tetratricopeptide repeat protein [Rubricoccaceae bacterium]	diamond	165	105	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
27845308	27845308	PRJNA900028_P_NODE_173104_length_163_cov_0.894737_g172355_i0	PRJNA900028	173104	163	0.894737	1.45842131	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	68.6	5.5e-12	NR	HEX8385928.1	2838334	g172355	i0	70.6	0.938650306748466	51	15	93.9	0	6	158	11	61	HEX8385928.1 cyanophycinase [Rubricoccaceae bacterium]	diamond	153	68.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
28547973	28547973	PRJNA900028_P_NODE_190627_length_161_cov_0.910714_g189878_i0	PRJNA900028	190627	161	0.910714	1.46624954	Rubricoccaceae	1853227	Bacteria	Bacteria	89.7	3.39e-19	NR	WP_094549909.1	716817	g189878	i0	81.8	2.49689440993789	44	8	82	0	7	138	115	158	WP_094549909.1 formate dehydrogenase subunit alpha [Rubricoccus marinus]	diamond	402	89.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccus	Rubricoccus marinus
31730791	31730791	PRJNA900028_P_NODE_178937_length_162_cov_0.902655_g178188_i0	PRJNA900028	178937	162	0.902655	1.4623011	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	82.4	1.16e-16	NR	HEX9953429.1	2838334	g178188	i0	86.5	1.92592592592593	52	7	96.3	0	5	160	164	215	HEX9953429.1 tRNA uridine-5-carboxymethylaminomethyl(34) synthesis GTPase MnmE [Rubricoccaceae bacterium]	diamond	312	82.4	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);;