metadata: contig_metadata: 18 rows where bioproject = "PRJNA1092581" and tax

18 rows where bioproject = "PRJNA1092581" 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
12951463	12951463	PRJNA1092581_P_NODE_74231_length_302_cov_5.183406_g73698_i0	PRJNA1092581	74231	302	5.183406	15.65388612	Nitrospira sp.	70125	Bacteria	Bacteria	499	8.35e-137	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g73698	i0	98.925	110.592715231788	279	3	92	0	20	298	201905	201627	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	33399	499	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18047418	18047418	PRJNA1092581_P_NODE_109155_length_241_cov_3.553571_g108622_i0	PRJNA1092581	109155	241	3.553571	8.56410611	Candidatus Manganitrophus sp.	2927580	Bacteria	Bacteria	187	5.699999999999998e-43	NTclustered	gi\|2449729286\|gb\|CP114553.1\|	2927580	g108622	i0	83.756	134.800829875519	197	32	82	0	23	219	1674903	1675099	MAG: Candidatus Manganitrophus sp. isolate GAC1 chromosome, complete genome	blastn	32487	187	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Candidatus Troglogloeales	Candidatus Manganitrophaceae	Candidatus Manganitrophus	Candidatus Manganitrophus sp.
22694738	22694738	PRJNA1092581_P_NODE_115098_length_231_cov_9.063291_g114565_i0	PRJNA1092581	115098	231	9.063291	20.93620221	Pseudomonadati	3379134	Bacteria	Bacteria	353	5.05e-93	NTclustered	gi\|3451272\|emb\|Y14638.1\|	70125	g114565	i0	99.485	83.982683982684	194	1	84	0	14	207	1187	994	Nitrospira sp. 16S rRNA gene, strain RC19	blastn	19400	353	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24423480	24423480	PRJNA1092581_P_NODE_68760_length_316_cov_3.308642_g68227_i0	PRJNA1092581	68760	316	3.308642	10.45530872	Nitrospira sp.	70125	Bacteria	Bacteria	110	3.24e-29	NR	MCS6283966.1	70125	g68227	i0	93	0.541139240506329	57	4	54.1	0	214	44	40	96	MCS6283966.1 type II toxin-antitoxin system RelE/ParE family toxin [Nitrospira sp.]	diamond	171	110	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
25244337	25244337	PRJNA1092581_P_NODE_13880_length_739_cov_4.055556_g13393_i0	PRJNA1092581	13880	739	4.055556	29.97055884	Nitrospira	1234	Bacteria	Bacteria	1147	0	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g13393	i0	95.417	110.97699594046	720	33	97	0	20	739	1277767	1278486	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	82012	1147	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
27121857	27121857	PRJNA1092581_P_NODE_89022_length_271_cov_3.686869_g88489_i0	PRJNA1092581	89022	271	3.686869	9.9914149900000009	Pseudomonadati	3379134	Bacteria	Bacteria	146	6.61e-41	NR	HNC82018.1	70125	g88489	i0	77.3	1.94833948339483	88	20	97.4	0	3	266	213	300	HNC82018.1 glycosyltransferase [Nitrospira sp.]	diamond	528	146	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27794262	27794262	PRJNA1092581_P_NODE_30024_length_506_cov_2.272517_g29492_i0	PRJNA1092581	30024	506	2.272517	11.49893602	Nitrospira sp.	70125	Bacteria	Bacteria	229	1.78e-68	NR	MBS0156715.1	70125	g29492	i0	69.1	1.95652173913043	165	51	97.8	0	1	495	224	388	MBS0156715.1 asparagine synthase (glutamine-hydrolyzing) [Nitrospira sp.]	diamond	990	229	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27817277	27817277	PRJNA1092581_P_NODE_26564_length_540_cov_1.961456_g26033_i0	PRJNA1092581	26564	540	1.961456	10.5918624	Nitrospira	1234	Bacteria	Bacteria	317	5.8e-107	NR	WP_181416788.1	1436998	g26033	i0	91.3	1.91111111111111	172	15	95.6	0	523	8	73	244	WP_181416788.1 dienelactone hydrolase family protein [Nitrospira lenta]	diamond	1032	319	0.993730407523511	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
28172893	28172893	PRJNA1092581_P_NODE_108546_length_242_cov_2.254438_g108013_i0	PRJNA1092581	108546	242	2.254438	5.45573996	Nitrospiria bacterium	2306052	Bacteria	Bacteria	100	6.74e-23	NR	HLB94810.1	2306052	g108013	i0	72.5	0.855371900826446	69	18	85.5	1	222	16	107	174	HLB94810.1 GAF domain-containing protein [Nitrospiria bacterium]	diamond	207	100	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria				Nitrospiria bacterium
28520425	28520425	PRJNA1092581_P_NODE_99047_length_254_cov_3.922652_g98514_i0	PRJNA1092581	99047	254	3.922652	9.96353608	Nitrospira sp.	70125	Bacteria	Bacteria	60.8	2.41e-9	NR	MEQ1795757.1	70125	g98514	i0	76.6	0.55511811023622	47	10	55.5	1	106	246	1	46	MEQ1795757.1 DUF3015 family protein [Nitrospira sp.]	diamond	141	60.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28543518	28543518	PRJNA1092581_P_NODE_86907_length_275_cov_2.589109_g86374_i0	PRJNA1092581	86907	275	2.589109	7.12004975	Pseudomonadati	3379134	Bacteria	Bacteria	82.4	1.71e-16	NR	MCL5061883.1	2026887	g86374	i0	54.4	6.81818181818182	79	36	86.2	0	20	256	16	94	MCL5061883.1 LysR family transcriptional regulator [Nitrospirota bacterium]	diamond	1875	82.8	0.995169082125604	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28583639	28583639	PRJNA1092581_P_NODE_96427_length_258_cov_5.972973_g95894_i0	PRJNA1092581	96427	258	5.972973	15.41027034	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	43.5	0.00171	NR	MBX9657682.1	2026770	g95894	i0	56.5	0.534883720930233	46	20	53.5	0	56	193	1	46	MBX9657682.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	138	43.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28772803	28772803	PRJNA1092581_P_NODE_105027_length_246_cov_3.734104_g104494_i0	PRJNA1092581	105027	246	3.734104	9.18589584	Nitrospirota bacterium	2026887	Bacteria	Bacteria	70.1	3.25e-12	NR	MBI3597044.1	2026887	g104494	i0	64.8	1.31707317073171	54	19	65.9	0	83	244	1	54	MBI3597044.1 glycerophosphodiester phosphodiesterase [Nitrospirota bacterium]	diamond	324	70.1	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
29458613	29458613	PRJNA1092581_P_NODE_66110_length_323_cov_6.944000_g65577_i0	PRJNA1092581	66110	323	6.944	22.42912	Bacteria	2	Bacteria	Bacteria	169	3.6599999999999996e-46	NR	UVT20637.1	70125	g65577	i0	88.4	35.3219814241486	95	11	88.2	0	19	303	281	375	UVT20637.1 MAG: type I restriction endonuclease subunit R [Nitrospira sp.]	diamond	11409	170	0.994117647058824	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29964241	29964241	PRJNA1092581_P_NODE_45091_length_403_cov_14.233333_g44558_i0	PRJNA1092581	45091	403	14.233333	57.36033199	Nitrospira	1234	Bacteria	Bacteria	255	4.21e-81	NR	MEQ1654837.1	70125	g44558	i0	99.2	2.7468982630273	123	1	91.6	0	388	20	270	392	MEQ1654837.1 hypothetical protein [Nitrospira sp.]	diamond	1107	256	0.99609375	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30375355	30375355	PRJNA1092581_P_NODE_112912_length_235_cov_3.759259_g112379_i0	PRJNA1092581	112912	235	3.759259	8.83425865	Pseudomonadati	3379134	Bacteria	Bacteria	134	6.829999999999998e-35	NR	HNG00865.1	70125	g112379	i0	88.6	1.78723404255319	70	8	89.4	0	21	230	380	449	HNG00865.1 phage terminase large subunit [Nitrospira sp.]	diamond	420	134	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30817248	30817248	PRJNA1092581_P_NODE_125194_length_206_cov_5.774436_g124661_i0	PRJNA1092581	125194	206	5.774436	11.89533816	Nitrospira	1234	Bacteria	Bacteria	95.5	1.55e-21	NR	MCS6305048.1	70125	g124661	i0	79	3.61165048543689	62	13	90.3	0	205	20	140	201	MCS6305048.1 cadherin-like beta sandwich domain-containing protein [Nitrospira sp.]	diamond	744	95.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32090764	32090764	PRJNA1092581_P_NODE_61118_length_339_cov_2.214286_g60585_i0	PRJNA1092581	61118	339	2.214286	7.50642954	Nitrospirota bacterium	2026887	Bacteria	Bacteria	115	1.81e-27	NR	HET7319221.1	2026887	g60585	i0	49	0.920353982300885	104	53	92	0	26	337	37	140	HET7319221.1 hypothetical protein [Nitrospirota bacterium]	diamond	312	115	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium

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