metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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
999280	999280	PRJNA1000943_P_NODE_9001_length_277_cov_1.911765_g8863_i0	PRJNA1000943	9001	277	1.911765	5.29558905	Pseudobdellovibrio	2862745	Bacteria	Bacteria	178	4.029999999999999e-40	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g8863	i0	78.767	20.2093862815884	292	43	100	10	1	277	1637	1350	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	5598	178	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
6102402	6102402	PRJNA1000943_P_NODE_5565_length_340_cov_1.632959_g5427_i0	PRJNA1000943	5565	340	1.632959	5.5520606	Bdellovibrio	958	Bacteria	Bacteria	316	1.0299999999999999e-81	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g5427	i0	84.164	306.002941176471	341	39	98	12	1	333	783093	783426	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	104041	316	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
7376733	7376733	PRJNA1000943_P_NODE_4066_length_389_cov_1.547468_g3929_i0	PRJNA1000943	4066	389	1.547468	6.01965052	Bdellovibrio	958	Bacteria	Bacteria	503	8.54e-138	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g3929	i0	89.899	194.52442159383	396	33	100	4	1	389	784587	784192	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	75670	508	0.990157480314961	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
11623737	11623737	PRJNA1000943_P_NODE_350_length_1137_cov_5.222744_g288_i0	PRJNA1000943	350	1137	5.222744	59.38259928	Pseudobdellovibrio sp. HCB154	3386277	Bacteria	Bacteria	1956	0	NTclustered	gi\|2872995934\|gb\|CP176530.1\|	3386277	g288	i0	97.715	178.018469656992	1138	24	100	2	1	1137	699588	700724	Pseudobdellovibrio sp. HCB154 chromosome, complete genome	blastn	202407	1956	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio sp. HCB154
15027081	15027081	PRJNA1000943_P_NODE_12572_length_249_cov_0.886364_g12434_i0	PRJNA1000943	12572	249	0.886364	2.20704636	Pseudobdellovibrio	2862745	Bacteria	Bacteria	276	1.2299999999999999e-69	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g12434	i0	86.853	290.78313253012	251	28	99	5	1	248	426	178	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	72405	276	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
18850918	18850918	PRJNA1000943_P_NODE_10275_length_261_cov_1.851064_g10137_i0	PRJNA1000943	10275	261	1.851064	4.83127704	Bacteriovorax	146784	Bacteria	Bacteria	392	1.2299999999999999e-104	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g10137	i0	93.87	397.563218390805	261	14	99	2	1	260	1662088	1661829	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	103764	392	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
18850944	18850944	PRJNA1000943_P_NODE_2275_length_506_cov_12.577367_g2138_i0	PRJNA1000943	2275	506	12.577367	63.64147702	Bdellovibrio	958	Bacteria	Bacteria	846	0	NTclustered	gi\|425858678\|gb\|CP002930.1\|	1069642	g2138	i0	96.838	127.025691699605	506	16	100	0	1	506	842408	842913	Bdellovibrio bacteriovorus str. Tiberius, complete genome	blastn	64275	852	0.992957746478873	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
20125763	20125763	PRJNA1000943_P_NODE_1256_length_673_cov_2.016667_g1125_i0	PRJNA1000943	1256	673	2.016667	13.57216891	Bacteriovorax	146784	Bacteria	Bacteria	845	0	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g1125	i0	89.365	148.364041604755	677	64	100	8	1	673	1661033	1660361	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	99849	845	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
20125811	20125811	PRJNA1000943_P_NODE_956_length_760_cov_7.478894_g830_i0	PRJNA1000943	956	760	7.478894	56.8395944	Bdellovibrio	958	Bacteria	Bacteria	1315	0	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g830	i0	97.898	127.067105263158	761	15	100	1	1	760	749548	748788	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	96571	1315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24371070	24371070	PRJNA1000943_P_NODE_6620_length_316_cov_1.283951_g6482_i0	PRJNA1000943	6620	316	1.283951	4.05728516	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	254	7.560000000000001e-63	NTclustered	gi\|2893356065\|emb\|OZ220488.1\|	2053517	g6482	i0	87.111	153.509493670886	225	27	71	2	81	304	730038	730261	MAG: Bdellovibrionales bacterium isolate 0d1acec5-ee6a-42a0-9e8e-8bc2840f726d genome assembly, chromosome: 1	blastn	48509	254	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);;