RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA414225 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
16385596 16385596 PRJNA414225_P_NODE_59293_length_166_cov_0.871795_g59206_i0 PRJNA414225 59293 166 0.871795 1.4471797 Brachypodium distachyon 15368 Plants Plants 89.7 2.2700000000000004e-21   NR XP_014757824.1 15368 g59206 i0 77.8 1.95180722891566 54 12 97.6 0 164 3 50 103 XP_014757824.1 uncharacterized protein K02A2.6-like [Brachypodium distachyon] diamond 324 89.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Brachypodium Brachypodium distachyon
26822555 26822555 PRJNA414225_P_NODE_12781_length_199_cov_1.173333_g12694_i0 PRJNA414225 12781 199 1.173333 2.33493267 Daucus carota subsp. sativus 79200 Plants Plants 108 3.01e-29   NR WOG96822.1 79200 g12694 i0 81.8 0.994974874371859 66 12 99.5 0 1 198 4 69 WOG96822.1 hypothetical protein DCAR_0416159 [Daucus carota subsp. sativus] diamond 198 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
26980583 26980583 PRJNA414225_P_NODE_91362_length_152_cov_2.669903_g91275_i0 PRJNA414225 91362 152 2.669903 4.05825256 Hordeum vulgare 4513 Plants Plants 55.5 3.37e-7   NR KAE8799701.1 4513 g91275 i0 68.8 0.631578947368421 32 10 63.2 0 55 150 112 143 KAE8799701.1 cyclopropane-fatty-acyl-phospholipid synthase [Hordeum vulgare] diamond 96 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27423461 27423461 PRJNA414225_P_NODE_85463_length_162_cov_0.902655_g85376_i0 PRJNA414225 85463 162 0.902655 1.4623011 Hordeum vulgare 4513 Plants Plants 66.6 4.31e-11   NR KAE8792888.1 4513 g85376 i0 59.6 3.87037037037037 52 21 96.3 0 6 161 312 363 KAE8792888.1 hypothetical protein D1007_32525 [Hordeum vulgare] diamond 627 66.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27802238 27802238 PRJNA414225_P_NODE_2144_length_300_cov_1.864542_g2057_i0 PRJNA414225 2144 300 1.864542 5.593626 Tanacetum cinerariifolium 118510 Plants Plants 158 1.99e-44   NR GFB96483.1 118510 g2057 i0 78.8 0.99 99 21 99 0 299 3 46 144 GFB96483.1 hypothetical protein [Tanacetum cinerariifolium] diamond 297 158 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
27802244 27802244 PRJNA414225_P_NODE_71324_length_164_cov_0.886957_g71237_i0 PRJNA414225 71324 164 0.886957 1.45460948 Eragrostis curvula 38414 Plants Plants 77.4 7.61e-15   NR TVU09293.1 38414 g71237 i0 61.1 3.95121951219512 54 21 98.8 0 164 3 458 511 TVU09293.1 hypothetical protein EJB05_42756, partial [Eragrostis curvula] diamond 648 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Eragrostis Eragrostis curvula
27881858 27881858 PRJNA414225_P_NODE_86205_length_162_cov_0.902655_g86118_i0 PRJNA414225 86205 162 0.902655 1.4623011 Poaceae 4479 Plants Plants 71.2 1.07e-12   NR XP_044336269.1 4565 g86118 i0 66 3.81481481481481 50 17 92.6 0 153 4 185 234 XP_044336269.1 uncharacterized protein LOC123057264 [Triticum aestivum] diamond 618 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
27896708 27896708 PRJNA414225_P_NODE_65785_length_165_cov_0.879310_g65698_i0 PRJNA414225 65785 165 0.87931 1.4508615 Triticum aestivum 4565 Plants Plants 50.8 1.74e-5   NR XBI17543.1 4565 g65698 i0 73.5 1.23636363636364 34 9 61.8 0 5 106 298 331 XBI17543.1 hypothetical protein VPH35_059571 [Triticum aestivum] diamond 204 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
27928407 27928407 PRJNA414225_P_NODE_57985_length_166_cov_0.871795_g57898_i0 PRJNA414225 57985 166 0.871795 1.4471797 Salvia miltiorrhiza 226208 Plants Plants 48.9 8.53e-5   NR XP_057782307.1 226208 g57898 i0 44 2.60240963855422 50 27 90.4 1 6 155 740 788 XP_057782307.1 DExH-box ATP-dependent RNA helicase DExH8 [Salvia miltiorrhiza] diamond 432 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia miltiorrhiza
28212316 28212316 PRJNA414225_P_NODE_77846_length_163_cov_0.894737_g77759_i0 PRJNA414225 77846 163 0.894737 1.45842131 Triticum aestivum 4565 Plants Plants 63.9 2.63e-10   NR BDI54607.1 4565 g77759 i0 63.5 1.91411042944785 52 19 95.7 0 158 3 111 162 BDI54607.1 LTR retrotransposon-like protein [Triticum aestivum] diamond 312 63.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
29191462 29191462 PRJNA414225_P_NODE_47489_length_167_cov_1.338983_g47402_i0 PRJNA414225 47489 167 1.338983 2.23610161 Citrus x changshan-huyou 2935761 Plants Plants 119 1.45e-32   NR KAK9224960.1 2935761 g47402 i0 100 0.988023952095808 55 0 98.8 0 2 166 91 145 KAK9224960.1 hypothetical protein WN943_010000 [Citrus x changshan-huyou] diamond 165 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus x changshan-huyou
29538575 29538575 PRJNA414225_P_NODE_87670_length_162_cov_0.902655_g87583_i0 PRJNA414225 87670 162 0.902655 1.4623011 Medicago truncatula 3880 Plants Plants 50.8 1.11e-5   NR KEH26362.1 3880 g87583 i0 45.5 1.61111111111111 44 24 81.5 0 160 29 165 208 KEH26362.1 hypothetical protein MTR_6g053050 [Medicago truncatula] diamond 261 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Medicago Medicago truncatula
29744501 29744501 PRJNA414225_P_NODE_79170_length_163_cov_0.894737_g79083_i0 PRJNA414225 79170 163 0.894737 1.45842131 Poaceae 4479 Plants Plants 71.2 1.07e-12   NR KAK1603765.1 4521 g79083 i0 60.4 3.90184049079755 53 21 97.5 0 161 3 176 228 KAK1603765.1 hypothetical protein QYE76_027438 [Lolium multiflorum] diamond 636 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
30945393 30945393 PRJNA414225_P_NODE_80214_length_163_cov_0.894737_g80127_i0 PRJNA414225 80214 163 0.894737 1.45842131 Streptophyta 35493 Plants Plants 55.5 4.09e-7   NR GLJ45662.1 3369 g80127 i0 71.1 12.5889570552147 38 11 69.9 0 37 150 132 169 GLJ45662.1 hypothetical protein SUGI_0961100 [Cryptomeria japonica] diamond 2052 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
31212568 31212568 PRJNA414225_P_NODE_57955_length_166_cov_0.871795_g57868_i0 PRJNA414225 57955 166 0.871795 1.4471797 Alopecurus aequalis 114194 Plants Plants 64.7 1.82e-10   NR CAM0943024.1 114194 g57868 i0 87.9 0.596385542168675 33 4 59.6 0 16 114 275 307 CAM0943024.1 unnamed protein product [Alopecurus aequalis] diamond 99 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Alopecurus Alopecurus aequalis
31307799 31307799 PRJNA414225_P_NODE_72855_length_164_cov_0.886957_g72768_i0 PRJNA414225 72855 164 0.886957 1.45460948 Picea sitchensis 3332 Plants Plants 50.1 9.46e-6   NR ABK26737.1 3332 g72768 i0 47.2 0.969512195121951 53 28 97 0 1 159 27 79 ABK26737.1 unknown [Picea sitchensis] diamond 159 50.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
31402953 31402953 PRJNA414225_P_NODE_41496_length_170_cov_3.198347_g41409_i0 PRJNA414225 41496 170 3.198347 5.4371899 Salvia splendens 180675 Plants Plants 65.5 1.32e-10   NR KAG6385467.1 180675 g41409 i0 54.5 1.95882352941176 55 25 97.1 0 5 169 431 485 KAG6385467.1 hypothetical protein SASPL_154302 [Salvia splendens] diamond 333 65.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia splendens
31908870 31908870 PRJNA414225_P_NODE_22737_length_185_cov_1.500000_g22650_i0 PRJNA414225 22737 185 1.5 2.775 Thalictrum thalictroides 46969 Plants Plants 43.5 0.00946   NR KAF5180416.1 46969 g22650 i0 41.4 1.91351351351351 58 34 94.1 0 3 176 2514 2571 KAF5180416.1 Ccr4-not transcription complex subunit [Thalictrum thalictroides] diamond 354 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Ranunculaceae Thalictrum Thalictrum thalictroides
31957055 31957055 PRJNA414225_P_NODE_74457_length_164_cov_0.886957_g74370_i0 PRJNA414225 74457 164 0.886957 1.45460948 Picea 3328 Plants Plants 48.9 6.85e-6   NR KUM48943.1 3330 g74370 i0 46 1.82926829268293 50 27 91.5 0 163 14 21 70 KUM48943.1 hypothetical protein ABT39_MTgene4279 [Picea glauca] diamond 300 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea glauca
32130551 32130551 PRJNA414225_P_NODE_85038_length_162_cov_0.902655_g84951_i0 PRJNA414225 85038 162 0.902655 1.4623011 Penstemon smallii 265156 Plants Plants 80.9 4.58e-16   NR KAL3824038.1 265156 g84951 i0 70.4 7 54 16 100 0 1 162 369 422 KAL3824038.1 hypothetical protein ACJIZ3_020067 [Penstemon smallii] diamond 1134 80.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Penstemon Penstemon smallii
32667652 32667652 PRJNA414225_P_NODE_48220_length_167_cov_0.864407_g48133_i0 PRJNA414225 48220 167 0.864407 1.44355969 Capsicum chinense 80379 Plants Plants 78.2 4.26e-15   NR PHU07288.1 80379 g48133 i0 65.5 1.97604790419162 55 19 98.8 0 167 3 168 222 PHU07288.1 Protein trichome birefringence-like 11 [Capsicum chinense] diamond 330 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum chinense

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