RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1103784 · 33 ✖

analysis 1

  • diamond · 33 ✖
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
2762822 2762822 PRJNA1103784_P_NODE_3263_length_304_cov_2.463203_g3208_i0 PRJNA1103784 3263 304 2.463203 7.48813712 Eukaryota 2759 Plants Plants 165 7.86e-50   NR DAD22394.1 4432 g3208 i0 80.2 43.8256578947368 96 19 94.7 0 298 11 1 96 DAD22394.1 TPA_asm: hypothetical protein HUJ06_023857 [Nelumbo nucifera] diamond 13323 165 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Proteales Nelumbonaceae Nelumbo Nelumbo nucifera
4038960 4038960 PRJNA1103784_P_NODE_944_length_508_cov_3.820690_g889_i0 PRJNA1103784 944 508 3.82069 19.4091052 Eukaryota 2759 Plants Plants 206 3.62e-63   NR KAF4353155.1 3483 g889 i0 61.6 61.2047244094488 159 60 93.9 1 507 31 150 307 KAF4353155.1 hypothetical protein G4B88_003032 [Cannabis sativa] diamond 31092 208 0.990384615384615 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
6590276 6590276 PRJNA1103784_P_NODE_926_length_512_cov_1.772210_g871_i0 PRJNA1103784 926 512 1.77221 9.0737152 Magnoliopsida 3398 Plants Plants 206 6.82e-65   NR NP_001413444.1 4232 g871 i0 65.6 5.326171875 154 51 89.6 2 54 512 7 159 NP_001413444.1 probable phospholipid hydroperoxide glutathione peroxidase [Helianthus annuus] diamond 2727 206 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
7397971 7397971 PRJNA1103784_P_NODE_4046_length_281_cov_2.163462_g3991_i0 PRJNA1103784 4046 281 2.163462 6.07932822 Lotus japonicus 34305 Plants Plants 142 1.17e-40   NR AFK45544.1 34305 g3991 i0 76.1 0.98220640569395 92 22 98.2 0 278 3 7 98 AFK45544.1 unknown [Lotus japonicus] diamond 276 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
8673421 8673421 PRJNA1103784_P_NODE_7067_length_244_cov_0.982456_g7012_i0 PRJNA1103784 7067 244 0.982456 2.39719264 Eukaryota 2759 Plants Plants 126 2.01e-34   NR XP_026448548.1 3469 g7012 i0 80 20.6803278688525 80 16 98.4 0 4 243 57 136 XP_026448548.1 60S ribosomal protein L19-1-like [Papaver somniferum] diamond 5046 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver somniferum
10415561 10415561 PRJNA1103784_P_NODE_5269_length_257_cov_1.673913_g5214_i0 PRJNA1103784 5269 257 1.673913 4.30195641 Eukaryota 2759 Plants Plants 155 2.44e-43   NR KAF2300883.1 3981 g5214 i0 87.1 144.817120622568 85 11 99.2 0 256 2 311 395 KAF2300883.1 hypothetical protein GH714_018009 [Hevea brasiliensis] diamond 37218 156 0.993589743589744 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
11690803 11690803 PRJNA1103784_P_NODE_2890_length_319_cov_1.756098_g2835_i0 PRJNA1103784 2890 319 1.756098 5.60195262 Eukaryota 2759 Plants Plants 157 2.8399999999999998e-42   NR WRX31834.1 3641 g2835 i0 70.8 194.210031347962 106 31 99.7 0 319 2 385 490 WRX31834.1 Helicase [Theobroma cacao] diamond 61953 157 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Theobroma Theobroma cacao
13773503 13773503 PRJNA1103784_P_NODE_1671_length_400_cov_3.119266_g1616_i0 PRJNA1103784 1671 400 3.119266 12.477064 Eukaryota 2759 Plants Plants 115 3.15e-28   NR NP_001077626.1 3702 g1616 i0 49.1 18.21 106 54 79.5 0 320 3 132 237 NP_001077626.1 60S ribosomal protein L18A-1 [Arabidopsis thaliana] diamond 7284 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
18063827 18063827 PRJNA1103784_P_NODE_4255_length_277_cov_1.377451_g4200_i0 PRJNA1103784 4255 277 1.377451 3.81553927 Eukaryota 2759 Plants Plants 176 7.64e-49   NR KAJ7526708.1 34168 g4200 i0 84.6 145.862815884477 91 14 98.6 0 273 1 588 678 KAJ7526708.1 hypothetical protein O6H91_16G019100 [Diphasiastrum complanatum] diamond 40404 176 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
18063877 18063877 PRJNA1103784_P_NODE_7315_length_243_cov_0.905882_g7260_i0 PRJNA1103784 7315 243 0.905882 2.20129326 Eukaryota 2759 Plants Plants 137 3.98e-38   NR XP_031482095.1 210225 g7260 i0 76.3 18.6049382716049 80 19 98.8 0 242 3 141 220 XP_031482095.1 60S ribosomal protein L7-2-like [Nymphaea colorata] diamond 4521 137 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
20613272 20613272 PRJNA1103784_P_NODE_1337_length_440_cov_1.405995_g1282_i0 PRJNA1103784 1337 440 1.405995 6.186378 Eukaryota 2759 Plants Plants 198 1.66e-61   NR KAF1894907.1 3870 g1282 i0 74.8 162.497727272727 131 33 89.3 0 438 46 80 210 KAF1894907.1 hypothetical protein Lal_00022401 [Lupinus albus] diamond 71499 199 0.994974874371859 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lupinus Lupinus albus
20613284 20613284 PRJNA1103784_P_NODE_2517_length_339_cov_2.075188_g2462_i0 PRJNA1103784 2517 339 2.075188 7.03488732 Streptophyta 35493 Plants Plants 173 2.52e-48   NR KAL2649746.1 41844 g2462 i0 73.5 49 113 30 100 0 1 339 233 345 KAL2649746.1 hypothetical protein R1flu_017874 [Riccia fluitans] diamond 16611 174 0.994252873563218 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Ricciaceae Riccia Riccia fluitans
21888979 21888979 PRJNA1103784_P_NODE_758_length_560_cov_3.043121_g704_i0 PRJNA1103784 758 560 3.043121 17.0414776 Magnoliopsida 3398 Plants Plants 269 2.38e-80   NR CAD5315813.1 3702 g704 i0 74.4 79.2428571428571 172 44 92.1 0 1 516 965 1136 CAD5315813.1 unnamed protein product [Arabidopsis thaliana] diamond 44376 271 0.992619926199262 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
26837633 26837633 PRJNA1103784_P_NODE_6461_length_247_cov_0.885057_g6406_i0 PRJNA1103784 6461 247 0.885057 2.18609079 Nymphaea 4418 Plants Plants 48.9 2.6e-4   NR XP_031483387.1 210225 g6406 i0 55 0.97165991902834 40 18 48.6 0 168 49 423 462 XP_031483387.1 small RNA degrading nuclease 5 isoform X2 [Nymphaea colorata] diamond 240 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
27067595 27067595 PRJNA1103784_P_NODE_7462_length_242_cov_2.207101_g7407_i0 PRJNA1103784 7462 242 2.207101 5.34118442 Hordeum vulgare subsp. vulgare 112509 Plants Plants 73.6 1.74e-14   NR BAJ99260.1 112509 g7407 i0 46.2 0.966942148760331 78 42 96.7 0 7 240 8 85 BAJ99260.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 234 73.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27343713 27343713 PRJNA1103784_P_NODE_2463_length_342_cov_1.888476_g2408_i0 PRJNA1103784 2463 342 1.888476 6.45858792 Magnoliopsida 3398 Plants Plants 166 1.06e-49   NR GMN43118.1 3494 g2408 i0 70.5 102.140350877193 112 33 98.2 0 1 336 87 198 GMN43118.1 hypothetical protein TIFTF001_012326 [Ficus carica] diamond 34932 167 0.994011976047904 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica
28132966 28132966 PRJNA1103784_P_NODE_5365_length_255_cov_2.368132_g5310_i0 PRJNA1103784 5365 255 2.368132 6.0387366 Eukaryota 2759 Plants Plants 54.3 9.27e-7   NR VFQ58962.1 132261 g5310 i0 54.8 5.49411764705882 62 23 68.2 2 255 82 66 126 VFQ58962.1 unnamed protein product [Cuscuta campestris] diamond 1401 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Cuscuta Cuscuta campestris
28385410 28385410 PRJNA1103784_P_NODE_4106_length_280_cov_1.487923_g4051_i0 PRJNA1103784 4106 280 1.487923 4.1661844 Eukaryota 2759 Plants Plants 105 5.24e-24   NR CAH9120503.1 186058 g4051 i0 55.6 2.89285714285714 90 40 96.4 0 275 6 407 496 CAH9120503.1 unnamed protein product [Cuscuta epithymum] diamond 810 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Cuscuta Cuscuta epithymum
28394061 28394061 PRJNA1103784_P_NODE_1266_length_450_cov_2.814324_g1211_i0 PRJNA1103784 1266 450 2.814324 12.664458 Thlaspi arvense 13288 Plants Plants 105 6.77e-25   NR CAH2035079.1 13288 g1211 i0 51.7 2.94 149 61 95.3 6 448 20 67 210 CAH2035079.1 unnamed protein product [Thlaspi arvense] diamond 1323 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Thlaspi Thlaspi arvense
28520534 28520534 PRJNA1103784_P_NODE_5487_length_253_cov_1.711111_g5432_i0 PRJNA1103784 5487 253 1.711111 4.32911083 Acorus calamus 4465 Plants Plants 130 8.29e-34   NR KAK1294705.1 4465 g5432 i0 71.3 5.72727272727273 80 23 94.9 0 240 1 317 396 KAK1294705.1 Selenium-binding protein 1 [Acorus calamus] diamond 1449 130 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Acorales Acoraceae Acorus Acorus calamus
28574821 28574821 PRJNA1103784_P_NODE_4987_length_263_cov_1.457895_g4932_i0 PRJNA1103784 4987 263 1.457895 3.83426385 Eukaryota 2759 Plants Plants 55.8 1.12e-6   NR XP_057845787.1 3369 g4932 i0 37 5.20152091254753 73 43 83.3 1 263 45 339 408 XP_057845787.1 serine/threonine-protein kinase STY17-like [Cryptomeria japonica] diamond 1368 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
28678467 28678467 PRJNA1103784_P_NODE_5647_length_251_cov_0.865169_g5592_i0 PRJNA1103784 5647 251 0.865169 2.17157419 Cajanus cajan 3821 Plants Plants 46.2 0.00239   NR XP_020212460.1 3821 g5592 i0 32.4 0.884462151394422 74 47 88.4 1 236 15 222 292 XP_020212460.1 DNA polymerase delta small subunit [Cajanus cajan] diamond 222 46.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Cajanus Cajanus cajan
28922031 28922031 PRJNA1103784_P_NODE_3488_length_296_cov_1.381166_g3433_i0 PRJNA1103784 3488 296 1.381166 4.08825136 Magnoliopsida 3398 Plants Plants 94.4 4.96e-20   NR KAH1207175.1 3847 g3433 i0 54.5 20.6858108108108 88 40 89.2 0 264 1 144 231 KAH1207175.1 Eukaryotic peptide chain release factor subunit 1-3 [Glycine max] diamond 6123 94.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
29648015 29648015 PRJNA1103784_P_NODE_7250_length_243_cov_1.805882_g7195_i0 PRJNA1103784 7250 243 1.805882 4.38829326 Eukaryota 2759 Plants Plants 57.4 1.86e-8   NR GMH21628.1 150966 g7195 i0 49.2 7.98765432098765 61 30 74.1 1 42 221 8 68 GMH21628.1 hypothetical protein Nepgr_023470 [Nepenthes gracilis] diamond 1941 57.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Nepenthaceae Nepenthes Nepenthes gracilis
30027522 30027522 PRJNA1103784_P_NODE_5651_length_251_cov_0.865169_g5596_i0 PRJNA1103784 5651 251 0.865169 2.17157419 Magnoliopsida 3398 Plants Plants 42.7 0.0407   NR XP_030483885.2 3483 g5596 i0 35.4 3.71713147410359 65 42 77.7 0 6 200 493 557 XP_030483885.2 CDK5RAP3-like protein [Cannabis sativa] diamond 933 43.1 0.990719257540603 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
30216843 30216843 PRJNA1103784_P_NODE_5252_length_257_cov_3.233696_g5197_i0 PRJNA1103784 5252 257 3.233696 8.31059872 Poaceae 4479 Plants Plants 91.3 1.33e-21   NR KAB8100522.1 4530 g5197 i0 49.4 5.83657587548638 83 39 96.9 1 257 9 33 112 KAB8100522.1 hypothetical protein EE612_031078, partial [Oryza sativa] diamond 1500 91.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
30248802 30248802 PRJNA1103784_P_NODE_1332_length_440_cov_5.286104_g1277_i0 PRJNA1103784 1332 440 5.286104 23.2588576 Eukaryota 2759 Plants Plants 97.1 6.900000000000001e-23   NR XP_030480012.1 3483 g1277 i0 64.1 3.63409090909091 78 26 51.8 1 22 249 1 78 XP_030480012.1 large ribosomal subunit protein P2y [Cannabis sativa] diamond 1599 97.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
30699487 30699487 PRJNA1103784_P_NODE_2234_length_358_cov_1.080702_g2179_i0 PRJNA1103784 2234 358 1.080702 3.86891316 Lotus japonicus 34305 Plants Plants 127 1.57e-34   NR AFK43985.1 34305 g2179 i0 56.7 1.98603351955307 120 45 94.7 2 3 341 56 175 AFK43985.1 unknown [Lotus japonicus] diamond 711 127 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
31923838 31923838 PRJNA1103784_P_NODE_5477_length_253_cov_1.927778_g5422_i0 PRJNA1103784 5477 253 1.927778 4.87727834 Eukaryota 2759 Plants Plants 130 8.55e-36   NR KAJ7563022.1 34168 g5422 i0 77.1 11.8102766798419 83 19 98.4 0 3 251 12 94 KAJ7563022.1 hypothetical protein O6H91_03G093300 [Diphasiastrum complanatum] diamond 2988 131 0.99236641221374 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
32312629 32312629 PRJNA1103784_P_NODE_5139_length_260_cov_1.593583_g5084_i0 PRJNA1103784 5139 260 1.593583 4.1433158 Iris pallida 29817 Plants Plants 45.1 0.00704   NR KAJ6820405.1 29817 g5084 i0 46.7 1.38461538461538 60 19 69.2 2 4 183 636 682 KAJ6820405.1 diacylglycerol kinase 1 [Iris pallida] diamond 360 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asparagales Iridaceae Iris Iris pallida
32439158 32439158 PRJNA1103784_P_NODE_3879_length_285_cov_2.127358_g3824_i0 PRJNA1103784 3879 285 2.127358 6.0629703 Sphagnum jensenii 128206 Plants Plants 51.2 5.94e-5   NR CAK9253046.1 128206 g3824 i0 42.6 0.568421052631579 54 30 56.8 1 220 59 314 366 CAK9253046.1 unnamed protein product [Sphagnum jensenii] diamond 162 51.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
32754378 32754378 PRJNA1103784_P_NODE_6060_length_249_cov_0.875000_g6005_i0 PRJNA1103784 6060 249 0.875 2.17875 Diphasiastrum complanatum 34168 Plants Plants 66.2 2.66e-11   NR KAJ7560677.1 34168 g6005 i0 54.1 1.26506024096386 61 26 71.1 1 220 44 105 165 KAJ7560677.1 hypothetical protein O6H91_04G140100 [Diphasiastrum complanatum] diamond 315 66.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Lycopodiales Lycopodiaceae Diphasiastrum Diphasiastrum complanatum
32777079 32777079 PRJNA1103784_P_NODE_7160_length_244_cov_0.900585_g7105_i0 PRJNA1103784 7160 244 0.900585 2.1974274 Magnoliopsida 3398 Plants Plants 70.5 6.49e-12   NR PIA33042.1 218851 g7105 i0 40 4.58606557377049 75 45 92.2 0 4 228 688 762 PIA33042.1 hypothetical protein AQUCO_04200058v1 [Aquilegia coerulea] diamond 1119 71.2 0.990168539325843 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Ranunculaceae Aquilegia Aquilegia coerulea

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