RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA983848" and tax_phylum = "Verrucomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Verrucomicrobiota · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA983848 · 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
27531923 27531923 PRJNA983848_P_NODE_96923_length_308_cov_2.119149_g91040_i0 PRJNA983848 96923 308 2.119149 6.52697892 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 42.7 0.0212   NR HXT83479.1 2499141 g91040 i0 47.5 0.38961038961039 40 21 39 0 150 31 55 94 HXT83479.1 hypothetical protein [Verrucomicrobiia bacterium] diamond 120 42.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
28194778 28194778 PRJNA983848_P_NODE_155366_length_244_cov_1.309942_g149483_i0 PRJNA983848 155366 244 1.309942 3.19625848 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 47.8 6.2e-4   NR MEO0454925.1 2026799 g149483 i0 47.8 0.565573770491803 46 23 56.6 1 173 36 175 219 MEO0454925.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 138 47.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28289525 28289525 PRJNA983848_P_NODE_160106_length_242_cov_0.923077_g154223_i0 PRJNA983848 160106 242 0.923077 2.23384634 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 123 6.2e-33   NR NDF17446.1 2026799 g154223 i0 69.1 1.00413223140496 81 24 99.2 1 3 242 91 171 NDF17446.1 hypothetical protein [Verrucomicrobiota bacterium] diamond 243 123 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28605430 28605430 PRJNA983848_P_NODE_60167_length_421_cov_1.979885_g54285_i0 PRJNA983848 60167 421 1.979885 8.33531585 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 45.1 0.0284   NR TMP98142.1 2026799 g54285 i0 51.3 0.27790973871734 39 18 27.8 1 114 230 183 220 TMP98142.1 MAG: prepilin-type N-terminal cleavage/methylation domain-containing protein [Verrucomicrobiota bacterium] diamond 117 45.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
28763175 28763175 PRJNA983848_P_NODE_145067_length_249_cov_1.534091_g139184_i0 PRJNA983848 145067 249 1.534091 3.81988659 Verrucomicrobiia bacterium 2499141 Bacteria Bacteria 43.9 0.015   NR HTX58466.1 2499141 g139184 i0 54.1 0.44578313253012 37 14 41 1 63 164 311 347 HTX58466.1 DUF1565 domain-containing protein [Verrucomicrobiia bacterium] diamond 111 43.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia       Verrucomicrobiia bacterium
29931764 29931764 PRJNA983848_P_NODE_159711_length_242_cov_0.923077_g153828_i0 PRJNA983848 159711 242 0.923077 2.23384634 Candidatus Didemnitutus sp. 2814259 Bacteria Bacteria 130 3.18e-33   NR HET7535355.1 2814259 g153828 i0 76.3 0.991735537190083 80 19 99.2 0 2 241 126 205 HET7535355.1 SulP family inorganic anion transporter [Candidatus Didemnitutus sp.] diamond 240 130 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Candidatus Didemnitutus Candidatus Didemnitutus sp.
30342830 30342830 PRJNA983848_P_NODE_143632_length_250_cov_0.881356_g137749_i0 PRJNA983848 143632 250 0.881356 2.20339 Opitutus terrae 107709 Bacteria Bacteria 58.2 1.53e-7   NR WP_012374816.1 107709 g137749 i0 49.3 0.804 67 34 80.4 0 222 22 718 784 WP_012374816.1 hypothetical protein [Opitutus terrae] diamond 201 58.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Opitutales Opitutaceae Opitutus Opitutus terrae
31353558 31353558 PRJNA983848_P_NODE_114356_length_281_cov_1.307692_g108473_i0 PRJNA983848 114356 281 1.307692 3.67461452 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 46.2 0.00362   NR MBI4661175.1 2026799 g108473 i0 36.2 0.736654804270463 69 39 68.3 2 202 11 704 772 MBI4661175.1 TonB-dependent receptor [Verrucomicrobiota bacterium] diamond 207 46.2 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota 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);;