RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJEB3181 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
3882122 3882122 PRJEB3181_P_NODE_7884_length_301_cov_1.877778_g7622_i0 PRJEB3181 7884 301 1.877778 5.65211178 Actinomycetota bacterium 2900548 Bacteria Bacteria 83.6 3.49e-16   NR MEY3331002.1 2900548 g7622 i0 61.5 3.90697674418605 78 26 73.8 1 1 222 305 382 MEY3331002.1 hypothetical protein [Actinomycetota bacterium] diamond 1176 83.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
8983274 8983274 PRJEB3181_S_NODE_848_length_494_cov_10118.344227_g582_i0 PRJEB3181 848 494 10118.344227 49984.62048138 Bacteria 2 Bacteria Bacteria 109 2.43e-26   NR MEI6867845.1 1883427 g582 i0 52.9 1.87044534412955 104 45 63.2 1 2 313 106 205 MEI6867845.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 924 110 0.990909090909091 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
29180900 29180900 PRJEB3181_P_NODE_2589_length_448_cov_8.352518_g2386_i0 PRJEB3181 2589 448 8.352518 37.41928064 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 56.6 3.86e-6   NR MFL5891499.1 1909295 g2386 i0 40.5 0.529017857142857 79 35 44.9 4 14 214 217 295 MFL5891499.1 hypothetical protein [Solirubrobacterales bacterium] diamond 237 56.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
29370214 29370214 PRJEB3181_S_NODE_1289_length_427_cov_10.821429_g1006_i0 PRJEB3181 1289 427 10.821429 46.20750183 Actinomycetota bacterium 2900548 Bacteria Bacteria 112 5.119999999999999e-28   NR MEY2634385.1 2900548 g1006 i0 59.8 1.43325526932084 102 41 71.7 0 2 307 106 207 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 612 112 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29622290 29622290 PRJEB3181_S_NODE_13490_length_176_cov_1.397163_g13197_i0 PRJEB3181 13490 176 1.397163 2.45900688 Actinomycetes bacterium 1883427 Bacteria Bacteria 75.1 8.84e-15   NR MEI6230221.1 1883427 g13197 i0 61.4 0.971590909090909 57 22 97.2 0 5 175 18 74 MEI6230221.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 171 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
31201888 31201888 PRJEB3181_P_NODE_10575_length_261_cov_3.634783_g10311_i0 PRJEB3181 10575 261 3.634783 9.48678363 Actinomycetota bacterium 2900548 Bacteria Bacteria 53.5 3.93e-6   NR MEY2634385.1 2900548 g10311 i0 62.5 1.64367816091954 48 18 55.2 0 260 117 160 207 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 429 53.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31613515 31613515 PRJEB3181_P_NODE_21056_length_178_cov_2.251701_g20792_i0 PRJEB3181 21056 178 2.251701 4.00802778 Catenulispora acidiphila 304895 Bacteria Bacteria 48.1 1.98e-4   NR WP_015794835.1 304895 g20792 i0 61.1 0.606741573033708 36 14 60.7 0 7 114 560 595 WP_015794835.1 alpha-galactosidase [Catenulispora acidiphila] diamond 108 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Catenulisporaceae Catenulispora Catenulispora acidiphila
31929791 31929791 PRJEB3181_S_NODE_14117_length_172_cov_2.321168_g13824_i0 PRJEB3181 14117 172 2.321168 3.99240896 Microbacterium sp. LRZ72 2942481 Bacteria Bacteria 60.8 8.41e-10   NR WP_319035189.1 2942481 g13824 i0 72.2 3.73255813953488 36 10 62.8 0 3 110 112 147 WP_319035189.1 50S ribosomal protein L13 [Microbacterium sp. LRZ72] diamond 642 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. LRZ72
31954845 31954845 PRJEB3181_P_NODE_16697_length_204_cov_2.554913_g16433_i0 PRJEB3181 16697 204 2.554913 5.21202252 FCB group 1783270 Bacteria Bacteria 46.6 9.55e-4   NR MFD1046374.1 1497396 g16433 i0 45.5 4.58823529411765 44 24 64.7 0 194 63 378 421 MFD1046374.1 RICIN domain-containing protein [Kibdelosporangium lantanae] diamond 936 47 0.991489361702128 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Kibdelosporangium Kibdelosporangium lantanae

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