metadata: contig_metadata: 7 rows where bioproject = "PRJNA1002816", tax_kingdom = "Pseudomonadati" and tax

7 rows where bioproject = "PRJNA1002816", 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_species
27319062	27319062	PRJNA1002816_P_NODE_10023_length_352_cov_1.964158_g9863_i0	PRJNA1002816	10023	352	1.964158	6.91383616	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	144	4.08e-41	NR	MCB0369646.1	2053517	g9863	i0	82.9	0.698863636363636	82	14	69.9	0	106	351	46	127	MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium]	diamond	246	144	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
27413979	27413979	PRJNA1002816_P_NODE_7623_length_409_cov_1.770833_g7463_i0	PRJNA1002816	7623	409	1.770833	7.24270697	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	154	1.51e-43	NR	MCB0369784.1	2053517	g7463	i0	58.5	0.990220048899755	135	56	99	0	408	4	98	232	MCB0369784.1 insulinase family protein [Bdellovibrionales bacterium]	diamond	405	154	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
27918825	27918825	PRJNA1002816_P_NODE_8205_length_394_cov_0.959502_g8045_i0	PRJNA1002816	8205	394	0.959502	3.78043788	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	72.4	1.93e-13	NR	MCB0369941.1	2053517	g8045	i0	40	0.761421319796954	100	56	75.4	3	323	27	21	117	MCB0369941.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	300	72.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
28076657	28076657	PRJNA1002816_P_NODE_17685_length_251_cov_0.865169_g17525_i0	PRJNA1002816	17685	251	0.865169	2.17157419	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	61.6	7.03e-10	NR	MCB0370850.1	2053517	g17525	i0	41.6	0.920318725099602	77	41	87.3	1	224	6	7	83	MCB0370850.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	231	61.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
28582112	28582112	PRJNA1002816_P_NODE_4507_length_534_cov_2.483731_g4347_i0	PRJNA1002816	4507	534	2.483731	13.26312354	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	224	8.529999999999999e-72	NR	MCB0368045.1	2053517	g4347	i0	67.4	0.98314606741573	175	56	97.8	1	523	2	1	175	MCB0368045.1 EF-hand domain-containing protein [Bdellovibrionales bacterium]	diamond	525	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
28771341	28771341	PRJNA1002816_P_NODE_12887_length_308_cov_1.404255_g12727_i0	PRJNA1002816	12887	308	1.404255	4.3251054	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	77.8	2.11e-15	NR	MCB0369646.1	2053517	g12727	i0	81.4	0.418831168831169	43	8	41.9	0	216	88	46	88	MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium]	diamond	129	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Bdellovibrionales bacterium
30855897	30855897	PRJNA1002816_P_NODE_15214_length_278_cov_1.214634_g15054_i0	PRJNA1002816	15214	278	1.214634	3.37668252	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	115	2.5099999999999996e-31	NR	MCB0368288.1	2053517	g15054	i0	61.4	0.949640287769784	88	33	93.9	1	277	17	2	89	MCB0368288.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	264	115	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);;