metadata: contig_metadata: 8 rows where bioproject = "PRJNA416866", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA416866", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
4246684	4246684	PRJNA416866_P_NODE_10484_length_206_cov_0.882759_g10340_i0	PRJNA416866	10484	206	0.882759	1.81848354	Planctomycetia	203683	Bacteria	Bacteria	105	1.34e-26	NR	MEE3180495.1	2026780	g10340	i0	80.3	6.56796116504854	61	12	88.8	0	22	204	19	79	MEE3180495.1 adenosylhomocysteinase [Planctomycetota bacterium]	diamond	1353	106	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
6797408	6797408	PRJNA416866_P_NODE_11426_length_202_cov_1.361702_g11282_i0	PRJNA416866	11426	202	1.361702	2.75063804	Aureliella sp.	2795609	Bacteria	Bacteria	115	5.13e-28	NR	MFN3191721.1	2795609	g11282	i0	81.5	1.93069306930693	65	12	96.5	0	197	3	499	563	MFN3191721.1 NADP-dependent isocitrate dehydrogenase [Aureliella sp.]	diamond	390	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
16997082	16997082	PRJNA416866_P_NODE_6094_length_264_cov_1.261084_g5950_i0	PRJNA416866	6094	264	1.261084	3.32926176	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	69.4	2.39e-7	NTclustered	gi\|2621705864\|emb\|OY763926.1\|	2813034	g5950	i0	95.349	4.83333333333333	43	2	16	0	7	49	2551960	2552002	MAG: Sedimentisphaerales bacterium isolate 7f5c64f7-1a0d-4936-834e-775057159072 genome assembly, chromosome: 1	blastn	1276	69.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
27896734	27896734	PRJNA416866_P_NODE_9605_length_209_cov_0.864865_g9461_i0	PRJNA416866	9605	209	0.864865	1.80756785	Gemmataceae bacterium	2052164	Bacteria	Bacteria	50.1	6.22e-5	NR	HEX5270779.1	2052164	g9461	i0	47.7	0.631578947368421	44	23	63.2	0	206	75	617	660	HEX5270779.1 hypothetical protein [Gemmataceae bacterium]	diamond	132	50.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31276205	31276205	PRJNA416866_P_NODE_7075_length_244_cov_1.398907_g6931_i0	PRJNA416866	7075	244	1.398907	3.41333308	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	42	0.0455	NR	MFM8642726.1	2052180	g6931	i0	45.2	1.0327868852459	42	23	51.6	0	126	1	78	119	MFM8642726.1 hypothetical protein [Phycisphaerales bacterium]	diamond	252	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31339463	31339463	PRJNA416866_P_NODE_10896_length_204_cov_0.895105_g10752_i0	PRJNA416866	10896	204	0.895105	1.8260142	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42	0.0399	NR	MFM8415446.1	2026780	g10752	i0	43.1	0.75	51	23	70.6	2	157	14	185	232	MFM8415446.1 hypothetical protein [Planctomycetota bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32541967	32541967	PRJNA416866_P_NODE_8979_length_214_cov_2.091503_g8835_i0	PRJNA416866	8979	214	2.091503	4.47581642	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	49.7	6.15e-6	NR	MCP4254449.1	2268189	g8835	i0	82.1	0.785046728971963	28	5	39.3	0	1	84	28	55	MCP4254449.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	168	49.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
32747302	32747302	PRJNA416866_P_NODE_11840_length_201_cov_0.914286_g11696_i0	PRJNA416866	11840	201	0.914286	1.83771486	Bacteria	2	Bacteria	Bacteria	43.5	0.00763	NR	MAE66251.1	2026777	g11696	i0	51.7	1.73134328358209	29	14	43.3	0	2	88	53	81	MAE66251.1 cytidine deaminase [Phycisphaeraceae bacterium]	diamond	348	43.9	0.990888382687927	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;