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

5 rows where bioproject = "PRJEB65099" 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_genus	tax_species
3956062	3956062	PRJEB65099_P_NODE_6744_length_243_cov_0.900000_g6639_i0	PRJEB65099	6744	243	0.9	2.187	Gemmatimonas groenlandica	2732249	Bacteria	Bacteria	224	4.3899999999999996e-54	NTclustered	gi\|1839994010\|gb\|CP053085.1\|	2732249	g6639	i0	87.629	27.238683127572	194	22	79	2	1	193	1103029	1103221	Gemmatimonas groenlandica strain TET16 chromosome, complete genome	blastn	6619	224	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas groenlandica
9921991	9921991	PRJEB65099_P_NODE_6468_length_244_cov_0.912281_g6363_i0	PRJEB65099	6468	244	0.912281	2.22596564	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	137	4.5299999999999997e-38	NR	MBA3496714.1	2448054	g6363	i0	86.4	0.995901639344262	81	11	99.6	0	1	243	111	191	MBA3496714.1 ABC transporter ATP-binding protein [Gemmatimonadales bacterium]	diamond	243	137	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
14158349	14158349	PRJEB65099_P_NODE_3892_length_283_cov_2.000000_g3787_i0	PRJEB65099	3892	283	2	5.66	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	381	2.929999999999999e-101	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g3787	i0	91.166	93.5724381625442	283	21	99	4	4	283	801442	801161	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	26481	381	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27381738	27381738	PRJEB65099_P_NODE_5963_length_247_cov_0.896552_g5858_i0	PRJEB65099	5963	247	0.896552	2.21448344	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	42.4	0.0478	NR	HEU5217613.1	2448054	g5858	i0	45.1	0.619433198380567	51	27	60.7	1	226	77	86	136	HEU5217613.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	153	42.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30792178	30792178	PRJEB65099_P_NODE_6294_length_245_cov_0.906977_g6189_i0	PRJEB65099	6294	245	0.906977	2.22209365	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	92	2.5300000000000003e-22	NR	MFQ5746296.1	2026742	g6189	i0	80.8	2.49795918367347	52	10	63.7	0	88	243	11	62	MFQ5746296.1 30S ribosomal protein S18 [Gemmatimonadota bacterium]	diamond	612	92	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);;