metadata: contig_metadata: 15 rows where bioproject = "PRJNA792582", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJNA792582", 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
777089	777089	PRJNA792582_P_NODE_52761_length_248_cov_0.880000_g51947_i0	PRJNA792582	52761	248	0.88	2.1824	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	137	1.6999999999999998e-36	NR	MCB0412082.1	2053517	g51947	i0	78	2.9758064516129	82	18	99.2	0	248	3	136	217	MCB0412082.1 DEAD/DEAH box helicase [Bdellovibrionales bacterium]	diamond	738	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
3328251	3328251	PRJNA792582_P_NODE_48863_length_253_cov_1.438889_g48049_i0	PRJNA792582	48863	253	1.438889	3.64038917	Bdellovibrio sp. ZAP7	2231053	Bacteria	Bacteria	215	2.77e-51	NTclustered	gi\|1700693790\|gb\|CP030082.1\|	2231053	g48049	i0	83.55	4.81818181818182	231	36	91	2	23	252	129669	129440	Bdellovibrio sp. ZAP7 chromosome, complete genome	blastn	1219	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ZAP7
7155333	7155333	PRJNA792582_P_NODE_34946_length_291_cov_1.871560_g34132_i0	PRJNA792582	34946	291	1.87156	5.4462396	Peredibacter starrii	28202	Bacteria	Bacteria	387	6.51e-103	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g34132	i0	90.785	144.3264604811	293	22	100	5	1	291	510696	510985	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	41999	387	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
12256457	12256457	PRJNA792582_P_NODE_30430_length_312_cov_3.016736_g29616_i0	PRJNA792582	30430	312	3.016736	9.41221632	Peredibacter starrii	28202	Bacteria	Bacteria	538	1.8399999999999993e-148	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g29616	i0	97.764	193.701923076923	313	6	100	1	1	312	511925	511613	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	60435	538	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13969176	13969176	PRJNA792582_P_NODE_17811_length_408_cov_1.970149_g16997_i0	PRJNA792582	17811	408	1.970149	8.03820792	Bdellovibrio	958	Bacteria	Bacteria	510	5.379999999999998e-140	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g16997	i0	91.892	203.28431372549	370	23	97	4	45	407	1607718	1607349	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	82940	510	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
15243687	15243687	PRJNA792582_P_NODE_22172_length_366_cov_1.092150_g21358_i0	PRJNA792582	22172	366	1.09215	3.997269	Peredibacter	263370	Bacteria	Bacteria	542	1.69e-149	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g21358	i0	93.443	50.7896174863388	366	23	100	1	1	366	510724	511088	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	18589	542	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17355068	17355068	PRJNA792582_P_NODE_17254_length_415_cov_1.897661_g16440_i0	PRJNA792582	17254	415	1.897661	7.87529315	Peredibacter starrii	28202	Bacteria	Bacteria	732	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g16440	i0	98.554	76.9542168674699	415	5	100	1	1	415	512315	511902	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	31936	732	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
18628442	18628442	PRJNA792582_P_NODE_29595_length_317_cov_1.795082_g28781_i0	PRJNA792582	29595	317	1.795082	5.69040994	Peredibacter starrii	28202	Bacteria	Bacteria	518	2.44e-142	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g28781	i0	96.215	153.876971608833	317	11	100	1	1	317	512190	512505	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	48779	518	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
20342004	20342004	PRJNA792582_P_NODE_54796_length_246_cov_0.890173_g53982_i0	PRJNA792582	54796	246	0.890173	2.18982558	Pseudobdellovibrio	2862745	Bacteria	Bacteria	409	1.1399999999999998e-109	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g53982	i0	96.735	90.0447154471545	245	8	99	0	1	245	1223	1467	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	22151	409	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
21617763	21617763	PRJNA792582_P_NODE_59697_length_241_cov_0.886905_g58883_i0	PRJNA792582	59697	241	0.886905	2.13744105	Peredibacter starrii	28202	Bacteria	Bacteria	127	5.579999999999998e-35	NR	WP_321393881.1	28202	g58883	i0	72	1.15767634854772	93	10	95.9	1	234	4	12	104	WP_321393881.1 DUF3015 family protein [Peredibacter starrii]	diamond	279	127	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
27401572	27401572	PRJNA792582_P_NODE_57563_length_243_cov_0.905882_g56749_i0	PRJNA792582	57563	243	0.905882	2.20129326	Bdellovibrio sp. SKB1291214	1732569	Bacteria	Bacteria	67	3.02e-12	NR	WP_088616025.1	1732569	g56749	i0	54.2	2.69135802469136	72	33	88.9	0	223	8	1	72	WP_088616025.1 ATP synthase F0 subunit C [Bdellovibrio sp. SKB1291214]	diamond	654	67	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
27654197	27654197	PRJNA792582_P_NODE_54404_length_246_cov_1.323699_g53590_i0	PRJNA792582	54404	246	1.323699	3.25629954	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	56.6	4.19e-8	NR	MCB0331116.1	2053517	g53590	i0	46.2	3.26829268292683	65	31	79.3	1	204	10	16	76	MCB0331116.1 50S ribosomal protein L23 [Bdellovibrionales bacterium]	diamond	804	56.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28317143	28317143	PRJNA792582_P_NODE_44766_length_265_cov_1.244792_g43952_i0	PRJNA792582	44766	265	1.244792	3.2986988	Bdellovibrio sp. 28-41-41	1970323	Bacteria	Bacteria	102	4.05e-24	NR	OYZ24383.1	1970323	g43952	i0	61.8	0.860377358490566	76	28	86	1	36	263	166	240	OYZ24383.1 MAG: hypothetical protein B7Y39_01625 [Bdellovibrio sp. 28-41-41]	diamond	228	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41
29620326	29620326	PRJNA792582_P_NODE_39330_length_279_cov_2.072816_g38516_i0	PRJNA792582	39330	279	2.072816	5.78315664	Pseudomonadati	3379134	Bacteria	Bacteria	61.2	1.9e-9	NR	MBK7891702.1	2053517	g38516	i0	48.4	2.26881720430108	64	33	68.8	0	241	50	7	70	MBK7891702.1 flagellar basal body rod protein FlgB [Bdellovibrionales bacterium]	diamond	633	61.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31136913	31136913	PRJNA792582_P_NODE_54675_length_246_cov_0.890173_g53861_i0	PRJNA792582	54675	246	0.890173	2.18982558	Bdellovibrionota	3018035	Bacteria	Bacteria	69.3	1.39e-11	NR	WP_325144650.1	1971216	g53861	i0	82.9	0.841463414634146	35	6	42.7	0	244	140	142	176	WP_325144650.1 IS3 family transposase [Oligoflexus sp.]	diamond	207	69.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.

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