metadata: contig_metadata: 5 rows where bioproject = "PRJEB10320", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJEB10320", 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
982419	982419	PRJEB10320_P_NODE_14081_length_246_cov_2.796209_g13823_i0	PRJEB10320	14081	246	2.796209	6.87867414	Pseudobdellovibrio	2862745	Bacteria	Bacteria	346	9.1e-91	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g13823	i0	92.562	208.59756097561	242	16	98	2	1	241	259	19	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	51315	346	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
982439	982439	PRJEB10320_P_NODE_4341_length_512_cov_35.798742_g4104_i0	PRJEB10320	4341	512	35.798742	183.28955904	Bacteriovorax	146784	Bacteria	Bacteria	568	4.02e-157	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g4104	i0	87.033	143.056640625	509	58	99	8	5	509	1660349	1660853	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	73245	568	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
29369631	29369631	PRJEB10320_P_NODE_19709_length_195_cov_1.093750_g19451_i0	PRJEB10320	19709	195	1.09375	2.1328125	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	50.4	1.31e-5	NR	MEC7183105.1	3034175	g19451	i0	44.2	0.8	52	29	80	0	158	3	44	95	MEC7183105.1 cyclic nucleotide-binding domain-containing protein [Bdellovibrionota bacterium]	diamond	156	50.4	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29653387	29653387	PRJEB10320_P_NODE_26810_length_156_cov_1.652893_g26552_i0	PRJEB10320	26810	156	1.652893	2.57851308	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	58.5	1.71e-8	NR	MBX9703510.1	2654442	g26552	i0	67.4	0.826923076923077	43	14	82.7	0	156	28	179	221	MBX9703510.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	129	58.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
31802536	31802536	PRJEB10320_P_NODE_1157_length_953_cov_4.705882_g1024_i0	PRJEB10320	1157	953	4.705882	44.84705546	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	375	6.709999999999999e-129	NR	MBX9767865.1	2053517	g1024	i0	90.5	0.632738719832109	201	19	63.3	0	263	865	1	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	603	375	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);;