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

5 rows where bioproject = "PRJNA792582", 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_species
7593472	7593472	PRJNA792582_P_NODE_34326_length_294_cov_0.918552_g33512_i0	PRJNA792582	34326	294	0.918552	2.70054288	Rhodothermales	1853224	Bacteria	Bacteria	361	3.9899999999999996e-95	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g33512	i0	88.963	291.69387755102	299	23	100	9	1	294	2906132	2905839	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	85758	363	0.994490358126722	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermaceae bacterium RA
18628500	18628500	PRJNA792582_P_NODE_36375_length_287_cov_1.803738_g35561_i0	PRJNA792582	36375	287	1.803738	5.17672806	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	204	6.919999999999999e-48	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g35561	i0	82.773	3.11149825783972	238	31	81	10	38	270	2086152	2085920	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	893	204	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccaceae bacterium
27211624	27211624	PRJNA792582_P_NODE_58842_length_241_cov_2.297619_g58028_i0	PRJNA792582	58842	241	2.297619	5.53726179	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	45.8	0.00108	NR	HEX8384703.1	2838334	g58028	i0	46.5	1.73029045643154	71	24	74.7	4	48	227	3	70	HEX8384703.1 hypothetical protein [Rubricoccaceae bacterium]	diamond	417	45.8	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccaceae bacterium
29737659	29737659	PRJNA792582_P_NODE_54610_length_246_cov_0.890173_g53796_i0	PRJNA792582	54610	246	0.890173	2.18982558	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	48.5	3.57e-4	NR	MDX1419468.1	2838334	g53796	i0	44.8	2.30487804878049	67	24	81.7	1	4	204	358	411	MDX1419468.1 T9SS type A sorting domain-containing protein [Rubricoccaceae bacterium]	diamond	567	48.5	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubricoccaceae bacterium
30748878	30748878	PRJNA792582_P_NODE_38614_length_281_cov_1.918269_g37800_i0	PRJNA792582	38614	281	1.918269	5.39033589	Rhodothermales bacterium	2306054	Bacteria	Bacteria	74.7	2.85e-13	NR	HYE57945.1	2306054	g37800	i0	59.5	0.843416370106762	79	32	84.3	0	1	237	24	102	HYE57945.1 HAMP domain-containing protein [Rhodothermales bacterium]	diamond	237	74.7	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales		Rhodothermales 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);;