metadata: contig_metadata: 10 rows where bioproject = "PRJNA169559", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA169559", 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
364777	364777	PRJNA169559_P_NODE_10001_length_536_cov_5.086785_g8261_i0	PRJNA169559	10001	536	5.086785	27.2651676	Peredibacter starrii	28202	Bacteria	Bacteria	806	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g8261	i0	93.843	74.8731343283582	536	31	99	2	2	536	511963	512497	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	40132	806	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10568892	10568892	PRJNA169559_P_NODE_11529_length_496_cov_2.751606_g9695_i0	PRJNA169559	11529	496	2.751606	13.64796576	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	577	6.459999999999999e-160	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g9695	i0	87.867	91.5483870967742	511	34	100	3	1	496	3446808	3447305	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	45408	577	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
18906265	18906265	PRJNA169559_P_NODE_22755_length_331_cov_7.258278_g20685_i0	PRJNA169559	22755	331	7.258278	24.02490018	Peredibacter	263370	Bacteria	Bacteria	582	8.939999999999999e-162	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g20685	i0	98.485	362.888217522659	330	5	99	0	1	330	511177	511506	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	120116	582	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
22041590	22041590	PRJNA169559_P_NODE_24638_length_306_cov_28.061372_g22562_i0	PRJNA169559	24638	306	28.061372	85.86779832	Peredibacter starrii	28202	Bacteria	Bacteria	507	5.07e-139	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g22562	i0	96.711	227.813725490196	304	10	99	0	3	306	511479	511782	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	69711	507	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
23317193	23317193	PRJNA169559_P_NODE_42099_length_229_cov_128.770000_g40022_i0	PRJNA169559	42099	229	128.77	294.8833	Peredibacter sp. HCB2-198	3383025	Bacteria	Bacteria	379	8.249999999999999e-101	NTclustered	gi\|2867657404\|gb\|CP174607.1\|	3383025	g40022	i0	98.598	215.362445414847	214	3	93	0	1	214	1293347	1293560	Peredibacter sp. HCB2-198 chromosome, complete genome	blastn	49318	379	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter sp. HCB2-198
24006803	24006803	PRJNA169559_P_NODE_47619_length_174_cov_2.482759_g45542_i0	PRJNA169559	47619	174	2.482759	4.32000066	Bacteriovorax	146784	Bacteria	Bacteria	202	1.3699999999999998e-47	NTclustered	gi\|1700689994\|gb\|CP030035.1\|	960	g45542	i0	87.113	12.1436781609195	194	5	100	7	1	174	1660562	1660369	Bacteriovorax stolpii strain AC01 chromosome, complete genome	blastn	2113	202	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax stolpii
30073789	30073789	PRJNA169559_P_NODE_48892_length_152_cov_1.195122_g46815_i0	PRJNA169559	48892	152	1.195122	1.81658544	Silvanigrellales bacterium	2767476	Bacteria	Bacteria	73.2	1.69e-13	NR	MCA2960788.1	2767476	g46815	i0	76	3.90789473684211	50	11	98.7	1	151	2	213	261	MCA2960788.1 S-methyl-5-thioribose-1-phosphate isomerase [Silvanigrellales bacterium]	diamond	594	73.2	1	Bacteria	Pseudomonadati	Bdellovibrionota	Oligoflexia	Silvanigrellales			Silvanigrellales bacterium
30421843	30421843	PRJNA169559_P_NODE_11153_length_504_cov_2.749474_g9334_i0	PRJNA169559	11153	504	2.749474	13.85734896	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	90.5	1.74e-19	NR	HVJ64814.1	3034175	g9334	i0	35.4	2.54166666666667	144	84	82.7	3	6	422	20	159	HVJ64814.1 GyrI-like domain-containing protein [Bdellovibrionota bacterium]	diamond	1281	90.5	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
30800504	30800504	PRJNA169559_P_NODE_36214_length_244_cov_2.083721_g34137_i0	PRJNA169559	36214	244	2.083721	5.08427924	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	48.1	4.54e-4	NR	MBY0414320.1	2053517	g34137	i0	47.8	1.13114754098361	46	22	56.6	1	10	147	264	307	MBY0414320.1 NAD(P)-dependent alcohol dehydrogenase [Bdellovibrionales bacterium]	diamond	276	48.1	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
32854939	32854939	PRJNA169559_P_NODE_44740_length_218_cov_2.333333_g42663_i0	PRJNA169559	44740	218	2.333333	5.08666594	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	122	7.12e-31	NR	MCB0368368.1	2053517	g42663	i0	86.1	0.990825688073395	72	8	99.1	1	2	217	305	374	MCB0368368.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	216	122	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);;