metadata: contig_metadata: 15 rows where bioproject = "PRJNA674308", tax_kingdom = "Pseudomonadati" and tax

15 rows where bioproject = "PRJNA674308", 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
1166440	1166440	PRJNA674308_P_NODE_12541_length_271_cov_1.117117_g12306_i0	PRJNA674308	12541	271	1.117117	3.02738707	Bdellovibrio	958	Bacteria	Bacteria	405	1.66e-108	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g12306	i0	98.268	74.0036900369004	231	4	85	0	1	231	779328	779558	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	20055	405	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
23597627	23597627	PRJNA674308_P_NODE_36319_length_169_cov_0.866667_g36084_i0	PRJNA674308	36319	169	0.866667	1.46466723	Bdellovibrio sp. qaytius	1916293	Bacteria	Bacteria	246	6.03e-61	NTclustered	gi\|1552089877\|gb\|CP025734.1\|	1916293	g36084	i0	92.899	161.869822485207	169	12	100	0	1	169	666301	666469	Bdellovibrio sp. qaytius chromosome, complete genome	blastn	27356	246	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. qaytius
26669952	26669952	PRJNA674308_P_NODE_1201_length_911_cov_13.966357_g1031_i0	PRJNA674308	1201	911	13.966357	127.23351227	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	375	3.9499999999999996e-129	NR	MBX9767865.1	2053517	g1031	i0	90.5	0.661909989023052	201	19	66.2	0	669	67	1	201	MBX9767865.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	603	375	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27429679	27429679	PRJNA674308_P_NODE_2323_length_646_cov_2.281407_g2103_i0	PRJNA674308	2323	646	2.281407	14.73788922	Halobacteriovorax sp.	2020862	Bacteria	Bacteria	47.4	0.00519	NR	MBK25694.1	2020862	g2103	i0	33.3	0.404024767801858	87	57	40.4	1	331	71	2	87	MBK25694.1 hypothetical protein [Halobacteriovorax sp.]	diamond	261	47.4	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax sp.
28029448	28029448	PRJNA674308_P_NODE_19285_length_223_cov_1.712644_g19050_i0	PRJNA674308	19285	223	1.712644	3.81919612	Bacteriovoracaceae bacterium	2081706	Bacteria	Bacteria	43.5	0.0154	NR	MBT3983607.1	2081706	g19050	i0	34.3	0.901345291479821	67	40	84.8	2	6	194	1247	1313	MBT3983607.1 hypothetical protein [Bacteriovoracaceae bacterium]	diamond	201	43.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae		Bacteriovoracaceae bacterium
29197738	29197738	PRJNA674308_P_NODE_38189_length_168_cov_0.873950_g37954_i0	PRJNA674308	38189	168	0.87395	1.468236	Bdellovibrio sp.	28201	Bacteria	Bacteria	106	5.61e-25	NR	NUN05725.1	28201	g37954	i0	94.5	0.982142857142857	55	3	98.2	0	167	3	106	160	NUN05725.1 hypothetical protein [Bdellovibrio sp.]	diamond	165	106	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
29260508	29260508	PRJNA674308_P_NODE_21529_length_213_cov_1.585366_g21294_i0	PRJNA674308	21529	213	1.585366	3.37682958	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	102	5.33e-26	NR	MBX9702949.1	2654442	g21294	i0	80.9	0.957746478873239	68	12	95.8	1	3	206	40	106	MBX9702949.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	204	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
29967385	29967385	PRJNA674308_P_NODE_32691_length_177_cov_1.500000_g32456_i0	PRJNA674308	32691	177	1.5	2.655	Bacteria	2	Bacteria	Bacteria	60.1	4.96e-10	NR	PWU12825.1	28201	g32456	i0	45.6	25.8983050847458	57	31	96.6	0	172	2	27	83	PWU12825.1 MAG: 30S ribosomal protein S15 [Bdellovibrio sp.]	diamond	4584	60.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
29987020	29987020	PRJNA674308_P_NODE_29071_length_187_cov_1.507246_g28836_i0	PRJNA674308	29071	187	1.507246	2.81855002	Pseudobacteriovorax antillogorgiicola	1513793	Bacteria	Bacteria	92.8	4.12e-20	NR	WP_132322376.1	1513793	g28836	i0	71	5.96791443850267	62	17	99.5	1	187	2	247	307	WP_132322376.1 NADPH-dependent 2,4-dienoyl-CoA reductase [Pseudobacteriovorax antillogorgiicola]	diamond	1116	92.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Oligoflexales	Pseudobacteriovoracaceae	Pseudobacteriovorax	Pseudobacteriovorax antillogorgiicola
30555544	30555544	PRJNA674308_P_NODE_9373_length_311_cov_1.316794_g9138_i0	PRJNA674308	9373	311	1.316794	4.09522934	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	83.6	7.87e-19	NR	MBX9703359.1	2654442	g9138	i0	62.7	0.491961414790997	51	19	49.2	0	253	101	1	51	MBX9703359.1 hypothetical protein [Silvanigrellaceae bacterium]	diamond	153	83.6	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
30713646	30713646	PRJNA674308_P_NODE_35794_length_169_cov_1.300000_g35559_i0	PRJNA674308	35794	169	1.3	2.197	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	60.8	5.61e-9	NR	MFN9065847.1	2053517	g35559	i0	51.9	1.91715976331361	54	26	95.9	0	168	7	37	90	MFN9065847.1 PAS domain-containing protein [Bdellovibrionales bacterium]	diamond	324	60.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31883373	31883373	PRJNA674308_P_NODE_31717_length_180_cov_1.091603_g31482_i0	PRJNA674308	31717	180	1.091603	1.9648854	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	43.5	0.00839	NR	MBY0415398.1	2053517	g31482	i0	42.4	1.88333333333333	59	34	98.3	0	2	178	217	275	MBY0415398.1 MFS transporter [Bdellovibrionales bacterium]	diamond	339	43.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32326829	32326829	PRJNA674308_P_NODE_18899_length_225_cov_1.602273_g18664_i0	PRJNA674308	18899	225	1.602273	3.60511425	Silvanigrellaceae bacterium	2654442	Bacteria	Bacteria	131	8.92e-38	NR	MBX9704131.1	2654442	g18664	i0	93.9	0.88	66	4	88	0	28	225	1	66	MBX9704131.1 DUF4442 domain-containing protein [Silvanigrellaceae bacterium]	diamond	198	131	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales	Silvanigrellaceae		Silvanigrellaceae bacterium
32642185	32642185	PRJNA674308_P_NODE_35220_length_170_cov_2.090909_g34985_i0	PRJNA674308	35220	170	2.090909	3.5545453	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	70.1	2.12e-13	NR	MEO5970318.1	3034169	g34985	i0	67.9	1.95882352941176	56	17	97.1	1	1	165	67	122	MEO5970318.1 hotdog fold thioesterase [Bdellovibrionia bacterium]	diamond	333	70.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia bacterium
32831405	32831405	PRJNA674308_P_NODE_2360_length_640_cov_1.923858_g2138_i0	PRJNA674308	2360	640	1.923858	12.3126912	Bdellovibrionia bacterium	3034169	Bacteria	Bacteria	192	1.7899999999999998e-56	NR	MEO5969990.1	3034169	g2138	i0	53.6	4.5609375	181	74	80.2	2	513	1	1	181	MEO5969990.1 NAD(P)H-quinone oxidoreductase [Bdellovibrionia bacterium]	diamond	2919	192	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia				Bdellovibrionia 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);;