metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA801875" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA801875" 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
801061	801061	PRJNA801875_P_NODE_3761_length_169_cov_1.179104_g3658_i0	PRJNA801875	3761	169	1.179104	1.99268576	Pseudobdellovibrio exovorus	453816	Bacteria	Bacteria	113	6.3800000000000005e-21	NTclustered	gi\|469929247\|gb\|CP003537.1\|	1184267	g3658	i0	80.982	0.964497041420118	163	13	88	9	8	156	878319	878477	Bdellovibrio exovorus JSS, complete genome	blastn	163	113	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
4629500	4629500	PRJNA801875_P_NODE_2824_length_200_cov_4.303030_g2721_i0	PRJNA801875	2824	200	4.30303	8.60606	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	65.8	2.23e-6	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g2721	i0	88.679	0.265	53	6	27	0	95	147	1088831	1088883	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	53	65.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
9729174	9729174	PRJNA801875_P_NODE_4008_length_164_cov_0.922481_g3905_i0	PRJNA801875	4008	164	0.922481	1.51286884	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	60.2	8.18e-5	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g3905	i0	97.143	19.3048780487805	35	1	21	0	10	44	35115	35081	Bdellovibrio bacteriovorus W, complete genome	blastn	3166	60.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
13975652	13975652	PRJNA801875_P_NODE_2291_length_231_cov_21.596939_g2188_i0	PRJNA801875	2291	231	21.596939	49.88892909	root	1	Root_unresolved	Root_unresolved	294	3.11e-75	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g2188	i0	89.655	168.562770562771	232	22	100	2	1	231	1677507	1677277	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	38938	294	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21623837	21623837	PRJNA801875_P_NODE_737_length_496_cov_13.783080_g635_i0	PRJNA801875	737	496	13.78308	68.3640768	Bdellovibrio	958	Bacteria	Bacteria	368	4.23e-97	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g635	i0	80.439	199.010080645161	501	82	99	12	1	491	1676850	1676356	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	98709	368	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus

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);;