metadata: contig_metadata: 10 rows where bioproject = "PRJDB3785" and tax

10 rows where bioproject = "PRJDB3785" 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
11486689	11486689	PRJDB3785_S_NODE_16830_length_191_cov_1.795775_g16677_i0	PRJDB3785	16830	191	1.795775	3.42993025	Bacteria	2	Bacteria	Bacteria	109	4.85e-26	NR	MCB0326570.1	2053517	g16677	i0	76.2	1.97905759162304	63	15	99	0	3	191	672	734	MCB0326570.1 ribonucleoside-diphosphate reductase subunit alpha [Bdellovibrionales bacterium]	diamond	378	109	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
14036782	14036782	PRJDB3785_S_NODE_14392_length_204_cov_1.316129_g14239_i0	PRJDB3785	14392	204	1.316129	2.68490316	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	134	4.57e-38	NR	MCB0370127.1	2053517	g14239	i0	95.5	0.985294117647059	67	3	98.5	0	202	2	36	102	MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium]	diamond	201	134	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26905897	26905897	PRJDB3785_S_NODE_17982_length_186_cov_1.116788_g17829_i0	PRJDB3785	17982	186	1.116788	2.07722568	Fluviispira multicolorata	2654512	Bacteria	Bacteria	51.2	1.51e-5	NR	WP_161597625.1	2654512	g17829	i0	38.7	2.69354838709677	62	36	100	1	1	186	131	190	WP_161597625.1 fatty acid desaturase family protein [Fluviispira multicolorata]	diamond	501	51.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Fluviispira	Fluviispira multicolorata
27632782	27632782	PRJDB3785_S_NODE_12344_length_218_cov_1.414201_g12191_i0	PRJDB3785	12344	218	1.414201	3.08295818	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	71.2	3.51e-14	NR	MCB0368788.1	2053517	g12191	i0	64.8	0.743119266055046	54	19	74.3	0	3	164	32	85	MCB0368788.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	162	71.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28232351	28232351	PRJDB3785_S_NODE_10146_length_238_cov_1.068783_g9993_i0	PRJDB3785	10146	238	1.068783	2.54370354	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	149	2.38e-43	NR	MCB0368367.1	2053517	g9993	i0	84.6	0.983193277310924	78	12	98.3	0	5	238	1	78	MCB0368367.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	234	149	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28390479	28390479	PRJDB3785_S_NODE_25986_length_163_cov_0.894737_g25833_i0	PRJDB3785	25986	163	0.894737	1.45842131	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	94	2e-23	NR	MCB0370657.1	2053517	g25833	i0	84.9	0.975460122699387	53	8	97.5	0	159	1	33	85	MCB0370657.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	159	94	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30032537	30032537	PRJDB3785_S_NODE_20391_length_176_cov_1.598425_g20238_i0	PRJDB3785	20391	176	1.598425	2.813228	Halobacteriovorax marinus	97084	Bacteria	Bacteria	82	1.56e-16	NR	WP_096910288.1	97084	g20238	i0	69.8	0.903409090909091	53	16	90.3	0	161	3	235	287	WP_096910288.1 trans-sulfuration enzyme family protein [Halobacteriovorax marinus]	diamond	159	82	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus
30158580	30158580	PRJDB3785_S_NODE_23172_length_167_cov_0.864407_g23019_i0	PRJDB3785	23172	167	0.864407	1.44355969	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	77.8	1.01e-15	NR	MEZ4846639.1	3034175	g23019	i0	74.5	0.844311377245509	47	12	84.4	0	163	23	181	227	MEZ4846639.1 MBL fold metallo-hydrolase [Bdellovibrionota bacterium]	diamond	141	77.8	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31770746	31770746	PRJDB3785_S_NODE_16117_length_195_cov_1.013699_g15964_i0	PRJDB3785	16117	195	1.013699	1.97671305	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	102	2.42e-25	NR	MCB0368367.1	2053517	g15964	i0	80.3	1.93846153846154	61	12	93.8	0	195	13	137	197	MCB0368367.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	378	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32182226	32182226	PRJDB3785_S_NODE_7158_length_281_cov_0.905172_g7005_i0	PRJDB3785	7158	281	0.905172	2.54353332	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	88.6	1.27e-19	NR	MCB0371038.1	2053517	g7005	i0	49.4	0.864768683274021	81	41	86.5	0	39	281	45	125	MCB0371038.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium]	diamond	243	88.6	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);;