RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 23 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB25789 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
3849243 3849243 PRJEB25789_S_NODE_10704_length_298_cov_0.982222_g10625_i0 PRJEB25789 10704 298 0.982222 2.92702156 Poaceae 4479 Plants Plants 176 1.01e-48   NR XP_044367446.1 4565 g10625 i0 80.8 42.5134228187919 99 19 99.7 0 298 2 1067 1165 XP_044367446.1 calmodulin-interacting protein 111-like [Triticum aestivum] diamond 12669 176 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
11501274 11501274 PRJEB25789_S_NODE_3850_length_447_cov_1.441176_g3771_i0 PRJEB25789 3850 447 1.441176 6.44205672 Eukaryota 2759 Plants Plants 154 2.5799999999999997e-45   NR ABK21285.1 3332 g3771 i0 62.7 42.8859060402685 134 47 89.9 1 440 39 5 135 ABK21285.1 unknown [Picea sitchensis] diamond 19170 154 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
14051265 14051265 PRJEB25789_S_NODE_15532_length_257_cov_11.423913_g15453_i0 PRJEB25789 15532 257 11.423913 29.35945641 Capsicum chinense 80379 Plants Plants 148 1.22e-44   NR PHU02471.1 80379 g15453 i0 95.9 0.852140077821012 73 3 85.2 0 13 231 1 73 PHU02471.1 hypothetical protein BC332_27722 [Capsicum chinense] diamond 219 148 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum chinense
17874895 17874895 PRJEB25789_S_NODE_4995_length_400_cov_1.431193_g4916_i0 PRJEB25789 4995 400 1.431193 5.724772 Striga asiatica 4170 Plants Plants 182 2.09e-50   NR GER25934.1 4170 g4916 i0 68.9 1.98 132 38 98.3 2 397 5 6 135 GER25934.1 glucose-repressible alcohol dehydrogenasetranscriptional effector [Striga asiatica] diamond 792 182 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga asiatica
19148545 19148545 PRJEB25789_S_NODE_12676_length_279_cov_1.495146_g12597_i0 PRJEB25789 12676 279 1.495146 4.17145734 Eukaryota 2759 Plants Plants 138 1.31e-39   NR KAG0574660.1 3225 g12597 i0 81 16.9032258064516 79 15 84.9 0 2 238 67 145 KAG0574660.1 hypothetical protein KC19_VG280900 [Ceratodon purpureus] diamond 4716 138 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
21388794 21388794 PRJEB25789_S_NODE_4137_length_433_cov_1.363889_g4058_i0 PRJEB25789 4137 433 1.363889 5.90563937 Abeliophyllum distichum 126358 Plants Plants 206 8.66e-65   NR KAL2533260.1 126358 g4058 i0 71 1.91224018475751 138 40 95.6 0 3 416 64 201 KAL2533260.1 40S ribosomal protein S3-2 [Abeliophyllum distichum] diamond 828 206 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Abeliophyllum Abeliophyllum distichum
21699922 21699922 PRJEB25789_S_NODE_20438_length_233_cov_2.406250_g20359_i0 PRJEB25789 20438 233 2.40625 5.6065625 Eukaryota 2759 Plants Plants 125 4.95e-33   NR XP_010927260.3 51953 g20359 i0 76.6 23.7424892703863 77 18 99.1 0 233 3 153 229 XP_010927260.3 60S ribosomal protein L7-4 isoform X1 [Elaeis guineensis] diamond 5532 126 0.992063492063492 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Arecales Arecaceae Elaeis Elaeis guineensis
22975006 22975006 PRJEB25789_S_NODE_10799_length_297_cov_0.964286_g10720_i0 PRJEB25789 10799 297 0.964286 2.86392942 Arachis hypogaea 3818 Plants Plants 102 2.95e-26   NR KAL4326576.1 3818 g10720 i0 100 0.565656565656566 56 0 56.6 0 297 130 30 85 KAL4326576.1 hypothetical protein AHAS_Ahas13G0013900 [Arachis hypogaea] diamond 168 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
24249029 24249029 PRJEB25789_S_NODE_19020_length_244_cov_0.900585_g18941_i0 PRJEB25789 19020 244 0.900585 2.1974274 Magnoliopsida 3398 Plants Plants 148 5.11e-41   NR XP_022148744.1 3673 g18941 i0 86.3 58.0327868852459 80 11 98.4 0 3 242 103 182 XP_022148744.1 ADP,ATP carrier protein 1, mitochondrial-like, partial [Momordica charantia] diamond 14160 149 0.993288590604027 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Momordica Momordica charantia
27191094 27191094 PRJEB25789_S_NODE_7602_length_338_cov_1.418868_g7523_i0 PRJEB25789 7602 338 1.418868 4.79577384 Lotus japonicus 34305 Plants Plants 173 7.57e-53   NR AFK43985.1 34305 g7523 i0 71.4 0.994082840236686 112 32 99.4 0 338 3 51 162 AFK43985.1 unknown [Lotus japonicus] diamond 336 173 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
27412665 27412665 PRJEB25789_S_NODE_12883_length_277_cov_1.789216_g12804_i0 PRJEB25789 12883 277 1.789216 4.95612832 Arachis hypogaea 3818 Plants Plants 143 2.3299999999999993e-42   NR KAL1298095.1 3818 g12804 i0 100 0.877256317689531 81 0 87.7 0 245 3 1 81 KAL1298095.1 hypothetical protein AAHE18_18G007500 [Arachis hypogaea] diamond 243 143 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
28201584 28201584 PRJEB25789_S_NODE_19986_length_241_cov_0.916667_g19907_i0 PRJEB25789 19986 241 0.916667 2.20916747 Brassica napus 3708 Plants Plants 59.3 1.4e-8   NR WZY98609.1 3708 g19907 i0 72.7 0.547717842323652 44 12 54.8 0 238 107 133 176 WZY98609.1 hypothetical protein YC2023_070938 [Brassica napus] diamond 132 59.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
29710512 29710512 PRJEB25789_S_NODE_5650_length_380_cov_1.250814_g5571_i0 PRJEB25789 5650 380 1.250814 4.7530932 Magnoliopsida 3398 Plants Plants 155 1.0800000000000001e-44   NR XP_007016064.2 3641 g5571 i0 66.9 30.7894736842105 118 38 92.4 1 351 1 73 190 XP_007016064.2 PREDICTED: superoxide dismutase [Cu-Zn], chloroplastic [Theobroma cacao] diamond 11700 155 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Theobroma Theobroma cacao
30532195 30532195 PRJEB25789_S_NODE_6493_length_360_cov_1.073171_g6414_i0 PRJEB25789 6493 360 1.073171 3.8634156 Eukaryota 2759 Plants Plants 167 1.29e-48   NR XP_002981679.1 88036 g6414 i0 68.9 11.8916666666667 119 37 99.2 0 2 358 82 200 XP_002981679.1 60S ribosomal protein L5-2 [Selaginella moellendorffii] diamond 4281 167 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
31069583 31069583 PRJEB25789_S_NODE_10015_length_305_cov_1.306034_g9936_i0 PRJEB25789 10015 305 1.306034 3.9834037 Eukaryota 2759 Plants Plants 135 2.86e-38   NR XP_019424438.1 3871 g9936 i0 72.3 12.9147540983607 101 27 99.3 1 303 1 29 128 XP_019424438.1 PREDICTED: 40S ribosomal protein S15-4-like [Lupinus angustifolius] diamond 3939 135 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lupinus Lupinus angustifolius
31297063 31297063 PRJEB25789_S_NODE_20295_length_237_cov_2.164634_g20216_i0 PRJEB25789 20295 237 2.164634 5.13018258 Ceratopteris richardii 49495 Plants Plants 58.9 9.71e-9   NR KAH7299535.1 49495 g20216 i0 65.3 1.24050632911392 49 17 62 0 207 61 19 67 KAH7299535.1 hypothetical protein KP509_24G016800 [Ceratopteris richardii] diamond 294 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
31613392 31613392 PRJEB25789_S_NODE_18336_length_246_cov_0.890173_g18257_i0 PRJEB25789 18336 246 0.890173 2.18982558 Carex littledalei 544730 Plants Plants 54.3 2.64e-6   NR KAF3338163.1 544730 g18257 i0 42.7 2.90243902439024 82 45 97.6 2 241 2 4 85 KAF3338163.1 Calmodulin [Carex littledalei] diamond 714 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Cyperaceae Carex Carex littledalei
31859839 31859839 PRJEB25789_S_NODE_8977_length_318_cov_0.877551_g8898_i0 PRJEB25789 8977 318 0.877551 2.79061218 Magnoliopsida 3398 Plants Plants 121 3.4e-32   NR KAJ0458454.1 4232 g8898 i0 71.2 11.7735849056604 104 30 98.1 0 3 314 70 173 KAJ0458454.1 putative ribosomal protein L29/L35 [Helianthus annuus] diamond 3744 121 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
32049786 32049786 PRJEB25789_S_NODE_12018_length_285_cov_1.080189_g11939_i0 PRJEB25789 12018 285 1.080189 3.07853865 Magnoliopsida 3398 Plants Plants 102 7.58e-25   NR XP_027367933.1 3816 g11939 i0 71.6 34.7789473684211 74 21 77.9 0 3 224 98 171 XP_027367933.1 60S ribosomal protein L19-1-like [Abrus precatorius] diamond 9912 102 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Abrus Abrus precatorius
32208105 32208105 PRJEB25789_S_NODE_8178_length_329_cov_1.203125_g8099_i0 PRJEB25789 8178 329 1.203125 3.95828125 Eukaryota 2759 Plants Plants 119 2.58e-32   NR KAH0928806.1 3708 g8099 i0 62.2 63.8115501519757 98 37 89.4 0 35 328 12 109 KAH0928806.1 hypothetical protein HID58_014533, partial [Brassica napus] diamond 20994 120 0.991666666666667 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
32309723 32309723 PRJEB25789_S_NODE_18399_length_246_cov_0.861272_g18320_i0 PRJEB25789 18399 246 0.861272 2.11872912 Brassica carinata 52824 Plants Plants 149 5.649999999999999e-40   NR KAG2312245.1 52824 g18320 i0 98.8 1.97560975609756 81 1 98.8 0 244 2 426 506 KAG2312245.1 hypothetical protein Bca52824_023802 [Brassica carinata] diamond 486 149 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata
32461272 32461272 PRJEB25789_S_NODE_20479_length_232_cov_2.138365_g20400_i0 PRJEB25789 20479 232 2.138365 4.9610068 Eukaryota 2759 Plants Plants 99.4 1.73e-22   NR XP_006837160.1 13333 g20400 i0 61.8 2.94827586206897 76 29 98.3 0 231 4 263 338 XP_006837160.1 60S ribosomal protein L4 [Amborella trichopoda] diamond 684 100 0.994 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Amborellales Amborellaceae Amborella Amborella trichopoda
32467870 32467870 PRJEB25789_S_NODE_16679_length_251_cov_0.865169_g16600_i0 PRJEB25789 16679 251 0.865169 2.17157419 Brassica carinata 52824 Plants Plants 48.5 3.53e-4   NR KAG2318828.1 52824 g16600 i0 100 0.262948207171315 22 0 26.3 0 2 67 307 328 KAG2318828.1 hypothetical protein Bca52824_012041 [Brassica carinata] diamond 66 48.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica carinata

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