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

10 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax_clade = "PVC group"

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
26757597	26757597	PRJNA309466_P_NODE_14941_length_171_cov_2.360656_g14884_i0	PRJNA309466	14941	171	2.360656	4.03672176	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	86.3	2.08e-18	NR	MFM9963103.1	2026779	g14884	i0	73.9	4.03508771929825	46	12	80.7	0	140	3	2	47	MFM9963103.1 phage Gp37/Gp68 family protein [Planctomycetaceae bacterium]	diamond	690	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
26821250	26821250	PRJNA309466_P_NODE_18141_length_162_cov_0.920354_g18084_i0	PRJNA309466	18141	162	0.920354	1.49097348	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	43.9	0.00505	NR	MCX6348641.1	2093365	g18084	i0	43.2	0.685185185185185	37	17	68.5	1	138	28	167	199	MCX6348641.1 alanine--tRNA ligase [Candidatus Auribacterota bacterium]	diamond	111	43.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
27692338	27692338	PRJNA309466_P_NODE_19804_length_152_cov_2.019417_g19747_i0	PRJNA309466	19804	152	2.019417	3.06951384	Pseudomonadati	3379134	Bacteria	Bacteria	73.2	2.81e-15	NR	MFH1226526.1	2026780	g19747	i0	70.2	3.71052631578947	47	14	92.8	0	12	152	17	63	MFH1226526.1 nucleotide pyrophosphohydrolase [Planctomycetota bacterium]	diamond	564	73.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27706438	27706438	PRJNA309466_P_NODE_11844_length_187_cov_1.876812_g11787_i0	PRJNA309466	11844	187	1.876812	3.50963844	Waddlia chondrophila	71667	Bacteria	Bacteria	51.2	6.46e-7	NR	WP_282954073.1	71667	g11787	i0	88	1.29946524064171	25	3	40.1	0	123	49	1	25	WP_282954073.1 hypothetical protein [Waddlia chondrophila]	diamond	243	51.2	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
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
31654312	31654312	PRJNA309466_P_NODE_17617_length_163_cov_1.394737_g17560_i0	PRJNA309466	17617	163	1.394737	2.27342131	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	82.4	2.87e-18	NR	MDI9320589.1	2052180	g17560	i0	76.9	0.957055214723926	52	12	95.7	0	5	160	81	132	MDI9320589.1 hypothetical protein [Phycisphaerales bacterium]	diamond	156	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;