metadata: contig_metadata: 4 rows where bioproject = "PRJEB43370" and tax

4 rows where bioproject = "PRJEB43370" and tax_phylum = "Verrucomicrobiota"

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
7712599	7712599	PRJEB43370_P_NODE_4847_length_205_cov_1.000000_g4804_i0	PRJEB43370	4847	205	1	2.05	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	121	4.839999999999999e-23	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g4804	i0	77.941	30.380487804878	204	37	98	8	1	200	3078687	3078886	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	6228	121	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26621862	26621862	PRJEB43370_P_NODE_7761_length_169_cov_0.866667_g7718_i0	PRJEB43370	7761	169	0.866667	1.46466723	Terrimicrobium sacchariphilum	690879	Bacteria	Bacteria	47.4	3.04e-4	NR	WP_075079027.1	690879	g7718	i0	58.8	0.603550295857988	34	14	60.4	0	167	66	290	323	WP_075079027.1 hypothetical protein [Terrimicrobium sacchariphilum]	diamond	102	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Terrimicrobiia	Terrimicrobiales	Terrimicrobiaceae	Terrimicrobium	Terrimicrobium sacchariphilum
27627250	27627250	PRJEB43370_P_NODE_4364_length_214_cov_1.260606_g4321_i0	PRJEB43370	4364	214	1.260606	2.69769684	Bacteria	2	Bacteria	Bacteria	101	1.0399999999999997e-23	NR	MFA5258231.1	2026772	g4321	i0	65.7	5.60747663551402	67	23	93.9	0	202	2	3	69	MFA5258231.1 malate dehydrogenase [Opitutales bacterium]	diamond	1200	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28770358	28770358	PRJEB43370_P_NODE_8947_length_166_cov_0.888889_g8904_i0	PRJEB43370	8947	166	0.888889	1.47555574	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	79.7	3.44e-16	NR	MDB4508061.1	2562705	g8904	i0	58.2	1.96987951807229	55	23	99.4	0	2	166	73	127	MDB4508061.1 endonuclease/exonuclease/phosphatase family protein [Akkermansiaceae bacterium]	diamond	327	79.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae 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);;