RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA703759", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 16 ✖

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJNA703759 · 16 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
18536573 18536573 PRJNA703759_P_NODE_48575_length_243_cov_1.729412_g48099_i0 PRJNA703759 48575 243 1.729412 4.20247116 FCB group 1783270 Bacteria Bacteria 108 3.44e-25   NR HEU4683897.1 70125 g48099 i0 66.3 8.88888888888889 80 27 98.8 0 241 2 453 532 HEU4683897.1 glycogen debranching N-terminal domain-containing protein [Nitrospira sp.] diamond 2160 108 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
21086713 21086713 PRJNA703759_P_NODE_27057_length_277_cov_1.274510_g26581_i0 PRJNA703759 27057 277 1.27451 3.5303927 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 281 2.99e-71   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g26581 i0 86.853 91.4259927797834 251 33 91 0 1 251 98842 98592 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 25325 281 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
27019552 27019552 PRJNA703759_P_NODE_16142_length_338_cov_1.766038_g15666_i0 PRJNA703759 16142 338 1.766038 5.96920844 Nitrospiria bacterium 2306052 Bacteria Bacteria 63.5 5.35e-9   NR HEY5648818.1 2306052 g15666 i0 41.3 1.42011834319527 80 43 71 1 3 242 182 257 HEY5648818.1 M48 family metalloprotease [Nitrospiria bacterium] diamond 480 63.5 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria       Nitrospiria bacterium
27304204 27304204 PRJNA703759_P_NODE_6643_length_547_cov_2.841772_g6167_i0 PRJNA703759 6643 547 2.841772 15.54449284 Nitrospira sp. 70125 Bacteria Bacteria 162 1.56e-42   NR MCA9469495.1 70125 g6167 i0 49.5 2.04570383912249 184 86 99.8 4 547 2 416 594 MCA9469495.1 ATP-binding protein [Nitrospira sp.] diamond 1119 162 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
27441843 27441843 PRJNA703759_P_NODE_35543_length_252_cov_1.720670_g35067_i0 PRJNA703759 35543 252 1.72067 4.3360884 Pseudomonadati 3379134 Bacteria Bacteria 139 3.1500000000000004e-36   NR MCA9469495.1 70125 g35067 i0 72.6 11 84 23 100 0 1 252 343 426 MCA9469495.1 ATP-binding protein [Nitrospira sp.] diamond 2772 140 0.992857142857143 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28882741 28882741 PRJNA703759_P_NODE_30228_length_266_cov_1.383420_g29752_i0 PRJNA703759 30228 266 1.38342 3.6798972 Nitrospirota bacterium 2026887 Bacteria Bacteria 109 1.56e-25   NR MEK6684577.1 2026887 g29752 i0 70.7 0.845864661654135 75 22 84.6 0 266 42 497 571 MEK6684577.1 alkaline phosphatase family protein [Nitrospirota bacterium] diamond 225 109 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
28977743 28977743 PRJNA703759_P_NODE_52508_length_227_cov_2.240260_g52032_i0 PRJNA703759 52508 227 2.24026 5.0853902 Nitrospira sp. 70125 Bacteria Bacteria 120 8.869999999999999e-31   NR MCA9469494.1 70125 g52032 i0 72 0.991189427312775 75 21 99.1 0 227 3 194 268 MCA9469494.1 DNA (cytosine-5-)-methyltransferase [Nitrospira sp.] diamond 225 120 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30093741 30093741 PRJNA703759_P_NODE_24452_length_287_cov_1.359813_g23976_i0 PRJNA703759 24452 287 1.359813 3.90266331 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.61e-4   NR MCI0428832.1 2026770 g23976 i0 70.4 0.564459930313589 27 8 28.2 0 283 203 408 434 MCI0428832.1 hypothetical protein [Nitrospiraceae bacterium] diamond 162 50.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30283936 30283936 PRJNA703759_P_NODE_51612_length_241_cov_2.190476_g51136_i0 PRJNA703759 51612 241 2.190476 5.27904716 Nitrospira 1234 Bacteria Bacteria 69.7 1.07e-11   NR MDR4472417.1 70125 g51136 i0 50 4.0954356846473 60 30 74.7 0 241 62 73 132 MDR4472417.1 response regulator [Nitrospira sp.] diamond 987 70.1 0.994293865905849 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30430720 30430720 PRJNA703759_P_NODE_16153_length_338_cov_1.630189_g15677_i0 PRJNA703759 16153 338 1.630189 5.51003882 Nitrospirota bacterium 2026887 Bacteria Bacteria 47.8 3.55e-4   NR MBI4847544.1 2026887 g15677 i0 56.1 0.363905325443787 41 18 36.4 0 214 336 8 48 MBI4847544.1 helix-turn-helix domain-containing protein [Nitrospirota bacterium] diamond 123 47.8 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
30504770 30504770 PRJNA703759_P_NODE_41793_length_248_cov_0.891429_g41317_i0 PRJNA703759 41793 248 0.891429 2.21074392 Nitrospira 1234 Bacteria Bacteria 160 6.559999999999999e-48   NR HEU5201343.1 70125 g41317 i0 100 2.9758064516129 82 0 99.2 0 1 246 69 150 HEU5201343.1 response regulator [Nitrospira sp.] diamond 738 160 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30746291 30746291 PRJNA703759_P_NODE_15094_length_348_cov_1.832727_g14618_i0 PRJNA703759 15094 348 1.832727 6.37788996 uncultured Nitrospira sp. 157176 Bacteria Bacteria 122 3.4299999999999996e-31   NR WP_342347897.1 157176 g14618 i0 83.1 1.12068965517241 65 11 56 0 154 348 1 65 WP_342347897.1 Ku protein [uncultured Nitrospira sp.] diamond 390 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira uncultured Nitrospira sp.
31547907 31547907 PRJNA703759_P_NODE_51096_length_242_cov_0.923077_g50620_i0 PRJNA703759 51096 242 0.923077 2.23384634 Nitrospira 1234 Bacteria Bacteria 110 9e-28   NR MCI0526011.1 70125 g50620 i0 64.2 1.98347107438017 81 28 99.2 1 241 2 101 181 MCI0526011.1 septal ring lytic transglycosylase RlpA family protein [Nitrospira sp.] diamond 480 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31757933 31757933 PRJNA703759_P_NODE_36917_length_251_cov_1.747191_g36441_i0 PRJNA703759 36917 251 1.747191 4.38544941 Candidatus Manganitrophaceae bacterium 2932367 Bacteria Bacteria 148 2.33e-39   NR HZR47310.1 2932367 g36441 i0 79.3 1.93625498007968 82 17 98 0 248 3 231 312 HZR47310.1 ABC transporter substrate-binding protein [Candidatus Manganitrophaceae bacterium] diamond 486 148 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae   Candidatus Manganitrophaceae bacterium
32422402 32422402 PRJNA703759_P_NODE_37999_length_251_cov_0.876404_g37523_i0 PRJNA703759 37999 251 0.876404 2.19977404 Candidatus Magnetobacterium casense 1455061 Bacteria Bacteria 51.2 4.37e-5   NR WP_040335292.1 1455061 g37523 i0 31.8 0.788844621513944 66 45 78.9 0 51 248 2227 2292 WP_040335292.1 LPD38 domain-containing protein [Candidatus Magnetobacterium casense] diamond 198 51.2 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales Candidatus Magnetobacteriaceae Candidatus Magnetobacterium Candidatus Magnetobacterium casense
32706331 32706331 PRJNA703759_P_NODE_12020_length_387_cov_1.461783_g11544_i0 PRJNA703759 12020 387 1.461783 5.65710021 Nitrospira sp. 70125 Bacteria Bacteria 179 5.99e-53   NR MEP7153597.1 70125 g11544 i0 63.1 2.96124031007752 130 47 100 1 387 1 56 185 MEP7153597.1 alpha/beta hydrolase [Nitrospira sp.] diamond 1146 179 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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