RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA833575" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA833575 · 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
19950826 19950826 PRJNA833575_P_NODE_33376_length_256_cov_1.540107_g33239_i0 PRJNA833575 33376 256 1.540107 3.94267392 Actinokineospora guangxiensis 1490288 Bacteria Bacteria 124 9.549999999999999e-32   NR WP_378251071.1 1490288 g33239 i0 66.7 2.9765625 84 27 98.4 1 255 4 157 239 WP_378251071.1 S8 family peptidase [Actinokineospora guangxiensis] diamond 762 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinokineospora Actinokineospora guangxiensis
26769769 26769769 PRJNA833575_P_NODE_39201_length_234_cov_0.872727_g39064_i0 PRJNA833575 39201 234 0.872727 2.04218118 Gordonia sesuvii 3116777 Bacteria Bacteria 47 0.00107   NR WP_330434099.1 3116777 g39064 i0 46.9 0.628205128205128 49 23 62.8 2 230 84 674 719 WP_330434099.1 hypothetical protein [Gordonia sesuvii] diamond 147 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia sesuvii
29485922 29485922 PRJNA833575_P_NODE_45070_length_228_cov_0.905660_g44933_i0 PRJNA833575 45070 228 0.90566 2.0649048 Pseudonocardia cypriaca 882449 Bacteria Bacteria 42.4 0.0396   NR WP_142095399.1 882449 g44933 i0 41.8 0.881578947368421 67 37 88.2 2 202 2 76 140 WP_142095399.1 carbohydrate ABC transporter permease [Pseudonocardia cypriaca] diamond 201 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia cypriaca
32308055 32308055 PRJNA833575_P_NODE_19859_length_331_cov_1.419847_g19722_i0 PRJNA833575 19859 331 1.419847 4.69969357 Cellulomonas 1707 Bacteria Bacteria 87 3.05e-17   NR WP_307494345.1 144055 g19722 i0 47.7 1.95770392749245 109 41 89.7 5 11 307 290 392 WP_307494345.1 hemopexin repeat-containing protein [Cellulomonas humilata] diamond 648 87 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas humilata

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