RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1158727" and tax_phylum = "Nitrospirota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrospirota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1158727 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
27261689 27261689 PRJNA1158727_P_NODE_160363_length_242_cov_0.911243_g152901_i0 PRJNA1158727 160363 242 0.911243 2.20520806 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 163 4.67e-47   NR MBX9659041.1 2026770 g152901 i0 98.8 1.98347107438017 80 1 99.2 0 240 1 124 203 MBX9659041.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Nitrospiraceae bacterium] diamond 480 163 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
27388182 27388182 PRJNA1158727_P_NODE_141843_length_249_cov_0.875000_g134381_i0 PRJNA1158727 141843 249 0.875 2.17875 Nitrospirota bacterium 2026887 Bacteria Bacteria 53.1 7.07e-6   NR MBU6483083.1 2026887 g134381 i0 44.3 3.32530120481928 70 38 83.1 1 12 218 201 270 MBU6483083.1 glycosyltransferase [Nitrospirota bacterium] diamond 828 53.1 1 Bacteria   Pseudomonadati Nitrospirota         Nitrospirota bacterium
27861486 27861486 PRJNA1158727_P_NODE_114265_length_274_cov_1.532338_g106804_i0 PRJNA1158727 114265 274 1.532338 4.19860612 Nitrospira sp. 70125 Bacteria Bacteria 99.4 1.1799999999999999e-23   NR MEQ1627049.1 70125 g106804 i0 100 0.514598540145985 47 0 51.5 0 133 273 1 47 MEQ1627049.1 hypothetical protein [Nitrospira sp.] diamond 141 99.4 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
29439996 29439996 PRJNA1158727_P_NODE_148010_length_246_cov_1.554913_g140548_i0 PRJNA1158727 148010 246 1.554913 3.82508598 Nitrospira sp. 70125 Bacteria Bacteria 110 3.39e-27   NR MBH0192386.1 70125 g140548 i0 100 0.682926829268293 56 0 68.3 0 245 78 214 269 MBH0192386.1 hypothetical protein [Nitrospira sp.] diamond 168 110 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30040331 30040331 PRJNA1158727_P_NODE_156651_length_243_cov_0.905882_g149189_i0 PRJNA1158727 156651 243 0.905882 2.20129326 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 87 9.42e-18   NR HAM52220.1 2026770 g149189 i0 55.1 0.851851851851852 69 31 85.2 0 35 241 450 518 HAM52220.1 hypothetical protein [Nitrospiraceae bacterium] diamond 207 87 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30198087 30198087 PRJNA1158727_P_NODE_131632_length_254_cov_1.701657_g124171_i0 PRJNA1158727 131632 254 1.701657 4.32220878 Nitrospira defluvii 330214 Bacteria Bacteria 74.3 3.140000000000001e-13   NR WP_213042236.1 330214 g124171 i0 100 0.413385826771654 35 0 41.3 0 253 149 479 513 WP_213042236.1 hypothetical protein [Nitrospira defluvii] diamond 105 74.3 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira defluvii
30470611 30470611 PRJNA1158727_P_NODE_146713_length_247_cov_0.885057_g139251_i0 PRJNA1158727 146713 247 0.885057 2.18609079 Nitrospira 1234 Bacteria Bacteria 163 6.72e-47   NR MBL8037992.1 70125 g139251 i0 93.8 11.8056680161943 81 5 98.4 0 3 245 160 240 MBL8037992.1 FIST C-terminal domain-containing protein [Nitrospira sp.] diamond 2916 163 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30881123 30881123 PRJNA1158727_P_NODE_160414_length_242_cov_0.911243_g152952_i0 PRJNA1158727 160414 242 0.911243 2.20520806 Nitrospira 1234 Bacteria Bacteria 146 3.77e-41   NR MBH0177984.1 70125 g152952 i0 93.8 2.97520661157025 80 5 99.2 0 241 2 83 162 MBH0177984.1 ABC transporter substrate-binding protein [Nitrospira sp.] diamond 720 147 0.993197278911565 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
30912961 30912961 PRJNA1158727_P_NODE_163914_length_241_cov_0.916667_g156452_i0 PRJNA1158727 163914 241 0.916667 2.20916747 Pseudomonadati 3379134 Bacteria Bacteria 60.8 1.03e-9   NR NGZ08543.1 2039809 g156452 i0 57.1 1.50622406639004 56 20 68.5 2 181 17 11 63 NGZ08543.1 hypothetical protein [Nitrospira sp. LK70] diamond 363 61.2 0.993464052287582 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp. LK70
31019852 31019852 PRJNA1158727_P_NODE_112875_length_276_cov_1.172414_g105414_i0 PRJNA1158727 112875 276 1.172414 3.23586264 Nitrospira sp. 70125 Bacteria Bacteria 43.9 0.0128   NR HNG00894.1 70125 g105414 i0 32.2 1.85869565217391 90 61 97.8 0 3 272 81 170 HNG00894.1 hypothetical protein [Nitrospira sp.] diamond 513 43.9 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae Nitrospira Nitrospira sp.
32379961 32379961 PRJNA1158727_P_NODE_153159_length_244_cov_1.801170_g145697_i0 PRJNA1158727 153159 244 1.80117 4.3948548 Nitrospira sp. 70125 Bacteria Bacteria 132 1e-34   NR MEI8016501.1 70125 g145697 i0 85 0.983606557377049 80 12 98.4 0 242 3 146 225 MEI8016501.1 ISL3 family transposase [Nitrospira sp.] diamond 240 132 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);;