metadata: contig_metadata: 14 rows where bioproject = "PRJEB49404", tax_kingdom = "Pseudomonadati" and tax

14 rows where bioproject = "PRJEB49404", 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
11594519	11594519	PRJEB49404_P_NODE_615090_length_156_cov_2.410256_g601289_i0	PRJEB49404	615090	156	2.410256	3.75999936	Nitrospira japonica	1325564	Bacteria	Bacteria	113	5.8100000000000006e-21	NTclustered	gi\|1167499077\|emb\|LT828648.1\|	1325564	g601289	i0	81.618	89.0320512820513	136	25	87	0	1	136	315954	316089	Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I	blastn	13889	113	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira japonica
16687778	16687778	PRJEB49404_P_NODE_508594_length_179_cov_2.814286_g494793_i0	PRJEB49404	508594	179	2.814286	5.03757194	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	105	5.0399999999999995e-25	NR	RPH74917.1	2026770	g494793	i0	79.3	0.972067039106145	58	12	97.2	0	174	1	261	318	RPH74917.1 MAG: glycogen debranching enzyme, partial [Nitrospiraceae bacterium]	diamond	174	105	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
17962994	17962994	PRJEB49404_P_NODE_515215_length_178_cov_1.215827_g501414_i0	PRJEB49404	515215	178	1.215827	2.16417206	Bacteria	2	Bacteria	Bacteria	100	7.209999999999999e-23	NR	MBS0156140.1	70125	g501414	i0	72.9	2.98314606741573	59	16	99.4	0	2	178	3290	3348	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	531	100	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27854780	27854780	PRJEB49404_P_NODE_407445_length_211_cov_1.470930_g393644_i0	PRJEB49404	407445	211	1.47093	3.1036623	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	77.4	3.91e-15	NR	MSQ77581.1	2026770	g393644	i0	63.8	4.90521327014218	69	25	98.1	0	3	209	148	216	MSQ77581.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	1035	77.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28448206	28448206	PRJEB49404_P_NODE_172506_length_391_cov_1.676136_g158713_i0	PRJEB49404	172506	391	1.676136	6.55369176	Pseudomonadati	3379134	Bacteria	Bacteria	70.1	4.96e-11	NR	EAY56129.1	419542	g158713	i0	40.6	3.1381074168798	106	58	80.6	2	337	23	10	111	EAY56129.1 MAG: probable IcmO protein [Leptospirillum rubarum]	diamond	1227	70.5	0.994326241134752	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum rubarum
28517958	28517958	PRJEB49404_P_NODE_499647_length_182_cov_1.391608_g485846_i0	PRJEB49404	499647	182	1.391608	2.53272656	Nitrospira sp.	70125	Bacteria	Bacteria	41.6	0.0437	NR	MBS0156140.1	70125	g485846	i0	41.2	0.840659340659341	51	28	84.1	1	29	181	2277	2325	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	153	41.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29086362	29086362	PRJEB49404_P_NODE_560808_length_167_cov_1.914062_g547007_i0	PRJEB49404	560808	167	1.914062	3.19648354	Nitrospira sp.	70125	Bacteria	Bacteria	64.3	3.26e-10	NR	MBS0156140.1	70125	g547007	i0	66	0.952095808383233	53	18	95.2	0	165	7	1438	1490	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	159	64.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29370463	29370463	PRJEB49404_P_NODE_414569_length_208_cov_2.094675_g400768_i0	PRJEB49404	414569	208	2.094675	4.356924	Nitrospira sp.	70125	Bacteria	Bacteria	59.7	2.36e-8	NR	HNP82742.1	70125	g400768	i0	53.4	1.65865384615385	58	26	82.2	1	176	6	3	60	HNP82742.1 hypothetical protein [Nitrospira sp.]	diamond	345	59.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29805602	29805602	PRJEB49404_P_NODE_495751_length_183_cov_1.423611_g481950_i0	PRJEB49404	495751	183	1.423611	2.60520813	Pseudomonadati	3379134	Bacteria	Bacteria	67	1.5e-12	NR	WP_213043643.1	1234	g481950	i0	58.2	3.32786885245902	55	23	90.2	0	19	183	1	55	WP_213043643.1 MULTISPECIES: hypothetical protein [Nitrospira]	diamond	609	67	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira
30507496	30507496	PRJEB49404_P_NODE_489113_length_185_cov_1.123288_g475312_i0	PRJEB49404	489113	185	1.123288	2.0780828	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	52.8	4.9099999999999996e-06	NR	HET9395990.1	2026770	g475312	i0	81.5	1.31351351351351	27	5	43.8	0	81	1	1	27	HET9395990.1 PAS domain-containing protein [Nitrospiraceae bacterium]	diamond	243	52.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
31455674	31455674	PRJEB49404_P_NODE_462776_length_192_cov_2.104575_g448975_i0	PRJEB49404	462776	192	2.104575	4.040784	Nitrospira sp.	70125	Bacteria	Bacteria	98.2	5.82e-22	NR	MBS0156140.1	70125	g448975	i0	75.8	0.96875	62	15	96.9	0	7	192	790	851	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	186	98.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32594508	32594508	PRJEB49404_P_NODE_453120_length_195_cov_1.948718_g439319_i0	PRJEB49404	453120	195	1.948718	3.8000001	Candidatus Manganitrophaceae bacterium	2932367	Bacteria	Bacteria	43.1	0.0125	NR	TAK00757.1	2932367	g439319	i0	47.1	0.784615384615385	51	22	78.5	1	4	156	168	213	TAK00757.1 MAG: DUF998 domain-containing protein, partial [Candidatus Manganitrophaceae bacterium]	diamond	153	43.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Candidatus Troglogloeales	Candidatus Manganitrophaceae		Candidatus Manganitrophaceae bacterium
32751805	32751805	PRJEB49404_P_NODE_434600_length_201_cov_1.975309_g420799_i0	PRJEB49404	434600	201	1.975309	3.97037109	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	87.4	1.15e-18	NR	HET7058514.1	2026770	g420799	i0	70.8	0.970149253731343	65	19	97	0	2	196	69	133	HET7058514.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	195	87.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
32839468	32839468	PRJEB49404_P_NODE_650900_length_150_cov_1.477477_g637099_i0	PRJEB49404	650900	150	1.477477	2.2162155	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	1.38e-13	NR	MBS0156140.1	70125	g637099	i0	70.8	1.94	48	14	96	0	148	5	1160	1207	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	291	73.6	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);;