metadata: contig_metadata: 17 rows where bioproject = "PRJNA577580", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA577580", 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
2413517	2413517	PRJNA577580_P_NODE_10182_length_287_cov_2.271028_g10104_i0	PRJNA577580	10182	287	2.271028	6.51785036	Bdellovibrio	958	Bacteria	Bacteria	274	5.199999999999998e-69	NTclustered	gi\|2663425168\|dbj\|AP029173.1\|	3113893	g10104	i0	84.848	98.5714285714286	297	18	94	8	1	270	756516	756220	Bdellovibrio sp. CKG001 DNA, complete genome	blastn	28290	274	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. CKG001
6241736	6241736	PRJNA577580_P_NODE_5665_length_376_cov_2.983498_g5587_i0	PRJNA577580	5665	376	2.983498	11.21795248	Pseudobdellovibrio	2862745	Bacteria	Bacteria	540	6.27e-149	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g5587	i0	93.681	167.808510638298	364	17	95	4	18	376	964	602	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	63096	540	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
15866701	15866701	PRJNA577580_P_NODE_2733_length_546_cov_2.604651_g2655_i0	PRJNA577580	2733	546	2.604651	14.22139446	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	588	3.31e-163	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g2655	i0	87.054	347.558608058608	533	54	95	11	25	545	3447552	3447023	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	189767	588	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
26699623	26699623	PRJNA577580_P_NODE_5961_length_367_cov_3.163265_g5883_i0	PRJNA577580	5961	367	3.163265	11.60918255	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	82	2.71e-16	NR	MCO5113132.1	2026715	g5883	i0	43.7	0.97275204359673	119	61	97.3	2	363	7	46	158	MCO5113132.1 glutaredoxin 2 [Pseudobdellovibrionaceae bacterium]	diamond	357	82	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28248060	28248060	PRJNA577580_P_NODE_17146_length_227_cov_2.025974_g17068_i0	PRJNA577580	17146	227	2.025974	4.59896098	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	84	9.21e-17	NR	MBL7542369.1	2026715	g17068	i0	54.9	0.9383259911894268	71	30	91.2	1	3	209	159	229	MBL7542369.1 hypothetical protein [Pseudobdellovibrionaceae bacterium]	diamond	213	84	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28324750	28324750	PRJNA577580_P_NODE_1806_length_677_cov_3.286424_g1731_i0	PRJNA577580	1806	677	3.286424	22.24909048	Bacteria	2	Bacteria	Bacteria	179	8.99e-53	NR	MCB9027028.1	2026715	g1731	i0	45.1	6.95716395864106	224	93	98.4	6	7	672	29	224	MCB9027028.1 carbonic anhydrase [Pseudobdellovibrionaceae bacterium]	diamond	4710	180	0.994444444444444	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28595737	28595737	PRJNA577580_P_NODE_8907_length_304_cov_3.186147_g8829_i0	PRJNA577580	8907	304	3.186147	9.68588688	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	124	3.8800000000000005e-33	NR	MBK8204574.1	2053517	g8829	i0	60	2.96052631578947	100	38	98.7	1	300	1	1	98	MBK8204574.1 carbonic anhydrase [Bdellovibrionales bacterium]	diamond	900	124	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29353443	29353443	PRJNA577580_P_NODE_10069_length_289_cov_0.935185_g9991_i0	PRJNA577580	10069	289	0.935185	2.70268465	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	44.3	0.00754	NR	MEW6056281.1	3034175	g9991	i0	34.3	0.726643598615917	70	45	72.7	1	8	217	56	124	MEW6056281.1 TraR/DksA C4-type zinc finger protein [Bdellovibrionota bacterium]	diamond	210	44.3	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
29953313	29953313	PRJNA577580_P_NODE_71_length_2093_cov_10.037129_g56_i0	PRJNA577580	71	2093	10.037129	210.07710997	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	205	5.309999999999999e-52	NR	MCH2533348.1	2053517	g56	i0	35	1.54801720019111	383	222	54.2	15	2089	956	347	707	MCH2533348.1 putative Ig domain-containing protein [Bdellovibrionales bacterium]	diamond	3240	205	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30269492	30269492	PRJNA577580_P_NODE_11192_length_275_cov_1.544554_g11114_i0	PRJNA577580	11192	275	1.544554	4.2475235	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	43.9	0.0216	NR	HLG19372.1	3034175	g11114	i0	44.4	0.589090909090909	54	22	58.9	1	81	242	749	794	HLG19372.1 S8 family serine peptidase [Bdellovibrionota bacterium]	diamond	162	43.9	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30364454	30364454	PRJNA577580_P_NODE_7172_length_336_cov_1.669202_g7094_i0	PRJNA577580	7172	336	1.669202	5.60851872	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	84.7	2.03e-16	NR	MEQ1878799.1	3034169	g7094	i0	43.8	0.857142857142857	96	53	85.7	1	6	293	135	229	MEQ1878799.1 serine hydrolase [Bdellovibrionia bacterium]	diamond	288	84.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
30756674	30756674	PRJNA577580_P_NODE_13074_length_257_cov_1.277174_g12996_i0	PRJNA577580	13074	257	1.277174	3.28233718	Pseudomonadati	3379134	Bacteria	Bacteria	64.7	3.94e-11	NR	MFM6928100.1	28201	g12996	i0	43.6	5.36964980544747	78	40	91.1	2	3	236	7	80	MFM6928100.1 thioredoxin [Bdellovibrio sp.]	diamond	1380	65.1	0.993855606758833	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
30964471	30964471	PRJNA577580_P_NODE_13234_length_255_cov_1.659341_g13156_i0	PRJNA577580	13234	255	1.659341	4.23131955	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	130	1.52e-36	NR	MCB0368223.1	2053517	g13156	i0	91.5	0.835294117647059	71	6	83.5	0	214	2	13	83	MCB0368223.1 cation transporting ATPase C-terminal domain-containing protein [Bdellovibrionales bacterium]	diamond	213	130	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30996018	30996018	PRJNA577580_P_NODE_294_length_1385_cov_3.806402_g262_i0	PRJNA577580	294	1385	3.806402	52.7186677	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	108	9.87e-21	NR	MCB0421895.1	2053517	g262	i0	31.4	0.807942238267148	373	245	79.1	9	266	1360	135	504	MCB0421895.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	1119	108	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31628253	31628253	PRJNA577580_P_NODE_16476_length_242_cov_0.923077_g16398_i0	PRJNA577580	16476	242	0.923077	2.23384634	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	84.3	8.39e-17	NR	MBL7554552.1	2026715	g16398	i0	78.8	1.98347107438017	80	17	99.2	0	2	241	723	802	MBL7554552.1 FHA domain-containing protein [Pseudobdellovibrionaceae bacterium]	diamond	480	84.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
32102786	32102786	PRJNA577580_P_NODE_7178_length_336_cov_1.273764_g7100_i0	PRJNA577580	7178	336	1.273764	4.27984704	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	177	3.16e-51	NR	WP_132323897.1	1513793	g7100	i0	73.1	0.964285714285714	108	29	96.4	0	325	2	330	437	WP_132323897.1 glutathione-disulfide reductase [Pseudobacteriovorax antillogorgiicola]	diamond	324	177	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
32671748	32671748	PRJNA577580_P_NODE_15100_length_247_cov_0.896552_g15022_i0	PRJNA577580	15100	247	0.896552	2.21448344	Bdellovibrio sp. 28-41-41	1970323	Bacteria	Bacteria	151	1.0499999999999999e-42	NR	OYZ24175.1	1970323	g15022	i0	93.9	0.995951417004049	82	5	99.6	0	1	246	89	170	OYZ24175.1 MAG: hypothetical protein B7Y39_01740 [Bdellovibrio sp. 28-41-41]	diamond	246	151	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. 28-41-41

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