metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1118794" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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
230559	230559	PRJNA1118794_P_NODE_29481_length_294_cov_2.371041_g28731_i0	PRJNA1118794	29481	294	2.371041	6.97086054	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	254	6.97e-63	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g28731	i0	83.513	253.632653061224	279	39	94	6	19	294	3250358	3250084	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	74568	254	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
230982	230982	PRJNA1118794_P_NODE_64261_length_245_cov_0.895349_g63511_i0	PRJNA1118794	64261	245	0.895349	2.19360505	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	292	1.2e-74	NTclustered	gi\|578016248\|gb\|CP002190.1\|	765869	g63511	i0	90.868	85.7673469387755	219	19	89	1	27	245	611500	611717	Bdellovibrio bacteriovorus W, complete genome	blastn	21013	292	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
2781376	2781376	PRJNA1118794_P_NODE_48803_length_251_cov_0.865169_g48053_i0	PRJNA1118794	48803	251	0.865169	2.17157419	Bdellovibrio bacteriovorus	959	Bacteria	Bacteria	270	5.77e-68	NTclustered	gi\|2800927921\|gb\|CP168969.1\|	959	g48053	i0	86.111	20.7729083665339	252	33	100	2	1	251	3806089	3805839	Bdellovibrio bacteriovorus strain Bd10 chromosome, complete genome	blastn	5214	270	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
8678126	8678126	PRJNA1118794_P_NODE_23367_length_320_cov_3.627530_g22617_i0	PRJNA1118794	23367	320	3.62753	11.608096	Pseudobdellovibrio	2862745	Bacteria	Bacteria	412	1.1999999999999999e-110	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g22617	i0	91.892	191.53125	296	22	92	2	26	320	309	15	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	61290	412	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
8678248	8678248	PRJNA1118794_P_NODE_6527_length_549_cov_1.886555_g5788_i0	PRJNA1118794	6527	549	1.886555	10.35718695	Pseudomonadati	3379134	Bacteria	Bacteria	335	4.789999999999999e-87	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g5788	i0	79.406	146.342440801457	505	81	90	18	23	516	3250517	3251009	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	80342	335	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
8678251	8678251	PRJNA1118794_P_NODE_66987_length_243_cov_2.100000_g66237_i0	PRJNA1118794	66987	243	2.1	5.103	Pseudobdellovibrio	2862745	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g66237	i0	92.593	78.6707818930041	243	18	100	0	1	243	1467	1225	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	19117	350	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15052529	15052529	PRJNA1118794_P_NODE_14592_length_380_cov_1.915309_g13842_i0	PRJNA1118794	14592	380	1.915309	7.2781742	Bdellovibrio	958	Bacteria	Bacteria	315	4.18e-81	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g13842	i0	82.238	256.094736842105	411	30	97	16	1	369	756528	756119	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	97316	315	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
18082342	18082342	PRJNA1118794_P_NODE_37475_length_274_cov_1.527363_g36725_i0	PRJNA1118794	37475	274	1.527363	4.18497462	Silvanigrella aquatica	1915309	Bacteria	Bacteria	106	1.9e-18	NTclustered	gi\|1114626566\|gb\|CP017834.1\|	1915309	g36725	i0	76.132	6.47445255474453	243	35	85	20	30	263	390360	390132	Silvanigrella aquatica strain MWH-Nonnen-W8red chromosome	blastn	1774	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Silvanigrella	Silvanigrella aquatica
21426941	21426941	PRJNA1118794_P_NODE_34677_length_280_cov_4.623188_g33927_i0	PRJNA1118794	34677	280	4.623188	12.9449264	Bdellovibrio	958	Bacteria	Bacteria	318	2.3e-82	NTclustered	gi\|2800924434\|gb\|CP168967.1\|	959	g33927	i0	87.143	344.264285714286	280	36	100	0	1	280	785732	786011	Bdellovibrio bacteriovorus strain Bd4 chromosome, complete genome	blastn	96394	318	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
21907900	21907900	PRJNA1118794_P_NODE_61018_length_246_cov_0.890173_g60268_i0	PRJNA1118794	61018	246	0.890173	2.18982558	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	383	6.94e-102	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g60268	i0	94.715	1	246	13	100	0	1	246	69428	69673	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	246	383	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
22701928	22701928	PRJNA1118794_P_NODE_48398_length_251_cov_1.584270_g47648_i0	PRJNA1118794	48398	251	1.58427	3.9765177	Bdellovibrio	958	Bacteria	Bacteria	381	2.549999999999999e-101	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g47648	i0	94.024	42.7211155378486	251	15	100	0	1	251	3641473	3641723	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	10723	381	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23183268	23183268	PRJNA1118794_P_NODE_69439_length_243_cov_0.858824_g68689_i0	PRJNA1118794	69439	243	0.858824	2.08694232	Pigmentibacter ruber	2683196	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2651759839\|dbj\|AP029159.1\|	2683196	g68689	i0	100	0.11522633744856	28	0	12	0	87	114	1911853	1911880	Pigmentibacter ruber GTC16762 DNA, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae	Pigmentibacter	Pigmentibacter ruber
23977321	23977321	PRJNA1118794_P_NODE_53519_length_249_cov_0.875000_g52769_i0	PRJNA1118794	53519	249	0.875	2.17875	Bdellovibrio	958	Bacteria	Bacteria	279	9.5e-71	NTclustered	gi\|2800917394\|gb\|CP168972.1\|	959	g52769	i0	87.2	36.3333333333333	250	27	99	5	1	247	3432399	3432152	Bdellovibrio bacteriovorus strain Bd19 chromosome, complete genome	blastn	9047	279	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23977378	23977378	PRJNA1118794_P_NODE_75499_length_229_cov_3.217949_g74749_i0	PRJNA1118794	75499	229	3.217949	7.36910321	Pseudobdellovibrio	2862745	Bacteria	Bacteria	385	1.77e-102	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g74749	i0	97.345	83.5371179039301	226	6	99	0	1	226	1747	1522	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	19130	385	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24456841	24456841	PRJNA1118794_P_NODE_3420_length_783_cov_2.421127_g2727_i0	PRJNA1118794	3420	783	2.421127	18.95742441	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	795	0	NTclustered	gi\|2258818259\|gb\|CP060220.1\|	2026715	g2727	i0	85.223	121.812260536398	785	102	99	13	2	783	3251991	3251218	MAG: Pseudobdellovibrionaceae bacterium isolate HK-STAS-BDEL-7 chromosome	blastn	95379	795	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae 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);;