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

5 rows where bioproject = "PRJNA857143", tax_clade = "FCB group" and tax_phylum = "Gemmatimonadota"

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
27031546	27031546	PRJNA857143_S_NODE_196222_length_240_cov_2.305389_g195129_i0	PRJNA857143	196222	240	2.305389	5.5329336	Bacteria	2	Bacteria	Bacteria	57.8	1.8e-7	NR	HSA57409.1	2026741	g195129	i0	56.8	2.675	44	19	55	0	220	89	989	1032	HSA57409.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Gemmatimonadaceae bacterium]	diamond	642	58.2	0.993127147766323	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae bacterium
27094844	27094844	PRJNA857143_S_NODE_163582_length_256_cov_2.792350_g162489_i0	PRJNA857143	163582	256	2.79235	7.148416	Candidatus Palauibacter	3056650	Bacteria	Bacteria	64.3	1.1e-9	NR	MYI46100.1	2026742	g162489	i0	42.1	2.671875	76	44	89.1	0	3	230	894	969	MYI46100.1 type I polyketide synthase [Gemmatimonadota bacterium]	diamond	684	64.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota bacterium
28697440	28697440	PRJNA857143_S_NODE_157547_length_261_cov_1.244681_g156454_i0	PRJNA857143	157547	261	1.244681	3.24861741	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	41.2	0.0469	NR	HEV2130098.1	3047548	g156454	i0	52.9	0.390804597701149	34	16	39.1	0	32	133	2	35	HEV2130098.1 hypothetical protein [Longimicrobiaceae bacterium]	diamond	102	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobiaceae bacterium
29234105	29234105	PRJNA857143_S_NODE_73309_length_349_cov_1.923913_g72216_i0	PRJNA857143	73309	349	1.923913	6.71445637	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	90.5	1.82e-18	NR	MFN2315150.1	2448054	g72216	i0	48.3	6.86819484240688	89	42	76.5	1	345	79	379	463	MFN2315150.1 M28 family metallopeptidase [Gemmatimonadales bacterium]	diamond	2397	90.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
29644067	29644067	PRJNA857143_S_NODE_113490_length_299_cov_1.026549_g112397_i0	PRJNA857143	113490	299	1.026549	3.06938151	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	45.1	0.00989	NR	MBP9106477.1	2026741	g112397	i0	66.7	0.802675585284281	24	8	24.1	0	67	138	71	94	MBP9106477.1 DUF4331 family protein [Gemmatimonadaceae bacterium]	diamond	240	45.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonadaceae 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);;