metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA864829" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA864829" 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
847293	847293	PRJNA864829_S_NODE_6821_length_234_cov_3.454054_g6735_i0	PRJNA864829	6821	234	3.454054	8.08248636	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	182	2.56e-41	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g6735	i0	81.944	0.923076923076923	216	38	92	1	14	229	3017377	3017163	Nitrospira sp. KM1 DNA, complete genome	blastn	216	182	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
2122653	2122653	PRJNA864829_S_NODE_3762_length_292_cov_2.172840_g3676_i0	PRJNA864829	3762	292	2.17284	6.3446928	Nitrospira sp.	70125	Bacteria	Bacteria	211	4.22e-50	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g3676	i0	80.576	0.952054794520548	278	51	95	3	11	287	326250	326525	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	278	211	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2122665	2122665	PRJNA864829_S_NODE_5902_length_248_cov_2.537688_g5816_i0	PRJNA864829	5902	248	2.537688	6.29346624	Nitrospira sp.	70125	Bacteria	Bacteria	159	1.28e-34	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g5816	i0	78.313	6.32661290322581	249	52	100	2	1	248	281643	281890	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	1569	159	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4675743	4675743	PRJNA864829_S_NODE_664_length_563_cov_11.998054_g581_i0	PRJNA864829	664	563	11.998054	67.54904402	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	843	0	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g581	i0	94.991	93.2664298401421	539	24	95	3	2	538	4206855	4206318	Nitrospira sp. KM1 DNA, complete genome	blastn	52509	843	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
4675752	4675752	PRJNA864829_S_NODE_7964_length_219_cov_1.800000_g7878_i0	PRJNA864829	7964	219	1.8	3.942	Nitrospira moscoviensis	42253	Bacteria	Bacteria	215	2.34e-51	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g7878	i0	87.234	12.027397260274	188	24	86	0	3	190	2227144	2226957	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	2634	215	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
7225481	7225481	PRJNA864829_S_NODE_4146_length_283_cov_1.564103_g4060_i0	PRJNA864829	4146	283	1.564103	4.42641149	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	195	4.1e-45	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g4060	i0	79.286	0.989399293286219	280	56	99	2	5	283	2582370	2582092	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	280	195	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
7614913	7614913	PRJNA864829_S_NODE_8246_length_216_cov_1.832335_g8160_i0	PRJNA864829	8246	216	1.832335	3.9578436	Thermodesulfovibrio	28261	Bacteria	Bacteria	104	5.19e-18	NTclustered	gi\|2752968415\|gb\|CP144374.1\|	3118332	g8160	i0	85.714	5.75925925925926	98	14	45	0	11	108	1029582	1029485	Thermodesulfovibrio obliviosus strain 3462-1 chromosome, complete genome	blastn	1244	104	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Thermodesulfovibrionaceae	Thermodesulfovibrio	Thermodesulfovibrio obliviosus
9775295	9775295	PRJNA864829_S_NODE_1828_length_379_cov_1.924242_g1742_i0	PRJNA864829	1828	379	1.924242	7.29287718	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	385	3.14e-102	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g1742	i0	86.88	2.6042216358839	343	45	91	0	37	379	3601135	3601477	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	987	385	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
12326419	12326419	PRJNA864829_S_NODE_1730_length_388_cov_3.262537_g1644_i0	PRJNA864829	1730	388	3.262537	12.65864356	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	385	3.22e-102	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g1644	i0	84.96	0.97680412371134	379	57	98	0	1	379	1070796	1071174	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	379	385	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
12326445	12326445	PRJNA864829_S_NODE_6510_length_239_cov_1.410526_g6424_i0	PRJNA864829	6510	239	1.410526	3.37115714	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	259	1.18e-64	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g6424	i0	86.192	5.63598326359833	239	33	100	0	1	239	3864933	3864695	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	1347	259	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
13600948	13600948	PRJNA864829_S_NODE_13631_length_174_cov_1.296000_g13545_i0	PRJNA864829	13631	174	1.296	2.25504	Nitrospira sp.	70125	Bacteria	Bacteria	206	1.0599999999999999e-48	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g13545	i0	87.931	1.98275862068966	174	21	100	0	1	174	3436558	3436731	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	345	206	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
14875321	14875321	PRJNA864829_S_NODE_7412_length_226_cov_2.084746_g7326_i0	PRJNA864829	7412	226	2.084746	4.71152596	Nitrospira sp.	70125	Bacteria	Bacteria	315	2.32e-81	NTclustered	gi\|2290915413\|gb\|CP060502.1\|	70125	g7326	i0	92.308	1.95575221238938	221	17	98	0	6	226	171317	171097	MAG: Nitrospira sp. isolate NSFW plasmid pNSFW1, complete sequence	blastn	442	315	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
16149990	16149990	PRJNA864829_S_NODE_6953_length_232_cov_3.278689_g6867_i0	PRJNA864829	6953	232	3.278689	7.60655848	Nitrospira sp.	70125	Bacteria	Bacteria	226	1.1599999999999999e-54	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g6867	i0	85.135	2.2801724137931	222	31	95	2	10	230	1608953	1608733	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	529	226	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17425485	17425485	PRJNA864829_S_NODE_6354_length_241_cov_2.921875_g6268_i0	PRJNA864829	6354	241	2.921875	7.04171875	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	230	9.34e-56	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g6268	i0	85.909	0.912863070539419	220	26	90	4	24	239	482004	482222	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	220	230	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
18698648	18698648	PRJNA864829_S_NODE_9055_length_208_cov_1.452830_g8969_i0	PRJNA864829	9055	208	1.45283	3.0218864	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	71.3	5.03e-8	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g8969	i0	86.154	0.591346153846154	65	9	31	0	120	184	482077	482013	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	123	71.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
21638914	21638914	PRJNA864829_S_NODE_6337_length_241_cov_4.541667_g6251_i0	PRJNA864829	6337	241	4.541667	10.94541747	Nitrospira	1234	Bacteria	Bacteria	364	2.4499999999999993e-96	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g6251	i0	96.789	109.605809128631	218	7	90	0	1	218	3063449	3063232	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	26415	364	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24188408	24188408	PRJNA864829_S_NODE_8079_length_218_cov_1.165680_g7993_i0	PRJNA864829	8079	218	1.16568	2.5411824	Thermodesulfovibrio	28261	Bacteria	Bacteria	121	5.209999999999999e-23	NTclustered	gi\|470483621\|ref\|NR_076603.1\|	28262	g7993	i0	81.944	39.6880733944954	144	25	66	1	51	193	1481	1338	Thermodesulfovibrio yellowstonii strain YP87 23S ribosomal RNA gene, complete sequence	blastn	8652	121	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Thermodesulfovibrionaceae	Thermodesulfovibrio	Thermodesulfovibrio yellowstonii
25073362	25073362	PRJNA864829_S_NODE_14280_length_171_cov_0.885246_g14194_i0	PRJNA864829	14280	171	0.885246	1.51377066	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	132	1.79e-26	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g14194	i0	80.838	38.9941520467836	167	32	98	0	5	171	2714185	2714351	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	6668	132	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
25463551	25463551	PRJNA864829_S_NODE_15240_length_167_cov_1.152542_g15154_i0	PRJNA864829	15240	167	1.152542	1.92474514	Leptospirillum	179	Bacteria	Bacteria	80.5	6.43e-11	NTclustered	gi\|470476041\|ref\|NR_076316.1\|	180	g15154	i0	92.857	2.91017964071856	56	3	34	1	94	149	363	417	Leptospirillum ferrooxidans strain C2-3 23S ribosomal RNA gene, complete sequence	blastn	486	80.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Leptospirillum	Leptospirillum ferrooxidans

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