metadata: contig_metadata: 14 rows where bioproject = "PRJNA1093380" and tax

14 rows where bioproject = "PRJNA1093380" 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
14227912	14227912	PRJNA1093380_P_NODE_6432_length_283_cov_0.971429_g6326_i0	PRJNA1093380	6432	283	0.971429	2.74914407	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	112	2.69e-26	NR	HEY8280308.1	3034175	g6326	i0	61.1	0.954063604240283	90	27	94.3	2	272	6	558	640	HEY8280308.1 MG2 domain-containing protein [Bdellovibrionota bacterium]	diamond	270	112	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
17596974	17596974	PRJNA1093380_P_NODE_234_length_1157_cov_2.727860_g174_i0	PRJNA1093380	234	1157	2.72786	31.5613402	Peredibacter	263370	Bacteria	Bacteria	1940	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g174	i0	96.975	239.404494382022	1157	32	100	2	1	1157	512411	511258	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	276991	1945	0.997429305912596	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26655847	26655847	PRJNA1093380_P_NODE_14321_length_246_cov_1.780347_g14215_i0	PRJNA1093380	14321	246	1.780347	4.37965362	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	99.4	4.67e-22	NR	HEY8278479.1	3034175	g14215	i0	57.3	1	82	35	100	0	246	1	474	555	HEY8278479.1 TIGR03545 family protein [Bdellovibrionota bacterium]	diamond	246	99.4	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
26687711	26687711	PRJNA1093380_P_NODE_13241_length_248_cov_3.285714_g13135_i0	PRJNA1093380	13241	248	3.285714	8.14857072	Oligoflexia bacterium	2599941	Bacteria	Bacteria	80.5	1.16e-16	NR	MCO5143424.1	2599941	g13135	i0	49.4	0.955645161290323	79	38	95.6	1	9	245	6	82	MCO5143424.1 RNA polymerase sigma factor [Oligoflexia bacterium]	diamond	237	80.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
28172934	28172934	PRJNA1093380_P_NODE_12266_length_250_cov_1.740113_g12160_i0	PRJNA1093380	12266	250	1.740113	4.3502825	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	146	8.12e-39	NR	HEY8279679.1	3034175	g12160	i0	74.7	0.996	83	21	99.6	0	249	1	377	459	HEY8279679.1 LTA synthase family protein [Bdellovibrionota bacterium]	diamond	249	146	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28172935	28172935	PRJNA1093380_P_NODE_14886_length_245_cov_1.383721_g14780_i0	PRJNA1093380	14886	245	1.383721	3.39011645	Bacteriovorax stolpii	960	Bacteria	Bacteria	99.8	4.859999999999999e-24	NR	WP_142409524.1	960	g14780	i0	61.1	0.881632653061225	72	27	88.2	1	245	30	60	130	WP_142409524.1 hypothetical protein [Bacteriovorax stolpii]	diamond	216	99.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
28646755	28646755	PRJNA1093380_P_NODE_15467_length_244_cov_0.900585_g15361_i0	PRJNA1093380	15467	244	0.900585	2.1974274	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	74.3	1.23e-13	NR	MAF90226.1	2026715	g15361	i0	50.8	0.774590163934426	63	31	77.5	0	55	243	16	78	MAF90226.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	189	74.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
29246482	29246482	PRJNA1093380_P_NODE_13469_length_248_cov_0.880000_g13363_i0	PRJNA1093380	13469	248	0.88	2.1824	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	137	4.23e-36	NR	HEY8278945.1	3034175	g13363	i0	87.7	0.979838709677419	81	10	98	0	244	2	275	355	HEY8278945.1 flagellar biosynthesis protein FlhF [Bdellovibrionota bacterium]	diamond	243	137	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29341371	29341371	PRJNA1093380_P_NODE_5289_length_289_cov_2.620370_g5183_i0	PRJNA1093380	5289	289	2.62037	7.5728693	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	173	3.49e-50	NR	HEY8278955.1	3034175	g5183	i0	93.8	0.996539792387543	96	6	99.7	0	288	1	311	406	HEY8278955.1 flagellar hook protein FlgE [Bdellovibrionota bacterium]	diamond	288	173	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29372882	29372882	PRJNA1093380_P_NODE_8189_length_272_cov_1.547739_g8083_i0	PRJNA1093380	8189	272	1.547739	4.20985008	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	94.7	2.37e-20	NR	MFL5812468.1	3034169	g8083	i0	86.5	0.573529411764706	52	7	57.4	0	115	270	2	53	MFL5812468.1 4Fe-4S binding protein [Bdellovibrionia bacterium]	diamond	156	94.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
30794200	30794200	PRJNA1093380_P_NODE_13274_length_248_cov_2.251429_g13168_i0	PRJNA1093380	13274	248	2.251429	5.58354392	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	155	7.289999999999999e-45	NR	HEY8278974.1	3034175	g13168	i0	86.6	0.991935483870968	82	11	99.2	0	248	3	46	127	HEY8278974.1 tRNA U-34 5-methylaminomethyl-2-thiouridine biosynthesis protein [Bdellovibrionota bacterium]	diamond	246	155	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30794201	30794201	PRJNA1093380_P_NODE_14234_length_247_cov_0.873563_g14128_i0	PRJNA1093380	14234	247	0.873563	2.15770061	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	103	1.2e-26	NR	HEY8279491.1	3034175	g14128	i0	75.8	0.753036437246964	62	15	75.3	0	62	247	21	82	HEY8279491.1 metal-sulfur cluster assembly factor [Bdellovibrionota bacterium]	diamond	186	103	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31331505	31331505	PRJNA1093380_P_NODE_9936_length_262_cov_1.677249_g9830_i0	PRJNA1093380	9936	262	1.677249	4.39439238	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	130	6.63e-33	NR	MDZ4083535.1	2053517	g9830	i0	69.8	18.7099236641221	86	26	98.5	0	260	3	862	947	MDZ4083535.1 alpha-2-macroglobulin family protein [Bdellovibrionales bacterium]	diamond	4902	130	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32154082	32154082	PRJNA1093380_P_NODE_16138_length_243_cov_0.905882_g16032_i0	PRJNA1093380	16138	243	0.905882	2.20129326	Oligoflexus sp.	1971216	Bacteria	Bacteria	106	2.45e-25	NR	WP_325144519.1	1971216	g16032	i0	58.7	1.91358024691358	75	31	92.6	0	3	227	30	104	WP_325144519.1 S66 peptidase family protein [Oligoflexus sp.]	diamond	465	106	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);;