metadata: contig_metadata: 14 rows where bioproject = "PRJNA1104180", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJNA1104180", tax_kingdom = "Pseudomonadati" and tax_phylum = "Bdellovibrionota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2763029	2763029	PRJNA1104180_P_NODE_17483_length_264_cov_1.308901_g17341_i0	PRJNA1104180	17483	264	1.308901	3.45549864	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	148	4.45e-39	NR	HEY8279362.1	3034175	g17341	i0	90.9	1	88	8	100	0	264	1	841	928	HEY8279362.1 vitamin B12-dependent ribonucleotide reductase [Bdellovibrionota bacterium]	diamond	264	148	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
12499107	12499107	PRJNA1104180_P_NODE_19210_length_255_cov_1.692308_g19067_i0	PRJNA1104180	19210	255	1.692308	4.3153854	Bdellovibrio	958	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g19067	i0	89.883	87.5098039215686	257	21	99	5	2	255	1963880	1964134	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	22315	326	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
26719132	26719132	PRJNA1104180_P_NODE_24821_length_243_cov_1.811765_g24678_i0	PRJNA1104180	24821	243	1.811765	4.40258895	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	57.4	2.51e-7	NR	HEY8280043.1	3034175	g24678	i0	76.5	0.419753086419753	34	8	42	0	103	2	4	37	HEY8280043.1 long-chain fatty acid--CoA ligase [Bdellovibrionota bacterium]	diamond	102	57.4	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27478483	27478483	PRJNA1104180_P_NODE_21983_length_248_cov_0.880000_g21840_i0	PRJNA1104180	21983	248	0.88	2.1824	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	72.8	1.03e-12	NR	HEY8278403.1	3034175	g21840	i0	77.3	0.532258064516129	44	10	53.2	0	133	2	1	44	HEY8278403.1 serine protein kinase PrkA [Bdellovibrionota bacterium]	diamond	132	72.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28078320	28078320	PRJNA1104180_P_NODE_21545_length_249_cov_0.875000_g21402_i0	PRJNA1104180	21545	249	0.875	2.17875	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	130	4.48e-35	NR	MCB0413676.1	2053517	g21402	i0	74.7	1	83	21	100	0	249	1	77	159	MCB0413676.1 RNA polymerase sigma factor [Bdellovibrionales bacterium]	diamond	249	130	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28417178	28417178	PRJNA1104180_P_NODE_20046_length_251_cov_1.657303_g19903_i0	PRJNA1104180	20046	251	1.657303	4.15983053	Pseudomonadati	3379134	Bacteria	Bacteria	114	2.93e-27	NR	MCB0325377.1	2053517	g19903	i0	65.4	1.9601593625498	81	28	96.8	0	248	6	157	237	MCB0325377.1 group II intron reverse transcriptase/maturase [Bdellovibrionales bacterium]	diamond	492	114	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29751564	29751564	PRJNA1104180_P_NODE_18051_length_261_cov_1.351064_g17909_i0	PRJNA1104180	18051	261	1.351064	3.52627704	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	60.1	3.71e-8	NR	MBK7890750.1	2053517	g17909	i0	45.2	0.96551724137931	84	43	95.4	3	12	260	1477	1558	MBK7890750.1 DUF2341 domain-containing protein [Bdellovibrionales bacterium]	diamond	252	60.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30004602	30004602	PRJNA1104180_P_NODE_20031_length_251_cov_1.724719_g19888_i0	PRJNA1104180	20031	251	1.724719	4.32904469	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	143	8.34e-41	NR	MBA2404721.1	2053517	g19888	i0	85.4	3.9203187250996	82	12	98	0	4	249	17	98	MBA2404721.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	984	143	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30036139	30036139	PRJNA1104180_P_NODE_14571_length_280_cov_1.178744_g14429_i0	PRJNA1104180	14571	280	1.178744	3.3004832	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	108	1.16e-25	NR	MBY0516305.1	2081706	g14429	i0	58.4	0.953571428571429	89	37	95.4	0	2	268	151	239	MBY0516305.1 catalase [Bacteriovoracaceae bacterium]	diamond	267	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30193955	30193955	PRJNA1104180_P_NODE_16492_length_269_cov_1.571429_g16350_i0	PRJNA1104180	16492	269	1.571429	4.22714401	Micavibrio sp.	2024841	Bacteria	Bacteria	156	8.059999999999999e-46	NR	MAI62891.1	2024841	g16350	i0	77.5	0.992565055762082	89	20	99.3	0	3	269	47	135	MAI62891.1 hypothetical protein [Micavibrio sp.]	diamond	267	156	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
30604733	30604733	PRJNA1104180_P_NODE_17053_length_266_cov_1.595855_g16911_i0	PRJNA1104180	17053	266	1.595855	4.2449743	Bdellovibrio sp.	28201	Bacteria	Bacteria	66.6	9.23e-11	NR	MFN7729575.1	28201	g16911	i0	45.7	0.789473684210526	70	38	78.9	0	259	50	182	251	MFN7729575.1 hypothetical protein [Bdellovibrio sp.]	diamond	210	66.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32312635	32312635	PRJNA1104180_P_NODE_23759_length_245_cov_0.895349_g23616_i0	PRJNA1104180	23759	245	0.895349	2.19360505	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	134	2.13e-36	NR	MFN8945129.1	2026715	g23616	i0	85.4	1.00408163265306	82	11	99.2	1	2	244	167	248	MFN8945129.1 type II secretion system protein GspC [Pseudobdellovibrionaceae bacterium]	diamond	246	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
32722933	32722933	PRJNA1104180_P_NODE_19220_length_255_cov_1.692308_g19077_i0	PRJNA1104180	19220	255	1.692308	4.3153854	Oligoflexia bacterium	2599941	Bacteria	Bacteria	147	3.989999999999999e-41	NR	MCO5142820.1	2599941	g19077	i0	85.7	2.96470588235294	84	12	98.8	0	2	253	78	161	MCO5142820.1 ABC transporter ATP-binding protein [Oligoflexia bacterium]	diamond	756	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32785729	32785729	PRJNA1104180_P_NODE_19280_length_255_cov_1.313187_g19137_i0	PRJNA1104180	19280	255	1.313187	3.34862685	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	109	1.1500000000000002e-27	NR	MCB0416969.1	2053517	g19137	i0	60.5	0.952941176470588	81	32	95.3	0	248	6	8	88	MCB0416969.1 TetR family transcriptional regulator [Bdellovibrionales bacterium]	diamond	243	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;