metadata: contig_metadata: 18 rows where bioproject = "PRJEB81463", tax_kingdom = "Pseudomonadati" and tax

18 rows where bioproject = "PRJEB81463", 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
6518514	6518514	PRJEB81463_P_NODE_11606_length_298_cov_2.688889_g11334_i0	PRJEB81463	11606	298	2.688889	8.01288922	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	496	1.06e-135	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g11334	i0	96.644	82.1644295302013	298	10	100	0	1	298	1292577	1292280	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	24485	496	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
17575278	17575278	PRJEB81463_P_NODE_22754_length_249_cov_1.329545_g22482_i0	PRJEB81463	22754	249	1.329545	3.31056705	Pseudobdellovibrio	2862745	Bacteria	Bacteria	422	1.49e-113	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g22482	i0	97.189	209.020080321285	249	7	100	0	1	249	2342	2094	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	52046	422	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
20541630	20541630	PRJEB81463_P_NODE_5697_length_419_cov_2.286127_g5425_i0	PRJEB81463	5697	419	2.286127	9.57887213	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	438	2.6499999999999998e-118	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g5425	i0	85.615	326.326968973747	431	46	100	14	1	419	3447445	3447019	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	136731	438	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
20541642	20541642	PRJEB81463_P_NODE_637_length_1228_cov_2.638095_g492_i0	PRJEB81463	637	1228	2.638095	32.3958066	Peredibacter starrii	28202	Bacteria	Bacteria	2019	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g492	i0	96.341	223.758143322476	1230	42	100	2	1	1228	511138	512366	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	274775	2019	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
21817062	21817062	PRJEB81463_P_NODE_11638_length_298_cov_1.400000_g11366_i0	PRJEB81463	11638	298	1.4	4.172	Pseudobdellovibrio sp.	2862747	Bacteria	Bacteria	137	1.76e-38	NR	MCC2678032.1	2862747	g11366	i0	76.7	3.6744966442953	90	21	90.6	0	283	14	2	91	MCC2678032.1 fimbrial protein pilA [Pseudobdellovibrio sp.]	diamond	1095	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp.
26748970	26748970	PRJEB81463_P_NODE_23661_length_248_cov_0.891429_g23389_i0	PRJEB81463	23661	248	0.891429	2.21074392	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	165	3.63e-47	NR	MCK6596183.1	2081706	g23389	i0	97.6	0.991935483870968	82	2	99.2	0	2	247	248	329	MCK6596183.1 glutamate--tRNA ligase [Bacteriovoracaceae bacterium]	diamond	246	165	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
27824163	27824163	PRJEB81463_P_NODE_1524_length_814_cov_5.871795_g1291_i0	PRJEB81463	1524	814	5.871795	47.7964113	Bacteriovorax sp.	2608087	Bacteria	Bacteria	191	6.4e-58	NR	MDO9181423.1	2608087	g1291	i0	84.3	0.468058968058968	127	20	46.8	0	813	433	15	141	MDO9181423.1 type II toxin-antitoxin system RelE/ParE family toxin [Bacteriovorax sp.]	diamond	381	191	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
27824164	27824164	PRJEB81463_P_NODE_15544_length_274_cov_2.477612_g15272_i0	PRJEB81463	15544	274	2.477612	6.78865688	Bdellovibrio sp.	28201	Bacteria	Bacteria	77.4	1.15e-14	NR	MBC7743064.1	28201	g15272	i0	62.7	0.733576642335766	67	25	73.4	0	70	270	1	67	MBC7743064.1 flagellin FliC [Bdellovibrio sp.]	diamond	201	77.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28392346	28392346	PRJEB81463_P_NODE_25886_length_245_cov_0.906977_g25614_i0	PRJEB81463	25886	245	0.906977	2.22209365	Micavibrio sp.	2024841	Bacteria	Bacteria	64.7	7e-10	NR	MDE1153754.1	2024841	g25614	i0	44.9	0.844897959183673	69	38	84.5	0	243	37	131	199	MDE1153754.1 ankyrin repeat domain-containing protein [Micavibrio sp.]	diamond	207	64.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
28802564	28802564	PRJEB81463_P_NODE_9188_length_332_cov_1.810811_g8916_i0	PRJEB81463	9188	332	1.810811	6.01189252	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	100	2.01e-25	NR	MCK6594133.1	2081706	g8916	i0	80	0.542168674698795	60	12	54.2	0	304	125	1	60	MCK6594133.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	180	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
28992573	28992573	PRJEB81463_P_NODE_22008_length_250_cov_1.615819_g21736_i0	PRJEB81463	22008	250	1.615819	4.0395475	Bacteriovorax stolpii	960	Bacteria	Bacteria	139	5.61e-36	NR	WP_102242528.1	960	g21736	i0	84.1	0.984	82	13	98.4	0	3	248	502	583	WP_102242528.1 endopeptidase La [Bacteriovorax stolpii]	diamond	246	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
29181867	29181867	PRJEB81463_P_NODE_23549_length_248_cov_0.891429_g23277_i0	PRJEB81463	23549	248	0.891429	2.21074392	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	150	3.95e-40	NR	MES2528511.1	3034175	g23277	i0	86.6	0.991935483870968	82	11	99.2	0	248	3	1077	1158	MES2528511.1 translocation/assembly module TamB domain-containing protein [Bdellovibrionota bacterium]	diamond	246	150	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29591763	29591763	PRJEB81463_P_NODE_11890_length_295_cov_1.400901_g11618_i0	PRJEB81463	11890	295	1.400901	4.13265795	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.1	0.0366	NR	MBK8201443.1	2053517	g11618	i0	32.1	0.569491525423729	56	38	56.9	0	276	109	124	179	MBK8201443.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	168	43.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29686563	29686563	PRJEB81463_P_NODE_22110_length_250_cov_0.881356_g21838_i0	PRJEB81463	22110	250	0.881356	2.20339	Bdellovibrio sp. CG_4_9_14_3_um_filter_39_7	1975525	Bacteria	Bacteria	66.6	5.88e-11	NR	PJB53603.1	1975525	g21838	i0	40	0.96	80	48	96	0	248	9	76	155	PJB53603.1 MAG: hypothetical protein CO099_06135 [Bdellovibrio sp. CG_4_9_14_3_um_filter_39_7]	diamond	240	66.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CG_4_9_14_3_um_filter_39_7
30824152	30824152	PRJEB81463_P_NODE_27274_length_243_cov_0.917647_g27002_i0	PRJEB81463	27274	243	0.917647	2.22988221	Bdellovibrio sp.	28201	Bacteria	Bacteria	136	6.329999999999999e-37	NR	NUN06910.1	28201	g27002	i0	87.3	3.91358024691358	79	10	97.5	0	6	242	211	289	NUN06910.1 tryptophan--tRNA ligase [Bdellovibrio sp.]	diamond	951	136	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
31740886	31740886	PRJEB81463_P_NODE_26397_length_244_cov_1.421053_g26125_i0	PRJEB81463	26397	244	1.421053	3.46736932	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	75.1	1.47e-13	NR	MEK6627748.1	3034175	g26125	i0	54.4	0.836065573770492	68	31	83.6	0	242	39	103	170	MEK6627748.1 FHA domain-containing protein [Bdellovibrionota bacterium]	diamond	204	75.1	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31962433	31962433	PRJEB81463_P_NODE_6738_length_385_cov_2.826923_g6466_i0	PRJEB81463	6738	385	2.826923	10.88365355	Bdellovibrio sp.	28201	Bacteria	Bacteria	87.8	1.87e-18	NR	MBC7464793.1	28201	g6466	i0	50	0.779220779220779	100	47	76.4	2	91	384	4	102	MBC7464793.1 hypothetical protein [Bdellovibrio sp.]	diamond	300	87.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
32721123	32721123	PRJEB81463_P_NODE_9900_length_321_cov_0.943548_g9628_i0	PRJEB81463	9900	321	0.943548	3.02878908	Bdellovibrionales bacterium RIFCSPHIGHO2_	2053517	Bacteria	Bacteria	102	4.579999999999999e-23	NR	OFZ28958.1	1797389	g9628	i0	49	0.97196261682243	104	52	96.3	1	310	2	191	294	OFZ28958.1 MAG: hypothetical protein A2622_12730 [Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29]	diamond	312	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFCSPHIGHO2_01_FULL_40_29

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);;