metadata: contig_metadata: 34 rows where bioproject = "PRJNA691918" and tax

34 rows where bioproject = "PRJNA691918" 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	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
672510	672510	PRJNA691918_S_NODE_221_length_192_cov_19046.863354_g220_i0	PRJNA691918	221	192	19046.863354	36569.97763968	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.27e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g220	i0	97.619	20.96875	42	1	22	151	192	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1948485	1948485	PRJNA691918_S_NODE_202_length_194_cov_18764.061350_g201_i0	PRJNA691918	202	194	18764.06135	36402.279019	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.29e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g201	i0	97.619	21.0824742268041	42	1	22	153	194	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4090	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1948488	1948488	PRJNA691918_S_NODE_262_length_184_cov_19583.111111_g261_i0	PRJNA691918	262	184	19583.111111	36032.92444424	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.2e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g261	i0	97.619	21.8804347826087	42	1	23	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2454511	2454511	PRJNA691918_S_NODE_62_length_247_cov_13881.625000_g61_i0	PRJNA691918	62	247	13881.625	34287.61375	root	1	Root_unresolved	Root_unresolved	73.1	1.71e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g61	i0	97.619	16.5263157894737	42	1	17	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4082	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
3223379	3223379	PRJNA691918_S_NODE_223_length_192_cov_18581.496894_g222_i0	PRJNA691918	223	192	18581.496894	35676.47403648	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.27e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g222	i0	97.619	20.96875	42	1	22	151	192	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
3223380	3223380	PRJNA691918_S_NODE_23_length_289_cov_11866.321705_g22_i0	PRJNA691918	23	289	11866.321705	34293.66972745	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.05e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g22	i0	97.619	13.9307958477509	42	1	15	248	289	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
3223383	3223383	PRJNA691918_S_NODE_43_length_262_cov_12952.233766_g42_i0	PRJNA691918	43	262	12952.233766	33934.85246692	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.83e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g42	i0	97.619	15.3664122137405	42	1	16	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5775981	5775981	PRJNA691918_S_NODE_185_length_198_cov_18336.772455_g184_i0	PRJNA691918	185	198	18336.772455	36306.8094609	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.32e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g184	i0	97.619	20.3333333333333	42	1	21	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5775987	5775987	PRJNA691918_S_NODE_65_length_245_cov_13367.158879_g64_i0	PRJNA691918	65	245	13367.158879	32749.53925355	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.7e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g64	i0	97.619	16.5591836734694	42	1	17	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4057	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7051110	7051110	PRJNA691918_S_NODE_186_length_198_cov_17949.257485_g185_i0	PRJNA691918	186	198	17949.257485	35539.5298203	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.32e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g185	i0	97.619	20.3333333333333	42	1	21	157	198	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8325603	8325603	PRJNA691918_S_NODE_127_length_215_cov_16672.119565_g126_i0	PRJNA691918	127	215	16672.119565	35845.05706475	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.45e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g126	i0	97.619	18.7255813953488	42	1	20	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9600933	9600933	PRJNA691918_S_NODE_108_length_222_cov_14946.120419_g107_i0	PRJNA691918	108	222	14946.120419	33180.38733018	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.51e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g107	i0	97.619	18.1351351351351	42	1	19	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9600934	9600934	PRJNA691918_S_NODE_128_length_215_cov_15555.728261_g127_i0	PRJNA691918	128	215	15555.728261	33444.81576115	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.45e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g127	i0	97.619	18.7255813953488	42	1	20	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10876533	10876533	PRJNA691918_S_NODE_109_length_222_cov_14936.455497_g108_i0	PRJNA691918	109	222	14936.455497	33158.93120334	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.51e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g108	i0	97.619	18.1351351351351	42	1	19	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10876537	10876537	PRJNA691918_S_NODE_229_length_190_cov_19259.207547_g228_i0	PRJNA691918	229	190	19259.207547	36592.4943393	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.25e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g228	i0	97.619	21.1894736842105	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10876538	10876538	PRJNA691918_S_NODE_249_length_186_cov_19785.967742_g248_i0	PRJNA691918	249	186	19785.967742	36801.90000012	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.22e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g248	i0	97.619	21.6451612903226	42	1	23	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
12151686	12151686	PRJNA691918_S_NODE_250_length_186_cov_19760.961290_g249_i0	PRJNA691918	250	186	19760.96129	36755.3879994	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.22e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g249	i0	97.619	21.9516129032258	42	1	23	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4083	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13426260	13426260	PRJNA691918_S_NODE_251_length_186_cov_19744.529032_g250_i0	PRJNA691918	251	186	19744.529032	36724.82399952	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.22e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g250	i0	97.619	21.6451612903226	42	1	23	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
14701474	14701474	PRJNA691918_S_NODE_212_length_193_cov_18510.814815_g211_i0	PRJNA691918	212	193	18510.814815	35725.87259295	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.28e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g211	i0	97.619	20.860103626943	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
15975189	15975189	PRJNA691918_S_NODE_213_length_193_cov_18460.092593_g212_i0	PRJNA691918	213	193	18460.092593	35627.97870449	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.28e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g212	i0	97.619	20.860103626943	42	1	22	152	193	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17250350	17250350	PRJNA691918_S_NODE_174_length_200_cov_17732.656805_g173_i0	PRJNA691918	174	200	17732.656805	35465.31361	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.33e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g173	i0	97.619	20.13	42	1	21	159	200	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17250351	17250351	PRJNA691918_S_NODE_74_length_239_cov_14621.533654_g73_i0	PRJNA691918	74	239	14621.533654	34945.46543306	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.65e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g73	i0	97.619	16.8451882845188	42	1	18	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18524467	18524467	PRJNA691918_S_NODE_155_length_206_cov_17131.228571_g154_i0	PRJNA691918	155	206	17131.228571	35290.33085626	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.38e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g154	i0	97.619	19.5436893203883	42	1	20	165	206	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18524469	18524469	PRJNA691918_S_NODE_235_length_189_cov_18041.012658_g234_i0	PRJNA691918	235	189	18041.012658	34097.51392362	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.24e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g234	i0	97.619	21.3015873015873	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18524470	18524470	PRJNA691918_S_NODE_55_length_252_cov_13821.850679_g54_i0	PRJNA691918	55	252	13821.850679	34831.06371108	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.75e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g54	i0	97.619	15.9761904761905	42	1	17	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19799402	19799402	PRJNA691918_S_NODE_156_length_206_cov_17118.748571_g155_i0	PRJNA691918	156	206	17118.748571	35264.62205626	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.38e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g155	i0	97.619	19.5436893203883	42	1	20	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19799403	19799403	PRJNA691918_S_NODE_16_length_299_cov_11373.940299_g15_i0	PRJNA691918	16	299	11373.940299	34008.08149401	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	2.13e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g15	i0	97.619	13.4648829431438	42	1	14	258	299	406648	406607	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19799406	19799406	PRJNA691918_S_NODE_236_length_188_cov_19443.974522_g235_i0	PRJNA691918	236	188	19443.974522	36554.67210136	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.24e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g235	i0	97.619	21.7127659574468	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4082	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19799410	19799410	PRJNA691918_S_NODE_96_length_225_cov_15415.525773_g95_i0	PRJNA691918	96	225	15415.525773	34684.93298925	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.54e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g95	i0	97.619	17.8933333333333	42	1	19	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21074939	21074939	PRJNA691918_S_NODE_157_length_206_cov_17092.131429_g156_i0	PRJNA691918	157	206	17092.131429	35209.79074374	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.38e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g156	i0	97.619	19.5436893203883	42	1	20	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21074945	21074945	PRJNA691918_S_NODE_97_length_225_cov_14680.685567_g96_i0	PRJNA691918	97	225	14680.685567	33031.54252575	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.54e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g96	i0	97.619	17.8933333333333	42	1	19	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23625187	23625187	PRJNA691918_S_NODE_239_length_188_cov_18138.624204_g238_i0	PRJNA691918	239	188	18138.624204	34100.61350352	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.24e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g238	i0	97.619	21.4148936170213	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24898764	24898764	PRJNA691918_S_NODE_200_length_194_cov_18780.214724_g199_i0	PRJNA691918	200	194	18780.214724	36433.61656456	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.29e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g199	i0	97.619	20.7525773195876	42	1	22	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24898768	24898768	PRJNA691918_S_NODE_60_length_248_cov_13789.741935_g59_i0	PRJNA691918	60	248	13789.741935	34198.5599988	Nitrospira sp.	70125	Bacteria	Bacteria	73.1	1.72e-8	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g59	i0	97.619	16.2338709677419	42	1	17	1	42	406607	406648	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	4026	73.1	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);;