RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Colwelliibacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Candidatus Colwelliibacteriota · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA1148190 · 14 ✖

analysis 1

tax_kingdom 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
9227814 9227814 PRJNA1148190_P_NODE_755348_length_242_cov_1.455621_g744175_i0 PRJNA1148190 755348 242 1.455621 3.52260282 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 110 3.3100000000000004e-26   NR HOB90292.1 2750074 g744175 i0 66.3 0.991735537190083 80 27 99.2 0 3 242 53 132 HOB90292.1 hypothetical protein [Candidatus Colwellbacteria bacterium] diamond 240 110 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
11772573 11772573 PRJNA1148190_P_NODE_31490_length_1239_cov_2.420240_g21725_i0 PRJNA1148190 31490 1239 2.42024 29.9867736 Bacteria 2 Bacteria Bacteria 408 1.25e-136   NR PIR98710.1 1974539 g21725 i0 55.6 12.1476997578692 354 152 85.7 2 1064 3 6 354 PIR98710.1 MAG: methionine--tRNA ligase, partial [Candidatus Colwellbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_28] diamond 15051 410 0.995121951219512 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_41_28
26913423 26913423 PRJNA1148190_P_NODE_727642_length_244_cov_0.900585_g716469_i0 PRJNA1148190 727642 244 0.900585 2.1974274 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 73.9 3.61e-13   NR MDD5099269.1 2750074 g716469 i0 50.7 0.872950819672131 71 35 87.3 0 242 30 181 251 MDD5099269.1 hypothetical protein [Candidatus Colwellbacteria bacterium] diamond 213 73.9 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
28334943 28334943 PRJNA1148190_P_NODE_709486_length_245_cov_0.895349_g698313_i0 PRJNA1148190 709486 245 0.895349 2.19360505 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 125 5.6e-33   NR MDD5099139.1 2750074 g698313 i0 76.3 5.93877551020408 80 19 98 0 243 4 128 207 MDD5099139.1 transglycosylase domain-containing protein [Candidatus Colwellbacteria bacterium] diamond 1455 125 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
28366290 28366290 PRJNA1148190_P_NODE_667906_length_247_cov_0.885057_g656733_i0 PRJNA1148190 667906 247 0.885057 2.18609079 Candidatus Colwellbacteria bacterium RIFCSPLOWO2_ 2750074 Bacteria Bacteria 133 6.14e-34   NR OGY59928.1 1797690 g656733 i0 81.9 1.0080971659919 83 14 99.6 1 247 2 420 502 OGY59928.1 MAG: hypothetical protein A3B23_02140 [Candidatus Colwellbacteria bacterium RIFCSPLOWO2_01_FULL_48_10] diamond 249 133 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium RIFCSPLOWO2_01_FULL_48_10
28934197 28934197 PRJNA1148190_P_NODE_264668_length_336_cov_1.171103_g253497_i0 PRJNA1148190 264668 336 1.171103 3.93490608 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 65.1 1.53e-9   NR HOB90249.1 2750074 g253497 i0 29.5 1.08928571428571 122 75 99.1 1 3 335 296 417 HOB90249.1 phage tail tape measure protein [Candidatus Colwellbacteria bacterium] diamond 366 65.1 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
28965977 28965977 PRJNA1148190_P_NODE_351808_length_300_cov_1.017621_g340635_i0 PRJNA1148190 351808 300 1.017621 3.052863 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 79.7 6.33e-17   NR MDD4930854.1 2750074 g340635 i0 43.7 0.87 87 49 87 0 3 263 12 98 MDD4930854.1 PQ-loop domain-containing transporter [Candidatus Colwellbacteria bacterium] diamond 261 79.7 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
29249746 29249746 PRJNA1148190_P_NODE_290589_length_324_cov_1.119522_g279418_i0 PRJNA1148190 290589 324 1.119522 3.62725128 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 46.2 0.00533   NR MCR4261111.1 2750074 g279418 i0 60.5 0.351851851851852 38 14 34.3 1 111 1 191 228 MCR4261111.1 hypothetical protein [Candidatus Colwellbacteria bacterium] diamond 114 46.2 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
30407566 30407566 PRJNA1148190_P_NODE_71593_length_657_cov_1.479452_g60501_i0 PRJNA1148190 71593 657 1.479452 9.71999964 Bacteria 2 Bacteria Bacteria 140 9.329999999999999e-35   NR OGY61072.1 1797692 g60501 i0 66.7 12.8356164383562 99 33 45.2 0 134 430 475 573 OGY61072.1 MAG: hypothetical protein A3I33_00350 [Candidatus Colwellbacteria bacterium RIFCSPLOWO2_02_FULL_45_11] diamond 8433 141 0.99290780141844 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium RIFCSPLOWO2_02_FULL_45_11
30514073 30514073 PRJNA1148190_P_NODE_755473_length_242_cov_1.437870_g744300_i0 PRJNA1148190 755473 242 1.43787 3.4796454 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 84 1.48e-17   NR MBI3273918.1 2750074 g744300 i0 64.4 3.07438016528926 59 21 73.1 0 241 65 178 236 MBI3273918.1 HAD family phosphatase [Candidatus Colwellbacteria bacterium] diamond 744 84 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
30798029 30798029 PRJNA1148190_P_NODE_563774_length_254_cov_1.701657_g552601_i0 PRJNA1148190 563774 254 1.701657 4.32220878 Candidatus Colwellbacteria bacterium RIFCSPLOWO2_ 2750074 Bacteria Bacteria 63.2 2.67e-9   NR OGY60792.1 1797692 g552601 i0 48.5 0.779527559055118 66 34 78 0 200 3 420 485 OGY60792.1 MAG: hypothetical protein A3I33_02450 [Candidatus Colwellbacteria bacterium RIFCSPLOWO2_02_FULL_45_11] diamond 198 63.2 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium RIFCSPLOWO2_02_FULL_45_11
31177158 31177158 PRJNA1148190_P_NODE_664075_length_247_cov_0.885057_g652902_i0 PRJNA1148190 664075 247 0.885057 2.18609079 Candidatus Colwellbacteria bacterium RIFCSPHIGHO2_12_FULL_44_17 1797689 Bacteria Bacteria 48.9 2.16e-4   NR OGY58662.1 1797689 g652902 i0 51.9 0.631578947368421 52 25 63.2 0 156 1 5 56 OGY58662.1 MAG: hypothetical protein A3F24_03110 [Candidatus Colwellbacteria bacterium RIFCSPHIGHO2_12_FULL_44_17] diamond 156 48.9 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium RIFCSPHIGHO2_12_FULL_44_17
31524533 31524533 PRJNA1148190_P_NODE_140836_length_443_cov_1.551351_g129671_i0 PRJNA1148190 140836 443 1.551351 6.87248493 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 88.6 3.84e-19   NR MDD4931377.1 2750074 g129671 i0 47.9 0.650112866817156 96 45 63.7 3 442 161 56 148 MDD4931377.1 hypothetical protein [Candidatus Colwellbacteria bacterium] diamond 288 88.6 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria bacterium
32062650 32062650 PRJNA1148190_P_NODE_45778_length_909_cov_3.576555_g35121_i0 PRJNA1148190 45778 909 3.576555 32.51088495 Candidatus Colwellbacteria bacterium 2750074 Bacteria Bacteria 170 4.539999999999999e-46   NR MBI3273775.1 2750074 g35121 i0 47.1 1.21452145214521 189 97 62 3 565 2 7 193 MBI3273775.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Candidatus Colwellbacteria bacterium] diamond 1104 170 1 Bacteria Bacteria candidate phyla   Candidatus Colwelliibacteriota         Candidatus Colwellbacteria 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);;