RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB30004", 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 · 18 ✖

tax_kingdom 1

  • Pseudomonadati · 18 ✖

bioproject 1

  • PRJEB30004 · 18 ✖

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
5149969 5149969 PRJEB30004_P_NODE_544165_length_179_cov_2.814286_g528538_i0 PRJEB30004 544165 179 2.814286 5.03757194 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 105 5.0399999999999995e-25   NR RPH74917.1 2026770 g528538 i0 79.3 0.972067039106145 58 12 97.2 0 174 1 261 318 RPH74917.1 MAG: glycogen debranching enzyme, partial [Nitrospiraceae bacterium] diamond 174 105 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
5150286 5150286 PRJEB30004_P_NODE_550805_length_178_cov_1.266187_g535178_i0 PRJEB30004 550805 178 1.266187 2.25381286 Bacteria 2 Bacteria Bacteria 100 7.209999999999999e-23   NR MBS0156140.1 70125 g535178 i0 72.9 2.98314606741573 59 16 99.4 0 2 178 3290 3348 MBS0156140.1 hypothetical protein [Nitrospira sp.] diamond 531 100 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
7699844 7699844 PRJEB30004_P_NODE_544287_length_179_cov_2.600000_g528660_i0 PRJEB30004 544287 179 2.6 4.654 Nitrospira japonica 1325564 Bacteria Bacteria 113 6.860000000000001e-21   NTclustered gi|1167499077|emb|LT828648.1| 1325564 g528660 i0 81.618 78.4078212290503 136 25 76 0 1 136 315954 316089 Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I blastn 14035 113 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira japonica
26868746 26868746 PRJEB30004_P_NODE_530821_length_183_cov_1.423611_g515194_i0 PRJEB30004 530821 183 1.423611 2.60520813 Pseudomonadati 3379134 Bacteria Bacteria 67 1.5e-12   NR WP_213043643.1 1234 g515194 i0 58.2 3.32786885245902 55 23 90.2 0 19 183 1 55 WP_213043643.1 MULTISPECIES: hypothetical protein [Nitrospira] diamond 609 67 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira  
27791552 27791552 PRJEB30004_P_NODE_617444_length_163_cov_1.653226_g601817_i0 PRJEB30004 617444 163 1.653226 2.69475838 Nitrospira lenta 1436998 Bacteria Bacteria 106 2.95e-25   NR WP_121990529.1 1436998 g601817 i0 88.9 3.95705521472393 54 6 99.4 0 162 1 284 337 WP_121990529.1 oleate hydratase [Nitrospira lenta] diamond 645 106 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira lenta
27816688 27816688 PRJEB30004_P_NODE_689024_length_150_cov_1.477477_g673397_i0 PRJEB30004 689024 150 1.477477 2.2162155 Pseudomonadati 3379134 Bacteria Bacteria 73.6 1.38e-13   NR MBS0156140.1 70125 g673397 i0 70.8 1.94 48 14 96 0 148 5 1160 1207 MBS0156140.1 hypothetical protein [Nitrospira sp.] diamond 291 73.6 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28549407 28549407 PRJEB30004_P_NODE_467207_length_201_cov_2.987654_g451580_i0 PRJEB30004 467207 201 2.987654 6.00518454 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 87.4 1.15e-18   NR HET7058514.1 2026770 g451580 i0 70.8 0.970149253731343 65 19 97 0 2 196 69 133 HET7058514.1 hypothetical protein [Nitrospiraceae bacterium] diamond 195 87.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
28833342 28833342 PRJEB30004_P_NODE_420548_length_218_cov_2.469274_g404921_i0 PRJEB30004 420548 218 2.469274 5.38301732 Nitrospira sp. 70125 Bacteria Bacteria 106 8.72e-25   NR MBS0156140.1 70125 g404921 i0 73.2 0.977064220183486 71 19 97.7 0 6 218 781 851 MBS0156140.1 hypothetical protein [Nitrospira sp.] diamond 213 106 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
28896381 28896381 PRJEB30004_P_NODE_220148_length_353_cov_2.458599_g204521_i0 PRJEB30004 220148 353 2.458599 8.67885447 Nitrospira sp. 70125 Bacteria Bacteria 59.7 1.43e-7   NR HNP82742.1 70125 g204521 i0 54.4 0.960339943342776 57 25 47.6 1 173 6 4 60 HNP82742.1 hypothetical protein [Nitrospira sp.] diamond 339 59.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30816639 30816639 PRJEB30004_P_NODE_266254_length_307_cov_2.783582_g250627_i0 PRJEB30004 266254 307 2.783582 8.54559674 Bacteria 2 Bacteria Bacteria 92.8 2.01e-19   NR NJN71141.1 70125 g250627 i0 53.5 4.74918566775244 71 33 69.4 0 88 300 322 392 NJN71141.1 DUF1559 domain-containing protein [Nitrospira sp.] diamond 1458 93.2 0.995708154506438 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30918118 30918118 PRJEB30004_P_NODE_440174_length_211_cov_1.470930_g424547_i0 PRJEB30004 440174 211 1.47093 3.1036623 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 77.4 3.91e-15   NR MSQ77581.1 2026770 g424547 i0 63.8 4.90521327014218 69 25 98.1 0 3 209 148 216 MSQ77581.1 hypothetical protein [Nitrospiraceae bacterium] diamond 1035 77.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31138792 31138792 PRJEB30004_P_NODE_612775_length_164_cov_1.640000_g597148_i0 PRJEB30004 612775 164 1.64 2.6896 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 45.4 0.00142   NR HKN86499.1 2026770 g597148 i0 57.5 0.731707317073171 40 13 65.9 1 111 4 7 46 HKN86499.1 trypsin-like peptidase domain-containing protein [Nitrospiraceae bacterium] diamond 120 45.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31480768 31480768 PRJEB30004_P_NODE_340596_length_256_cov_2.396313_g324969_i0 PRJEB30004 340596 256 2.396313 6.13456128 Pseudomonadati 3379134 Bacteria Bacteria 139 1.9799999999999997e-37   NR HEV2172866.1 70125 g324969 i0 74.7 3.703125 79 20 92.6 0 2 238 326 404 HEV2172866.1 epoxide hydrolase [Nitrospira sp.] diamond 948 140 0.992857142857143 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
31512296 31512296 PRJEB30004_P_NODE_579976_length_171_cov_1.553030_g564349_i0 PRJEB30004 579976 171 1.55303 2.6556813 Nitrospira 1234 Bacteria Bacteria 90.5 2.17e-19   NR MBS0156140.1 70125 g564349 i0 73.7 1.92982456140351 57 15 100 0 171 1 990 1046 MBS0156140.1 hypothetical protein [Nitrospira sp.] diamond 330 90.9 0.995599559955996 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32681821 32681821 PRJEB30004_P_NODE_665500_length_154_cov_1.486957_g649873_i0 PRJEB30004 665500 154 1.486957 2.28991378 Pseudomonadati 3379134 Bacteria Bacteria 59.7 6.22e-9   NR MDR4460151.1 2358460 g649873 i0 62.5 6.40909090909091 48 18 93.5 0 152 9 164 211 MDR4460151.1 restriction endonuclease [Nitrospirales bacterium] diamond 987 59.7 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales     Nitrospirales bacterium
32720124 32720124 PRJEB30004_P_NODE_524360_length_185_cov_1.123288_g508733_i0 PRJEB30004 524360 185 1.123288 2.0780828 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 52.8 4.9099999999999996e-06   NR HET9395990.1 2026770 g508733 i0 81.5 1.31351351351351 27 5 43.8 0 81 1 1 27 HET9395990.1 PAS domain-containing protein [Nitrospiraceae bacterium] diamond 243 52.8 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32845986 32845986 PRJEB30004_P_NODE_477460_length_198_cov_1.911950_g461833_i0 PRJEB30004 477460 198 1.91195 3.785661 Candidatus Manganitrophaceae bacterium 2932367 Bacteria Bacteria 43.1 0.0129   NR TAK00757.1 2932367 g461833 i0 47.1 0.772727272727273 51 22 77.3 1 4 156 168 213 TAK00757.1 MAG: DUF998 domain-containing protein, partial [Candidatus Manganitrophaceae bacterium] diamond 153 43.1 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae   Candidatus Manganitrophaceae bacterium
32877489 32877489 PRJEB30004_P_NODE_688100_length_150_cov_1.693694_g672473_i0 PRJEB30004 688100 150 1.693694 2.540541 Nitrospira sp. 70125 Bacteria Bacteria 62 1.7e-9   NR MBS0156140.1 70125 g672473 i0 64.6 0.96 48 13 96 1 150 7 857 900 MBS0156140.1 hypothetical protein [Nitrospira sp.] diamond 144 62 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);;