RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA624323" 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 · 13 ✖

bioproject 1

  • PRJNA624323 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
596361 596361 PRJNA624323_P_NODE_5061_length_323_cov_1.232000_g4899_i0 PRJNA624323 5061 323 1.232 3.97936 Smallanthus sonchifolius 185202 Plants Plants 80.1 7.02e-15   NR KAI3829423.1 185202 g4899 i0 57.1 2.70278637770898 56 24 52 0 168 1 42 97 KAI3829423.1 hypothetical protein L1987_03547 [Smallanthus sonchifolius] diamond 873 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
26872217 26872217 PRJNA624323_P_NODE_9501_length_241_cov_0.916667_g9339_i0 PRJNA624323 9501 241 0.916667 2.20916747 Streptophyta 35493 Plants Plants 50.1 8.41e-5   NR XP_019425150.1 3871 g9339 i0 54.3 2.58921161825726 35 16 43.6 0 130 234 234 268 XP_019425150.1 PREDICTED: uncharacterized protein LOC109334032 [Lupinus angustifolius] diamond 624 50.4 0.994047619047619 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lupinus Lupinus angustifolius
27017243 27017243 PRJNA624323_P_NODE_4882_length_329_cov_1.765625_g4720_i0 PRJNA624323 4882 329 1.765625 5.80890625 Picea sitchensis 3332 Plants Plants 93.6 7.62e-20   NR ABK25009.1 3332 g4720 i0 60.9 1.27659574468085 69 26 62 1 2 205 329 397 ABK25009.1 unknown [Picea sitchensis] diamond 420 93.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
27112042 27112042 PRJNA624323_P_NODE_8882_length_245_cov_0.895349_g8720_i0 PRJNA624323 8882 245 0.895349 2.19360505 Taxus chinensis 29808 Plants Plants 73.6 5.48e-13   NR KAH9329797.1 29808 g8720 i0 49.4 0.991836734693878 81 41 99.2 0 245 3 1055 1135 KAH9329797.1 hypothetical protein KI387_001905, partial [Taxus chinensis] diamond 243 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
27270144 27270144 PRJNA624323_P_NODE_9183_length_243_cov_0.905882_g9021_i0 PRJNA624323 9183 243 0.905882 2.20129326 Nymphaea colorata 210225 Plants Plants 64.3 9.01e-10   NR VVV74533.1 210225 g9021 i0 43.8 5.96296296296296 64 36 79 0 8 199 17 80 VVV74533.1 unnamed protein product, partial [Nymphaea colorata] diamond 1449 64.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28722827 28722827 PRJNA624323_P_NODE_9247_length_243_cov_0.905882_g9085_i0 PRJNA624323 9247 243 0.905882 2.20129326 Cryptomeria japonica 3369 Plants Plants 153 3.94e-41   NR GLJ54442.1 3369 g9085 i0 91.3 0.987654320987654 80 7 98.8 0 242 3 276 355 GLJ54442.1 hypothetical protein SUGI_1169320 [Cryptomeria japonica] diamond 240 153 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
29417230 29417230 PRJNA624323_P_NODE_9229_length_243_cov_0.905882_g9067_i0 PRJNA624323 9229 243 0.905882 2.20129326 Cryptomeria japonica 3369 Plants Plants 97.8 1.6400000000000002e-21   NR GLJ25944.1 3369 g9067 i0 64.2 1.98765432098765 81 29 100 0 243 1 966 1046 GLJ25944.1 hypothetical protein SUGI_0497330 [Cryptomeria japonica] diamond 483 97.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
29701170 29701170 PRJNA624323_P_NODE_8230_length_249_cov_0.875000_g8068_i0 PRJNA624323 8230 249 0.875 2.17875 Taxus chinensis 29808 Plants Plants 67.8 6.32e-11   NR KAH9316782.1 29808 g8068 i0 50 0.72289156626506 60 26 72.3 1 243 64 233 288 KAH9316782.1 hypothetical protein KI387_044020 [Taxus chinensis] diamond 180 67.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
29967047 29967047 PRJNA624323_P_NODE_8611_length_247_cov_0.885057_g8449_i0 PRJNA624323 8611 247 0.885057 2.18609079 Pinopsida 58019 Plants Plants 126 1.6299999999999996e-31   NR KAH9306665.1 29808 g8449 i0 69.1 1.97975708502024 81 25 98.4 0 5 247 310 390 KAH9306665.1 hypothetical protein KI387_011069 [Taxus chinensis] diamond 489 127 0.992125984251969 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
30851614 30851614 PRJNA624323_P_NODE_8874_length_245_cov_0.895349_g8712_i0 PRJNA624323 8874 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 109 8.15e-26   NR KAH9330560.1 29808 g8712 i0 65.4 6.94285714285714 81 28 99.2 0 1 243 341 421 KAH9330560.1 hypothetical protein KI387_002668 [Taxus chinensis] diamond 1701 109 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
31249572 31249572 PRJNA624323_P_NODE_5375_length_313_cov_1.254167_g5213_i0 PRJNA624323 5375 313 1.254167 3.92554271 Picea sitchensis 3332 Plants Plants 118 1.55e-28   NR ABR16596.1 3332 g5213 i0 59.2 0.987220447284345 103 40 97.8 2 6 311 34 135 ABR16596.1 unknown [Picea sitchensis] diamond 309 118 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
32008834 32008834 PRJNA624323_P_NODE_4798_length_332_cov_2.355212_g4636_i0 PRJNA624323 4798 332 2.355212 7.81930384 Cryptomeria japonica 3369 Plants Plants 63.5 9.32e-10   NR XP_057863391.1 3369 g4636 i0 34.2 1.96987951807229 120 61 92.2 3 25 330 4 123 XP_057863391.1 TPD1 protein homolog 1 [Cryptomeria japonica] diamond 654 63.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
32338277 32338277 PRJNA624323_P_NODE_9339_length_242_cov_0.911243_g9177_i0 PRJNA624323 9339 242 0.911243 2.20520806 Streptophyta 35493 Plants Plants 59.7 2.4e-8   NR XP_024365322.1 3218 g9177 i0 46.2 2.72727272727273 52 28 64.5 0 3 158 201 252 XP_024365322.1 aldehyde oxidase GLOX-like [Physcomitrium patens] diamond 660 59.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens

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