metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA309466" 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
29853182	29853182	PRJNA309466_P_NODE_12771_length_182_cov_1.759398_g12714_i0	PRJNA309466	12771	182	1.759398	3.20210436	Akkermansia muciniphila	239935	Bacteria	Bacteria	53.9	1.78e-6	NR	WP_306701351.1	239935	g12714	i0	51.1	4.56593406593407	45	22	74.2	0	3	137	183	227	WP_306701351.1 phage terminase large subunit family protein [Akkermansia muciniphila]	diamond	831	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
31591424	31591424	PRJNA309466_P_NODE_4496_length_271_cov_8.423423_g4440_i0	PRJNA309466	4496	271	8.423423	22.82747633	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	45.8	0.00358	NR	HEY4813219.1	2201154	g4440	i0	34.3	0.774907749077491	70	45	76.4	1	49	255	89	158	HEY4813219.1 peptidase E [Chthoniobacterales bacterium]	diamond	210	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32224063	32224063	PRJNA309466_P_NODE_17078_length_164_cov_6.200000_g17021_i0	PRJNA309466	17078	164	6.2	10.168	Luteolibacter marinus	2776705	Bacteria	Bacteria	62.8	1.25e-10	NR	WP_193214802.1	2776705	g17021	i0	55.6	0.823170731707317	45	20	82.3	0	156	22	92	136	WP_193214802.1 hypothetical protein [Luteolibacter marinus]	diamond	135	62.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter marinus
32382222	32382222	PRJNA309466_P_NODE_10099_length_199_cov_1.253333_g10042_i0	PRJNA309466	10099	199	1.253333	2.49413267	Verrucomicrobiota bacterium JB023	3064552	Bacteria	Bacteria	42	0.0386	NR	MDP0490338.1	3064552	g10042	i0	39.7	0.874371859296482	58	33	87.4	1	10	183	162	217	MDP0490338.1 DMT family transporter [Verrucomicrobiota bacterium JB023]	diamond	174	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium JB023
32666390	32666390	PRJNA309466_P_NODE_8280_length_213_cov_4.481707_g8223_i0	PRJNA309466	8280	213	4.481707	9.54603591	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42	0.0489	NR	HUJ72028.1	2499141	g8223	i0	39.7	0.887323943661972	63	33	88.7	2	7	195	154	211	HUJ72028.1 tetratricopeptide repeat protein [Verrucomicrobiia bacterium]	diamond	189	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;