metadata: contig_metadata: 17 rows where bioproject = "PRJNA753704", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA753704", 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
730986	730986	PRJNA753704_P_NODE_21681_length_262_cov_1.941799_g21320_i0	PRJNA753704	21681	262	1.941799	5.08751338	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	335	2.119999999999999e-87	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g21320	i0	90.272	13.408396946564901	257	23	98	2	1	256	3549419	3549674	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	3513	335	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
2007115	2007115	PRJNA753704_P_NODE_25322_length_249_cov_0.886364_g24961_i0	PRJNA753704	25322	249	0.886364	2.20704636	Nitrospira tepida	2973512	Bacteria	Bacteria	193	1.27e-44	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g24961	i0	93.798	52.3052208835341	129	7	51	1	108	235	1825662	1825534	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	13024	193	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
4559474	4559474	PRJNA753704_P_NODE_20564_length_268_cov_2.994872_g20203_i0	PRJNA753704	20564	268	2.994872	8.02625696	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	348	2.79e-91	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g20203	i0	96.226	25.160447761194	212	8	79	0	57	268	3603892	3604103	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	6743	348	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
5834735	5834735	PRJNA753704_P_NODE_29285_length_235_cov_2.765432_g28924_i0	PRJNA753704	29285	235	2.765432	6.4987652	Nitrospira tepida	2973512	Bacteria	Bacteria	206	1.53e-48	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g28924	i0	82.937	90.2085106382979	252	20	99	13	1	233	1318240	1317993	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	21199	206	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
11405851	11405851	PRJNA753704_P_NODE_20449_length_269_cov_1.591837_g20088_i0	PRJNA753704	20449	269	1.591837	4.28204153	Nitrospira	1234	Bacteria	Bacteria	438	1.6199999999999996e-118	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g20088	i0	96.935	147.568773234201	261	8	97	0	1	261	1277851	1277591	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	39696	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
12210477	12210477	PRJNA753704_P_NODE_15870_length_301_cov_5.057018_g15509_i0	PRJNA753704	15870	301	5.057018	15.22162418	Nitrospira tepida	2973512	Bacteria	Bacteria	435	2.38e-117	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g15509	i0	92.691	258.016611295681	301	22	100	0	1	301	1826256	1826556	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	77663	435	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
12210684	12210684	PRJNA753704_P_NODE_6490_length_453_cov_1.231579_g6129_i0	PRJNA753704	6490	453	1.231579	5.57905287	Candidatus Manganitrophaceae bacterium	2932367	Bacteria	Bacteria	196	1.92e-45	NTclustered	gi\|2874254047\|emb\|OY970371.1\|	2932367	g6129	i0	85.052	63.3399558498896	194	27	43	2	261	453	2246916	2247108	MAG: Candidatus Manganitrophaceae bacterium isolate MFD03066.bin.c.2 genome assembly, chromosome: 1	blastn	28693	196	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Candidatus Troglogloeales	Candidatus Manganitrophaceae		Candidatus Manganitrophaceae bacterium
13484756	13484756	PRJNA753704_P_NODE_1431_length_913_cov_4.779762_g1126_i0	PRJNA753704	1431	913	4.779762	43.63922706	Nitrospira tepida	2973512	Bacteria	Bacteria	1445	0	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g1126	i0	95.28	132.812705366922	911	43	99	0	1	911	1826757	1827667	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	121258	1445	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
19053792	19053792	PRJNA753704_P_NODE_2295_length_722_cov_2.305085_g1960_i0	PRJNA753704	2295	722	2.305085	16.6427137	Thermodesulfovibrio	28261	Bacteria	Bacteria	56.5	0.006	NTclustered	gi\|470483621\|ref\|NR_076603.1\|	28262	g1960	i0	92.5	1.62049861495845	40	2	6	1	673	712	522	484	Thermodesulfovibrio yellowstonii strain YP87 23S ribosomal RNA gene, complete sequence	blastn	1170	56.5	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Thermodesulfovibrionaceae	Thermodesulfovibrio	Thermodesulfovibrio yellowstonii
21133574	21133574	PRJNA753704_P_NODE_18857_length_279_cov_1.514563_g18496_i0	PRJNA753704	18857	279	1.514563	4.22563077	Nitrospira tepida	2973512	Bacteria	Bacteria	477	3.5799999999999985e-130	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g18496	i0	97.491	244.598566308244	279	7	100	0	1	279	1828014	1828292	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	68243	477	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
24153667	24153667	PRJNA753704_P_NODE_17339_length_289_cov_3.412037_g16978_i0	PRJNA753704	17339	289	3.412037	9.86078693	Nitrospira	1234	Bacteria	Bacteria	484	2.2299999999999998e-132	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g16978	i0	96.886	17.8754325259516	289	9	100	0	1	289	2738131	2737843	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	5166	484	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
26682782	26682782	PRJNA753704_P_NODE_24721_length_250_cov_0.881356_g24360_i0	PRJNA753704	24721	250	0.881356	2.20339	Nitrospira	1234	Bacteria	Bacteria	131	2.42e-35	NR	WP_086426417.1	96242	g24360	i0	83.1	1.848	77	13	92.4	0	1	231	215	291	WP_086426417.1 Mrp/NBP35 family ATP-binding protein [Nitrospira cf. moscoviensis SBR1015]	diamond	462	131	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira cf. moscoviensis SBR1015
26768073	26768073	PRJNA753704_P_NODE_25301_length_249_cov_0.886364_g24940_i0	PRJNA753704	25301	249	0.886364	2.20704636	Nitrospira sp.	70125	Bacteria	Bacteria	151	2.88e-42	NR	MEZ4244304.1	70125	g24940	i0	92.7	0.987951807228916	82	6	98.8	0	248	3	138	219	MEZ4244304.1 dihydroxy-acid dehydratase [Nitrospira sp.]	diamond	246	151	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30274343	30274343	PRJNA753704_P_NODE_25172_length_249_cov_0.886364_g24811_i0	PRJNA753704	25172	249	0.886364	2.20704636	Nitrospira sp. BO4	2944935	Bacteria	Bacteria	45.8	0.00258	NR	MDK2741970.1	2944935	g24811	i0	42.9	0.674698795180723	56	31	67.5	1	82	249	3	57	MDK2741970.1 hypothetical protein [Nitrospira sp. BO4]	diamond	168	45.8	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. BO4
30306150	30306150	PRJNA753704_P_NODE_26492_length_246_cov_0.901734_g26131_i0	PRJNA753704	26492	246	0.901734	2.21826564	Nitrospira sp. WS110	2039811	Bacteria	Bacteria	136	2.7599999999999997e-37	NR	NGZ96292.1	2039811	g26131	i0	82.9	1.98780487804878	82	14	100	0	1	246	187	268	NGZ96292.1 NAD-dependent dehydratase [Nitrospira sp. WS110]	diamond	489	136	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. WS110
31032639	31032639	PRJNA753704_P_NODE_4275_length_544_cov_2.450106_g3916_i0	PRJNA753704	4275	544	2.450106	13.32857664	Nitrospira sp.	70125	Bacteria	Bacteria	190	1.35e-56	NR	HNA85763.1	70125	g3916	i0	53	0.998161764705882	181	85	99.8	0	544	2	5	185	HNA85763.1 hypothetical protein [Nitrospira sp.]	diamond	543	190	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31095492	31095492	PRJNA753704_P_NODE_24635_length_250_cov_1.683616_g24274_i0	PRJNA753704	24635	250	1.683616	4.20904	Nitrospira sp. WS238	2039812	Bacteria	Bacteria	123	4.41e-31	NR	NGZ03672.1	2039812	g24274	i0	96.8	0.756	63	2	75.6	0	190	2	1	63	NGZ03672.1 adenylosuccinate lyase [Nitrospira sp. WS238]	diamond	189	123	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. WS238

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