metadata: contig_metadata: 9 rows where bioproject = "PRJNA255848" and tax

9 rows where bioproject = "PRJNA255848" 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
368698	368698	PRJNA255848_P_NODE_4141_length_553_cov_3.521825_g3837_i0	PRJNA255848	4141	553	3.521825	19.47569225	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	933	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3837	i0	97.107	278.580470162749	553	16	100	0	1	553	2463	1911	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	154055	933	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1643575	1643575	PRJNA255848_P_NODE_722_length_1244_cov_4.487029_g578_i0	PRJNA255848	722	1244	4.487029	55.81864076	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1954	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g578	i0	95.016	225.733922829582	1244	62	100	0	1	1244	338	1581	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	280813	1954	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
9985098	9985098	PRJNA255848_P_NODE_42368_length_164_cov_0.886957_g42050_i0	PRJNA255848	42368	164	0.886957	1.45460948	Pedosphaera	1032526	Bacteria	Bacteria	102	6.25e-25	NR	PHX95918.1	2024890	g42050	i0	92.6	3.95121951219512	54	4	98.8	0	1	162	108	161	PHX95918.1 MAG: hypothetical protein CK546_00005 [Pedosphaera sp.]	diamond	648	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
13122435	13122435	PRJNA255848_P_NODE_18991_length_228_cov_1.703911_g18673_i0	PRJNA255848	18991	228	1.703911	3.88491708	Luteolibacter sp.	1962973	Bacteria	Bacteria	372	1.37e-98	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g18673	i0	96.053	273.565789473684	228	9	100	0	1	228	1008799	1009026	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	62373	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18220445	18220445	PRJNA255848_P_NODE_7955_length_377_cov_2.268293_g7637_i0	PRJNA255848	7955	377	2.268293	8.55146461	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	577	4.789999999999999e-160	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g7637	i0	97.904	231.46949602122	334	5	88	1	46	377	1562	1895	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	87264	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
22045271	22045271	PRJNA255848_P_NODE_28178_length_187_cov_3.797101_g27860_i0	PRJNA255848	28178	187	3.797101	7.10057887	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	243	8.85e-60	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g27860	i0	92.398	3.01604278074866	171	11	91	2	4	173	316	147	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	564	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
28828503	28828503	PRJNA255848_P_NODE_47248_length_161_cov_0.910714_g46930_i0	PRJNA255848	47248	161	0.910714	1.46624954	Bacteria	2	Bacteria	Bacteria	74.3	8.4e-15	NR	MEA2011983.1	2026799	g46930	i0	60.4	3.93167701863354	53	21	98.8	0	159	1	35	87	MEA2011983.1 phosphohydrolase [Verrucomicrobiota bacterium]	diamond	633	74.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29726289	29726289	PRJNA255848_P_NODE_18250_length_233_cov_1.135870_g17932_i0	PRJNA255848	18250	233	1.13587	2.6465771	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42.4	0.0414	NR	HEY3862872.1	2499141	g17932	i0	48.5	0.424892703862661	33	17	42.5	0	91	189	193	225	HEY3862872.1 3'(2'),5'-bisphosphate nucleotidase CysQ [Verrucomicrobiia bacterium]	diamond	99	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30263901	30263901	PRJNA255848_P_NODE_45952_length_162_cov_0.902655_g45634_i0	PRJNA255848	45952	162	0.902655	1.4623011	Luteolibacter yonseiensis	1144680	Bacteria	Bacteria	92.4	2.25e-21	NR	WP_200350219.1	1144680	g45634	i0	75.9	1	54	13	100	0	1	162	121	174	WP_200350219.1 GDSL-type esterase/lipase family protein [Luteolibacter yonseiensis]	diamond	162	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter yonseiensis

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);;