RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Bdellovibrionota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bdellovibrionota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA784298 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
28758914 28758914 PRJNA784298_P_NODE_24167_length_249_cov_2.278409_g23966_i0 PRJNA784298 24167 249 2.278409 5.67323841 Bdellovibrionales bacterium 2053517 Bacteria Bacteria 46.2 0.00105   NR NQZ02112.1 2053517 g23966 i0 38.7 2.5421686746988 62 36 72.3 1 33 212 42 103 NQZ02112.1 chemotaxis protein CheW [Bdellovibrionales bacterium] diamond 633 46.2 1 Bacteria   Pseudomonadati Bdellovibrionota Bdellovibrionia Bdellovibrionales     Bdellovibrionales bacterium
30496094 30496094 PRJNA784298_P_NODE_14373_length_329_cov_1.105469_g14172_i0 PRJNA784298 14373 329 1.105469 3.63699301 Silvanigrellaceae bacterium 2654442 Bacteria Bacteria 161 1.92e-48   NR MBX9838926.1 2654442 g14172 i0 82.4 0.775075987841945 85 15 77.5 0 257 3 1 85 MBX9838926.1 hypothetical protein [Silvanigrellaceae bacterium] diamond 255 161 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales Silvanigrellaceae   Silvanigrellaceae bacterium
30590669 30590669 PRJNA784298_P_NODE_13033_length_346_cov_1.128205_g12832_i0 PRJNA784298 13033 346 1.128205 3.9035893 Silvanigrellaceae bacterium 2654442 Bacteria Bacteria 48.5 3.1e-4   NR MBX9839915.1 2654442 g12832 i0 35.9 0.676300578034682 78 43 62.4 2 253 38 44 120 MBX9839915.1 hypothetical protein [Silvanigrellaceae bacterium] diamond 234 48.5 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales Silvanigrellaceae   Silvanigrellaceae bacterium
31390306 31390306 PRJNA784298_P_NODE_25596_length_245_cov_0.895349_g25395_i0 PRJNA784298 25596 245 0.895349 2.19360505 Silvanigrella 2024975 Bacteria Bacteria 125 1.3399999999999996e-34   NR WP_233231179.1 1915309 g25395 i0 77.8 2.97551020408163 81 18 99.2 0 243 1 90 170 WP_233231179.1 50S ribosomal protein L10 [Silvanigrella aquatica] diamond 729 125 1 Bacteria   Pseudomonadati Bdellovibrionota Oligoflexia Silvanigrellales Silvanigrellaceae Silvanigrella Silvanigrella aquatica

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