metadata: contig_metadata: 9 rows where bioproject = "PRJNA565778", tax_kingdom = "Pseudomonadati" and tax

9 rows where bioproject = "PRJNA565778", tax_kingdom = "Pseudomonadati" and tax_phylum = "Spirochaetota"

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
5662047	5662047	PRJNA565778_S_NODE_27845_length_209_cov_3.965116_g27549_i0	PRJNA565778	27845	209	3.965116	8.28709244	Brachyspira murdochii	84378	Bacteria	Bacteria	62.1	3.04e-5	NTclustered	gi\|296016874\|gb\|CP001959.1\|	526224	g27549	i0	91.111	0.416267942583732	45	4	22	0	74	118	3163465	3163421	Brachyspira murdochii DSM 12563, complete genome	blastn	87	62.1	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Brachyspirales	Brachyspiraceae	Brachyspira	Brachyspira murdochii
27016134	27016134	PRJNA565778_S_NODE_9502_length_352_cov_5.053968_g9206_i0	PRJNA565778	9502	352	5.053968	17.78996736	Spirochaetota bacterium	2202144	Bacteria	Bacteria	118	1.4199999999999998e-31	NR	TXG86438.1	2202144	g9206	i0	98.2	0.46875	55	1	46.9	0	352	188	68	122	TXG86438.1 MAG: hypothetical protein E6R13_00450 [Spirochaetota bacterium]	diamond	165	118	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
27441062	27441062	PRJNA565778_S_NODE_14123_length_293_cov_1.828125_g13827_i0	PRJNA565778	14123	293	1.828125	5.35640625	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0402	NR	WP_014803165.1	29510	g13827	i0	60	0.747440273037543	35	14	35.8	0	15	119	107	141	WP_014803165.1 GatB/YqeY domain-containing protein [Turneriella parva]	diamond	219	42.7	0.992974238875878	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Turneriella	Turneriella parva
29289952	29289952	PRJNA565778_S_NODE_37549_length_176_cov_9.661871_g37253_i0	PRJNA565778	37549	176	9.661871	17.00489296	Spirochaetota bacterium	2202144	Bacteria	Bacteria	89	2.6e-21	NR	TXG86437.1	2202144	g37253	i0	89.1	0.784090909090909	46	5	78.4	0	139	2	54	99	TXG86437.1 MAG: hypothetical protein E6R13_00445 [Spirochaetota bacterium]	diamond	138	89	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
29858261	29858261	PRJNA565778_S_NODE_10031_length_343_cov_3.777778_g9735_i0	PRJNA565778	10031	343	3.777778	12.95777854	Leptospira sp.	178	Bacteria	Bacteria	184	4.559999999999999e-52	NR	NCN09903.1	178	g9735	i0	90.1	0.883381924198251	101	7	88.3	1	35	337	576	673	NCN09903.1 hypothetical protein [Leptospira sp.]	diamond	303	184	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae	Leptospira	Leptospira sp.
31027533	31027533	PRJNA565778_S_NODE_28115_length_208_cov_2.672515_g27819_i0	PRJNA565778	28115	208	2.672515	5.5588312	Spirochaetota bacterium	2202144	Bacteria	Bacteria	114	1.2200000000000002e-27	NR	TXG85034.1	2202144	g27819	i0	91.4	0.836538461538462	58	5	83.7	0	206	33	119	176	TXG85034.1 MAG: hypothetical protein E6R13_02405 [Spirochaetota bacterium]	diamond	174	114	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31533453	31533453	PRJNA565778_S_NODE_23896_length_226_cov_4.153439_g23600_i0	PRJNA565778	23896	226	4.153439	9.38677214	Spirochaetota bacterium	2202144	Bacteria	Bacteria	131	2.13e-33	NR	TXG81818.1	2202144	g23600	i0	96.9	0.849557522123894	64	2	85	0	33	224	565	628	TXG81818.1 MAG: hypothetical protein E6R13_05795 [Spirochaetota bacterium]	diamond	192	131	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
31786072	31786072	PRJNA565778_S_NODE_6997_length_402_cov_146.586301_g6719_i0	PRJNA565778	6997	402	146.586301	589.27693002	Spirochaetota bacterium	2202144	Bacteria	Bacteria	122	8.03e-31	NR	TXG86121.1	2202144	g6719	i0	53.5	0.850746268656716	114	53	85.1	0	344	3	92	205	TXG86121.1 MAG: hypothetical protein E6R13_01155 [Spirochaetota bacterium]	diamond	342	122	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota bacterium
32387407	32387407	PRJNA565778_S_NODE_6859_length_406_cov_5.487805_g6582_i0	PRJNA565778	6859	406	5.487805	22.2804883	Spirochaetota bacterium	2202144	Bacteria	Bacteria	219	6.57e-71	NR	TXG85442.1	2202144	g6582	i0	97.2	0.798029556650246	108	3	79.8	0	51	374	1	108	TXG85442.1 MAG: hypothetical protein E6R13_02105 [Spirochaetota bacterium]	diamond	324	219	1	Bacteria	Pseudomonadati	Spirochaetota					Spirochaetota 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);;