metadata: contig_metadata: 10 rows where bioproject = "PRJNA1156092", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA1156092", 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
2853891	2853891	PRJNA1156092_P_NODE_29763_length_244_cov_0.900585_g29633_i0	PRJNA1156092	29763	244	0.900585	2.1974274	Bdellovibrio	958	Bacteria	Bacteria	127	6.85e-34	NR	WP_374075959.1	958	g29633	i0	76.5	0.995901639344262	81	19	99.6	0	1	243	28	108	WP_374075959.1 MULTISPECIES: class I SAM-dependent methyltransferase [Bdellovibrio]	diamond	243	127	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio
6140102	6140102	PRJNA1156092_P_NODE_31205_length_242_cov_0.911243_g31075_i0	PRJNA1156092	31205	242	0.911243	2.20520806	Bdellovibrio	958	Bacteria	Bacteria	390	4.0699999999999996e-104	NTclustered	gi\|2313021230\|gb\|CP102930.1\|	959	g31075	i0	95.851	80.7066115702479	241	10	99	0	2	242	2386398	2386158	Bdellovibrio bacteriovorus strain kdesi chromosome, complete genome	blastn	19531	390	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11781496	11781496	PRJNA1156092_P_NODE_26030_length_247_cov_0.885057_g25900_i0	PRJNA1156092	26030	247	0.885057	2.18609079	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g25900	i0	92.713	26.0688259109312	247	18	100	0	1	247	96537	96783	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	6439	357	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
27924759	27924759	PRJNA1156092_P_NODE_21205_length_255_cov_1.346154_g21075_i0	PRJNA1156092	21205	255	1.346154	3.4326927	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	136	1.97e-36	NR	HLT22541.1	2081706	g21075	i0	77.6	2	85	18	100	1	1	255	90	173	HLT22541.1 chorismate-binding protein [Bacteriovoracaceae bacterium]	diamond	510	136	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
29156359	29156359	PRJNA1156092_P_NODE_27929_length_245_cov_0.895349_g27799_i0	PRJNA1156092	27929	245	0.895349	2.19360505	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	159	9.16e-47	NR	WP_413939877.1	3394362	g27799	i0	96.3	0.991836734693878	81	3	99.2	0	244	2	153	233	WP_413939877.1 isoprenyl transferase [Bdellovibrio sp. HCB2-146]	diamond	243	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
29219426	29219426	PRJNA1156092_P_NODE_25429_length_248_cov_0.880000_g25299_i0	PRJNA1156092	25429	248	0.88	2.1824	Bdellovibrio sp. HCB2-146	3394362	Bacteria	Bacteria	147	2.36e-42	NR	WP_413940938.1	3394362	g25299	i0	90.2	0.991935483870968	82	8	99.2	0	3	248	23	104	WP_413940938.1 ribonuclease III [Bdellovibrio sp. HCB2-146]	diamond	246	147	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB2-146
30514241	30514241	PRJNA1156092_P_NODE_23153_length_250_cov_0.870056_g23023_i0	PRJNA1156092	23153	250	0.870056	2.17514	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	111	1.94e-26	NR	MDH5580332.1	2053517	g23023	i0	68.3	0.984	82	26	98.4	0	3	248	502	583	MDH5580332.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	246	111	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30798506	30798506	PRJNA1156092_P_NODE_31134_length_242_cov_0.911243_g31004_i0	PRJNA1156092	31134	242	0.911243	2.20520806	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	40	0.0421	NR	NOT78014.1	2081706	g31004	i0	43.9	0.508264462809917	41	20	47.1	1	124	11	1	41	NOT78014.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	123	40	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31810306	31810306	PRJNA1156092_P_NODE_25897_length_247_cov_0.885057_g25767_i0	PRJNA1156092	25897	247	0.885057	2.18609079	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	86.3	4.22e-19	NR	MFL5785762.1	2081706	g25767	i0	56.3	0.862348178137652	71	31	86.2	0	246	34	84	154	MFL5785762.1 SRPBCC domain-containing protein [Bacteriovoracaceae bacterium]	diamond	213	86.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
31841749	31841749	PRJNA1156092_P_NODE_12057_length_327_cov_1.212598_g11927_i0	PRJNA1156092	12057	327	1.212598	3.96519546	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	129	6.62e-33	NR	MFK7839511.1	2053517	g11927	i0	66	1.91743119266055	106	36	97.2	0	4	321	211	316	MFK7839511.1 efflux transporter outer membrane subunit [Bdellovibrionales bacterium]	diamond	627	129	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);;