RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 10 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1237347 · 10 ✖

analysis 1

  • diamond · 10 ✖
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
27357702 27357702 PRJNA1237347_P_NODE_30643_length_1409_cov_5.517216_g27076_i0 PRJNA1237347 30643 1409 5.517216 77.73757344 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 81.6 7.84e-13   NR MBN1268983.1 2212473 g27076 i0 26.5 0.747338537970192 351 220 71.5 7 62 1069 13 340 MBN1268983.1 MFS transporter [Kiritimatiellia bacterium] diamond 1053 81.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
27389215 27389215 PRJNA1237347_P_NODE_233603_length_391_cov_2.672956_g227031_i0 PRJNA1237347 233603 391 2.672956 10.45125796 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.1 0.0297   NR MFT5240214.1 2212473 g227031 i0 39.1 0.491048593350384 64 38 48.3 1 215 27 1054 1117 MFT5240214.1 hypothetical protein [Kiritimatiellia bacterium] diamond 192 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28147244 28147244 PRJNA1237347_P_NODE_447825_length_260_cov_1.454545_g441252_i0 PRJNA1237347 447825 260 1.454545 3.781817 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 61.6 1.02e-8   NR MBQ6247394.1 2212473 g441252 i0 58.2 0.634615384615385 55 23 63.5 0 3 167 124 178 MBQ6247394.1 leucine-rich repeat protein [Kiritimatiellia bacterium] diamond 165 61.6 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29440951 29440951 PRJNA1237347_P_NODE_159430_length_503_cov_2.158140_g152869_i0 PRJNA1237347 159430 503 2.15814 10.8554442 Kiritimatiellales bacterium 2202731 Bacteria Bacteria 46.2 0.0245   NR MCF7817458.1 2202731 g152869 i0 33.8 0.918489065606362 77 51 45.9 0 199 429 87 163 MCF7817458.1 hypothetical protein [Kiritimatiellales bacterium] diamond 462 46.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales     Kiritimatiellales bacterium
29523065 29523065 PRJNA1237347_P_NODE_276050_length_352_cov_1.103943_g269477_i0 PRJNA1237347 276050 352 1.103943 3.88587936 Pseudomonadati 3379134 Bacteria Bacteria 45.4 0.00911   NR MBR0196784.1 2212473 g269477 i0 39.4 1.03977272727273 71 43 60.5 0 281 69 64 134 MBR0196784.1 leucine-rich repeat domain-containing protein [Kiritimatiellia bacterium] diamond 366 45.8 0.991266375545852 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29598924 29598924 PRJNA1237347_P_NODE_215770_length_412_cov_3.141593_g209198_i0 PRJNA1237347 215770 412 3.141593 12.94336316 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 49.7 8.25e-4   NR MBO5751257.1 2212473 g209198 i0 37.3 0.546116504854369 75 40 53.2 2 12 230 105 174 MBO5751257.1 hypothetical protein [Kiritimatiellia bacterium] diamond 225 49.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
30199512 30199512 PRJNA1237347_P_NODE_559252_length_238_cov_3.884848_g552679_i0 PRJNA1237347 559252 238 3.884848 9.24593824 Pontiellaceae bacterium 2813032 Bacteria Bacteria 43.5 0.00817   NR MBN2704539.1 2813032 g552679 i0 31.3 0.80672268907563 64 42 78.2 1 199 14 40 103 MBN2704539.1 hypothetical protein [Pontiellaceae bacterium] diamond 192 43.5 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae   Pontiellaceae bacterium
30862874 30862874 PRJNA1237347_P_NODE_298674_length_335_cov_1.175573_g292101_i0 PRJNA1237347 298674 335 1.175573 3.93816955 Kiritimatiellota bacterium B12222 3040511 Bacteria Bacteria 45.1 0.0169   NR WFB34705.1 3040511 g292101 i0 27.6 0.877611940298507 98 69 87.8 1 41 334 969 1064 WFB34705.1 DUF2723 domain-containing protein [Kiritimatiellota bacterium B12222] diamond 294 45.1 1 Bacteria PVC group Pseudomonadati Kiritimatiellota         Kiritimatiellota bacterium B12222
31766681 31766681 PRJNA1237347_P_NODE_408957_length_276_cov_1.137931_g402384_i0 PRJNA1237347 408957 276 1.137931 3.14068956 Pseudomonadati 3379134 Bacteria Bacteria 79 1.07e-14   NR MFT7520358.1 2212473 g402384 i0 42.9 6.8804347826087 91 48 98.9 2 4 276 1107 1193 MFT7520358.1 signal transduction histidine kinase/class 3 adenylate cyclase/ActR [Kiritimatiellia bacterium] diamond 1899 79.3 0.996216897856242 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
32412855 32412855 PRJNA1237347_P_NODE_398179_length_280_cov_1.845411_g391606_i0 PRJNA1237347 398179 280 1.845411 5.1671508 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 47.8 0.00106   NR MBP7831231.1 2212473 g391606 i0 41.6 1.93928571428571 89 40 92.1 4 19 276 2929 3008 MBP7831231.1 DUF2341 domain-containing protein [Kiritimatiellia bacterium] diamond 543 47.8 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);;