metadata: contig_metadata: 12 rows where bioproject = "PRJEB43370", tax_kingdom = "Pseudomonadati" and tax

12 rows where bioproject = "PRJEB43370", 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
989937	989937	PRJEB43370_P_NODE_10561_length_162_cov_1.840708_g10518_i0	PRJEB43370	10561	162	1.840708	2.98194696	Bdellovibrio	958	Bacteria	Bacteria	224	2.7e-54	NTclustered	gi\|2800920897\|gb\|CP168968.1\|	959	g10518	i0	92.857	34.4938271604938	154	11	95	0	9	162	779255	779102	Bdellovibrio bacteriovorus strain Bd5 chromosome, complete genome	blastn	5588	224	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17911768	17911768	PRJEB43370_P_NODE_3615_length_231_cov_1.142857_g3572_i0	PRJEB43370	3615	231	1.142857	2.63999967	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	138	3.8099999999999996e-38	NR	MCB0370750.1	2053517	g3572	i0	85.7	1	77	10	100	1	231	1	74	149	MCB0370750.1 inositol-3-phosphate synthase [Bdellovibrionales bacterium]	diamond	231	138	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
27475869	27475869	PRJEB43370_P_NODE_8303_length_167_cov_1.245763_g8260_i0	PRJEB43370	8303	167	1.245763	2.08042421	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	52	8.77e-7	NR	MCB0369089.1	2053517	g8260	i0	75	0.574850299401198	32	8	57.5	0	97	2	1	32	MCB0369089.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	96	52	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28012825	28012825	PRJEB43370_P_NODE_8305_length_167_cov_1.228814_g8262_i0	PRJEB43370	8305	167	1.228814	2.05211938	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	118	4.809999999999999e-31	NR	MCB0368832.1	2053517	g8262	i0	94.5	0.988023952095808	55	3	98.8	0	166	2	37	91	MCB0368832.1 ThiF family adenylyltransferase [Bdellovibrionales bacterium]	diamond	165	118	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28391505	28391505	PRJEB43370_P_NODE_3226_length_243_cov_1.072165_g3183_i0	PRJEB43370	3226	243	1.072165	2.60536095	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	50.8	2.84e-5	NR	MDH5582071.1	2053517	g3183	i0	30.8	1.12345679012346	91	46	98.8	3	243	4	63	147	MDH5582071.1 cupin-like domain-containing protein [Bdellovibrionales bacterium]	diamond	273	50.8	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28549590	28549590	PRJEB43370_P_NODE_1467_length_360_cov_1.504823_g1424_i0	PRJEB43370	1467	360	1.504823	5.4173628	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	121	2.95e-29	NR	MBK9041010.1	2053517	g1424	i0	51.3	2.94166666666667	119	57	99.2	1	360	4	57	174	MBK9041010.1 bifunctional aspartate kinase/homoserine dehydrogenase I [Bdellovibrionales bacterium]	diamond	1059	121	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28637667	28637667	PRJEB43370_P_NODE_9247_length_165_cov_0.896552_g9204_i0	PRJEB43370	9247	165	0.896552	1.4793108	Bacteria	2	Bacteria	Bacteria	65.1	1.43e-10	NR	MFM6928627.1	28201	g9204	i0	52.8	14.2363636363636	53	25	96.4	0	6	164	16	68	MFM6928627.1 lipoate--protein ligase [Bdellovibrio sp.]	diamond	2349	65.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
28865088	28865088	PRJEB43370_P_NODE_3248_length_242_cov_1.347150_g3205_i0	PRJEB43370	3248	242	1.34715	3.260103	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	117	1.4599999999999999e-31	NR	MCB0369136.1	2053517	g3205	i0	68.8	0.991735537190083	80	25	99.2	0	242	3	57	136	MCB0369136.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	240	117	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29780745	29780745	PRJEB43370_P_NODE_3411_length_237_cov_1.382979_g3368_i0	PRJEB43370	3411	237	1.382979	3.27766023	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	137	6.14e-38	NR	MCB0369784.1	2053517	g3368	i0	78.5	1	79	17	100	0	237	1	36	114	MCB0369784.1 insulinase family protein [Bdellovibrionales bacterium]	diamond	237	137	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
29938814	29938814	PRJEB43370_P_NODE_5911_length_188_cov_1.294964_g5868_i0	PRJEB43370	5911	188	1.294964	2.43453232	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	93.2	2.0399999999999998e-23	NR	MCB0369464.1	2053517	g5868	i0	83.9	0.893617021276596	56	9	89.4	0	181	14	2	57	MCB0369464.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	168	93.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
31645158	31645158	PRJEB43370_P_NODE_10257_length_163_cov_0.912281_g10214_i0	PRJEB43370	10257	163	0.912281	1.48701803	Bdellovibrionales bacterium RIFOXYD1_FULL_55_31	1797404	Bacteria	Bacteria	58.2	4.43e-8	NR	OFZ83107.1	1797404	g10214	i0	56.9	0.938650306748466	51	21	93.9	1	3	155	1082	1131	OFZ83107.1 MAG: hypothetical protein A2603_05625 [Bdellovibrionales bacterium RIFOXYD1_FULL_55_31]	diamond	153	58.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium RIFOXYD1_FULL_55_31
32341560	32341560	PRJEB43370_P_NODE_6919_length_174_cov_1.664000_g6876_i0	PRJEB43370	6919	174	1.664	2.89536	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	53.9	1.63e-7	NR	MCB0369525.1	2053517	g6876	i0	52	0.862068965517241	50	24	86.2	0	151	2	12	61	MCB0369525.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	150	53.9	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);;