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

5 rows where bioproject = "PRJNA505329", 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
3661645	3661645	PRJNA505329_P_NODE_45683_length_166_cov_0.888889_g45212_i0	PRJNA505329	45683	166	0.888889	1.47555574	Rhodothermales	1853224	Bacteria	Bacteria	224	2.7799999999999995e-54	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g45212	i0	92.405	178.975903614458	158	11	95	1	6	163	2905305	2905461	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	29710	224	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
13237014	13237014	PRJNA505329_P_NODE_12431_length_233_cov_3.163043_g11960_i0	PRJNA505329	12431	233	3.163043	7.36989019	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	148	2.5899999999999997e-31	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g11960	i0	93.069	243.021459227468	101	7	43	0	1	101	3830958	3830858	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	56624	148	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
22160065	22160065	PRJNA505329_P_NODE_30038_length_187_cov_2.130435_g29567_i0	PRJNA505329	30038	187	2.130435	3.98391345	Rhodocaloribacter litoris	2558931	Bacteria	Bacteria	252	1.47e-62	NTclustered	gi\|2076465437\|gb\|CP076718.1\|	2558931	g29567	i0	91.304	189.866310160428	184	16	98	0	4	187	2532211	2532394	Rhodocaloribacter litoris strain ISCAR-4553 chromosome	blastn	35505	252	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodocaloribacter	Rhodocaloribacter litoris
27993168	27993168	PRJNA505329_P_NODE_22245_length_200_cov_3.701987_g21774_i0	PRJNA505329	22245	200	3.701987	7.403974	Rhodothermales bacterium	2306054	Bacteria	Bacteria	60.8	8.56e-9	NR	MBE2185245.1	2306054	g21774	i0	61.8	0.825	55	14	82.5	1	169	5	8	55	MBE2185245.1 amidohydrolase family protein [Rhodothermales bacterium]	diamond	165	60.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
29350823	29350823	PRJNA505329_P_NODE_52129_length_154_cov_2.923810_g51658_i0	PRJNA505329	52129	154	2.92381	4.5026674	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	89.4	3.28e-19	NR	HEX9950714.1	2838334	g51658	i0	88	0.974025974025974	50	6	97.4	0	3	152	56	105	HEX9950714.1 type II secretion system F family protein [Rubricoccaceae bacterium]	diamond	150	89.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);;