RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA1082072" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1082072 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
27288721 27288721 PRJNA1082072_P_NODE_2043_length_251_cov_1.370787_g2036_i0 PRJNA1082072 2043 251 1.370787 3.44067537 Streptosporangium 2000 Bacteria Bacteria 63.2 2.18e-9   NR WP_362769229.1 2000 g2036 i0 49.4 1.9601593625498 83 36 96.8 3 1 243 85 163 WP_362769229.1 MULTISPECIES: hypothetical protein [Streptosporangium] diamond 492 63.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium  
27383660 27383660 PRJNA1082072_P_NODE_1643_length_278_cov_1.326829_g1636_i0 PRJNA1082072 1643 278 1.326829 3.68858462 Promicromonospora sp. NPDC 1873457 Bacteria Bacteria 179 7.14e-50   NR WP_397432854.1 3364407 g1636 i0 100 0.992805755395683 92 0 99.3 0 1 276 15 106 WP_397432854.1 FtsX-like permease family protein [Promicromonospora sp. NPDC052451] diamond 276 179 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Promicromonosporaceae Promicromonospora Promicromonospora sp. NPDC052451
28172834 28172834 PRJNA1082072_P_NODE_1146_length_323_cov_1.924000_g1139_i0 PRJNA1082072 1146 323 1.924 6.21452 Sinosporangium siamense 1367973 Bacteria Bacteria 75.9 1.11e-14   NR WP_204030472.1 1367973 g1139 i0 34.6 0.96594427244582 104 66 96.6 1 10 321 6 107 WP_204030472.1 hypothetical protein, partial [Sinosporangium siamense] diamond 312 75.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sinosporangium Sinosporangium siamense
28520341 28520341 PRJNA1082072_P_NODE_1487_length_287_cov_1.121495_g1480_i0 PRJNA1082072 1487 287 1.121495 3.21869065 uncultured Corynebacterium sp. 159447 Bacteria Bacteria 43.1 0.0456   NR WP_366513535.1 159447 g1480 i0 33.3 0.909407665505226 87 49 90.9 2 19 279 143 220 WP_366513535.1 chromosomal replication initiator protein DnaA [uncultured Corynebacterium sp.] diamond 261 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium uncultured Corynebacterium sp.
28732768 28732768 PRJNA1082072_P_NODE_1407_length_291_cov_1.688073_g1400_i0 PRJNA1082072 1407 291 1.688073 4.91229243 Bacillati 1783272 Bacteria Bacteria 68.6 5.32e-12   NR WP_204030472.1 1367973 g1400 i0 33 2.83505154639175 94 61 96.9 1 10 291 6 97 WP_204030472.1 hypothetical protein, partial [Sinosporangium siamense] diamond 825 68.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sinosporangium Sinosporangium siamense
28890445 28890445 PRJNA1082072_P_NODE_1168_length_320_cov_1.246964_g1161_i0 PRJNA1082072 1168 320 1.246964 3.9902848 Myceligenerans 253183 Bacteria Bacteria 61.6 2.07e-8   NR WP_242637001.1 1230528 g1161 i0 37.8 2.26875 82 50 75.9 1 77 319 45 126 WP_242637001.1 family 43 glycosylhydrolase [Myceligenerans salitolerans] diamond 726 61.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Promicromonosporaceae Myceligenerans Myceligenerans salitolerans
30825734 30825734 PRJNA1082072_P_NODE_2194_length_250_cov_0.870056_g2187_i0 PRJNA1082072 2194 250 0.870056 2.17514 Pseudarthrobacter oxydans 1671 Bacteria Bacteria 51.2 3.33e-5   NR WP_400621719.1 1671 g2187 i0 38.3 1.128 94 41 96 2 240 1 8 98 WP_400621719.1 hypothetical protein [Pseudarthrobacter oxydans] diamond 282 51.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter oxydans

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