metadata: contig_metadata: 16 rows where bioproject = "PRJNA745553", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA745553", 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
5827672	5827672	PRJNA745553_S_NODE_14085_length_328_cov_2.152941_g13890_i0	PRJNA745553	14085	328	2.152941	7.06164648	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	224	6.179999999999998e-54	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g13890	i0	79.937	258.164634146341	319	53	95	9	17	328	3448035	3448349	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	84678	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
5827896	5827896	PRJNA745553_S_NODE_25945_length_244_cov_2.274854_g25750_i0	PRJNA745553	25945	244	2.274854	5.55064376	uncultured Oligoflexales bacterium	2735263	Bacteria	Bacteria	148	2.7299999999999997e-31	NTclustered	gi\|2531963191\|emb\|OY282434.1\|	2735263	g25750	i0	83.537	105.204918032787	164	22	66	5	21	180	954538	954700	MAG: uncultured Oligoflexales bacterium genome assembly, chromosome: 1	blastn	25670	148	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales			uncultured Oligoflexales bacterium
8377491	8377491	PRJNA745553_S_NODE_18347_length_288_cov_4.609302_g18152_i0	PRJNA745553	18347	288	4.609302	13.27478976	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	359	1.4e-94	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g18152	i0	95.928	59.1597222222222	221	9	77	0	21	241	1292539	1292759	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	17038	359	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
9652834	9652834	PRJNA745553_S_NODE_4708_length_514_cov_3.038549_g4517_i0	PRJNA745553	4708	514	3.038549	15.61814186	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	675	0	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g4517	i0	91.147	122.570038910506	497	44	97	0	10	506	1292276	1292772	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	63001	675	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
10927967	10927967	PRJNA745553_S_NODE_10049_length_382_cov_5.190939_g9854_i0	PRJNA745553	10049	382	5.190939	19.82938698	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	322	2.51e-83	NTclustered	gi\|2556916994\|gb\|CP129486.1\|	3034175	g9854	i0	83.014	169.523560209424	365	52	94	9	5	362	469192	469553	MAG: Bdellovibrionota bacterium isolate cMAG.10 chromosome, complete genome	blastn	64758	322	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
12678288	12678288	PRJNA745553_S_NODE_23010_length_258_cov_1.562162_g22815_i0	PRJNA745553	23010	258	1.562162	4.03037796	Peredibacter	263370	Bacteria	Bacteria	451	1.98e-122	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g22815	i0	98.444	250.027131782946	257	3	99	1	2	258	512012	511757	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	64507	451	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13478205	13478205	PRJNA745553_S_NODE_4611_length_518_cov_11.907865_g4421_i0	PRJNA745553	4611	518	11.907865	61.6827407	Peredibacter starrii	28202	Bacteria	Bacteria	717	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g4421	i0	92.742	100.667953667954	496	36	96	0	2	497	511179	510684	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	52146	717	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
13478287	13478287	PRJNA745553_S_NODE_8551_length_411_cov_5.352071_g8356_i0	PRJNA745553	8551	411	5.352071	21.99701181	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	364	4.469999999999999e-96	NTclustered	gi\|1950812799\|gb\|CP066681.1\|	349221	g8356	i0	84.01	254.360097323601	394	48	94	15	15	400	659521	659907	Micavibrio aeruginosavorus isolate NC_groundwater_70_Ag_B-0.1um_54_66 chromosome	blastn	104542	364	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
24150265	24150265	PRJNA745553_S_NODE_17839_length_292_cov_3.232877_g17644_i0	PRJNA745553	17839	292	3.232877	9.44000084	Pseudobdellovibrionaceae	213483	Bacteria	Bacteria	335	2.4e-87	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g17644	i0	87.415	219.880136986301	294	34	100	3	1	292	2394	2102	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	64205	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
26799517	26799517	PRJNA745553_S_NODE_24681_length_249_cov_4.602273_g24486_i0	PRJNA745553	24681	249	4.602273	11.45965977	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	104	2.81e-26	NR	HEY8279091.1	3034175	g24486	i0	70.6	0.819277108433735	68	20	81.9	0	223	20	33	100	HEY8279091.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Bdellovibrionota bacterium]	diamond	204	104	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
27526691	27526691	PRJNA745553_S_NODE_18443_length_287_cov_5.037383_g18248_i0	PRJNA745553	18443	287	5.037383	14.45728921	Oligoflexus sp.	1971216	Bacteria	Bacteria	89	1.61e-19	NR	WP_324958659.1	1971216	g18248	i0	54.6	1.01393728222997	97	28	84.7	2	245	3	16	112	WP_324958659.1 hypothetical protein [Oligoflexus sp.]	diamond	291	89	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
27590029	27590029	PRJNA745553_S_NODE_17144_length_298_cov_3.333333_g16949_i0	PRJNA745553	17144	298	3.333333	9.93333234	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	71.6	5.23e-12	NR	MBX3023134.1	2053517	g16949	i0	41.5	0.825503355704698	82	45	81.5	2	286	44	206	285	MBX3023134.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	246	71.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27653156	27653156	PRJNA745553_S_NODE_28724_length_227_cov_6.597403_g28529_i0	PRJNA745553	28724	227	6.597403	14.97610481	Micavibrio sp.	2024841	Bacteria	Bacteria	94	2.6199999999999998e-23	NR	HEY8189317.1	2024841	g28529	i0	68.3	3.87224669603524	60	19	79.3	0	48	227	1	60	HEY8189317.1 CsbD family protein [Micavibrio sp.]	diamond	879	94	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio sp.
32171039	32171039	PRJNA745553_S_NODE_26518_length_242_cov_1.366864_g26323_i0	PRJNA745553	26518	242	1.366864	3.30781088	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	82.8	5.05e-18	NR	NJM09770.1	2026715	g26323	i0	56.1	0.818181818181818	66	29	81.8	0	25	222	59	124	NJM09770.1 riboflavin synthase [Pseudobdellovibrionaceae bacterium]	diamond	198	82.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
32392301	32392301	PRJNA745553_S_NODE_19919_length_277_cov_1.887255_g19724_i0	PRJNA745553	19919	277	1.887255	5.22769635	Oligoflexus sp.	1971216	Bacteria	Bacteria	66.6	1.16e-11	NR	WP_324954830.1	1971216	g19724	i0	58	1.50541516245487	69	28	74.7	1	253	47	51	118	WP_324954830.1 preprotein translocase subunit SecG [Oligoflexus sp.]	diamond	417	66.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
32875327	32875327	PRJNA745553_S_NODE_7000_length_447_cov_1.483957_g6806_i0	PRJNA745553	7000	447	1.483957	6.63328779	Pseudomonadati	3379134	Bacteria	Bacteria	172	2.18e-51	NR	MBL7714230.1	2053517	g6806	i0	77.1	2.40268456375839	118	26	79.2	1	94	447	2	118	MBL7714230.1 NAD(P)-binding domain-containing protein [Bdellovibrionales bacterium]	diamond	1074	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;