metadata: contig_metadata: 19 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

19 rows where analysis = "diamond", bioproject = "PRJEB20058" 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
25786764	25786764	PRJEB20058_P_NODE_143691_length_323_cov_2.671756_g140870_i0	PRJEB20058	143691	323	2.671756	8.62977188	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	165	4.809999999999998e-47	NR	HNX36462.1	2212473	g140870	i0	82	1.85758513931889	100	18	92.9	0	22	321	210	309	HNX36462.1 DNA-binding transcriptional regulator [Kiritimatiellia bacterium]	diamond	600	165	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
25884421	25884421	PRJEB20058_P_NODE_135611_length_336_cov_2.240000_g132791_i0	PRJEB20058	135611	336	2.24	7.5264	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	159	7.879999999999999e-48	NR	HMP95551.1	2212473	g132791	i0	77.7	0.839285714285714	94	21	83.9	0	297	16	1	94	HMP95551.1 HIT family protein [Kiritimatiellia bacterium]	diamond	282	159	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
26020904	26020904	PRJEB20058_P_NODE_145644_length_320_cov_3.393822_g142823_i0	PRJEB20058	145644	320	3.393822	10.8602304	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	160	7.73e-46	NR	HNX35131.1	2212473	g142823	i0	84	0.88125	94	15	88.1	0	5	286	243	336	HNX35131.1 TRAP transporter substrate-binding protein [Kiritimatiellia bacterium]	diamond	282	160	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32910899	32910899	PRJEB20058_P_NODE_194673_length_260_cov_6.753769_g191849_i0	PRJEB20058	194673	260	6.753769	17.5597994	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	85.1	8.13e-19	NR	MBO7308399.1	2212473	g191849	i0	55.1	0.9	78	32	90	1	234	1	62	136	MBO7308399.1 dUTP diphosphatase [Kiritimatiellia bacterium]	diamond	234	85.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32911448	32911448	PRJEB20058_P_NODE_68329_length_504_cov_31.887133_g65559_i0	PRJEB20058	68329	504	31.887133	160.71115032	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	228	5.3e-69	NR	HMP74937.1	2212473	g65559	i0	68.8	0.952380952380952	160	50	95.2	0	493	14	147	306	HMP74937.1 FGGY family carbohydrate kinase [Kiritimatiellia bacterium]	diamond	480	228	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32911545	32911545	PRJEB20058_P_NODE_87809_length_439_cov_5.621693_g85017_i0	PRJEB20058	87809	439	5.621693	24.67923227	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	215	3.78e-68	NR	HNX35953.1	2212473	g85017	i0	81.7	1.79043280182232	131	24	89.5	0	26	418	49	179	HNX35953.1 HAD family hydrolase [Kiritimatiellia bacterium]	diamond	786	215	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32927899	32927899	PRJEB20058_P_NODE_169569_length_288_cov_1.691630_g166746_i0	PRJEB20058	169569	288	1.69163	4.8718944	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	171	4.86e-47	NR	HNX34141.1	2212473	g166746	i0	82.4	2.84375	91	16	94.8	0	275	3	716	806	HNX34141.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	819	171	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32945819	32945819	PRJEB20058_P_NODE_78858_length_467_cov_2.108374_g76078_i0	PRJEB20058	78858	467	2.108374	9.84610658	Pontiella sulfatireligans	2750658	Bacteria	Bacteria	225	1.87e-70	NR	WP_136065607.1	2750658	g76078	i0	88.6	2.92933618843683	114	13	73.2	0	454	113	118	231	WP_136065607.1 UDP-glucose 4-epimerase GalE [Pontiella sulfatireligans]	diamond	1368	225	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Pontiellaceae	Pontiella	Pontiella sulfatireligans
32945867	32945867	PRJEB20058_P_NODE_86802_length_442_cov_6.099738_g84013_i0	PRJEB20058	86802	442	6.099738	26.96084196	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	177	5.249999999999998e-55	NR	MDD3546378.1	2212473	g84013	i0	83.3	1.30316742081448	96	16	65.2	0	333	46	1	96	MDD3546378.1 CRISPR-associated endonuclease Cas2 [Kiritimatiellia bacterium]	diamond	576	177	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32962516	32962516	PRJEB20058_P_NODE_207090_length_251_cov_2.789474_g204266_i0	PRJEB20058	207090	251	2.789474	7.00157974	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	49.3	2.01e-4	NR	MBQ9344064.1	2212473	g204266	i0	59.5	1.08764940239044	37	15	44.2	0	179	69	583	619	MBQ9344064.1 ATP-dependent zinc metalloprotease FtsH [Kiritimatiellia bacterium]	diamond	273	49.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
32979598	32979598	PRJEB20058_P_NODE_206139_length_252_cov_1.277487_g203315_i0	PRJEB20058	206139	252	1.277487	3.21926724	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	132	4.51e-35	NR	HMO03783.1	2212473	g203315	i0	86.4	0.964285714285714	81	11	96.4	0	251	9	198	278	HMO03783.1 AI-2E family transporter [Kiritimatiellia bacterium]	diamond	243	132	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33030652	33030652	PRJEB20058_P_NODE_201244_length_255_cov_5.154639_g198420_i0	PRJEB20058	201244	255	5.154639	13.14432945	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	102	4.65e-24	NR	MDP6523666.1	2212473	g198420	i0	65.8	0.894117647058824	76	26	89.4	0	7	234	169	244	MDP6523666.1 ABC transporter permease [Kiritimatiellia bacterium]	diamond	228	102	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33030736	33030736	PRJEB20058_P_NODE_215620_length_245_cov_6.581522_g212796_i0	PRJEB20058	215620	245	6.581522	16.1247289	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	43.1	0.0282	NR	MDP6491653.1	2212473	g212796	i0	37.9	0.808163265306122	66	41	80.8	0	41	238	592	657	MDP6491653.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	198	43.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33065082	33065082	PRJEB20058_P_NODE_55237_length_565_cov_5.273810_g52489_i0	PRJEB20058	55237	565	5.27381	29.7970265	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	298	1.63e-100	NR	HNX35549.1	2212473	g52489	i0	94.3	0.844247787610619	159	9	84.4	0	9	485	39	197	HNX35549.1 helix-turn-helix domain-containing protein [Kiritimatiellia bacterium]	diamond	477	298	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33082103	33082103	PRJEB20058_P_NODE_44262_length_632_cov_3.644483_g41584_i0	PRJEB20058	44262	632	3.644483	23.03313256	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	140	1.59e-34	NR	MDD4024940.1	2212473	g41584	i0	56.8	2.10759493670886	111	47	52.2	1	44	373	909	1019	MDD4024940.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	1332	140	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33098612	33098612	PRJEB20058_P_NODE_169230_length_288_cov_5.647577_g166407_i0	PRJEB20058	169230	288	5.647577	16.26502176	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	108	2.45e-25	NR	HNX34783.1	2212473	g166407	i0	60.2	0.916666666666667	88	35	91.7	0	23	286	80	167	HNX34783.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	264	108	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33099112	33099112	PRJEB20058_P_NODE_38158_length_681_cov_4.748387_g35535_i0	PRJEB20058	38158	681	4.748387	32.33651547	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	267	1.8699999999999999e-84	NR	MBP7638525.1	2212473	g35535	i0	62.6	0.94273127753304	214	79	94.3	1	19	660	56	268	MBP7638525.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	642	267	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33166698	33166698	PRJEB20058_P_NODE_149256_length_315_cov_1.259843_g146434_i0	PRJEB20058	149256	315	1.259843	3.96850545	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	137	3.92e-35	NR	MDX9794905.1	2212473	g146434	i0	76	1.82857142857143	96	23	91.4	0	10	297	274	369	MDX9794905.1 autotransporter-associated beta strand repeat-containing protein [Kiritimatiellia bacterium]	diamond	576	137	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
33167129	33167129	PRJEB20058_P_NODE_225520_length_237_cov_8.045455_g222695_i0	PRJEB20058	225520	237	8.045455	19.06772835	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	109	1.29e-25	NR	MDD3585151.1	2212473	g222695	i0	63.9	1.82278481012658	72	26	91.1	0	216	1	389	460	MDD3585151.1 M60 family metallopeptidase [Kiritimatiellia bacterium]	diamond	432	109	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);;