metadata: contig_metadata: 5 rows where bioproject = "PRJNA576995" and tax

5 rows where bioproject = "PRJNA576995" 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
12039720	12039720	PRJNA576995_P_NODE_23010_length_317_cov_1.577869_g22418_i0	PRJNA576995	23010	317	1.577869	5.00184473	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	399	9.21e-107	NTclustered	gi\|2874253978\|emb\|OY970303.1\|	412054	g22418	i0	89.655	26.7287066246057	319	26	99	6	2	317	1903184	1903498	MAG: uncultured Gemmatimonadales bacterium isolate MFD01275.bin.c.12 genome assembly, chromosome: 1	blastn	8473	399	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		uncultured Gemmatimonadales bacterium
14589573	14589573	PRJNA576995_P_NODE_29632_length_280_cov_1.458937_g29040_i0	PRJNA576995	29632	280	1.458937	4.0850236	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	98.2	1.08e-21	NR	MFL5386477.1	3047548	g29040	i0	84.1	0.675	63	10	67.5	0	278	90	15	77	MFL5386477.1 IS21 family transposase [Longimicrobiaceae bacterium]	diamond	189	98.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobiaceae bacterium
22237831	22237831	PRJNA576995_P_NODE_32878_length_262_cov_1.222222_g32286_i0	PRJNA576995	32878	262	1.222222	3.20222164	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	355	1.63e-93	NTclustered	gi\|2874253728\|emb\|OY969570.1\|	412054	g32286	i0	91.255	132.030534351145	263	20	100	3	1	262	172076	172336	MAG: uncultured Gemmatimonadales bacterium isolate MFD02840.bin.c.1 genome assembly, chromosome: 1	blastn	34592	355	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		uncultured Gemmatimonadales bacterium
30995920	30995920	PRJNA576995_P_NODE_24854_length_306_cov_1.364807_g24262_i0	PRJNA576995	24854	306	1.364807	4.17630942	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	135	1.81e-35	NR	HSB53493.1	2448054	g24262	i0	65.3	5.68627450980392	95	33	93.1	0	3	287	312	406	HSB53493.1 aspartate aminotransferase family protein [Gemmatimonadales bacterium]	diamond	1740	135	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales		Gemmatimonadales bacterium
32829264	32829264	PRJNA576995_P_NODE_18220_length_352_cov_1.003584_g17628_i0	PRJNA576995	18220	352	1.003584	3.53261568	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	47.4	0.00294	NR	NNE08319.1	2026742	g17628	i0	33	1.53409090909091	91	50	69.9	2	99	344	41	129	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	540	47.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota				Gemmatimonadota 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);;