RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA340009 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
392533 392533 PRJNA340009_P_NODE_69561_length_164_cov_0.886957_g69254_i0 PRJNA340009 69561 164 0.886957 1.45460948 Nitrospira sp. 70125 Bacteria Bacteria 231 1.6399999999999998e-56   NTclustered gi|1938802452|gb|CP054184.1| 70125 g69254 i0 92.547 1.97560975609756 161 12 98 0 3 163 3333018 3332858 MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome blastn 324 231 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
1666441 1666441 PRJNA340009_P_NODE_1142_length_874_cov_7.069091_g900_i0 PRJNA340009 1142 874 7.069091 61.78385534 Nitrospira sp. 70125 Bacteria Bacteria 444 1.2399999999999995e-119   NTclustered gi|2863125063|dbj|AP038805.1| 70125 g900 i0 83.507 0.835240274599542 479 76 54 2 132 607 98232 98710 MAG: Nitrospira sp. AFB01 DNA, complete genome blastn 730 444 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
2943194 2943194 PRJNA340009_P_NODE_73603_length_162_cov_0.902655_g73296_i0 PRJNA340009 73603 162 0.902655 1.4623011 Nitrospira sp. 70125 Bacteria Bacteria 206 9.78e-49   NTclustered gi|2194428397|gb|CP092079.1| 70125 g73296 i0 89.506 3.90123456790123 162 17 100 0 1 162 2563943 2563782 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 632 206 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
4219781 4219781 PRJNA340009_P_NODE_7044_length_417_cov_1.877717_g6737_i0 PRJNA340009 7044 417 1.877717 7.83007989 Nitrospira moscoviensis 42253 Bacteria Bacteria 654 0   NTclustered gi|922305621|gb|CP011801.1| 42253 g6737 i0 94.964 133.282973621103 417 21 100 0 1 417 1278301 1277885 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 55579 654 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis
6770098 6770098 PRJNA340009_P_NODE_66826_length_165_cov_0.879310_g66519_i0 PRJNA340009 66826 165 0.87931 1.4508615 Candidatus Manganitrophus sp. 2927580 Bacteria Bacteria 167 4.72e-37   NTclustered gi|2449738114|gb|CP114561.1| 2927580 g66519 i0 91.667 125.981818181818 120 10 87 0 25 144 862743 862862 MAG: Candidatus Manganitrophus sp. isolate GAC4 chromosome, complete genome blastn 20787 167 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Candidatus Troglogloeales Candidatus Manganitrophaceae Candidatus Manganitrophus Candidatus Manganitrophus sp.
8045647 8045647 PRJNA340009_P_NODE_58427_length_171_cov_2.434426_g58120_i0 PRJNA340009 58427 171 2.434426 4.16286846 Nitrospira sp. 70125 Bacteria Bacteria 226 7.969999999999998e-55   NTclustered gi|2194428397|gb|CP092079.1| 70125 g58120 i0 90.588 0.994152046783626 170 16 99 0 2 171 701994 701825 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 170 226 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
13146237 13146237 PRJNA340009_P_NODE_79091_length_156_cov_7.551402_g78784_i0 PRJNA340009 79091 156 7.551402 11.78018712 Thermodesulfovibrionales bacterium 2814272 Bacteria Bacteria 71.3 3.55e-8   NTclustered gi|2874253970|emb|OY970295.1| 2814272 g78784 i0 97.619 1.46153846153846 42 0 27 1 22 63 776394 776434 MAG: Thermodesulfovibrionales bacterium isolate MFD01299.bin.c.3 genome assembly, chromosome: 1 blastn 228 71.3 1 Bacteria   Pseudomonadati Nitrospirota Thermodesulfovibrionia Thermodesulfovibrionales     Thermodesulfovibrionales bacterium
16969391 16969391 PRJNA340009_P_NODE_24714_length_247_cov_1.186869_g24407_i0 PRJNA340009 24714 247 1.186869 2.93156643 Nitrospira sp. 70125 Bacteria Bacteria 436 5.279999999999999e-118   NTclustered gi|2194428397|gb|CP092079.1| 70125 g24407 i0 98.78 173.056680161943 246 2 99 1 1 246 2506845 2506601 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 42745 436 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
20793705 20793705 PRJNA340009_P_NODE_52077_length_180_cov_1.977099_g51770_i0 PRJNA340009 52077 180 1.977099 3.5587782 Candidatus Nitrospira kreftii 2652173 Bacteria Bacteria 110 8.93e-20   NTclustered gi|1884724763|gb|CP047423.1| 2652173 g51770 i0 82.927 0.683333333333333 123 19 67 2 60 180 1629780 1629658 Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome blastn 123 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Candidatus Nitrospira kreftii
23344100 23344100 PRJNA340009_P_NODE_3899_length_528_cov_4.592902_g3600_i0 PRJNA340009 3899 528 4.592902 24.25052256 Nitrospira sp. 70125 Bacteria Bacteria 638 3.13e-178   NTclustered gi|2194428397|gb|CP092079.1| 70125 g3600 i0 88.825 0.982954545454545 519 58 98 0 10 528 1343775 1344293 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 519 638 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24618116 24618116 PRJNA340009_P_NODE_23220_length_253_cov_2.000000_g22913_i0 PRJNA340009 23220 253 2 5.06 Nitrospira sp. 70125 Bacteria Bacteria 200 7.749999999999998e-47   NTclustered gi|2194428397|gb|CP092079.1| 70125 g22913 i0 81.377 1.24901185770751 247 44 98 2 1 247 1017992 1018236 MAG: Nitrospira sp. isolate UBC3 chromosome blastn 316 200 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
24618185 24618185 PRJNA340009_P_NODE_28840_length_231_cov_1.401099_g28533_i0 PRJNA340009 28840 231 1.401099 3.23653869 Nitrospira moscoviensis 42253 Bacteria Bacteria 388 1.39e-103   NTclustered gi|922305621|gb|CP011801.1| 42253 g28533 i0 96.97 258.264069264069 231 7 100 0 1 231 1278794 1278564 Nitrospira moscoviensis strain NSP M-1, complete genome blastn 59659 388 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira moscoviensis

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