metadata: contig_metadata: 8 rows where bioproject = "PRJNA1215813", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA1215813", 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
27293932	27293932	PRJNA1215813_P_NODE_3503_length_406_cov_1.117117_g3423_i0	PRJNA1215813	3503	406	1.117117	4.53549502	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	155	1.09e-40	NR	MBS1969835.1	2053517	g3423	i0	56.7	0.990147783251232	134	58	99	0	404	3	1189	1322	MBS1969835.1 endonuclease/exonuclease/phosphatase family protein [Bdellovibrionales bacterium]	diamond	402	155	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27767881	27767881	PRJNA1215813_P_NODE_5324_length_335_cov_2.374046_g5244_i0	PRJNA1215813	5324	335	2.374046	7.9530541	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	95.1	1.7e-20	NR	MBS1972053.1	2053517	g5244	i0	48	0.913432835820896	102	53	91.3	0	30	335	83	184	MBS1972053.1 site-specific integrase [Bdellovibrionales bacterium]	diamond	306	95.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28714963	28714963	PRJNA1215813_P_NODE_9627_length_252_cov_0.871508_g9547_i0	PRJNA1215813	9627	252	0.871508	2.19620016	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	77	3.71e-14	NR	MBS1969835.1	2053517	g9547	i0	51.4	0.880952380952381	74	34	88.1	1	252	31	291	362	MBS1969835.1 endonuclease/exonuclease/phosphatase family protein [Bdellovibrionales bacterium]	diamond	222	77	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29440771	29440771	PRJNA1215813_P_NODE_11270_length_246_cov_0.901734_g11190_i0	PRJNA1215813	11270	246	0.901734	2.21826564	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	71.6	2.55e-12	NR	MBS1972700.1	2053517	g11190	i0	44.9	0.951219512195122	78	40	91.5	1	244	20	673	750	MBS1972700.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	234	71.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30609668	30609668	PRJNA1215813_P_NODE_6013_length_318_cov_1.261224_g5933_i0	PRJNA1215813	6013	318	1.261224	4.01069232	Bdellovibrio bacteriovorus W	765869	Bacteria	Bacteria	67.8	1.21e-10	NR	AHI04568.1	765869	g5933	i0	43.3	0.849056603773585	90	51	84.9	0	279	10	41	130	AHI04568.1 peptide chain release factor RF-1 [Bdellovibrio bacteriovorus W]	diamond	270	67.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
32633164	32633164	PRJNA1215813_P_NODE_520_length_934_cov_3.080139_g470_i0	PRJNA1215813	520	934	3.080139	28.76849826	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	375	5.3499999999999986e-129	NR	MBX9767865.1	2053517	g470	i0	90.5	0.645610278372591	201	19	64.6	0	256	858	1	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	603	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32790622	32790622	PRJNA1215813_P_NODE_11760_length_245_cov_0.877907_g11680_i0	PRJNA1215813	11760	245	0.877907	2.15087215	Oligoflexia bacterium	2599941	Bacteria	Bacteria	52.8	1.13e-5	NR	MDR3606671.1	2599941	g11680	i0	46.5	0.869387755102041	71	36	85.7	2	236	27	904	973	MDR3606671.1 SMP-30/gluconolactonase/LRE family protein [Oligoflexia bacterium]	diamond	213	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia				Oligoflexia bacterium
32790632	32790632	PRJNA1215813_P_NODE_7640_length_284_cov_1.478673_g7560_i0	PRJNA1215813	7640	284	1.478673	4.19943132	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	59.7	6.41e-8	NR	MBS1972054.1	2053517	g7560	i0	55.8	0.549295774647887	52	23	54.9	0	2	157	419	470	MBS1972054.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	156	59.7	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);;