RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA772154 · 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
2023423 2023423 PRJNA772154_P_NODE_21982_length_244_cov_0.912281_g21797_i0 PRJNA772154 21982 244 0.912281 2.22596564 Perilla frutescens var. hirtella 608512 Plants Plants 142 4.56e-37   NR KAH6797138.1 608512 g21797 i0 85 1.9672131147541 80 12 98.4 0 242 3 72 151 KAH6797138.1 HAESA-like 2 [Perilla frutescens var. hirtella] diamond 480 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
5850798 5850798 PRJNA772154_P_NODE_15305_length_277_cov_1.387255_g15120_i0 PRJNA772154 15305 277 1.387255 3.84269635 Magnoliopsida 3398 Plants Plants 123 1.14e-30   NR KAK1294318.1 4465 g15120 i0 86.4 1.91696750902527 59 8 63.9 0 275 99 447 505 KAK1294318.1 putative xyloglucan endotransglucosylase/hydrolase protein B [Acorus calamus] diamond 531 124 0.991935483870968 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Acorales Acoraceae Acorus Acorus calamus
5850952 5850952 PRJNA772154_P_NODE_20745_length_246_cov_0.901734_g20560_i0 PRJNA772154 20745 246 0.901734 2.21826564 Viridiplantae 33090 Plants Plants 154 3.5e-44   NR XP_057539195.1 29722 g20560 i0 91.4 101.743902439024 81 7 98.8 0 2 244 114 194 XP_057539195.1 26S proteasome non-ATPase regulatory subunit 14 homolog [Amaranthus tricolor] diamond 25029 155 0.993548387096774 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Amaranthaceae Amaranthus Amaranthus tricolor
5850959 5850959 PRJNA772154_P_NODE_21065_length_246_cov_0.867052_g20880_i0 PRJNA772154 21065 246 0.867052 2.13294792 Perilla frutescens var. hirtella 608512 Plants Plants 145 3.8899999999999997e-38   NR KAH6767720.1 608512 g20880 i0 86.4 0.98780487804878 81 11 98.8 0 3 245 748 828 KAH6767720.1 lipoxygenase 2 [Perilla frutescens var. hirtella] diamond 243 145 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
9675756 9675756 PRJNA772154_P_NODE_16868_length_259_cov_1.655914_g16683_i0 PRJNA772154 16868 259 1.655914 4.28881726 Lamiaceae 4136 Plants Plants 124 2.9399999999999995e-35   NR KAH6764277.1 151328 g16683 i0 86.4 2.29343629343629 66 8 76.4 1 34 231 1 65 KAH6764277.1 metallothionein 3 [Perilla frutescens var. frutescens] diamond 594 124 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
19874087 19874087 PRJNA772154_P_NODE_17656_length_253_cov_0.866667_g17471_i0 PRJNA772154 17656 253 0.866667 2.19266751 Salvia miltiorrhiza 226208 Plants Plants 101 3.79e-25   NR XP_057791535.1 226208 g17471 i0 73.5 0.806324110671937 68 18 80.6 0 204 1 11 78 XP_057791535.1 probable calcium-binding protein CML27 [Salvia miltiorrhiza] diamond 204 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia miltiorrhiza
26673127 26673127 PRJNA772154_P_NODE_18661_length_251_cov_0.876404_g18476_i0 PRJNA772154 18661 251 0.876404 2.19977404 Perilla frutescens var. frutescens 151328 Plants Plants 107 5.48e-25   NR KAH6757280.1 151328 g18476 i0 86.2 0.776892430278884 65 8 76.5 1 203 12 3995 4059 KAH6757280.1 hypothetical protein C2S51_038874 [Perilla frutescens var. frutescens] diamond 195 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
26999394 26999394 PRJNA772154_P_NODE_22382_length_243_cov_0.917647_g22197_i0 PRJNA772154 22382 243 0.917647 2.22988221 Eukaryota 2759 Plants Plants 82 4.26e-17   NR MQL84260.1 4460 g22197 i0 69.6 8.03703703703704 56 16 67.9 1 2 166 150 205 MQL84260.1 hypothetical protein [Colocasia esculenta] diamond 1953 82.4 0.995145631067961 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
27116292 27116292 PRJNA772154_P_NODE_18622_length_251_cov_0.876404_g18437_i0 PRJNA772154 18622 251 0.876404 2.19977404 Selaginella moellendorffii 88036 Plants Plants 42.7 0.0412   NR EFJ06307.1 88036 g18437 i0 36.4 0.920318725099602 77 48 92 1 251 21 42 117 EFJ06307.1 hypothetical protein SELMODRAFT_430804 [Selaginella moellendorffii] diamond 231 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
27432778 27432778 PRJNA772154_P_NODE_10403_length_352_cov_2.236559_g10218_i0 PRJNA772154 10403 352 2.236559 7.87268768 Triticum aestivum 4565 Plants Plants 181 7.65e-57   NR KAF7098706.1 4565 g10218 i0 85.6 0.826704545454545 97 14 82.7 0 293 3 1 97 KAF7098706.1 hypothetical protein CFC21_100422 [Triticum aestivum] diamond 291 181 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
27495747 27495747 PRJNA772154_P_NODE_22683_length_242_cov_0.923077_g22498_i0 PRJNA772154 22683 242 0.923077 2.23384634 Hordeum vulgare subsp. vulgare 112509 Plants Plants 53.9 4.23e-6   NR BAK01125.1 112509 g22498 i0 40.5 0.979338842975207 79 43 97.9 1 239 3 647 721 BAK01125.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 237 53.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27622111 27622111 PRJNA772154_P_NODE_16764_length_260_cov_1.572193_g16579_i0 PRJNA772154 16764 260 1.572193 4.0877018 Sphagnum balticum 128184 Plants Plants 141 1.1999999999999999e-39   NR CAM6004337.1 128184 g16579 i0 69.8 0.992307692307692 86 26 99.2 0 259 2 68 153 CAM6004337.1 unnamed protein product [Sphagnum balticum] diamond 258 141 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
28443050 28443050 PRJNA772154_P_NODE_15746_length_272_cov_1.150754_g15561_i0 PRJNA772154 15746 272 1.150754 3.13005088 Hordeum vulgare subsp. vulgare 112509 Plants Plants 67.4 6.49e-12   NR BAJ99260.1 112509 g15561 i0 64.2 0.584558823529412 53 19 58.5 0 5 163 80 132 BAJ99260.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 159 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
29011582 29011582 PRJNA772154_P_NODE_21248_length_245_cov_0.906977_g21063_i0 PRJNA772154 21248 245 0.906977 2.22209365 Perilla frutescens var. frutescens 151328 Plants Plants 95.5 9.98e-21   NR KAH6790364.1 151328 g21063 i0 71.4 0.942857142857143 77 21 94.3 1 237 7 106 181 KAH6790364.1 hypothetical protein C2S51_005370 [Perilla frutescens var. frutescens] diamond 231 95.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
30748432 30748432 PRJNA772154_P_NODE_18874_length_250_cov_0.881356_g18689_i0 PRJNA772154 18874 250 0.881356 2.20339 Perilla frutescens var. frutescens 151328 Plants Plants 79 7.26e-15   NR KAH6789861.1 151328 g18689 i0 56.6 0.996 83 33 96 1 11 250 261 343 KAH6789861.1 hypothetical protein C2S51_004867 [Perilla frutescens var. frutescens] diamond 249 79 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
31073968 31073968 PRJNA772154_P_NODE_20735_length_246_cov_0.901734_g20550_i0 PRJNA772154 20735 246 0.901734 2.21826564 Poaceae 4479 Plants Plants 47 3.03e-4   NR KAE8776710.1 4513 g20550 i0 59.1 1.13414634146341 44 9 45.1 2 98 208 79 120 KAE8776710.1 hypothetical protein D1007_50586 [Hordeum vulgare] diamond 279 47.4 0.991561181434599 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
31696785 31696785 PRJNA772154_P_NODE_19417_length_249_cov_0.886364_g19232_i0 PRJNA772154 19417 249 0.886364 2.20704636 Citrus unshiu 55188 Plants Plants 64.7 5.16e-10   NR GAY69047.1 55188 g19232 i0 74 0.602409638554217 50 11 60.2 1 1 150 45 92 GAY69047.1 hypothetical protein CUMW_268950 [Citrus unshiu] diamond 150 64.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus unshiu
32076444 32076444 PRJNA772154_P_NODE_20398_length_247_cov_0.896552_g20213_i0 PRJNA772154 20398 247 0.896552 2.21448344 Trifolium repens 3899 Plants Plants 57.8 1.81e-7   NR WJX68561.1 3899 g20213 i0 30.7 0.910931174089069 75 52 91.1 0 2 226 87 161 WJX68561.1 hypothetical protein P8452_52916 [Trifolium repens] diamond 225 57.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium repens
32424503 32424503 PRJNA772154_P_NODE_19919_length_248_cov_0.891429_g19734_i0 PRJNA772154 19919 248 0.891429 2.21074392 Aegilops tauschii subsp. strangulata 200361 Plants Plants 101 1.02e-22   NR XP_040249384.1 200361 g19734 i0 52.4 1.98387096774194 82 39 99.2 0 246 1 545 626 XP_040249384.1 uncharacterized protein LOC120966872 [Aegilops tauschii subsp. strangulata] diamond 492 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops tauschii
32875462 32875462 PRJNA772154_P_NODE_18200_length_252_cov_0.871508_g18015_i0 PRJNA772154 18200 252 0.871508 2.19620016 Magnoliopsida 3398 Plants Plants 75.9 8.83e-14   NR RVW96542.1 29760 g18015 i0 50.7 3.46428571428571 69 33 82.1 1 209 3 56 123 RVW96542.1 Proline-rich protein 2 [Vitis vinifera] diamond 873 75.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
32897287 32897287 PRJNA772154_P_NODE_17440_length_253_cov_1.455556_g17255_i0 PRJNA772154 17440 253 1.455556 3.68255668 Salvia miltiorrhiza 226208 Plants Plants 139 3.1500000000000004e-36   NR XP_057806286.1 226208 g17255 i0 78 0.972332015810277 82 18 97.2 0 251 6 278 359 XP_057806286.1 calmodulin-binding protein 60 A-like [Salvia miltiorrhiza] diamond 246 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia miltiorrhiza

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