RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA206070" 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

  • PRJNA206070 · 12 ✖

analysis 1

  • diamond · 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
23318795 23318795 PRJNA206070_S_NODE_9599_length_396_cov_3.359331_g7726_i0 PRJNA206070 9599 396 3.359331 13.30295076 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 122 1.67e-33   NR MBX9660014.1 2026770 g7726 i0 93.7 0.477272727272727 63 4 47.7 0 343 155 22 84 MBX9660014.1 hypothetical protein [Nitrospiraceae bacterium] diamond 189 122 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
28242367 28242367 PRJNA206070_S_NODE_16426_length_244_cov_2.816425_g14550_i0 PRJNA206070 16426 244 2.816425 6.872077 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 166 1.93e-46   NR MBX9661385.1 2026770 g14550 i0 100 0.995901639344262 81 0 99.6 0 2 244 479 559 MBX9661385.1 DUF2326 domain-containing protein [Nitrospiraceae bacterium] diamond 243 166 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
29599959 29599959 PRJNA206070_S_NODE_14570_length_272_cov_1.982979_g12694_i0 PRJNA206070 14570 272 1.982979 5.39370288 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 84 1.67e-16   NR MBX9661385.1 2026770 g12694 i0 100 0.463235294117647 42 0 46.3 0 1 126 557 598 MBX9661385.1 DUF2326 domain-containing protein [Nitrospiraceae bacterium] diamond 126 84 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30705751 30705751 PRJNA206070_S_NODE_17054_length_236_cov_3.527638_g15178_i0 PRJNA206070 17054 236 3.527638 8.32522568 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 166 9.17e-49   NR MBX9661383.1 2026770 g15178 i0 100 0.991525423728814 78 0 99.2 0 3 236 48 125 MBX9661383.1 hypothetical protein [Nitrospiraceae bacterium] diamond 234 166 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30737327 30737327 PRJNA206070_S_NODE_12654_length_309_cov_2.716912_g10778_i0 PRJNA206070 12654 309 2.716912 8.39525808 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 193 9.59e-59   NR MBX9659115.1 2026770 g10778 i0 100 1 103 0 100 0 1 309 228 330 MBX9659115.1 hypothetical protein [Nitrospiraceae bacterium] diamond 309 193 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
30832203 30832203 PRJNA206070_S_NODE_10674_length_360_cov_3.300310_g8799_i0 PRJNA206070 10674 360 3.30031 11.881116 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 218 1.33e-65   NR MBX9661385.1 2026770 g8799 i0 100 0.991666666666667 119 0 99.2 0 3 359 367 485 MBX9661385.1 DUF2326 domain-containing protein [Nitrospiraceae bacterium] diamond 357 218 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31970492 31970492 PRJNA206070_S_NODE_16218_length_247_cov_2.409524_g14342_i0 PRJNA206070 16218 247 2.4095240000000002 5.95152428 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 165 3.0699999999999997e-48   NR MBX9661383.1 2026770 g14342 i0 100 0.995951417004049 82 0 99.6 0 2 247 196 277 MBX9661383.1 hypothetical protein [Nitrospiraceae bacterium] diamond 246 165 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
31970508 31970508 PRJNA206070_S_NODE_5618_length_658_cov_3.357488_g3811_i0 PRJNA206070 5618 658 3.357488 22.09227104 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 168 6.97e-45   NR MBX9661385.1 2026770 g3811 i0 100 0.39209726443769 86 0 39.2 0 260 3 1 86 MBX9661385.1 DUF2326 domain-containing protein [Nitrospiraceae bacterium] diamond 258 168 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32065404 32065404 PRJNA206070_S_NODE_13238_length_297_cov_2.984615_g11362_i0 PRJNA206070 13238 297 2.984615 8.86430655 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 182 3.29e-52   NR MBX9661385.1 2026770 g11362 i0 100 0.98989898989899 98 0 99 0 296 3 272 369 MBX9661385.1 DUF2326 domain-containing protein [Nitrospiraceae bacterium] diamond 294 182 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32350431 32350431 PRJNA206070_S_NODE_16979_length_237_cov_2.720000_g15103_i0 PRJNA206070 16979 237 2.72 6.4464 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 147 2.399999999999999e-41   NR MBX9659115.1 2026770 g15103 i0 100 0.987341772151899 78 0 98.7 0 236 3 156 233 MBX9659115.1 hypothetical protein [Nitrospiraceae bacterium] diamond 234 147 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32634391 32634391 PRJNA206070_S_NODE_12020_length_323_cov_3.527972_g10144_i0 PRJNA206070 12020 323 3.527972 11.39534956 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 127 1.19e-34   NR MBX9661387.1 2026770 g10144 i0 98.5 0.603715170278638 65 1 60.4 0 128 322 1 65 MBX9661387.1 hypothetical protein [Nitrospiraceae bacterium] diamond 195 127 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium
32729161 32729161 PRJNA206070_S_NODE_16000_length_250_cov_3.661972_g14124_i0 PRJNA206070 16000 250 3.661972 9.15493 Nitrospiraceae bacterium 2026770 Bacteria Bacteria 164 4.52e-48   NR MBX9661383.1 2026770 g14124 i0 100 0.996 83 0 99.6 0 2 250 120 202 MBX9661383.1 hypothetical protein [Nitrospiraceae bacterium] diamond 249 164 1 Bacteria   Pseudomonadati Nitrospirota Nitrospiria Nitrospirales Nitrospiraceae   Nitrospiraceae bacterium

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