metadata: contig_metadata: 11 rows where bioproject = "PRJNA800053", tax_kingdom = "Pseudomonadati" and tax

11 rows where bioproject = "PRJNA800053", 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
27307079	27307079	PRJNA800053_P_NODE_8843_length_323_cov_1.588000_g8679_i0	PRJNA800053	8843	323	1.588	5.12924	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	104	1.5999999999999999e-24	NR	MCB0418291.1	2053517	g8679	i0	53.5	1.87616099071207	101	44	93.8	1	18	320	153	250	MCB0418291.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	606	104	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27812420	27812420	PRJNA800053_P_NODE_19844_length_247_cov_0.885057_g19680_i0	PRJNA800053	19844	247	0.885057	2.18609079	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	47	3.25e-4	NR	HXH30623.1	2081706	g19680	i0	52.9	0.412955465587045	34	16	41.3	0	104	3	3	36	HXH30623.1 DOPA 4,5-dioxygenase family protein [Bacteriovoracaceae bacterium]	diamond	102	47	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
28222487	28222487	PRJNA800053_P_NODE_17686_length_251_cov_0.865169_g17522_i0	PRJNA800053	17686	251	0.865169	2.17157419	Bacteriovoracia bacterium	3058048	Bacteria	Bacteria	127	9.38e-34	NR	MFP5490585.1	3058048	g17522	i0	73.4	0.944223107569721	79	21	94.4	0	6	242	74	152	MFP5490585.1 sugar phosphate nucleotidyltransferase [Bacteriovoracia bacterium]	diamond	237	127	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia				Bacteriovoracia bacterium
28317397	28317397	PRJNA800053_P_NODE_18766_length_249_cov_0.875000_g18602_i0	PRJNA800053	18766	249	0.875	2.17875	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	125	9.169999999999999e-35	NR	MCB0370516.1	2053517	g18602	i0	67.5	1	83	27	100	0	249	1	10	92	MCB0370516.1 30S ribosomal protein S13 [Bdellovibrionales bacterium]	diamond	249	125	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28664758	28664758	PRJNA800053_P_NODE_22927_length_242_cov_1.260355_g22763_i0	PRJNA800053	22927	242	1.260355	3.0500591	Oligoflexus sp.	1971216	Bacteria	Bacteria	115	3.37e-28	NR	WP_325138358.1	1971216	g22763	i0	94.7	0.706611570247934	57	3	70.7	0	238	68	404	460	WP_325138358.1 IS66 family transposase [Oligoflexus sp.]	diamond	171	115	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Oligoflexaceae	Oligoflexus	Oligoflexus sp.
29075356	29075356	PRJNA800053_P_NODE_12928_length_280_cov_1.487923_g12764_i0	PRJNA800053	12928	280	1.487923	4.1661844	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	170	7.71e-51	NR	MES2527803.1	3034175	g12764	i0	84.4	0.964285714285714	90	14	96.4	0	276	7	55	144	MES2527803.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	270	170	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29075357	29075357	PRJNA800053_P_NODE_15848_length_260_cov_1.336898_g15684_i0	PRJNA800053	15848	260	1.336898	3.4759348	Bdellovibrio sp. CG1	28201	Bacteria	Bacteria	42.7	0.0454	NR	PIS11363.1	1975526	g15684	i0	31.8	0.980769230769231	85	58	98.1	0	5	259	225	309	PIS11363.1 MAG: hypothetical protein COT73_04485 [Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8]	diamond	255	42.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CG10_big_fil_rev_8_21_14_0_10_47_8
31065373	31065373	PRJNA800053_P_NODE_17655_length_251_cov_0.865169_g17491_i0	PRJNA800053	17655	251	0.865169	2.17157419	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	119	2.45e-30	NR	MEK6554645.1	3034175	g17491	i0	71.1	0.99203187250996006	83	23	99.2	1	251	3	258	339	MEK6554645.1 outer membrane beta-barrel protein [Bdellovibrionota bacterium]	diamond	249	119	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31381435	31381435	PRJNA800053_P_NODE_23716_length_241_cov_0.916667_g23552_i0	PRJNA800053	23716	241	0.916667	2.20916747	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	140	4e-39	NR	PZQ44217.1	349221	g23552	i0	83.5	0.983402489626556	79	13	98.3	0	239	3	155	233	PZQ44217.1 MAG: segregation/condensation protein A [Micavibrio aeruginosavorus]	diamond	237	140	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
31982164	31982164	PRJNA800053_P_NODE_17478_length_251_cov_0.865169_g17314_i0	PRJNA800053	17478	251	0.865169	2.17157419	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	151	4.3e-41	NR	MES2527698.1	3034175	g17314	i0	91.6	0.99203187250996006	83	7	99.2	0	251	3	134	216	MES2527698.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	249	151	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
32045655	32045655	PRJNA800053_P_NODE_18558_length_249_cov_1.125000_g18394_i0	PRJNA800053	18558	249	1.125	2.80125	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	43.5	0.0205	NR	MBY0518265.1	2081706	g18394	i0	40.2	0.987951807228916	82	42	97.6	3	248	6	61	136	MBY0518265.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	246	43.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae 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);;