RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA940501" and tax_phylum = "Kiritimatiellota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Kiritimatiellota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA940501 · 8 ✖

analysis 1

  • diamond · 8 ✖
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
27214651 27214651 PRJNA940501_S_NODE_309282_length_165_cov_1.926230_g308464_i0 PRJNA940501 309282 165 1.92623 3.1782795 Tichowtungia aerotolerans 2697043 Bacteria Bacteria 47.4 3.11e-4   NR WP_160627809.1 2697043 g308464 i0 75.9 0.527272727272727 29 7 52.7 0 87 1 638 666 WP_160627809.1 elongation factor G [Tichowtungia aerotolerans] diamond 87 47.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Tichowtungiia Tichowtungiales Tichowtungiaceae Tichowtungia Tichowtungia aerotolerans
27246435 27246435 PRJNA940501_S_NODE_347503_length_158_cov_1.226087_g346685_i0 PRJNA940501 347503 158 1.226087 1.93721746 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 41.2 0.0421   NR MBQ2625524.1 2212473 g346685 i0 41.9 0.816455696202532 43 24 79.7 1 156 31 1455 1497 MBQ2625524.1 InlB B-repeat-containing protein [Kiritimatiellia bacterium] diamond 129 41.2 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28730591 28730591 PRJNA940501_S_NODE_172647_length_202_cov_2.069182_g171829_i0 PRJNA940501 172647 202 2.069182 4.17974764 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 106 8.86e-25   NR MCQ2368633.1 2212473 g171829 i0 75.8 2.91089108910891 66 16 98 0 3 200 320 385 MCQ2368633.1 ATP-dependent helicase [Kiritimatiellia bacterium] diamond 588 106 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
28824997 28824997 PRJNA940501_S_NODE_148628_length_212_cov_1.390533_g147810_i0 PRJNA940501 148628 212 1.390533 2.94792996 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 40 0.0484   NR MCQ2394624.1 2212473 g147810 i0 38.9 0.509433962264151 36 22 50.9 0 90 197 3 38 MCQ2394624.1 hypothetical protein [Kiritimatiellia bacterium] diamond 108 40 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
29172822 29172822 PRJNA940501_S_NODE_56889_length_276_cov_1.412017_g56071_i0 PRJNA940501 56889 276 1.412017 3.89716692 Pontiella sp. 2837462 Bacteria Bacteria 44.7 0.00759   NR HEY5653097.1 2837462 g56071 i0 41.1 0.608695652173913 56 33 60.9 0 169 2 97 152 HEY5653097.1 hypothetical protein [Pontiella sp.] diamond 168 44.7 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia Kiritimatiellales Pontiellaceae Pontiella Pontiella sp.
29898968 29898968 PRJNA940501_S_NODE_51151_length_283_cov_2.316667_g50333_i0 PRJNA940501 51151 283 2.316667 6.55616761 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 45.4 0.00638   NR MBQ3289925.1 2212473 g50333 i0 44.6 1.24028268551237 56 25 59.4 3 13 180 190 239 MBQ3289925.1 alpha/beta fold hydrolase [Kiritimatiellia bacterium] diamond 351 45.4 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31415692 31415692 PRJNA940501_S_NODE_95596_length_241_cov_1.424242_g94778_i0 PRJNA940501 95596 241 1.424242 3.43242322 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 96.3 2.0500000000000003e-21   NR HNX35019.1 2212473 g94778 i0 59 0.970954356846473 78 30 97.1 1 234 1 254 329 HNX35019.1 cellulase family glycosylhydrolase [Kiritimatiellia bacterium] diamond 234 96.3 1 Bacteria PVC group Pseudomonadati Kiritimatiellota Kiritimatiellia       Kiritimatiellia bacterium
31890027 31890027 PRJNA940501_S_NODE_257177_length_177_cov_1.358209_g256359_i0 PRJNA940501 257177 177 1.358209 2.40402993 Kiritimatiellia bacterium 2212473 Bacteria Bacteria 82 2.12e-16   NR MCR5751064.1 2212473 g256359 i0 92.7 3.47457627118644 41 3 69.5 0 175 53 513 553 MCR5751064.1 hypothetical protein [Kiritimatiellia bacterium] diamond 615 82 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);;