metadata: contig_metadata: 28 rows where bioproject = "PRJNA488043", tax_phylum = "Nitrospirota" and tax

28 rows where bioproject = "PRJNA488043", 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
450057	450057	PRJNA488043_P_NODE_6781_length_479_cov_2.435556_g4688_i0	PRJNA488043	6781	479	2.435556	11.66631324	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	298	5.4299999999999997e-76	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g4688	i0	86.121	17.1711899791232	281	33	86	5	202	479	3399332	3399055	Nitrospira sp. KM1 DNA, complete genome	blastn	8225	298	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
7475927	7475927	PRJNA488043_P_NODE_20626_length_165_cov_4.529412_g18384_i0	PRJNA488043	20626	165	4.529412	7.4735298	Nitrospira	1234	Bacteria	Bacteria	231	1.65e-56	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g18384	i0	93.038	82.9757575757576	158	11	96	0	6	163	2684490	2684647	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	13691	231	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9377836	9377836	PRJNA488043_P_NODE_9408_length_359_cov_12.272727_g7178_i0	PRJNA488043	9408	359	12.272727	44.05908993	Nitrospira moscoviensis	42253	Bacteria	Bacteria	514	3.61e-141	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g7178	i0	92.5	162.16991643454	360	25	100	2	1	359	1277242	1277600	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	58219	514	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
14478534	14478534	PRJNA488043_P_NODE_5352_length_568_cov_8.155844_g3405_i0	PRJNA488043	5352	568	8.155844	46.32519392	Nitrospira sp.	70125	Bacteria	Bacteria	948	0	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3405	i0	96.147	131.140845070423	571	19	100	1	1	568	2094551	2093981	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	74488	948	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
15752660	15752660	PRJNA488043_P_NODE_6873_length_473_cov_9.315315_g4771_i0	PRJNA488043	6873	473	9.315315	44.06143995	Nitrospira moscoviensis	42253	Bacteria	Bacteria	488	2.9599999999999996e-133	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g4771	i0	89.086	142.042283298097	394	41	83	2	81	473	1277634	1277242	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	67186	488	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
16400432	16400432	PRJNA488043_P_NODE_13473_length_252_cov_2.636771_g11231_i0	PRJNA488043	13473	252	2.636771	6.64466292	Nitrospira	1234	Bacteria	Bacteria	294	3.44e-75	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g11231	i0	98.788	182.031746031746	165	2	65	0	1	165	3066337	3066501	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	45872	294	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17675569	17675569	PRJNA488043_P_NODE_18734_length_184_cov_39.070968_g16492_i0	PRJNA488043	18734	184	39.070968	71.89058112	Nitrospira	1234	Bacteria	Bacteria	316	5.04e-82	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g16492	i0	100	92.6684782608696	171	0	93	0	14	184	2686944	2687114	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	17051	316	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17675575	17675575	PRJNA488043_P_NODE_19454_length_177_cov_3.675676_g17212_i0	PRJNA488043	19454	177	3.675676	6.50594652	Nitrospira	1234	Bacteria	Bacteria	230	6.439999999999999e-56	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g17212	i0	90.395	24.045197740113	177	14	99	3	1	175	883572	883747	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	4256	230	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18949528	18949528	PRJNA488043_P_NODE_7475_length_441_cov_11.781553_g5325_i0	PRJNA488043	7475	441	11.781553	51.95664873	Nitrospira	1234	Bacteria	Bacteria	671	0	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g5325	i0	94.104	128.360544217687	441	26	100	0	1	441	3063201	3062761	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	56607	671	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19575552	19575552	PRJNA488043_P_NODE_11996_length_283_cov_1.535433_g9755_i0	PRJNA488043	11996	283	1.535433	4.34527539	Nitrospira sp.	70125	Bacteria	Bacteria	204	6.809999999999998e-48	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g9755	i0	90.909	5.46643109540636	154	11	54	3	131	283	732626	732475	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	1547	204	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22126223	22126223	PRJNA488043_P_NODE_10838_length_313_cov_4.232394_g8597_i0	PRJNA488043	10838	313	4.232394	13.24739322	Nitrospira sp.	70125	Bacteria	Bacteria	538	1.8399999999999993e-148	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g8597	i0	97.756	17.7635782747604	312	7	99	0	2	313	2738163	2737852	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	5560	538	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23402264	23402264	PRJNA488043_P_NODE_5099_length_589_cov_5.680357_g3186_i0	PRJNA488043	5099	589	5.680357	33.45730273	Nitrospira sp.	70125	Bacteria	Bacteria	710	0	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g3186	i0	96.092	382.449915110357	435	17	98	0	1	435	2683847	2683413	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	225263	710	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26696386	26696386	PRJNA488043_P_NODE_15401_length_222_cov_2.031088_g13159_i0	PRJNA488043	15401	222	2.031088	4.50901536	Nitrospira sp.	70125	Bacteria	Bacteria	76.3	1.34e-14	NR	MBK7421585.1	70125	g13159	i0	100	1.44594594594595	36	0	48.6	0	115	222	1	36	MBK7421585.1 hypothetical protein [Nitrospira sp.]	diamond	321	76.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26791593	26791593	PRJNA488043_P_NODE_13721_length_248_cov_2.319635_g11479_i0	PRJNA488043	13721	248	2.319635	5.7526948	Nitrospira sp.	70125	Bacteria	Bacteria	96.7	1.94e-21	NR	HMV57845.1	70125	g11479	i0	57.3	0.991935483870968	82	35	99.2	0	2	247	71	152	HMV57845.1 Clp protease ClpP [Nitrospira sp.]	diamond	246	96.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26823328	26823328	PRJNA488043_P_NODE_7461_length_442_cov_2.944310_g5312_i0	PRJNA488043	7461	442	2.94431	13.0138502	Nitrospira sp.	70125	Bacteria	Bacteria	229	8.77e-70	NR	HMV57842.1	70125	g5312	i0	72.1	0.997737556561086	147	41	99.8	0	441	1	103	249	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	441	229	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26934169	26934169	PRJNA488043_P_NODE_21122_length_161_cov_2.515152_g18880_i0	PRJNA488043	21122	161	2.515152	4.04939472	Pseudomonadati	3379134	Bacteria	Bacteria	60.5	6.62e-9	NR	HMV57851.1	70125	g18880	i0	51.9	1.93788819875776	52	25	96.9	0	158	3	118	169	HMV57851.1 DUF1834 family protein [Nitrospira sp.]	diamond	312	60.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27424213	27424213	PRJNA488043_P_NODE_18803_length_184_cov_1.709677_g16561_i0	PRJNA488043	18803	184	1.709677	3.14580568	Nitrospira sp.	70125	Bacteria	Bacteria	125	1.6599999999999998e-31	NR	MBK8380046.1	70125	g16561	i0	100	0.978260869565217	60	0	97.8	0	182	3	650	709	MBK8380046.1 hypothetical protein [Nitrospira sp.]	diamond	180	125	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27550166	27550166	PRJNA488043_P_NODE_6144_length_516_cov_4.351129_g4116_i0	PRJNA488043	6144	516	4.351129	22.45182564	Nitrospira sp.	70125	Bacteria	Bacteria	107	1.8399999999999998e-23	NR	HMV57842.1	70125	g4116	i0	63.9	0.418604651162791	72	26	41.9	0	296	511	7	78	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	216	107	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27834348	27834348	PRJNA488043_P_NODE_10784_length_315_cov_2.241259_g8543_i0	PRJNA488043	10784	315	2.241259	7.05996585	Nitrospira sp.	70125	Bacteria	Bacteria	63.2	4.6e-9	NR	HMV57846.1	70125	g8543	i0	37.1	0.923809523809524	97	59	92.4	1	4	294	174	268	HMV57846.1 hypothetical protein [Nitrospira sp.]	diamond	291	63.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28150332	28150332	PRJNA488043_P_NODE_13145_length_258_cov_2.716157_g10904_i0	PRJNA488043	13145	258	2.716157	7.00768506	Nitrospira sp.	70125	Bacteria	Bacteria	88.2	2.63e-20	NR	HMV57844.1	70125	g10904	i0	69.4	0.720930232558139	62	19	72.1	0	3	188	52	113	HMV57844.1 hypothetical protein [Nitrospira sp.]	diamond	186	88.2	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30013257	30013257	PRJNA488043_P_NODE_1011_length_1800_cov_2.656691_g352_i0	PRJNA488043	1011	1800	2.656691	47.820438	Nitrospira sp.	70125	Bacteria	Bacteria	314	2.9399999999999986e-96	NR	HMV57842.1	70125	g352	i0	79	0.31	186	37	30.7	1	1	552	331	516	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	558	314	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30060625	30060625	PRJNA488043_P_NODE_14631_length_233_cov_2.441176_g12389_i0	PRJNA488043	14631	233	2.441176	5.68794008	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	2.09e-10	NR	HND02873.1	70125	g12389	i0	43.7	1.89270386266094	71	40	91.4	0	231	19	94	164	HND02873.1 hypothetical protein [Nitrospira sp.]	diamond	441	63.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30297989	30297989	PRJNA488043_P_NODE_4172_length_681_cov_3.142638_g2423_i0	PRJNA488043	4172	681	3.142638	21.40136478	Nitrospira sp.	70125	Bacteria	Bacteria	82	4.82e-15	NR	HNN43760.1	70125	g2423	i0	41	0.92511013215859	105	60	46.3	1	384	70	27	129	HNN43760.1 replication protein P [Nitrospira sp.]	diamond	630	82	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31276890	31276890	PRJNA488043_P_NODE_10255_length_332_cov_2.155116_g8014_i0	PRJNA488043	10255	332	2.155116	7.15498512	Nitrospira sp.	70125	Bacteria	Bacteria	62.4	1.03e-8	NR	HMV57846.1	70125	g8014	i0	37.1	0.876506024096386	97	59	87.7	1	4	294	174	268	HMV57846.1 hypothetical protein [Nitrospira sp.]	diamond	291	62.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31846274	31846274	PRJNA488043_P_NODE_8237_length_404_cov_2.157333_g6039_i0	PRJNA488043	8237	404	2.157333	8.71562532	Nitrospira sp.	70125	Bacteria	Bacteria	241	1.2299999999999999e-74	NR	HMV57842.1	70125	g6039	i0	82.8	0.995049504950495	134	23	99.5	0	404	3	331	464	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	402	241	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32321300	32321300	PRJNA488043_P_NODE_7299_length_450_cov_2.263658_g5158_i0	PRJNA488043	7299	450	2.263658	10.186461	Nitrospira sp.	70125	Bacteria	Bacteria	281	6.18e-90	NR	HMV57842.1	70125	g5158	i0	81.9	0.993333333333333	149	27	99.3	0	447	1	271	419	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	447	281	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32731585	32731585	PRJNA488043_P_NODE_16520_length_208_cov_1.608939_g14278_i0	PRJNA488043	16520	208	1.608939	3.34659312	Nitrospira sp.	70125	Bacteria	Bacteria	75.5	1.76e-15	NR	MBK7421579.1	70125	g14278	i0	100	0.548076923076923	38	0	54.8	0	207	94	91	128	MBK7421579.1 hypothetical protein [Nitrospira sp.]	diamond	114	75.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32857414	32857414	PRJNA488043_P_NODE_1020_length_1774_cov_2.721490_g352_i1	PRJNA488043	1020	1774	2.72149	48.2792326	Nitrospira sp.	70125	Bacteria	Bacteria	314	2.279999999999999e-96	NR	HMV57842.1	70125	g352	i1	79	0.788049605411499	186	37	31.1	1	1	552	331	516	HMV57842.1 hypothetical protein [Nitrospira sp.]	diamond	1398	314	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);;