metadata: contig_metadata: 5 rows where bioproject = "PRJNA436017", tax_kingdom = "Pseudomonadati" and tax

5 rows where bioproject = "PRJNA436017", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

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
4257644	4257644	PRJNA436017_P_NODE_14504_length_218_cov_348.779006_g14206_i0	PRJNA436017	14504	218	348.779006	760.33823308	Candidatus Manganitrophus sp.	2927580	Bacteria	Bacteria	237	4.96e-58	NTclustered	gi\|2449729286\|gb\|CP114553.1\|	2927580	g14206	i0	86.574	269.110091743119	216	27	99	2	1	215	491452	491666	MAG: Candidatus Manganitrophus sp. isolate GAC1 chromosome, complete genome	blastn	58666	237	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Candidatus Troglogloeales	Candidatus Manganitrophaceae	Candidatus Manganitrophus	Candidatus Manganitrophus sp.
23382782	23382782	PRJNA436017_P_NODE_10879_length_260_cov_1.748879_g10581_i0	PRJNA436017	10879	260	1.748879	4.5470854	Nitrospira sp.	70125	Bacteria	Bacteria	75	5.06e-9	NTclustered	gi\|2511635996\|gb\|CP126122.1\|	70125	g10581	i0	86.957	49.9653846153846	69	6	26	3	60	126	751601	751534	MAG: Nitrospira sp. isolate bin_005 chromosome	blastn	12991	75	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27692776	27692776	PRJNA436017_P_NODE_20684_length_180_cov_1.167832_g20386_i0	PRJNA436017	20684	180	1.167832	2.1020976	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	113	1.2900000000000002e-27	NR	HNC85192.1	70125	g20386	i0	89.7	6.76666666666667	58	6	96.7	0	179	6	185	242	HNC85192.1 Fic family protein [Nitrospira sp.]	diamond	1218	113	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30218570	30218570	PRJNA436017_P_NODE_21652_length_176_cov_1.086331_g21354_i0	PRJNA436017	21652	176	1.086331	1.91194256	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	51.6	1.08e-5	NR	WP_038505962.1	178606	g21354	i0	54.9	4.27840909090909	51	23	86.9	0	23	175	2	52	WP_038505962.1 sensor domain-containing diguanylate cyclase [Leptospirillum ferriphilum]	diamond	753	51.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferriphilum
31767355	31767355	PRJNA436017_P_NODE_2617_length_583_cov_1.714286_g2357_i0	PRJNA436017	2617	583	1.714286	9.99428738	Pseudomonadati	3379134	Bacteria	Bacteria	189	2.72e-57	NR	MBF0317489.1	2026887	g2357	i0	51.1	2.75814751286449	180	86	92.6	2	581	42	14	191	MBF0317489.1 NAD(P)H-dependent oxidoreductase [Nitrospirota bacterium]	diamond	1608	190	0.994736842105263	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota 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);;