metadata: contig_metadata: 16 rows where bioproject = "PRJNA438111", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA438111", 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_order	tax_family	tax_genus	tax_species
5537697	5537697	PRJNA438111_P_NODE_29325_length_210_cov_4.745856_g28700_i0	PRJNA438111	29325	210	4.745856	9.9662976	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	108	3.88e-19	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g28700	i0	86.598	2.06666666666667	97	13	46	0	1	97	2668925	2669021	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	434	108	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
26980964	26980964	PRJNA438111_P_NODE_32062_length_210_cov_3.535912_g31437_i0	PRJNA438111	32062	210	3.535912	7.4254152	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	72.4	5.5e-13	NR	MDE0839027.1	2212473	g31437	i0	100	0.471428571428571	33	0	47.1	0	1	99	275	307	MDE0839027.1 fatty acid desaturase [Kiritimatiellia bacterium]	diamond	99	72.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27313711	27313711	PRJNA438111_P_NODE_32383_length_210_cov_3.403315_g31758_i0	PRJNA438111	32383	210	3.403315	7.1469615	Pseudomonadati	3379134	Bacteria	Bacteria	70.1	2.25e-12	NR	MBQ6007524.1	2212473	g31758	i0	86.8	9.45714285714286	38	5	54.3	0	209	96	91	128	MBQ6007524.1 type III secretion system export apparatus subunit SctT [Kiritimatiellia bacterium]	diamond	1986	70.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27549776	27549776	PRJNA438111_P_NODE_45404_length_187_cov_2.544304_g44779_i0	PRJNA438111	45404	187	2.544304	4.75784848	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	69.7	5.26e-12	NR	MFA6632188.1	2212473	g44779	i0	49.2	2.93582887700535	61	31	97.9	0	185	3	459	519	MFA6632188.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Kiritimatiellia bacterium]	diamond	549	69.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27644840	27644840	PRJNA438111_P_NODE_56844_length_174_cov_4.275862_g56219_i0	PRJNA438111	56844	174	4.275862	7.43999988	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	85.1	1.16e-17	NR	MDE0839028.1	2212473	g56219	i0	100	0.741379310344828	43	0	74.1	0	172	44	352	394	MDE0839028.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Kiritimatiellia bacterium]	diamond	129	85.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
28970741	28970741	PRJNA438111_P_NODE_24308_length_220_cov_3.581152_g23683_i0	PRJNA438111	24308	220	3.581152	7.8785344	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	144	3.68e-38	NR	MDE0839434.1	2212473	g23683	i0	100	0.981818181818182	72	0	98.2	0	218	3	503	574	MDE0839434.1 prolyl oligopeptidase family serine peptidase [Kiritimatiellia bacterium]	diamond	216	144	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29601862	29601862	PRJNA438111_P_NODE_30610_length_210_cov_4.033149_g29985_i0	PRJNA438111	30610	210	4.033149	8.4696129	Kiritimatiellota bacterium	2599938	Bacteria	Bacteria	69.7	7.28e-12	NR	MCX7010480.1	2599938	g29985	i0	76.9	3.08571428571429	39	9	55.7	0	118	2	149	187	MCX7010480.1 IS21 family transposase [Kiritimatiellota bacterium]	diamond	648	69.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium
29601902	29601902	PRJNA438111_P_NODE_77150_length_160_cov_2.633588_g76525_i0	PRJNA438111	77150	160	2.633588	4.2137408	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	68.9	6.45e-12	NR	MCZ7592937.1	2212473	g76525	i0	57.7	2.925	52	22	97.5	0	158	3	351	402	MCZ7592937.1 FAD-dependent oxidoreductase [Kiritimatiellia bacterium]	diamond	468	68.9	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30044258	30044258	PRJNA438111_P_NODE_31731_length_210_cov_3.635359_g31106_i0	PRJNA438111	31731	210	3.635359	7.6342539	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	119	1.8e-30	NR	MDE0837962.1	2212473	g31106	i0	61.3	1.51428571428571	106	4	98.6	1	208	2	30	135	MDE0837962.1 FAD-binding oxidoreductase [Kiritimatiellia bacterium]	diamond	318	119	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30423907	30423907	PRJNA438111_P_NODE_64973_length_168_cov_1.021583_g64348_i0	PRJNA438111	64973	168	1.021583	1.71625944	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	112	1.7e-30	NR	MDE0840025.1	2212473	g64348	i0	100	0.982142857142857	55	0	98.2	0	167	3	43	97	MDE0840025.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	165	112	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
30612939	30612939	PRJNA438111_P_NODE_53273_length_178_cov_2.791946_g52648_i0	PRJNA438111	53273	178	2.791946	4.96966388	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	120	6.2000000000000005e-30	NR	MDE0839434.1	2212473	g52648	i0	100	0.97752808988764	58	0	97.8	0	176	3	322	379	MDE0839434.1 prolyl oligopeptidase family serine peptidase [Kiritimatiellia bacterium]	diamond	174	120	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31845862	31845862	PRJNA438111_P_NODE_43837_length_189_cov_2.412500_g43212_i0	PRJNA438111	43837	189	2.4125	4.559625	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	130	1.99e-33	NR	MDE0839589.1	2212473	g43212	i0	100	0.984126984126984	62	0	98.4	0	188	3	464	525	MDE0839589.1 MMPL family transporter [Kiritimatiellia bacterium]	diamond	186	130	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
31957145	31957145	PRJNA438111_P_NODE_30837_length_210_cov_3.861878_g30212_i0	PRJNA438111	30837	210	3.861878	8.1099438	PVC group	1783257	Bacteria	Bacteria	42	0.0437	NR	HMO51476.1	2212473	g30212	i0	37	2.3	81	39	98.6	2	2	208	119	199	HMO51476.1 glycosyltransferase [Kiritimatiellia bacterium]	diamond	483	42.4	0.990566037735849	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32573927	32573927	PRJNA438111_P_NODE_27959_length_210_cov_6.248619_g27334_i0	PRJNA438111	27959	210	6.248619	13.1220999	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	73.2	9.06e-15	NR	MDE0839147.1	2212473	g27334	i0	100	0.471428571428571	33	0	47.1	0	209	111	57	89	MDE0839147.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	99	73.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32605171	32605171	PRJNA438111_P_NODE_30920_length_210_cov_3.828729_g30295_i0	PRJNA438111	30920	210	3.828729	8.0403309	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	57.8	7.37e-9	NR	MDE0839617.1	2212473	g30295	i0	100	0.414285714285714	29	0	41.4	0	122	208	1	29	MDE0839617.1 helix-turn-helix transcriptional regulator [Kiritimatiellia bacterium]	diamond	87	57.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32605172	32605172	PRJNA438111_P_NODE_33160_length_209_cov_4.294444_g32535_i0	PRJNA438111	33160	209	4.294444	8.97538796	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	85.5	2.07e-17	NR	MDD4059100.1	2212473	g32535	i0	51.2	3.74641148325359	86	25	99	1	207	1	586	671	MDD4059100.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	783	85.5	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);;