metadata: contig_metadata: 10 rows where bioproject = "PRJNA1240805", tax_phylum = "Nitrospirota" and tax

10 rows where bioproject = "PRJNA1240805", tax_phylum = "Nitrospirota" and tax_superkingdom = "Bacteria"

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
2900235	2900235	PRJNA1240805_P_NODE_1043_length_489_cov_2.797727_g996_i0	PRJNA1240805	1043	489	2.797727	13.68088503	Nitrospira sp.	70125	Bacteria	Bacteria	300	2.91e-100	NR	MBK8277207.1	70125	g996	i0	94.3	0.96319018404908	157	9	96.3	0	17	487	130	286	MBK8277207.1 NAD-dependent epimerase/dehydratase family protein [Nitrospira sp.]	diamond	471	300	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9277660	9277660	PRJNA1240805_P_NODE_1548_length_395_cov_2.491329_g1499_i0	PRJNA1240805	1548	395	2.491329	9.84074955	Nitrospira sp.	70125	Bacteria	Bacteria	231	4.519999999999998e-56	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g1499	i0	85.022	0.574683544303797	227	34	57	0	169	395	2669360	2669586	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	227	231	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27041971	27041971	PRJNA1240805_P_NODE_3222_length_259_cov_13.995238_g3173_i0	PRJNA1240805	3222	259	13.995238	36.24766642	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	159	1.0299999999999998e-43	NR	MBX9657915.1	2026770	g3173	i0	96.4	0.961389961389961	83	3	96.1	0	249	1	106	188	MBX9657915.1 response regulator [Nitrospiraceae bacterium]	diamond	249	159	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28747331	28747331	PRJNA1240805_P_NODE_6087_length_185_cov_4.735294_g6038_i0	PRJNA1240805	6087	185	4.735294	8.7602939	Nitrospira sp.	70125	Bacteria	Bacteria	66.2	4.34e-12	NR	HAN93880.1	70125	g6038	i0	64.2	1.08648648648649	67	16	95.7	2	4	180	47	113	HAN93880.1 hypothetical protein [Nitrospira sp.]	diamond	201	66.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28778787	28778787	PRJNA1240805_P_NODE_6407_length_181_cov_1.689394_g6358_i0	PRJNA1240805	6407	181	1.689394	3.05780314	Nitrospirota bacterium	2026887	Bacteria	Bacteria	72.4	6.38e-14	NR	MBI4682166.1	2026887	g6358	i0	57.1	6.14917127071823	63	18	89.5	2	18	179	24	86	MBI4682166.1 topoisomerase DNA-binding C4 zinc finger domain-containing protein [Nitrospirota bacterium]	diamond	1113	72.4	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30736954	30736954	PRJNA1240805_P_NODE_2934_length_274_cov_17.657778_g2885_i0	PRJNA1240805	2934	274	17.657778	48.38231172	Nitrospira lenta	1436998	Bacteria	Bacteria	165	1.67e-49	NR	WP_121990515.1	1436998	g2885	i0	97.7	0.941605839416058	86	2	94.2	0	15	272	49	134	WP_121990515.1 response regulator [Nitrospira lenta]	diamond	258	165	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
31147392	31147392	PRJNA1240805_P_NODE_8095_length_163_cov_1.947368_g8046_i0	PRJNA1240805	8095	163	1.947368	3.17420984	Nitrospira sp.	70125	Bacteria	Bacteria	118	4.02e-31	NR	MCS6285447.1	70125	g8046	i0	100	0.993865030674847	54	0	99.4	0	163	2	170	223	MCS6285447.1 hypothetical protein [Nitrospira sp.]	diamond	162	118	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31671869	31671869	PRJNA1240805_P_NODE_6957_length_174_cov_2.896000_g6908_i0	PRJNA1240805	6957	174	2.896	5.03904	Pseudomonadati	3379134	Bacteria	Bacteria	56.6	1.79e-7	NR	HEY7130390.1	70125	g6908	i0	55.2	3.91379310344828	58	26	100	0	174	1	19	76	HEY7130390.1 AMP-binding protein [Nitrospira sp.]	diamond	681	56.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32318522	32318522	PRJNA1240805_P_NODE_6759_length_176_cov_3.637795_g6710_i0	PRJNA1240805	6759	176	3.637795	6.4025192	Nitrospira sp.	70125	Bacteria	Bacteria	45.1	0.00231	NR	MCI0526054.1	70125	g6710	i0	43.1	1.72159090909091	58	28	98.9	1	1	174	325	377	MCI0526054.1 UvrD-helicase domain-containing protein [Nitrospira sp.]	diamond	303	45.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32413239	32413239	PRJNA1240805_P_NODE_6059_length_186_cov_1.489051_g6010_i0	PRJNA1240805	6059	186	1.489051	2.76963486	Nitrospira sp.	70125	Bacteria	Bacteria	45.8	0.00136	NR	MDO9119191.1	70125	g6010	i0	95.2	0.67741935483871	21	1	33.9	0	2	64	290	310	MDO9119191.1 NAD-dependent epimerase/dehydratase family protein [Nitrospira sp.]	diamond	126	45.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.

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);;