RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJEB55250" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 5 ✖

bioproject 1

  • PRJEB55250 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
9049036 9049036 PRJEB55250_P_NODE_3068_length_380_cov_1.657980_g2944_i0 PRJEB55250 3068 380 1.65798 6.300324 Eukaryota 2759 Plants Plants 165 5.89e-50   NR NP_001365255.1 3218 g2944 i0 67.8 8.36842105263158 115 37 90.8 0 347 3 7 121 NP_001365255.1 40S ribosomal protein S24-1 [Physcomitrium patens] diamond 3180 165 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
27127972 27127972 PRJEB55250_P_NODE_8762_length_270_cov_2.020305_g8638_i0 PRJEB55250 8762 270 2.020305 5.4548235 Dillenia turbinata 194707 Plants Plants 118 3.8e-30   NR KAK6916979.1 194707 g8638 i0 77.5 13.8333333333333 71 16 78.9 0 215 3 11 81 KAK6916979.1 Cytidyltransferase-like domain [Dillenia turbinata] diamond 3735 118 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Dilleniales Dilleniaceae Dillenia Dillenia turbinata
28732242 28732242 PRJEB55250_P_NODE_8647_length_271_cov_1.555556_g8523_i0 PRJEB55250 8647 271 1.555556 4.21555676 root 1 Root_unresolved Root_unresolved 80.1 4.42e-16   NR XP_017216104.1 79200 g8523 i0 50 21.4981549815498 74 37 81.9 0 265 44 145 218 XP_017216104.1 peroxiredoxin Q, chloroplastic [Daucus carota subsp. sativus] diamond 5826 80.5 0.995031055900621 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
31803417 31803417 PRJEB55250_P_NODE_13677_length_247_cov_0.885057_g13553_i0 PRJEB55250 13677 247 0.885057 2.18609079 Sphagnum fallax 53036 Plants Plants 88.6 4.23e-19   NR KAH8974410.1 53036 g13553 i0 61.4 1.78542510121457 70 27 85 0 222 13 12 81 KAH8974410.1 hypothetical protein BDL97_01G101300 [Sphagnum fallax] diamond 441 88.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum fallax
32594557 32594557 PRJEB55250_P_NODE_10440_length_258_cov_1.594595_g10316_i0 PRJEB55250 10440 258 1.594595 4.1140551 Taraxacum kok-saghyz 333970 Plants Plants 57 3e-7   NR KAL4579928.1 333970 g10316 i0 68.4 0.441860465116279 38 12 44.2 0 41 154 157 194 KAL4579928.1 hypothetical protein LXL04_016099 [Taraxacum kok-saghyz] diamond 114 57 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Taraxacum Taraxacum kok-saghyz

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