metadata: contig_metadata: 6 rows where bioproject = "PRJNA664479", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJNA664479", tax_clade = "PVC group" and tax_superkingdom = "Bacteria"

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
8282368	8282368	PRJNA664479_S_NODE_12827_length_173_cov_1.096774_g12751_i0	PRJNA664479	12827	173	1.096774	1.89741902	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	187	3.82e-43	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g12751	i0	96.46	81.2658959537572	113	4	65	0	3	115	1155466	1155354	Planctomyces sp. SH-PL62, complete genome	blastn	14059	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
13383214	13383214	PRJNA664479_S_NODE_9791_length_189_cov_1.571429_g9715_i0	PRJNA664479	9791	189	1.571429	2.97000081	Thalassoglobus polymorphus	2527994	Bacteria	Bacteria	283	5.28e-72	NTclustered	gi\|1712486265\|gb\|CP036267.1\|	2527994	g9715	i0	95.028	122.444444444444	181	7	95	2	10	189	5086921	5086742	Thalassoglobus polymorphus strain Mal48 chromosome	blastn	23142	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Thalassoglobus	Thalassoglobus polymorphus
26732894	26732894	PRJNA664479_S_NODE_11481_length_180_cov_0.717557_g11405_i0	PRJNA664479	11481	180	0.717557	1.2916026	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42	0.0298	NR	GIW73795.1	2052180	g11405	i0	47.7	0.733333333333333	44	22	73.3	1	148	17	56	98	GIW73795.1 MAG: hypothetical protein KatS3mg103_0317 [Phycisphaerales bacterium]	diamond	132	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
29892100	29892100	PRJNA664479_S_NODE_5351_length_232_cov_0.918033_g5275_i0	PRJNA664479	5351	232	0.918033	2.12983656	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.4	0.0217	NR	HKE01096.1	2026780	g5275	i0	35.8	0.866379310344828	67	40	82.8	2	39	230	13	79	HKE01096.1 PH domain-containing protein [Planctomycetota bacterium]	diamond	201	42.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31345517	31345517	PRJNA664479_S_NODE_19056_length_161_cov_0.857143_g18980_i0	PRJNA664479	19056	161	0.857143	1.38000023	Gemmataceae bacterium	2052164	Bacteria	Bacteria	43.5	0.00655	NR	HVS39311.1	2052164	g18980	i0	47.1	0.950310559006211	51	25	95	1	4	156	16	64	HVS39311.1 MFS transporter [Gemmataceae bacterium]	diamond	153	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32073006	32073006	PRJNA664479_S_NODE_4558_length_246_cov_0.923858_g4482_i0	PRJNA664479	4558	246	0.923858	2.27269068	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	43.5	0.00377	NR	MFM8783593.1	2052180	g4482	i0	55	0.48780487804878	40	15	45.1	1	51	161	8	47	MFM8783593.1 hypothetical protein [Phycisphaerales bacterium]	diamond	120	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;