metadata: contig_metadata: 19 rows where bioproject = "PRJNA1111077", tax_kingdom = "Pseudomonadati" and tax

19 rows where bioproject = "PRJNA1111077", 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
214713	214713	PRJNA1111077_P_NODE_27021_length_262_cov_5.645503_g26800_i0	PRJNA1111077	27021	262	5.645503	14.79121786	Nitrospira sp.	70125	Bacteria	Bacteria	292	1.2899999999999999e-74	NTclustered	gi\|2511635996\|gb\|CP126122.1\|	70125	g26800	i0	86.973	3.01908396946565	261	32	99	2	2	262	2661237	2660979	MAG: Nitrospira sp. isolate bin_005 chromosome	blastn	791	292	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2765152	2765152	PRJNA1111077_P_NODE_14583_length_310_cov_8.122363_g14362_i0	PRJNA1111077	14583	310	8.122363	25.1793253	Nitrospira sp.	70125	Bacteria	Bacteria	239	2.07e-58	NTclustered	gi\|2511631678\|gb\|CP126123.1\|	70125	g14362	i0	95.333	13.4322580645161	150	7	97	0	161	310	4131964	4132113	MAG: Nitrospira sp. isolate bin_003 chromosome, complete genome	blastn	4164	239	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4041295	4041295	PRJNA1111077_P_NODE_14884_length_310_cov_4.485232_g14663_i0	PRJNA1111077	14884	310	4.485232	13.9042192	Nitrospira sp.	70125	Bacteria	Bacteria	207	5.84e-49	NTclustered	gi\|2511631678\|gb\|CP126123.1\|	70125	g14663	i0	77.982	2.22258064516129	327	55	100	2	1	310	1697255	1697581	MAG: Nitrospira sp. isolate bin_003 chromosome, complete genome	blastn	689	207	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
6592920	6592920	PRJNA1111077_P_NODE_29646_length_252_cov_2.324022_g29425_i0	PRJNA1111077	29646	252	2.324022	5.85653544	Pseudomonadati	3379134	Bacteria	Bacteria	163	1.08e-46	NR	HNP42311.1	70125	g29425	i0	100	1.97619047619048	83	0	98.8	0	250	2	286	368	HNP42311.1 terminase family protein [Nitrospira sp.]	diamond	498	163	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
7867235	7867235	PRJNA1111077_P_NODE_16047_length_310_cov_2.413502_g15826_i0	PRJNA1111077	16047	310	2.413502	7.4818562	Nitrospira	1234	Bacteria	Bacteria	99	1.6400000000000001e-22	NR	TKB87193.1	70125	g15826	i0	73.1	4.51935483870968	67	18	64.8	0	203	3	99	165	TKB87193.1 MAG: sigma-54-dependent Fis family transcriptional regulator, partial [Nitrospira sp.]	diamond	1401	99	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19340501	19340501	PRJNA1111077_P_NODE_21496_length_282_cov_1.387560_g21275_i0	PRJNA1111077	21496	282	1.38756	3.9129192	Nitrospira sp.	70125	Bacteria	Bacteria	206	1.8899999999999994e-48	NTclustered	gi\|2511635996\|gb\|CP126122.1\|	70125	g21275	i0	80.597	0.950354609929078	268	50	95	2	2	268	1238004	1238270	MAG: Nitrospira sp. isolate bin_005 chromosome	blastn	268	206	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21891279	21891279	PRJNA1111077_P_NODE_14758_length_310_cov_5.172996_g14537_i0	PRJNA1111077	14758	310	5.172996	16.0362876	Nitrospira sp.	70125	Bacteria	Bacteria	90.9	1.02e-18	NR	MEP7151613.1	70125	g14537	i0	95.9	0.474193548387097	49	2	47.4	0	149	3	13	61	MEP7151613.1 CusA/CzcA family heavy metal efflux RND transporter [Nitrospira sp.]	diamond	147	90.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
25247571	25247571	PRJNA1111077_P_NODE_36920_length_240_cov_3.856287_g36699_i0	PRJNA1111077	36920	240	3.856287	9.2550888	Nitrospira	1234	Bacteria	Bacteria	438	1.4199999999999995e-118	NTclustered	gi\|2194436381\|gb\|CP092080.1\|	70125	g36699	i0	99.583	200.020833333333	240	1	100	0	1	240	1558720	1558959	MAG: Nitrospira sp. isolate UBC1 chromosome	blastn	48005	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26878189	26878189	PRJNA1111077_P_NODE_17321_length_298_cov_5.897778_g17100_i0	PRJNA1111077	17321	298	5.897778	17.57537844	Nitrospira sp.	70125	Bacteria	Bacteria	92.4	1.08e-20	NR	MCC2642014.1	70125	g17100	i0	79.2	0.533557046979866	53	11	53.4	0	159	1	79	131	MCC2642014.1 hypothetical protein [Nitrospira sp.]	diamond	159	92.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26941079	26941079	PRJNA1111077_P_NODE_15542_length_310_cov_2.962025_g15321_i0	PRJNA1111077	15542	310	2.962025	9.1822775	Nitrospira sp.	70125	Bacteria	Bacteria	97.4	5.28e-21	NR	MCC6966551.1	70125	g15321	i0	61.6	2.85483870967742	86	27	77.4	2	240	1	11	96	MCC6966551.1 SLBB domain-containing protein [Nitrospira sp.]	diamond	885	97.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27699912	27699912	PRJNA1111077_P_NODE_22224_length_279_cov_3.000000_g22003_i0	PRJNA1111077	22224	279	3	8.37	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	174	8.869999999999998e-54	NR	MBX9661008.1	2026770	g22003	i0	100	1	93	0	100	0	279	1	34	126	MBX9661008.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Nitrospiraceae bacterium]	diamond	279	174	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
28425906	28425906	PRJNA1111077_P_NODE_14646_length_310_cov_6.371308_g14425_i0	PRJNA1111077	14646	310	6.371308	19.7510548	Nitrospira sp.	70125	Bacteria	Bacteria	91.7	1.41e-20	NR	MCC2640289.1	70125	g14425	i0	91.1	0.541935483870968	56	5	54.2	0	143	310	74	129	MCC2640289.1 putative Outer rane chaperone Skp precursor [Nitrospira sp.]	diamond	168	91.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28764255	28764255	PRJNA1111077_P_NODE_15927_length_310_cov_2.578059_g15706_i0	PRJNA1111077	15927	310	2.578059	7.9919829	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	5.51e-10	NR	HEU4506352.1	70125	g15706	i0	66	1.91612903225806	47	16	45.5	0	308	168	46	92	HEU4506352.1 hypothetical protein [Nitrospira sp.]	diamond	594	64.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30375415	30375415	PRJNA1111077_P_NODE_16872_length_303_cov_4.373913_g16651_i0	PRJNA1111077	16872	303	4.373913	13.25295639	Nitrospira	1234	Bacteria	Bacteria	89.4	5.96e-21	NR	MBS0163339.1	70125	g16651	i0	91.8	0.97029702970297	49	4	48.5	0	3	149	30	78	MBS0163339.1 P-II family nitrogen regulator [Nitrospira sp.]	diamond	294	89.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31268484	31268484	PRJNA1111077_P_NODE_19995_length_287_cov_1.289720_g19774_i0	PRJNA1111077	19995	287	1.28972	3.7014964	Nitrospira sp.	70125	Bacteria	Bacteria	153	2.2699999999999993e-46	NR	MEP7152641.1	70125	g19774	i0	88.6	0.825783972125436	79	9	82.6	0	280	44	1	79	MEP7152641.1 CsbD family protein [Nitrospira sp.]	diamond	237	153	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31837612	31837612	PRJNA1111077_P_NODE_22837_length_277_cov_2.735294_g22616_i0	PRJNA1111077	22837	277	2.735294	7.57676438	Nitrospira defluvii	330214	Bacteria	Bacteria	169	1.59e-48	NR	MBI4000450.1	330214	g22616	i0	90.7	6.77978339350181	86	8	93.1	0	258	1	56	141	MBI4000450.1 ABC transporter substrate-binding protein [Nitrospira defluvii]	diamond	1878	169	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
32280980	32280980	PRJNA1111077_P_NODE_30219_length_251_cov_0.865169_g29998_i0	PRJNA1111077	30219	251	0.865169	2.17157419	Nitrospira sp.	70125	Bacteria	Bacteria	138	1.18e-35	NR	MBS0156140.1	70125	g29998	i0	78.3	0.99203187250996006	83	18	99.2	0	249	1	690	772	MBS0156140.1 hypothetical protein [Nitrospira sp.]	diamond	249	138	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32407396	32407396	PRJNA1111077_P_NODE_29019_length_255_cov_1.318681_g28798_i0	PRJNA1111077	29019	255	1.318681	3.36263655	Nitrospirota bacterium	2026887	Bacteria	Bacteria	43.1	0.00755	NR	MDH4162899.1	2026887	g28798	i0	39.1	0.541176470588235	46	28	54.1	0	254	117	53	98	MDH4162899.1 hypothetical protein [Nitrospirota bacterium]	diamond	138	43.1	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
32785817	32785817	PRJNA1111077_P_NODE_35020_length_244_cov_0.900585_g34799_i0	PRJNA1111077	35020	244	0.900585	2.1974274	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	158	1.41e-44	NR	MBX9661055.1	2026770	g34799	i0	98.8	0.983606557377049	80	1	98.4	0	242	3	180	259	MBX9661055.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	240	158	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae 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);;