RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA1108009" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1108009 · 16 ✖

analysis 1

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
7865831 7865831 PRJNA1108009_P_NODE_25607_length_250_cov_0.870056_g25289_i0 PRJNA1108009 25607 250 0.870056 2.17514 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 155 2.7099999999999992e-43   NR MBO4287099.1 2212473 g25289 i0 94 7.968 83 5 99.6 0 1 249 346 428 MBO4287099.1 O-acetylhomoserine aminocarboxypropyltransferase/cysteine synthase [Kiritimatiellia bacterium] diamond 1992 155 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
9140801 9140801 PRJNA1108009_P_NODE_31068_length_242_cov_0.911243_g30750_i0 PRJNA1108009 31068 242 0.911243 2.20520806 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 137 1.55e-36   NR MBQ1346293.1 2212473 g30750 i0 100 7.93388429752066 80 0 99.2 0 240 1 44 123 MBQ1346293.1 FHIPEP family type III secretion protein [Kiritimatiellia bacterium] diamond 1920 137 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
9140818 9140818 PRJNA1108009_P_NODE_31788_length_241_cov_0.916667_g31470_i0 PRJNA1108009 31788 241 0.916667 2.20916747 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 159 5.2599999999999995e-45   NR MBR2065709.1 2212473 g31470 i0 93.8 0.995850622406639 80 5 99.6 0 1 240 15 94 MBR2065709.1 beta-ketoacyl-ACP synthase II [Kiritimatiellia bacterium] diamond 240 159 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
11691807 11691807 PRJNA1108009_P_NODE_27670_length_247_cov_0.885057_g27352_i0 PRJNA1108009 27670 247 0.885057 2.18609079 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 176 1.75e-52   NR MBR2939586.1 2212473 g27352 i0 100 2.98785425101215 82 0 99.6 0 1 246 40 121 MBR2939586.1 transketolase [Kiritimatiellia bacterium] diamond 738 176 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27320673 27320673 PRJNA1108009_P_NODE_26303_length_249_cov_0.875000_g25985_i0 PRJNA1108009 26303 249 0.875 2.17875 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 169 1.48e-49   NR MBQ3098392.1 2212473 g25985 i0 95.1 0.987951807228916 82 4 98.8 0 248 3 44 125 MBQ3098392.1 branched-chain amino acid aminotransferase [Kiritimatiellia bacterium] diamond 246 169 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29372998 29372998 PRJNA1108009_P_NODE_30109_length_243_cov_0.905882_g29791_i0 PRJNA1108009 30109 243 0.905882 2.20129326 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 161 6.94e-46   NR MBQ6328016.1 2212473 g29791 i0 95 0.987654320987654 80 4 98.8 0 2 241 103 182 MBQ6328016.1 ATP-binding protein [Kiritimatiellia bacterium] diamond 240 161 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29656714 29656714 PRJNA1108009_P_NODE_20450_length_284_cov_1.189573_g20132_i0 PRJNA1108009 20450 284 1.189573 3.37838732 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 101 1.66e-22   NR MBQ6010937.1 2212473 g20132 i0 50 1.98591549295775 94 43 99.3 1 2 283 356 445 MBQ6010937.1 hypothetical protein [Kiritimatiellia bacterium] diamond 564 101 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30067642 30067642 PRJNA1108009_P_NODE_23032_length_263_cov_1.594737_g22714_i0 PRJNA1108009 23032 263 1.594737 4.19415831 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 107 6.08e-28   NR MBR3957726.1 2212473 g22714 i0 60.9 0.992395437262357 87 27 99.2 2 262 2 33 112 MBR3957726.1 hypothetical protein [Kiritimatiellia bacterium] diamond 261 107 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30604747 30604747 PRJNA1108009_P_NODE_23653_length_258_cov_1.659459_g23335_i0 PRJNA1108009 23653 258 1.659459 4.28140422 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 152 2.88e-45   NR MBR3222251.1 2212473 g23335 i0 89.4 2.94186046511628 85 9 98.8 0 4 258 1 85 MBR3222251.1 GxxExxY protein [Kiritimatiellia bacterium] diamond 759 152 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30636228 30636228 PRJNA1108009_P_NODE_23893_length_256_cov_1.666667_g23575_i0 PRJNA1108009 23893 256 1.666667 4.26666752 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 181 5.649999999999999e-52   NR MBQ2345977.1 2212473 g23575 i0 95.2 0.97265625 83 4 97.3 0 2 250 305 387 MBQ2345977.1 penicillin-binding protein 2 [Kiritimatiellia bacterium] diamond 249 181 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30762913 30762913 PRJNA1108009_P_NODE_30154_length_243_cov_0.905882_g29836_i0 PRJNA1108009 30154 243 0.905882 2.20129326 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 157 2.840000000000001e-44   NR MBQ3315478.1 2212473 g29836 i0 93.8 4 81 5 100 0 243 1 277 357 MBQ3315478.1 hypothetical protein [Kiritimatiellia bacterium] diamond 972 157 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31300016 31300016 PRJNA1108009_P_NODE_28135_length_246_cov_0.890173_g27817_i0 PRJNA1108009 28135 246 0.890173 2.18982558 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 156 2.55e-45   NR MBR0068587.1 2212473 g27817 i0 98.8 1.98780487804878 81 1 98.8 0 1 243 68 148 MBR0068587.1 hypothetical protein [Kiritimatiellia bacterium] diamond 489 156 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31331594 31331594 PRJNA1108009_P_NODE_26696_length_248_cov_0.880000_g26378_i0 PRJNA1108009 26696 248 0.88 2.1824 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 58.5 1.22e-8   NR MBR3777817.1 2212473 g26378 i0 100 0.314516129032258 26 0 31.5 0 3 80 103 128 MBR3777817.1 hypothetical protein [Kiritimatiellia bacterium] diamond 78 58.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31426520 31426520 PRJNA1108009_P_NODE_27176_length_248_cov_0.880000_g26858_i0 PRJNA1108009 27176 248 0.88 2.1824 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 135 6.480000000000001e-36   NR MBR6733607.1 2212473 g26858 i0 91.5 0.858870967741935 71 6 85.9 0 219 7 1 71 MBR6733607.1 class I SAM-dependent RNA methyltransferase [Kiritimatiellia bacterium] diamond 213 135 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32027621 32027621 PRJNA1108009_P_NODE_20558_length_283_cov_1.352381_g20240_i0 PRJNA1108009 20558 283 1.352381 3.82723823 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 43.5 0.0302   NR MFO1531008.1 2212473 g20240 i0 34.4 0.646643109540636 61 38 63.6 2 263 84 152 211 MFO1531008.1 MFS transporter [Kiritimatiellia bacterium] diamond 183 43.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32249426 32249426 PRJNA1108009_P_NODE_19798_length_289_cov_1.231481_g19480_i0 PRJNA1108009 19798 289 1.231481 3.55898009 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 160 4.43e-47   NR MBR3956490.1 2212473 g19480 i0 96.7 0.955017301038062 92 3 95.5 0 13 288 1 92 MBR3956490.1 hypothetical protein [Kiritimatiellia bacterium] diamond 276 160 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia 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);;