metadata: contig_metadata: 12 rows where bioproject = "PRJNA454503", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJNA454503", 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
2368977	2368977	PRJNA454503_P_NODE_23202_length_256_cov_1.358974_g22873_i0	PRJNA454503	23202	256	1.358974	3.47897344	Bdellovibrio	958	Bacteria	Bacteria	372	1.57e-98	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g22873	i0	92.941	221.74609375	255	18	99	0	2	256	611390	611136	Bdellovibrio bacteriovorus W, complete genome	blastn	56767	372	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
28212886	28212886	PRJNA454503_P_NODE_83506_length_202_cov_1.843972_g83177_i0	PRJNA454503	83506	202	1.843972	3.72482344	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	68.2	2.34e-11	NR	MCB0346654.1	2053517	g83177	i0	51.5	3.92079207920792	66	31	98	1	2	199	417	481	MCB0346654.1 PhoH family protein [Bdellovibrionales bacterium]	diamond	792	68.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29492254	29492254	PRJNA454503_P_NODE_44230_length_222_cov_1.248447_g43901_i0	PRJNA454503	44230	222	1.248447	2.77155234	Bacteriovorax	146784	Bacteria	Bacteria	117	1.55e-28	NR	WP_102241963.1	960	g43901	i0	65.8	3.94594594594595	73	25	98.6	0	219	1	496	568	WP_102241963.1 ABC transporter substrate-binding protein [Bacteriovorax stolpii]	diamond	876	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
29949823	29949823	PRJNA454503_P_NODE_35011_length_233_cov_1.348837_g34682_i0	PRJNA454503	35011	233	1.348837	3.14279021	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	90.5	5.01e-19	NR	MES2963473.1	3034175	g34682	i0	61.3	1.90557939914163	75	29	96.6	0	226	2	412	486	MES2963473.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	444	90.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30076034	30076034	PRJNA454503_P_NODE_68792_length_207_cov_0.890411_g68463_i0	PRJNA454503	68792	207	0.890411	1.84315077	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	92.8	1.33e-20	NR	MCM2351647.1	2081706	g68463	i0	71	1	69	19	100	1	207	1	86	153	MCM2351647.1 FHA domain-containing protein [Bacteriovoracaceae bacterium]	diamond	207	92.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
30644694	30644694	PRJNA454503_P_NODE_52273_length_213_cov_1.710526_g51944_i0	PRJNA454503	52273	213	1.710526	3.64342038	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	85.1	2.72e-17	NR	MES2963570.1	3034175	g51944	i0	58.1	1.74647887323944	62	26	87.3	0	187	2	3	64	MES2963570.1 AmpG family muropeptide MFS transporter [Bdellovibrionota bacterium]	diamond	372	85.1	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31403522	31403522	PRJNA454503_P_NODE_36036_length_231_cov_2.852941_g35707_i0	PRJNA454503	36036	231	2.852941	6.59029371	Halobacteriovoraceae bacterium	2026745	Bacteria	Bacteria	99.4	3.92e-22	NR	MAX66883.1	2026745	g35707	i0	59.7	1	77	31	100	0	1	231	185	261	MAX66883.1 hypothetical protein [Halobacteriovoraceae bacterium]	diamond	231	99.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae		Halobacteriovoraceae bacterium
32035994	32035994	PRJNA454503_P_NODE_73398_length_205_cov_1.805556_g73069_i0	PRJNA454503	73398	205	1.805556	3.7013898	Bacteriovorax sp.	2608087	Bacteria	Bacteria	83.2	3.63e-17	NR	MBC7427325.1	2608087	g73069	i0	63.9	0.892682926829268	61	22	89.3	0	204	22	188	248	MBC7427325.1 zinc ABC transporter substrate-binding protein [Bacteriovorax sp.]	diamond	183	83.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
32415842	32415842	PRJNA454503_P_NODE_52279_length_213_cov_1.710526_g51950_i0	PRJNA454503	52279	213	1.710526	3.64342038	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	124	4.85e-31	NR	PZP55148.1	349221	g51950	i0	98.6	0.985915492957746	70	1	98.6	0	211	2	990	1059	PZP55148.1 MAG: CusA/CzcA family heavy metal efflux RND transporter [Micavibrio aeruginosavorus]	diamond	210	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
32432014	32432014	PRJNA454503_P_NODE_34019_length_234_cov_1.502890_g33690_i0	PRJNA454503	34019	234	1.50289	3.5167626	Bdellovibrio	958	Bacteria	Bacteria	102	1.29e-23	NR	WP_176400962.1	1732569	g33690	i0	67.1	3.87179487179487	76	25	97.4	0	6	233	78	153	WP_176400962.1 alpha/beta hydrolase fold domain-containing protein [Bdellovibrio sp. SKB1291214]	diamond	906	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. SKB1291214
32699702	32699702	PRJNA454503_P_NODE_56280_length_211_cov_0.866667_g55951_i0	PRJNA454503	56280	211	0.866667	1.82866737	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	107	5.43e-25	NR	MBA2403248.1	2053517	g55951	i0	73.9	0.981042654028436	69	18	98.1	0	209	3	518	586	MBA2403248.1 enoyl-CoA hydratase/isomerase family protein [Bdellovibrionales bacterium]	diamond	207	107	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32794048	32794048	PRJNA454503_P_NODE_63800_length_208_cov_1.727891_g63471_i0	PRJNA454503	63800	208	1.727891	3.59401328	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	139	1.4399999999999998e-37	NR	PZP55973.1	349221	g63471	i0	98.6	0.995192307692308	69	1	99.5	0	207	1	286	354	PZP55973.1 MAG: argininosuccinate synthase [Micavibrio aeruginosavorus]	diamond	207	139	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus

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