RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1034995" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 28 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1034995 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
1443137 1443137 PRJNA1034995_S_NODE_24922_length_318_cov_10.156364_g24766_i0 PRJNA1034995 24922 318 10.156364 32.29723752 Dipteronia dyeriana 168575 Plants Plants 95.1 3.23e-20   NR KAK2653519.1 168575 g24766 i0 84.9 0.5 53 8 50 0 38 196 351 403 KAK2653519.1 hypothetical protein Ddye_013375 [Dipteronia dyeriana] diamond 159 95.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia dyeriana
3994858 3994858 PRJNA1034995_S_NODE_15064_length_493_cov_33.622222_g14913_i0 PRJNA1034995 15064 493 33.622222 165.75755446 Carpinus fangiana 176857 Plants Plants 102 3.19e-25   NR KAE8037843.1 176857 g14913 i0 79.7 0.359026369168357 59 12 35.9 0 101 277 1 59 KAE8037843.1 hypothetical protein FH972_010398 [Carpinus fangiana] diamond 177 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
7820955 7820955 PRJNA1034995_S_NODE_14867_length_499_cov_22.747807_g14716_i0 PRJNA1034995 14867 499 22.747807 113.51155693 Carpinus fangiana 176857 Plants Plants 156 1.4199999999999998e-46   NR KAE8000011.1 176857 g14716 i0 94.9 0.468937875751503 78 3 46.3 1 6 236 1 78 KAE8000011.1 hypothetical protein FH972_004383 [Carpinus fangiana] diamond 234 156 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
10371573 10371573 PRJNA1034995_S_NODE_17829_length_424_cov_30.448819_g17674_i0 PRJNA1034995 17829 424 30.448819 129.10299256 Eukaryota 2759 Plants Plants 148 9.989999999999999e-41   NR AUF72246.1 200751 g17674 i0 75.9 12.877358490566 87 21 61.6 0 419 159 241 327 AUF72246.1 aldehyde dehydrogenase 2B2 [Syntrichia caninervis] diamond 5460 149 0.993288590604027 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pottiales Pottiaceae Syntrichia Syntrichia caninervis
14197190 14197190 PRJNA1034995_S_NODE_46372_length_177_cov_1.716418_g46216_i0 PRJNA1034995 46372 177 1.716418 3.03805986 Fagaceae 3503 Plants Plants 75.9 5.05e-15   NR KAK7832824.1 58331 g46216 i0 80.4 2.61016949152542 51 9 84.7 1 8 157 166 216 KAK7832824.1 hypothetical protein CFP56_026186 [Quercus suber] diamond 462 76.3 0.99475753604194 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus suber
15035286 15035286 PRJNA1034995_S_NODE_13272_length_563_cov_24.673077_g13133_i0 PRJNA1034995 13272 563 24.673077 138.90942351 Olea europaea subsp. europaea 158383 Plants Plants 233 1.6999999999999996e-75   NR CAA2999206.1 158383 g13133 i0 96.7 0.63943161634103 120 4 63.9 0 562 203 42 161 CAA2999206.1 probable calcium-binding CML16 [Olea europaea subsp. europaea] diamond 360 233 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
26782085 26782085 PRJNA1034995_S_NODE_17901_length_423_cov_17.281579_g17746_i0 PRJNA1034995 17901 423 17.281579 73.10107917 Carya illinoinensis 32201 Plants Plants 82.4 8.01e-18   NR KAG2687014.1 32201 g17746 i0 84.4 0.453900709219858 64 10 45.4 0 15 206 1 64 KAG2687014.1 hypothetical protein I3760_09G033900 [Carya illinoinensis] diamond 192 82.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Carya Carya illinoinensis
27003320 27003320 PRJNA1034995_S_NODE_17062_length_440_cov_32.279597_g16908_i0 PRJNA1034995 17062 440 32.279597 142.0302268 Fraxinus pennsylvanica 56036 Plants Plants 136 1.77e-38   NR CAI9779374.1 56036 g16908 i0 100 0.497727272727273 73 0 49.8 0 439 221 32 104 CAI9779374.1 unnamed protein product [Fraxinus pennsylvanica] diamond 219 136 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Fraxinus Fraxinus pennsylvanica
27003323 27003323 PRJNA1034995_S_NODE_24822_length_319_cov_11.728261_g24666_i0 PRJNA1034995 24822 319 11.728261 37.41315259 Digitaria exilis 1010633 Plants Plants 44.3 0.0262   NR KAF8723751.1 1010633 g24666 i0 42.2 0.423197492163009 45 26 42.3 0 61 195 658 702 KAF8723751.1 hypothetical protein HU200_021723 [Digitaria exilis] diamond 135 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Digitaria Digitaria exilis
27098321 27098321 PRJNA1034995_S_NODE_17562_length_430_cov_30.025840_g17407_i0 PRJNA1034995 17562 430 30.02584 129.111112 Carpinus fangiana 176857 Plants Plants 77.8 7.61e-16   NR KAE8076566.1 176857 g17407 i0 57.5 0.509302325581395 73 28 48.8 2 394 185 1 73 KAE8076566.1 hypothetical protein FH972_015206 [Carpinus fangiana] diamond 219 77.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
27280128 27280128 PRJNA1034995_S_NODE_13643_length_545_cov_12.551793_g13501_i0 PRJNA1034995 13643 545 12.551793 68.40727185 Magnoliopsida 3398 Plants Plants 90.1 1.97e-17   NR KAK6129861.1 99300 g13501 i0 97.7 74.245871559633 43 1 23.7 0 543 415 246 288 KAK6129861.1 hypothetical protein DH2020_036379 [Rehmannia glutinosa] diamond 40464 90.5 0.995580110497237 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
27319739 27319739 PRJNA1034995_S_NODE_16643_length_450_cov_11.132678_g16489_i0 PRJNA1034995 16643 450 11.132678 50.097051 Aristolochia fimbriata 158543 Plants Plants 49.3 0.00166   NR KAG9444621.1 158543 g16489 i0 66.7 0.2 30 10 20 0 230 319 871 900 KAG9444621.1 hypothetical protein H6P81_015961 [Aristolochia fimbriata] diamond 90 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
27982751 27982751 PRJNA1034995_S_NODE_25185_length_315_cov_16.823529_g25029_i0 PRJNA1034995 25185 315 16.823529 52.99411635 Quercus suber 58331 Plants Plants 116 3.72e-29   NR XP_023881912.2 58331 g25029 i0 91.8 1.16190476190476 61 5 58.1 0 7 189 247 307 XP_023881912.2 LOW QUALITY PROTEIN: ferritin-like catalase Nec2 [Quercus suber] diamond 366 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus suber
28551243 28551243 PRJNA1034995_S_NODE_19947_length_384_cov_36.082111_g19792_i0 PRJNA1034995 19947 384 36.082111 138.55530624 Carpinus fangiana 176857 Plants Plants 111 3.12e-29   NR KAE7996271.1 176857 g19792 i0 85.5 0.5390625 69 8 52.3 1 383 183 9 77 KAE7996271.1 hypothetical protein FH972_001005 [Carpinus fangiana] diamond 207 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
28677497 28677497 PRJNA1034995_S_NODE_17847_length_424_cov_21.015748_g17692_i0 PRJNA1034995 17847 424 21.015748 89.10677152 Forsythia ovata 205694 Plants Plants 69.3 1.18e-11   NR KAL2548042.1 205694 g17692 i0 57.6 0.466981132075472 66 19 45.3 2 25 216 8 66 KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] diamond 198 69.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata
28985421 28985421 PRJNA1034995_S_NODE_27448_length_292_cov_27.550201_g27292_i0 PRJNA1034995 27448 292 27.550201 80.44658692 Eukaryota 2759 Plants Plants 43.9 0.0247   NR VAI62701.1 4567 g27292 i0 59 0.636986301369863 39 15 40.1 1 174 290 173 210 VAI62701.1 unnamed protein product [Triticum turgidum subsp. durum] diamond 186 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum turgidum
29119637 29119637 PRJNA1034995_S_NODE_12349_length_639_cov_33.483221_g12247_i0 PRJNA1034995 12349 639 33.483221 213.95778219 Alnus glutinosa 3517 Plants Plants 66.6 4.26e-9   NR XP_062163396.1 3517 g12247 i0 59.6 0.685446009389671 146 44 65.7 7 639 220 155 291 XP_062163396.1 fasciclin-like arabinogalactan protein 14 [Alnus glutinosa] diamond 438 66.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Alnus Alnus glutinosa
29434839 29434839 PRJNA1034995_S_NODE_18470_length_412_cov_10.078591_g18315_i0 PRJNA1034995 18470 412 10.078591 41.52379492 Carpinus fangiana 176857 Plants Plants 140 1.52e-39   NR KAE8126039.1 176857 g18315 i0 94.7 0.546116504854369 75 4 54.6 0 18 242 100 174 KAE8126039.1 hypothetical protein FH972_020792 [Carpinus fangiana] diamond 225 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
30667055 30667055 PRJNA1034995_S_NODE_47293_length_173_cov_5.984615_g47137_i0 PRJNA1034995 47293 173 5.984615 10.35338395 Calluna vulgaris 13385 Plants Plants 43.9 0.00564   NR CAM5854212.1 13385 g47137 i0 36.4 0.763005780346821 44 28 76.3 0 135 4 83 126 CAM5854212.1 unnamed protein product [Calluna vulgaris] diamond 132 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Calluna Calluna vulgaris
30753896 30753896 PRJNA1034995_S_NODE_43434_length_189_cov_1.575342_g43278_i0 PRJNA1034995 43434 189 1.575342 2.97739638 Eukaryota 2759 Plants Plants 41.6 0.0474   NR KAL3701937.1 122646 g43278 i0 47.8 1.3015873015873 46 21 68.3 1 163 35 1202 1247 KAL3701937.1 hypothetical protein R1sor_019959 [Riccia sorocarpa] diamond 246 42 0.990476190476191 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Ricciaceae Riccia Riccia sorocarpa
31299033 31299033 PRJNA1034995_S_NODE_19255_length_397_cov_20.042373_g19100_i0 PRJNA1034995 19255 397 20.042373 79.56822081 Oldenlandia corymbosa var. corymbosa 529605 Plants Plants 45.1 0.0279   NR CAI9104576.1 529605 g19100 i0 30 0.680100755667506 90 61 68 1 383 114 216 303 CAI9104576.1 OLC1v1003279C1 [Oldenlandia corymbosa var. corymbosa] diamond 270 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Gentianales Rubiaceae Oldenlandia Oldenlandia corymbosa
31520629 31520629 PRJNA1034995_S_NODE_28296_length_284_cov_13.008299_g28140_i0 PRJNA1034995 28296 284 13.008299 36.94356916 Triticum turgidum subsp. durum 4567 Plants Plants 43.1 0.0449   NR VAH35142.1 4567 g28140 i0 42.4 0.623239436619718 59 32 60.2 1 112 282 742 800 VAH35142.1 unnamed protein product [Triticum turgidum subsp. durum] diamond 177 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum turgidum
31615364 31615364 PRJNA1034995_S_NODE_32456_length_251_cov_4.134615_g32300_i0 PRJNA1034995 32456 251 4.134615 10.37788365 Iris pallida 29817 Plants Plants 48.9 2.23e-4   NR KAJ6796307.1 29817 g32300 i0 57.5 0.932270916334661 40 15 47.8 1 243 124 209 246 KAJ6796307.1 putative carbohydrate esterase [Iris pallida] diamond 234 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Iridaceae Iris Iris pallida
32501475 32501475 PRJNA1034995_S_NODE_13099_length_574_cov_11.305085_g12966_i0 PRJNA1034995 13099 574 11.305085 64.8911879 Carya illinoinensis 32201 Plants Plants 63.9 6.03e-10   NR KAG2716517.1 32201 g12966 i0 66.7 0.219512195121951 42 11 21.4 2 572 450 33 72 KAG2716517.1 hypothetical protein I3760_03G130300 [Carya illinoinensis] diamond 126 63.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Juglandaceae Carya Carya illinoinensis
32658657 32658657 PRJNA1034995_S_NODE_27240_length_295_cov_3.285714_g27084_i0 PRJNA1034995 27240 295 3.285714 9.6928563 Alnus glutinosa 3517 Plants Plants 97.8 1.94e-21   NR XP_062151856.1 3517 g27084 i0 58.5 0.833898305084746 82 33 82.4 1 13 255 361 442 XP_062151856.1 disease resistance protein RPV1-like [Alnus glutinosa] diamond 246 97.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Alnus Alnus glutinosa
32658659 32658659 PRJNA1034995_S_NODE_32900_length_247_cov_60.245098_g32744_i0 PRJNA1034995 32900 247 60.245098 148.80539206 Closterium sp. Naga37s-1 2996811 Plants Plants 43.1 0.0283   NR CAI5507319.1 2996811 g32744 i0 45.8 0.874493927125506 72 24 74.1 4 242 60 90 157 CAI5507319.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 216 43.1 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1
32690320 32690320 PRJNA1034995_S_NODE_24200_length_326_cov_4.689046_g24044_i0 PRJNA1034995 24200 326 4.689046 15.28628996 Dipteronia sinensis 43782 Plants Plants 81.3 6.1e-17   NR KAK3222257.1 43782 g24044 i0 58.2 0.616564417177914 67 15 55.2 3 213 34 3 63 KAK3222257.1 hypothetical protein Dsin_009282 [Dipteronia sinensis] diamond 201 81.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia sinensis
32721990 32721990 PRJNA1034995_S_NODE_17580_length_430_cov_21.211886_g17425_i0 PRJNA1034995 17580 430 21.211886 91.2111098 Acer negundo 4023 Plants Plants 103 2.87e-24   NR KAI9166062.1 4023 g17425 i0 91.7 0.418604651162791 60 5 41.9 0 22 201 149 208 KAI9166062.1 hypothetical protein LWI28_025636 [Acer negundo] diamond 180 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo

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