RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB49404" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB49404 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
16293875 16293875 PRJEB49404_P_NODE_615793_length_156_cov_1.991453_g601992_i0 PRJEB49404 615793 156 1.991453 3.10666668 Olea europaea subsp. europaea 158383 Plants Plants 99 1.76e-22   NR CAA2977210.1 158383 g601992 i0 100 2.94230769230769 51 0 98.1 0 2 154 951 1001 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 459 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
26621922 26621922 PRJEB49404_P_NODE_555321_length_168_cov_2.317829_g541520_i0 PRJEB49404 555321 168 2.317829 3.89395272 Olea europaea subsp. europaea 158383 Plants Plants 102 1.81e-23   NR CAA2991155.1 158383 g541520 i0 100 1 56 0 100 0 1 168 317 372 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 168 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
26843840 26843840 PRJEB49404_P_NODE_558341_length_168_cov_1.271318_g544540_i0 PRJEB49404 558341 168 1.271318 2.13581424 Olea europaea subsp. europaea 158383 Plants Plants 105 7.72e-25   NR CAA2977210.1 158383 g544540 i0 100 2.94642857142857 55 0 98.2 0 167 3 178 232 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 495 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27949594 27949594 PRJEB49404_P_NODE_467865_length_191_cov_1.177632_g454064_i0 PRJEB49404 467865 191 1.177632 2.24927712 Sesamum angolense 2727404 Plants Plants 93.2 2.85e-20   NR KAK4391689.1 2727404 g454064 i0 70.2 1.79057591623037 57 17 89.5 0 172 2 7 63 KAK4391689.1 putative aldehyde oxidase Art an 7 [Sesamum angolense] diamond 342 93.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum angolense
27981175 27981175 PRJEB49404_P_NODE_650805_length_150_cov_1.477477_g637004_i0 PRJEB49404 650805 150 1.477477 2.2162155 Lolium multiflorum 4521 Plants Plants 108 9.58e-26   NR KAK1678802.1 4521 g637004 i0 100 11 50 0 100 0 1 150 395 444 KAK1678802.1 hypothetical protein QYE76_039650 [Lolium multiflorum] diamond 1650 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
28075713 28075713 PRJEB49404_P_NODE_406125_length_211_cov_2.622093_g392324_i0 PRJEB49404 406125 211 2.622093 5.53261623 Olea europaea subsp. europaea 158383 Plants Plants 143 8.63e-38   NR CAA2977210.1 158383 g392324 i0 100 0.995260663507109 70 0 99.5 0 1 210 729 798 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 210 143 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28226718 28226718 PRJEB49404_P_NODE_573546_length_165_cov_0.920635_g559745_i0 PRJEB49404 573546 165 0.920635 1.51904775 Lamiales 4143 Plants Plants 76.3 1.75e-14   NR KAK4492938.1 160366 g559745 i0 61.8 5 55 21 100 0 1 165 35 89 KAK4492938.1 hypothetical protein RD792_000265 [Penstemon davidsonii] diamond 825 77 0.990909090909091 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Penstemon Penstemon davidsonii
28675867 28675867 PRJEB49404_P_NODE_511087_length_179_cov_1.314286_g497286_i0 PRJEB49404 511087 179 1.314286 2.35257194 Olea europaea subsp. europaea 158383 Plants Plants 115 6.419999999999999e-31   NR CAA3004955.1 158383 g497286 i0 100 0.988826815642458 59 0 98.9 0 179 3 88 146 CAA3004955.1 Hypothetical predicted protein [Olea europaea subsp. europaea] diamond 177 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28738922 28738922 PRJEB49404_P_NODE_511767_length_179_cov_1.171429_g497966_i0 PRJEB49404 511767 179 1.171429 2.09685791 Olea europaea subsp. europaea 158383 Plants Plants 122 3.1599999999999997e-32   NR CAA2962657.1 158383 g497966 i0 100 1.97765363128492 59 0 98.9 0 178 2 84 142 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 354 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
29117980 29117980 PRJEB49404_P_NODE_206089_length_345_cov_1.133987_g192290_i0 PRJEB49404 206089 345 1.133987 3.91225515 Handroanthus impetiginosus 429701 Plants Plants 42.4 0.0436   NR PIN08873.1 429701 g192290 i0 65.4 0.226086956521739 26 9 22.6 0 178 255 1 26 PIN08873.1 hypothetical protein CDL12_18546 [Handroanthus impetiginosus] diamond 78 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Bignoniaceae Handroanthus Handroanthus impetiginosus
29338889 29338889 PRJEB49404_P_NODE_508089_length_180_cov_1.106383_g494288_i0 PRJEB49404 508089 180 1.106383 1.9914894 Olea europaea subsp. europaea 158383 Plants Plants 111 8.640000000000001e-27   NR CAA2977210.1 158383 g494288 i0 100 0.983333333333333 59 0 98.3 0 178 2 245 303 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 177 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
29963691 29963691 PRJEB49404_P_NODE_623691_length_155_cov_1.405172_g609890_i0 PRJEB49404 623691 155 1.405172 2.1780166 Lamiales 4143 Plants Plants 61.2 7.1e-10   NR KAG8365535.1 168488 g609890 i0 58.5 5.10967741935484 41 17 79.4 0 30 152 70 110 KAG8365535.1 hypothetical protein BUALT_Bualt18G0115200 [Buddleja alternifolia] diamond 792 61.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Scrophulariaceae Buddleja Buddleja alternifolia
30254986 30254986 PRJEB49404_P_NODE_508272_length_180_cov_0.822695_g494471_i0 PRJEB49404 508272 180 0.822695 1.480851 Taxus chinensis 29808 Plants Plants 99.8 1.34e-22   NR KAH9316782.1 29808 g494471 i0 73.7 0.95 57 15 95 0 172 2 1036 1092 KAH9316782.1 hypothetical protein KI387_044020 [Taxus chinensis] diamond 171 99.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
30343286 30343286 PRJEB49404_P_NODE_266792_length_287_cov_1.588710_g252991_i0 PRJEB49404 266792 287 1.58871 4.5595977 Magnoliopsida 3398 Plants Plants 148 1.63e-40   NR KAJ7943525.1 32244 g252991 i0 74.7 1.98606271777003 95 24 99.3 0 3 287 128 222 KAJ7943525.1 Pectate lyase [Quillaja saponaria] diamond 570 149 0.993288590604027 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria
30886602 30886602 PRJEB49404_P_NODE_193234_length_360_cov_14.429907_g179435_i0 PRJEB49404 193234 360 14.429907 51.9476652 Aristolochia fimbriata 158543 Plants Plants 45.8 0.0109   NR KAG9438328.1 158543 g179435 i0 47.2 0.441666666666667 53 26 44.2 1 86 244 193 243 KAG9438328.1 hypothetical protein H6P81_021735 [Aristolochia fimbriata] diamond 159 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
30918351 30918351 PRJEB49404_P_NODE_413294_length_209_cov_1.205882_g399493_i0 PRJEB49404 413294 209 1.205882 2.52029338 Genlisea aurea 192259 Plants Plants 87.4 4.3e-18   NR EPS72881.1 192259 g399493 i0 80.9 0.674641148325359 47 9 67.5 0 207 67 539 585 EPS72881.1 pollen-specific protein [Genlisea aurea] diamond 141 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lentibulariaceae Genlisea Genlisea aurea
31234000 31234000 PRJEB49404_P_NODE_330155_length_246_cov_1.792271_g316354_i0 PRJEB49404 330155 246 1.792271 4.40898666 Olea europaea subsp. europaea 158383 Plants Plants 168 1.24e-49   NR CAA2962657.1 158383 g316354 i0 100 2 82 0 100 0 1 246 187 268 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 492 168 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31329054 31329054 PRJEB49404_P_NODE_577536_length_164_cov_1.296000_g563735_i0 PRJEB49404 577536 164 1.296 2.12544 Penstemon davidsonii 160366 Plants Plants 87.4 1.54e-18   NR KAK4492938.1 160366 g563735 i0 69.8 1.9390243902439 53 16 97 0 4 162 93 145 KAK4492938.1 hypothetical protein RD792_000265 [Penstemon davidsonii] diamond 318 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Penstemon Penstemon davidsonii
31480834 31480834 PRJEB49404_P_NODE_645196_length_151_cov_1.464286_g631395_i0 PRJEB49404 645196 151 1.464286 2.21107186 root 1 Root_unresolved Root_unresolved 95.5 2.77e-21   NR CAA2991155.1 158383 g631395 i0 100 1.98675496688742 50 0 99.3 0 2 151 138 187 CAA2991155.1 ATP-dependent exoDNAse (exonuclease V) beta subunit (contains helicase and exonuclease domains), partial [Olea europaea subsp. europaea] diamond 300 95.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
32373199 32373199 PRJEB49404_P_NODE_619279_length_156_cov_1.051282_g605478_i0 PRJEB49404 619279 156 1.051282 1.63999992 Mangifera indica 29780 Plants Plants 59.7 9.64e-9   NR XP_044509625.1 29780 g605478 i0 61.5 1.98076923076923 52 20 100 0 156 1 136 187 XP_044509625.1 uncharacterized protein LOC123228334 [Mangifera indica] diamond 309 59.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Anacardiaceae Mangifera Mangifera indica

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