metadata: contig_metadata: 17 rows where bioproject = "PRJNA946307", tax_clade = "PVC group" and tax

17 rows where bioproject = "PRJNA946307", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

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_species
3478399	3478399	PRJNA946307_P_NODE_67023_length_199_cov_4.353333_g66149_i0	PRJNA946307	67023	199	4.353333	8.66313267	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	104	3.16e-24	NR	MBW7908541.1	2212473	g66149	i0	59.2	1.55276381909548	103	1	93.5	1	199	14	102	204	MBW7908541.1 preprotein translocase subunit SecA [Kiritimatiellia bacterium]	diamond	309	104	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
12404803	12404803	PRJNA946307_P_NODE_109790_length_180_cov_1.244275_g108916_i0	PRJNA946307	109790	180	1.244275	2.239695	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	117	5.96e-29	NR	MBW7908541.1	2212473	g108916	i0	100	0.9	54	0	90	0	166	5	55	108	MBW7908541.1 preprotein translocase subunit SecA [Kiritimatiellia bacterium]	diamond	162	117	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
27151362	27151362	PRJNA946307_P_NODE_105962_length_181_cov_2.939394_g105088_i0	PRJNA946307	105962	181	2.939394	5.32030314	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	124	1.8099999999999998e-32	NR	MFA7054871.1	2212473	g105088	i0	98.2	0.92817679558011	56	1	92.8	0	181	14	118	173	MFA7054871.1 RRXRR domain-containing protein [Kiritimatiellia bacterium]	diamond	168	124	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
27499545	27499545	PRJNA946307_P_NODE_64903_length_200_cov_3.662252_g64029_i0	PRJNA946307	64903	200	3.662252	7.324504	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	108	4.25e-27	NR	MCO5068618.1	2212473	g64029	i0	86.2	0.975	65	6	93	1	187	2	112	176	MCO5068618.1 MotA/TolQ/ExbB proton channel family protein [Kiritimatiellia bacterium]	diamond	195	108	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
28351839	28351839	PRJNA946307_P_NODE_140366_length_167_cov_1.635593_g139492_i0	PRJNA946307	140366	167	1.635593	2.73144031	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	67	3.15e-11	NR	MCO5069465.1	2212473	g139492	i0	91.7	0.646706586826347	36	3	64.7	0	53	160	297	332	MCO5069465.1 type II secretion system protein GspK [Kiritimatiellia bacterium]	diamond	108	67	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
29242700	29242700	PRJNA946307_P_NODE_102689_length_183_cov_1.447761_g101815_i0	PRJNA946307	102689	183	1.447761	2.64940263	Candidatus Colisoma	3082832	Bacteria	Bacteria	50.8	2.39e-5	NR	MBO5939584.1	2212473	g101815	i0	68.8	2	32	10	52.5	0	19	114	717	748	MBO5939584.1 GH92 family glycosyl hydrolase [Kiritimatiellia bacterium]	diamond	366	51.2	0.9921875	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
29330733	29330733	PRJNA946307_P_NODE_96129_length_186_cov_1.416058_g95255_i0	PRJNA946307	96129	186	1.416058	2.63386788	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	120	6.959999999999999e-31	NR	MCO5044323.1	2212473	g95255	i0	100	0.919354838709677	57	0	91.9	0	186	16	126	182	MCO5044323.1 YgeY family selenium metabolism-linked hydrolase [Kiritimatiellia bacterium]	diamond	171	120	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30120114	30120114	PRJNA946307_P_NODE_57532_length_210_cov_2.695652_g56658_i0	PRJNA946307	57532	210	2.695652	5.6608692	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	70.1	5.78e-12	NR	MCO5069109.1	2212473	g56658	i0	100	0.471428571428571	33	0	47.1	0	1	99	2403	2435	MCO5069109.1 right-handed parallel beta-helix repeat-containing protein [Kiritimatiellia bacterium]	diamond	99	70.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30214891	30214891	PRJNA946307_P_NODE_72252_length_198_cov_5.805369_g71378_i0	PRJNA946307	72252	198	5.805369	11.49463062	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	67	5.38e-11	NR	MCO5067681.1	2212473	g71378	i0	93.9	0.5	33	2	50	0	99	197	252	284	MCO5067681.1 integrase [Kiritimatiellia bacterium]	diamond	99	67	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30657364	30657364	PRJNA946307_P_NODE_93753_length_187_cov_1.413043_g92879_i0	PRJNA946307	93753	187	1.413043	2.64239041	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	67.4	3.42e-11	NR	MCO5062447.1	2212473	g92879	i0	97.1	0.545454545454545	34	1	54.5	0	15	116	280	313	MCO5062447.1 30S ribosomal protein S1 [Kiritimatiellia bacterium]	diamond	102	67.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
30783716	30783716	PRJNA946307_P_NODE_164294_length_161_cov_2.535714_g163420_i0	PRJNA946307	164294	161	2.535714	4.08249954	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	102	3.92e-24	NR	MCO5045465.1	2212473	g163420	i0	94.2	0.968944099378882	52	3	96.9	0	160	5	69	120	MCO5045465.1 DNA polymerase IV [Kiritimatiellia bacterium]	diamond	156	102	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31131055	31131055	PRJNA946307_P_NODE_67535_length_199_cov_4.140000_g66661_i0	PRJNA946307	67535	199	4.14	8.2386	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	76.6	1.64e-14	NR	MBW7908436.1	2212473	g66661	i0	91.9	0.557788944723618	37	3	55.8	0	2	112	156	192	MBW7908436.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	111	76.6	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31352631	31352631	PRJNA946307_P_NODE_108376_length_180_cov_2.603053_g107502_i0	PRJNA946307	108376	180	2.603053	4.6854954	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	110	6.03e-27	NR	MBW7908566.1	2212473	g107502	i0	100	0.916666666666667	55	0	91.7	0	180	16	191	245	MBW7908566.1 LL-diaminopimelate aminotransferase [Kiritimatiellia bacterium]	diamond	165	110	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31826846	31826846	PRJNA946307_P_NODE_152177_length_164_cov_1.695652_g151303_i0	PRJNA946307	152177	164	1.695652	2.78086928	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	103	6.89e-25	NR	MCO5060400.1	2212473	g151303	i0	100	0.914634146341463	50	0	91.5	0	150	1	172	221	MCO5060400.1 signal peptide peptidase SppA [Kiritimatiellia bacterium]	diamond	150	103	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31890230	31890230	PRJNA946307_P_NODE_140457_length_167_cov_1.610169_g139583_i0	PRJNA946307	140457	167	1.610169	2.68898223	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	103	6.83e-24	NR	MCO5069109.1	2212473	g139583	i0	98	0.916167664670659	51	1	91.6	0	2	154	2298	2348	MCO5069109.1 right-handed parallel beta-helix repeat-containing protein [Kiritimatiellia bacterium]	diamond	153	103	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
31890301	31890301	PRJNA946307_P_NODE_67857_length_199_cov_3.793333_g66983_i0	PRJNA946307	67857	199	3.793333	7.54873267	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	69.3	8.93e-12	NR	MBW7908433.1	2212473	g66983	i0	94.1	0.512562814070352	34	2	51.3	0	103	2	634	667	MBW7908433.1 family 10 glycosylhydrolase [Kiritimatiellia bacterium]	diamond	102	69.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia bacterium
32617824	32617824	PRJNA946307_P_NODE_56140_length_210_cov_2.857143_g55266_i0	PRJNA946307	56140	210	2.857143	6.0000003	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	99.8	9.13e-23	NR	MCO5043775.1	2212473	g55266	i0	62.1	1.35714285714286	95	5	91.4	1	195	4	1	95	MCO5043775.1 MFS transporter [Kiritimatiellia bacterium]	diamond	285	99.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellia 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);;