metadata: contig_metadata: 19 rows where bioproject = "PRJDB9741", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJDB9741", 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
981833	981833	PRJDB9741_P_NODE_34521_length_164_cov_0.886957_g34204_i0	PRJDB9741	34521	164	0.886957	1.45460948	Bdellovibrio	958	Bacteria	Bacteria	215	1.65e-51	NTclustered	gi\|2801803968\|gb\|CP169237.1\|	959	g34204	i0	90.244	7.67682926829268	164	16	100	0	1	164	664222	664385	Bdellovibrio bacteriovorus strain Bd3 chromosome, complete genome	blastn	1259	215	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2560804	2560804	PRJDB9741_P_NODE_32703_length_164_cov_3.373913_g32386_i0	PRJDB9741	32703	164	3.373913	5.53321732	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	294	2.06e-75	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g32386	i0	99.383	118.65243902439	162	1	99	0	1	162	1292811	1292650	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	19459	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
3532565	3532565	PRJDB9741_P_NODE_8083_length_221_cov_2.366279_g7766_i0	PRJDB9741	8083	221	2.366279	5.22947659	Bdellovibrio	958	Bacteria	Bacteria	375	1.0199999999999998e-99	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g7766	i0	97.285	86.9773755656109	221	6	100	0	1	221	784641	784421	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	19222	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
14039060	14039060	PRJDB9741_P_NODE_36732_length_162_cov_2.584071_g36415_i0	PRJDB9741	36732	162	2.584071	4.18619502	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	100	2.37e-25	NR	PZP56992.1	349221	g36415	i0	90.6	0.981481481481482	53	5	98.1	0	162	4	85	137	PZP56992.1 MAG: 30S ribosomal protein S11 [Micavibrio aeruginosavorus]	diamond	159	100	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
15009730	15009730	PRJDB9741_P_NODE_34212_length_164_cov_0.886957_g33895_i0	PRJDB9741	34212	164	0.886957	1.45460948	Bacteria	2	Bacteria	Bacteria	91.7	6.81e-20	NR	MBL7687417.1	2026715	g33895	i0	85.2	1.97560975609756	54	8	98.8	0	2	163	330	383	MBL7687417.1 polyribonucleotide nucleotidyltransferase [Pseudobdellovibrionaceae bacterium]	diamond	324	91.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
16284449	16284449	PRJDB9741_P_NODE_2213_length_502_cov_6.028698_g1900_i0	PRJDB9741	2213	502	6.028698	30.26406396	Bdellovibrio	958	Bacteria	Bacteria	582	1.4099999999999996e-161	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g1900	i0	87.795	241.474103585657	508	49	99	12	2	502	2950431	2949930	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	121220	582	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17862632	17862632	PRJDB9741_P_NODE_12915_length_190_cov_2.390071_g12598_i0	PRJDB9741	12915	190	2.390071	4.5411349	Peredibacter starrii	28202	Bacteria	Bacteria	335	1.4499999999999993e-87	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g12598	i0	98.421	4.62631578947368	190	3	100	0	1	190	512329	512140	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	879	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
17862705	17862705	PRJDB9741_P_NODE_22235_length_174_cov_1.632000_g21918_i0	PRJDB9741	22235	174	1.632	2.83968	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	294	2.1999999999999998e-75	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g21918	i0	97.126	128.425287356322	174	5	100	0	1	174	1292273	1292446	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	22346	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
17862759	17862759	PRJDB9741_P_NODE_2975_length_408_cov_3.977716_g2660_i0	PRJDB9741	2975	408	3.977716	16.22908128	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	649	0	NTclustered	gi\|2800914199\|gb\|CP168971.1\|	959	g2660	i0	95.343	192.28921568627501	408	19	100	0	1	408	750758	750351	Bdellovibrio bacteriovorus strain Bd16 chromosome, complete genome	blastn	78454	649	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20108317	20108317	PRJDB9741_P_NODE_18256_length_181_cov_1.416667_g17939_i0	PRJDB9741	18256	181	1.416667	2.56416727	Bdellovibrio	958	Bacteria	Bacteria	329	6.340000000000001e-86	NTclustered	gi\|1210342126\|gb\|CP020946.1\|	959	g17939	i0	99.448	89.4254143646409	181	1	100	0	1	181	2949231	2949051	Bdellovibrio bacteriovorus strain SSB218315, complete genome	blastn	16186	329	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20108447	20108447	PRJDB9741_P_NODE_9076_length_210_cov_5.385093_g8759_i0	PRJDB9741	9076	210	5.385093	11.3086953	Bdellovibrio	958	Bacteria	Bacteria	185	1.74e-42	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g8759	i0	100	2.82857142857143	100	0	94	0	1	100	3475981	3475882	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	594	185	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
22658925	22658925	PRJDB9741_P_NODE_7038_length_236_cov_2.700535_g6721_i0	PRJDB9741	7038	236	2.700535	6.3732626	Peredibacter	263370	Bacteria	Bacteria	363	8.609999999999998e-96	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g6721	i0	94.468	270.021186440678	235	13	99	0	2	236	511892	512126	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	63725	363	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
25207925	25207925	PRJDB9741_P_NODE_22260_length_174_cov_1.632000_g21943_i0	PRJDB9741	22260	174	1.632	2.83968	Bdellovibrio	958	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2663428595\|dbj\|AP029174.1\|	3113894	g21943	i0	100	4.00574712643678	174	0	100	0	1	174	308648	308821	Bdellovibrio sp. HM001 DNA, complete genome	blastn	697	322	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HM001
25208028	25208028	PRJDB9741_P_NODE_7860_length_224_cov_1.760000_g7543_i0	PRJDB9741	7860	224	1.76	3.9424	Peredibacter	263370	Bacteria	Bacteria	385	1.73e-102	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g7543	i0	97.758	177.633928571429	223	5	99	0	1	223	512340	512562	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	39790	385	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26620961	26620961	PRJDB9741_P_NODE_28201_length_167_cov_0.864407_g27884_i0	PRJDB9741	28201	167	0.864407	1.44355969	Bdellovibrio sp. ArHS	1569284	Bacteria	Bacteria	58.9	2.58e-8	NR	WP_041875954.1	1569284	g27884	i0	100	0.413173652694611	23	0	41.3	0	99	167	416	438	WP_041875954.1 catalase/peroxidase HPI [Bdellovibrio sp. ArHS]	diamond	69	58.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. ArHS
29274491	29274491	PRJDB9741_P_NODE_18809_length_180_cov_1.496183_g18492_i0	PRJDB9741	18809	180	1.496183	2.6931294	Bdellovibrio svalbardensis	2972972	Bacteria	Bacteria	87.4	2.96e-18	NR	WP_277576255.1	2972972	g18492	i0	65	1	60	21	100	0	1	180	311	370	WP_277576255.1 hypothetical protein [Bdellovibrio svalbardensis]	diamond	180	87.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio svalbardensis
29653201	29653201	PRJDB9741_P_NODE_17170_length_183_cov_1.208955_g16853_i0	PRJDB9741	17170	183	1.208955	2.21238765	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	68.9	9.64e-12	NR	HMN67505.1	2053517	g16853	i0	85.7	0.573770491803279	35	5	57.4	0	183	79	399	433	HMN67505.1 translational GTPase TypA [Bdellovibrionales bacterium]	diamond	105	68.9	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31454665	31454665	PRJDB9741_P_NODE_35876_length_163_cov_0.894737_g35559_i0	PRJDB9741	35876	163	0.894737	1.45842131	Bacteriovorax antarcticus	3088717	Bacteria	Bacteria	93.2	3.4e-21	NR	WP_323578651.1	3088717	g35559	i0	82.7	0.957055214723926	52	9	95.7	0	6	161	218	269	WP_323578651.1 trypsin-like serine peptidase [Bacteriovorax antarcticus]	diamond	156	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax antarcticus
32435636	32435636	PRJDB9741_P_NODE_33519_length_164_cov_0.947826_g33202_i0	PRJDB9741	33519	164	0.947826	1.55443464	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	67.4	1.02e-11	NR	HEY8278642.1	3034175	g33202	i0	62.3	0.969512195121951	53	20	97	0	2	160	183	235	HEY8278642.1 RsmE family RNA methyltransferase [Bdellovibrionota bacterium]	diamond	159	67.4	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);;