metadata: contig_metadata: 27 rows where bioproject = "PRJNA498309", tax_kingdom = "Pseudomonadati" and tax

27 rows where bioproject = "PRJNA498309", tax_kingdom = "Pseudomonadati" 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
481115	481115	PRJNA498309_P_NODE_60721_length_324_cov_7.519164_g58573_i0	PRJNA498309	60721	324	7.519164	24.36209136	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	78.6	1.01e-14	NR	MBX9660349.1	2026770	g58573	i0	97.4	0.361111111111111	39	1	36.1	0	19	135	258	296	MBX9660349.1 helix-turn-helix domain-containing protein [Nitrospiraceae bacterium]	diamond	117	78.6	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
3030978	3030978	PRJNA498309_P_NODE_105303_length_182_cov_2.103448_g103154_i0	PRJNA498309	105303	182	2.103448	3.82827536	Nitrospira sp.	70125	Bacteria	Bacteria	226	8.619999999999999e-55	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g103154	i0	90.173	3.14835164835165	173	17	95	0	4	176	2600362	2600190	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	573	226	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9409345	9409345	PRJNA498309_P_NODE_74828_length_268_cov_2.675325_g72679_i0	PRJNA498309	74828	268	2.675325	7.169871	Nitrospirota bacterium	2026887	Bacteria	Bacteria	117	2.78e-28	NR	MEK7760525.1	2026887	g72679	i0	89.6	4.5	67	7	75	0	45	245	224	290	MEK7760525.1 adenosylcobalamin-dependent ribonucleoside-diphosphate reductase [Nitrospirota bacterium]	diamond	1206	117	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
18332687	18332687	PRJNA498309_P_NODE_59615_length_329_cov_5.489726_g57467_i0	PRJNA498309	59615	329	5.489726	18.06119854	Nitrospira sp.	70125	Bacteria	Bacteria	324	5.94e-84	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g57467	i0	85.902	0.927051671732523	305	42	92	1	15	318	711343	711647	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	305	324	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18333994	18333994	PRJNA498309_S_NODE_38655_length_221_cov_6.403226_g36487_i0	PRJNA498309	38655	221	6.403226	14.15112946	uncultured Nitrospira sp.	157176	Bacteria	Bacteria	281	2.29e-71	NTclustered	gi\|969812311\|dbj\|LC017023.1\|	157176	g36487	i0	89.64	71.841628959276	222	22	100	1	1	221	350	571	Uncultured Nitrospira sp. gene for 16S ribosomal RNA, partial sequence, clone: EDay154C-CL65	blastn	15877	281	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	uncultured Nitrospira sp.
19606417	19606417	PRJNA498309_P_NODE_25356_length_572_cov_3.745794_g23417_i0	PRJNA498309	25356	572	3.745794	21.42594168	Nitrospira sp.	70125	Bacteria	Bacteria	366	1.7699999999999993e-96	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g23417	i0	83.127	0.704545454545455	403	66	70	2	22	422	2658808	2658406	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	403	366	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19607054	19607054	PRJNA498309_P_NODE_63156_length_313_cov_11.597826_g61008_i0	PRJNA498309	63156	313	11.597826	36.30119538	Nitrospira sp.	70125	Bacteria	Bacteria	209	1.64e-49	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g61008	i0	80.435	0.881789137380192	276	52	88	2	14	288	2325533	2325807	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	276	209	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
20884756	20884756	PRJNA498309_S_NODE_8737_length_885_cov_12.140000_g7064_i0	PRJNA498309	8737	885	12.14	107.439	Nitrospira sp.	70125	Bacteria	Bacteria	833	0	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g7064	i0	84.634	0.955932203389831	846	120	95	9	23	863	2328400	2327560	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	846	833	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23434047	23434047	PRJNA498309_P_NODE_95819_length_204_cov_2.694611_g93670_i0	PRJNA498309	95819	204	2.694611	5.49700644	Nitrospira sp.	70125	Bacteria	Bacteria	233	5.919999999999999e-57	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g93670	i0	87.255	1	204	26	100	0	1	204	2327642	2327845	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	204	233	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26680912	26680912	PRJNA498309_P_NODE_70701_length_283_cov_2.804878_g68552_i0	PRJNA498309	70701	283	2.804878	7.93780474	Nitrospira	1234	Bacteria	Bacteria	122	3.3799999999999995e-32	NR	MDX2251558.1	70125	g68552	i0	68.3	2.59717314487632	82	26	86.9	0	16	261	176	257	MDX2251558.1 GNAT family N-acetyltransferase [Nitrospira sp.]	diamond	735	123	0.991869918699187	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26760416	26760416	PRJNA498309_P_NODE_54141_length_355_cov_2.377358_g51993_i0	PRJNA498309	54141	355	2.377358	8.4396209	Nitrospirota bacterium	2026887	Bacteria	Bacteria	64.3	5.28e-11	NR	MEW6245385.1	2026887	g51993	i0	61.7	0.397183098591549	47	18	39.7	0	29	169	16	62	MEW6245385.1 hypothetical protein [Nitrospirota bacterium]	diamond	141	64.3	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
26934323	26934323	PRJNA498309_P_NODE_60442_length_326_cov_1.501730_g58294_i0	PRJNA498309	60442	326	1.50173	4.8956398	Pseudomonadati	3379134	Bacteria	Bacteria	119	5.25e-29	NR	NTW68083.1	2026887	g58294	i0	75.3	4.69325153374233	73	18	67.2	0	106	324	135	207	NTW68083.1 nitrogenase molybdenum-iron protein subunit beta [Nitrospirota bacterium]	diamond	1530	119	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
27045446	27045446	PRJNA498309_P_NODE_36622_length_462_cov_2.762353_g34562_i0	PRJNA498309	36622	462	2.762353	12.76207086	Nitrospirota bacterium	2026887	Bacteria	Bacteria	149	8.82e-43	NR	MDO8356972.1	2026887	g34562	i0	72.1	0.720779220779221	111	31	72.1	0	107	439	1	111	MDO8356972.1 hypothetical protein [Nitrospirota bacterium]	diamond	333	149	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
29350782	29350782	PRJNA498309_P_NODE_87629_length_227_cov_1.531579_g85480_i0	PRJNA498309	87629	227	1.531579	3.47668433	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	59.7	3.49e-9	NR	MBX9659451.1	2026770	g85480	i0	93.1	0.383259911894273	29	2	38.3	0	141	227	1	29	MBX9659451.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	87	59.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
29539993	29539993	PRJNA498309_P_NODE_105310_length_182_cov_2.068966_g103161_i0	PRJNA498309	105310	182	2.068966	3.76551812	Nitrospira sp.	70125	Bacteria	Bacteria	59.3	2.33e-8	NR	NOS81392.1	70125	g103161	i0	65.4	1.71428571428571	52	17	85.7	1	182	27	115	165	NOS81392.1 efflux RND transporter periplasmic adaptor subunit [Nitrospira sp.]	diamond	312	59.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29824102	29824102	PRJNA498309_P_NODE_105131_length_182_cov_9.517241_g102982_i0	PRJNA498309	105131	182	9.517241	17.32137862	Nitrospira sp.	70125	Bacteria	Bacteria	80.5	8.05e-16	NR	MEQ1561419.1	70125	g102982	i0	62.1	1.82967032967033	58	21	94	1	6	176	255	312	MEQ1561419.1 UbiA family prenyltransferase [Nitrospira sp.]	diamond	333	80.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29919233	29919233	PRJNA498309_S_NODE_20591_length_445_cov_3.285366_g18477_i0	PRJNA498309	20591	445	3.285366	14.6198787	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	233	6.21e-76	NR	MBX9658710.1	2026770	g18477	i0	87.4	0.802247191011236	119	15	80.2	0	425	69	39	157	MBX9658710.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	357	233	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
30013966	30013966	PRJNA498309_P_NODE_91931_length_214_cov_3.338983_g89782_i0	PRJNA498309	91931	214	3.338983	7.14542362	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	48.5	2.3e-5	NR	MBX9659231.1	2026770	g89782	i0	100	0.308411214953271	22	0	30.8	0	199	134	52	73	MBX9659231.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	66	48.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
30187217	30187217	PRJNA498309_P_NODE_30852_length_510_cov_17.596195_g28845_i0	PRJNA498309	30852	510	17.596195	89.7405945	Pseudomonadati	3379134	Bacteria	Bacteria	113	1.86e-25	NR	MBI5696276.1	2026887	g28845	i0	59.6	2.19411764705882	94	38	55.3	0	303	22	478	571	MBI5696276.1 thrombospondin type 3 repeat-containing protein [Nitrospirota bacterium]	diamond	1119	113	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30519387	30519387	PRJNA498309_P_NODE_57733_length_338_cov_1.843854_g55585_i0	PRJNA498309	57733	338	1.843854	6.23222652	Nitrospira sp.	70125	Bacteria	Bacteria	205	6.01e-62	NR	HEX7766269.1	70125	g55585	i0	96.3	2.8491124260355	107	4	95	0	16	336	318	424	HEX7766269.1 HlyD family type I secretion periplasmic adaptor subunit [Nitrospira sp.]	diamond	963	205	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31056835	31056835	PRJNA498309_P_NODE_7995_length_1094_cov_165.926206_g6695_i0	PRJNA498309	7995	1094	165.926206	1815.23269364	Nitrospira sp.	70125	Bacteria	Bacteria	60.8	3.35e-7	NR	MDE0145683.1	70125	g6695	i0	32.1	0.307129798903108	112	73	30.4	3	708	376	5	114	MDE0145683.1 LAGLIDADG family homing endonuclease [Nitrospira sp.]	diamond	336	60.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31214017	31214017	PRJNA498309_P_NODE_52495_length_363_cov_4.582822_g50347_i0	PRJNA498309	52495	363	4.582822	16.63564386	Thermodesulfovibrionales bacterium	2814272	Bacteria	Bacteria	56.6	3.12e-7	NR	MFA4919290.1	2814272	g50347	i0	34.1	0.677685950413223	82	53	66.9	1	330	88	11	92	MFA4919290.1 hypothetical protein [Thermodesulfovibrionales bacterium]	diamond	246	56.6	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales			Thermodesulfovibrionales bacterium
31594223	31594223	PRJNA498309_P_NODE_23616_length_594_cov_12.955117_g21716_i0	PRJNA498309	23616	594	12.955117	76.95339498	Nitrospirota bacterium	2026887	Bacteria	Bacteria	79.7	3.79e-15	NR	MDH4162156.1	2026887	g21716	i0	46.7	0.454545454545455	90	48	45.5	0	387	118	7	96	MDH4162156.1 type II toxin-antitoxin system VapC family toxin [Nitrospirota bacterium]	diamond	270	79.7	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
31910329	31910329	PRJNA498309_P_NODE_18177_length_685_cov_5.783951_g16423_i0	PRJNA498309	18177	685	5.783951	39.62006435	Nitrospira sp.	70125	Bacteria	Bacteria	154	8.33e-44	NR	MEX5217687.1	70125	g16423	i0	82.7	0.858394160583942	98	17	42.9	0	218	511	2	99	MEX5217687.1 hypothetical protein [Nitrospira sp.]	diamond	588	154	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32195150	32195150	PRJNA498309_P_NODE_56578_length_343_cov_3.424837_g54430_i0	PRJNA498309	56578	343	3.424837	11.74719091	Nitrospirota bacterium	2026887	Bacteria	Bacteria	154	2.56e-42	NR	RMD58697.1	2026887	g54430	i0	69	5.27405247813411	100	31	87.5	0	338	39	137	236	RMD58697.1 MAG: adenosylmethionine--8-amino-7-oxononanoate transaminase [Nitrospirota bacterium]	diamond	1809	154	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
32448478	32448478	PRJNA498309_P_NODE_16019_length_735_cov_2.838109_g14348_i0	PRJNA498309	16019	735	2.838109	20.86010115	Nitrospirota bacterium	2026887	Bacteria	Bacteria	160	9.14e-46	NR	MEW6247144.1	2026887	g14348	i0	46	1.31428571428571	161	86	65.3	1	502	23	5	165	MEW6247144.1 dihydrofolate reductase family protein [Nitrospirota bacterium]	diamond	966	160	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
32575030	32575030	PRJNA498309_S_NODE_12139_length_694_cov_223.757208_g10269_i0	PRJNA498309	12139	694	223.757208	1552.87502352	Nitrospira sp.	70125	Bacteria	Bacteria	154	8.9e-44	NR	MEX5217687.1	70125	g10269	i0	82.7	0.847262247838617	98	17	42.4	0	222	515	2	99	MEX5217687.1 hypothetical protein [Nitrospira sp.]	diamond	588	154	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);;