metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA429937" 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
1700791	1700791	PRJNA429937_P_NODE_140142_length_205_cov_2.636364_g117515_i0	PRJNA429937	140142	205	2.636364	5.4045462	Nitrospira defluvii	330214	Bacteria	Bacteria	187	4.6999999999999985e-43	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g117515	i0	96.46	1.02926829268293	113	4	100	0	1	113	1325806	1325918	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	211	187	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
1701065	1701065	PRJNA429937_P_NODE_21082_length_801_cov_14.480570_g12470_i0	PRJNA429937	21082	801	14.48057	115.9893657	Nitrospira sp.	70125	Bacteria	Bacteria	898	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g12470	i0	87.859	8.27965043695381	766	92	96	1	20	785	3238364	3237600	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	6632	898	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701092	1701092	PRJNA429937_P_NODE_22002_length_784_cov_24.170861_g13058_i0	PRJNA429937	22002	784	24.170861	189.49955024	Nitrospira sp.	70125	Bacteria	Bacteria	590	1.3499999999999998e-163	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g13058	i0	84.124	0.779336734693878	611	95	78	2	23	631	1126273	1126883	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	611	590	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701096	1701096	PRJNA429937_P_NODE_22182_length_781_cov_3.510638_g13176_i0	PRJNA429937	22182	781	3.510638	27.41808278	Nitrospira sp.	70125	Bacteria	Bacteria	614	7.969999999999998e-171	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g13176	i0	85.354	1.01024327784891	594	85	80	2	171	763	2078282	2077690	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	789	614	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701849	1701849	PRJNA429937_P_NODE_56722_length_463_cov_14.271889_g37802_i0	PRJNA429937	56722	463	14.271889	66.07884607	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.2599999999999996e-176	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g37802	i0	96.354	81.3131749460043	384	14	83	0	2	385	201355	201738	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	37648	632	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2976363	2976363	PRJNA429937_P_NODE_115283_length_260_cov_4.722944_g92657_i0	PRJNA429937	115283	260	4.722944	12.2796544	Nitrospira tepida	2973512	Bacteria	Bacteria	193	1.34e-44	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g92657	i0	81.513	0.915384615384615	238	41	91	3	24	259	333361	333125	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	238	193	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
4252888	4252888	PRJNA429937_P_NODE_138724_length_207_cov_92.056180_g116097_i0	PRJNA429937	138724	207	92.05618	190.5562926	Nitrospira sp.	70125	Bacteria	Bacteria	342	9.599999999999999e-90	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g116097	i0	98.953	162.951690821256	191	2	92	0	1	191	2094005	2094195	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	33731	342	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4253713	4253713	PRJNA429937_P_NODE_43324_length_545_cov_2.298450_g27672_i0	PRJNA429937	43324	545	2.29845	12.5265525	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	163	2.37e-35	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g27672	i0	90.323	0.607339449541284	124	12	23	0	422	545	2124014	2124137	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	331	163	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
6803260	6803260	PRJNA429937_P_NODE_10426_length_1122_cov_3.763038_g5815_i1	PRJNA429937	10426	1122	3.763038	42.22128636	Nitrospira sp.	70125	Bacteria	Bacteria	311	1.71e-79	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g5815	i1	84.79	0.275401069518717	309	47	28	0	291	599	2197830	2197522	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	309	311	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8079803	8079803	PRJNA429937_P_NODE_32187_length_640_cov_5.178396_g17314_i1	PRJNA429937	32187	640	5.178396	33.1417344	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.7899999999999997e-176	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g17314	i1	87.143	8.7859375	560	68	87	4	62	618	3197046	3197604	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	5623	632	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9353649	9353649	PRJNA429937_P_NODE_104388_length_289_cov_5.857692_g81770_i0	PRJNA429937	104388	289	5.857692	16.92872988	Nitrospira moscoviensis	42253	Bacteria	Bacteria	422	1.77e-113	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g81770	i0	93.056	279.543252595156	288	20	99	0	2	289	1277504	1277791	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	80788	422	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
9354798	9354798	PRJNA429937_P_NODE_39088_length_577_cov_3.529197_g24624_i0	PRJNA429937	39088	577	3.529197	20.36346669	Nitrospira sp.	70125	Bacteria	Bacteria	569	1.2699999999999997e-157	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g24624	i0	89.686	0.974003466204506	446	46	77	0	19	464	2001735	2002180	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	562	569	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10631504	10631504	PRJNA429937_P_NODE_92709_length_324_cov_5.013559_g70123_i0	PRJNA429937	92709	324	5.013559	16.24393116	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	255	2.16e-63	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g70123	i0	93.567	207.833333333333	171	11	53	0	1	171	1781595	1781425	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	67338	255	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
11904835	11904835	PRJNA429937_P_NODE_15710_length_926_cov_22.208473_g9285_i0	PRJNA429937	15710	926	22.208473	205.65045998	Nitrospira sp.	70125	Bacteria	Bacteria	933	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g9285	i0	85.73	3.39740820734341	883	126	95	0	20	902	304795	303913	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	3146	933	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
15729701	15729701	PRJNA429937_P_NODE_58353_length_455_cov_4.352113_g39053_i0	PRJNA429937	58353	455	4.352113	19.80211415	Nitrospira sp.	70125	Bacteria	Bacteria	525	2.1599999999999992e-144	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g39053	i0	89.26	0.920879120879121	419	45	92	0	23	441	3091134	3090716	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	419	525	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17005004	17005004	PRJNA429937_P_NODE_9894_length_1150_cov_3.756467_g5815_i0	PRJNA429937	9894	1150	3.756467	43.1993705	Nitrospira sp.	70125	Bacteria	Bacteria	340	2.23e-88	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g5815	i0	84.866	0.29304347826087	337	51	29	0	524	860	2197522	2197858	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	337	340	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18278433	18278433	PRJNA429937_P_NODE_4695_length_1569_cov_4.323377_g2777_i0	PRJNA429937	4695	1569	4.323377	67.83378513	Nitrospira sp.	70125	Bacteria	Bacteria	1053	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g2777	i0	83.659	1.23199490121096	1126	177	82	7	168	1289	1815351	1814229	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	1933	1053	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19552078	19552078	PRJNA429937_P_NODE_1956_length_2146_cov_4.380727_g1174_i0	PRJNA429937	1956	2146	4.380727	94.01040142	Nitrospira sp.	70125	Bacteria	Bacteria	634	1.7299999999999994e-176	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g1174	i0	79.109	1.96738117427773	943	180	44	10	2	936	1437590	1436657	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	4222	634	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19552890	19552890	PRJNA429937_P_NODE_54956_length_473_cov_3.684685_g36419_i0	PRJNA429937	54956	473	3.684685	17.42856005	Nitrospira sp.	70125	Bacteria	Bacteria	473	8.289999999999999e-129	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g36419	i0	86.27	0.923890063424947	437	58	92	2	23	457	3259528	3259964	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	437	473	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22102667	22102667	PRJNA429937_P_NODE_16618_length_901_cov_4.932339_g9839_i0	PRJNA429937	16618	901	4.932339	44.44037439	Nitrospira sp.	70125	Bacteria	Bacteria	737	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g9839	i0	81.88	0.980022197558269	883	152	98	7	23	901	960945	960067	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	883	737	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22102980	22102980	PRJNA429937_P_NODE_28658_length_681_cov_5.119632_g17314_i0	PRJNA429937	28658	681	5.119632	34.86469392	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.9099999999999995e-176	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g17314	i0	87.143	8.25697503671072	560	68	82	4	103	659	3197046	3197604	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	5623	632	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);;