metadata: contig_metadata: 11 rows where bioproject = "PRJNA546018" and tax

11 rows where bioproject = "PRJNA546018" 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
8164167	8164167	PRJNA546018_S_NODE_54907_length_206_cov_0.896552_g54582_i0	PRJNA546018	54907	206	0.896552	1.84689712	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	120	7.22e-30	NR	MES2856630.1	3034175	g54582	i0	80.9	0.990291262135922	68	13	99	0	3	206	194	261	MES2856630.1 bifunctional proline dehydrogenase/L-glutamate gamma-semialdehyde dehydrogenase [Bdellovibrionota bacterium]	diamond	204	120	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
8164298	8164298	PRJNA546018_S_NODE_9007_length_582_cov_7.760077_g8691_i0	PRJNA546018	9007	582	7.760077	45.16364814	Bdellovibrionota	3018035	Bacteria	Bacteria	318	2.27e-103	NR	MBI2711298.1	28201	g8691	i0	77.6	5.65979381443299	183	41	94.3	0	22	570	29	211	MBI2711298.1 glutamine--tRNA ligase/YqeY domain fusion protein [Bdellovibrio sp.]	diamond	3294	320	0.99375	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
10715061	10715061	PRJNA546018_S_NODE_31069_length_281_cov_2.145455_g30744_i0	PRJNA546018	31069	281	2.145455	6.02872855	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	107	1.03e-24	NR	MBA2404122.1	2053517	g30744	i0	84.3	0.747330960854093	70	11	74.7	0	260	51	113	182	MBA2404122.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	210	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
23463063	23463063	PRJNA546018_S_NODE_23559_length_329_cov_6.611940_g23234_i0	PRJNA546018	23559	329	6.61194	21.7532826	Peredibacter starrii	28202	Bacteria	Bacteria	429	1.2199999999999999e-115	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g23234	i0	92.905	5.45896656534954	296	20	90	1	25	320	512095	512389	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	1796	429	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27551639	27551639	PRJNA546018_S_NODE_7424_length_652_cov_4.345178_g7126_i0	PRJNA546018	7424	652	4.345178	28.33056056	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	215	1.3699999999999999e-62	NR	HEY8278402.1	3034175	g7126	i0	62.9	0.80521472392638	175	62	80.1	3	536	15	183	355	HEY8278402.1 bifunctional UDP-sugar hydrolase/5'-nucleotidase [Bdellovibrionota bacterium]	diamond	525	215	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28657101	28657101	PRJNA546018_S_NODE_56647_length_203_cov_1.394366_g56322_i0	PRJNA546018	56647	203	1.394366	2.83056298	Bacteriovoracales bacterium	2497611	Bacteria	Bacteria	65.9	1.3099999999999999e-10	NR	MFI5389776.1	2497611	g56322	i0	58.5	3.93103448275862	53	22	78.3	0	22	180	127	179	MFI5389776.1 hypothetical protein [Bacteriovoracales bacterium]	diamond	798	65.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales			Bacteriovoracales bacterium
29477571	29477571	PRJNA546018_S_NODE_47770_length_220_cov_1.628931_g47445_i0	PRJNA546018	47770	220	1.628931	3.5836482	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	68.2	2.41e-11	NR	MEK6704275.1	3034175	g47445	i0	55.4	0.763636363636364	56	25	76.4	0	169	2	40	95	MEK6704275.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	168	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29540907	29540907	PRJNA546018_S_NODE_8750_length_593_cov_2.422932_g8436_i0	PRJNA546018	8750	593	2.422932	14.36798676	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	92.4	1.08e-20	NR	MDZ4084007.1	2053517	g8436	i0	53.8	0.39460370994941	78	36	39.5	0	235	2	11	88	MDZ4084007.1 acyl carrier protein [Bdellovibrionales bacterium]	diamond	234	92.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30488673	30488673	PRJNA546018_S_NODE_25933_length_312_cov_2.549801_g25608_i0	PRJNA546018	25933	312	2.549801	7.95537912	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	77.8	4.03e-14	NR	MDX9730510.1	2053517	g25608	i0	81.8	0.423076923076923	44	8	42.3	0	296	165	615	658	MDX9730510.1 ABC transporter permease [Bdellovibrionales bacterium]	diamond	132	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30566376	30566376	PRJNA546018_S_NODE_34153_length_266_cov_1.629268_g33828_i0	PRJNA546018	34153	266	1.629268	4.33385288	Bacteria	2	Bacteria	Bacteria	167	3.3200000000000002e-49	NR	MBX3032880.1	2026715	g33828	i0	85	7.25187969924812	80	12	90.2	0	266	27	23	102	MBX3032880.1 SRPBCC domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	1929	167	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
32890350	32890350	PRJNA546018_S_NODE_8140_length_617_cov_7.221223_g7830_i0	PRJNA546018	8140	617	7.221223	44.55494591	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	280	4.32e-88	NR	HEY8279176.1	3034175	g7830	i0	75.7	0.918962722852512	189	46	91.9	0	588	22	1	189	HEY8279176.1 type IV-A pilus assembly ATPase PilB [Bdellovibrionota bacterium]	diamond	567	280	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota 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);;