RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA785164 · 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
5869793 5869793 PRJNA785164_P_NODE_44605_length_269_cov_3.918367_g44140_i0 PRJNA785164 44605 269 3.918367 10.54040723 Quercus rubra 3512 Plants Plants 131 6.47e-38   NR KAK4605734.1 3512 g44140 i0 91.2 0.758364312267658 68 6 75.8 0 237 34 1 68 KAK4605734.1 hypothetical protein RGQ29_000149 [Quercus rubra] diamond 204 131 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
7145138 7145138 PRJNA785164_P_NODE_58886_length_244_cov_0.900585_g58421_i0 PRJNA785164 58886 244 0.900585 2.1974274 Hydrangea macrophylla 23110 Plants Plants 94.4 8.21e-21   NR ABG22118.1 23110 g58421 i0 71.9 7.02049180327869 64 18 78.7 0 224 33 125 188 ABG22118.1 polyprotein, partial [Hydrangea macrophylla] diamond 1713 94.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Hydrangeaceae Hydrangea Hydrangea macrophylla
10970270 10970270 PRJNA785164_P_NODE_37649_length_294_cov_1.352941_g37184_i0 PRJNA785164 37649 294 1.352941 3.97764654 Camellia sinensis 4442 Plants Plants 54.3 5.87e-6   NR KAF5934632.1 4442 g37184 i0 31.3 1.01020408163265 99 65 98 1 289 2 627 725 KAF5934632.1 hypothetical protein HYC85_030803 [Camellia sinensis] diamond 297 54.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
22891105 22891105 PRJNA785164_P_NODE_10818_length_653_cov_4.641379_g10368_i0 PRJNA785164 10818 653 4.641379 30.30820487 Tanacetum cinerariifolium 118510 Plants Plants 222 1.17e-69   NR GFC72503.1 118510 g10368 i0 66.9 0.817764165390505 178 36 81.8 1 26 559 62 216 GFC72503.1 ribosomal protein S13, chloroplast precursor [Tanacetum cinerariifolium] diamond 534 222 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
24992126 24992126 PRJNA785164_P_NODE_15300_length_512_cov_1.052392_g14835_i0 PRJNA785164 15300 512 1.052392 5.38824704 Acer negundo 4023 Plants Plants 305 4.7e-99   NR KAI9194767.1 4023 g14835 i0 100 0.99609375 170 0 99.6 0 1 510 330 499 KAI9194767.1 hypothetical protein LWI28_009044 [Acer negundo] diamond 510 305 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer negundo
24993131 24993131 PRJNA785164_P_NODE_57660_length_245_cov_0.895349_g57195_i0 PRJNA785164 57660 245 0.895349 2.19360505 Magnoliopsida 3398 Plants Plants 133 5.849999999999999e-34   NR KAJ6925657.1 444605 g57195 i0 81.3 5.48571428571429 75 14 91.8 0 227 3 140 214 KAJ6925657.1 gag-pol polyprotein [Populus alba x Populus x berolinensis] diamond 1344 134 0.992537313432836 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus alba x Populus x berolinensis
27022086 27022086 PRJNA785164_P_NODE_60482_length_242_cov_1.396450_g60017_i0 PRJNA785164 60482 242 1.39645 3.379409 Sphagnum balticum 128184 Plants Plants 84 5.88e-17   NR CAM5999387.1 128184 g60017 i0 50 0.991735537190083 80 40 99.2 0 3 242 139 218 CAM5999387.1 unnamed protein product [Sphagnum balticum] diamond 240 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27085333 27085333 PRJNA785164_P_NODE_8022_length_808_cov_3.171429_g7609_i0 PRJNA785164 8022 808 3.171429 25.62514632 Cryptomeria japonica 3369 Plants Plants 135 1.17e-35   NR XP_057863391.1 3369 g7609 i0 44.4 4.49628712871287 153 81 56.1 2 131 583 23 173 XP_057863391.1 TPD1 protein homolog 1 [Cryptomeria japonica] diamond 3633 135 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
27433140 27433140 PRJNA785164_P_NODE_33103_length_316_cov_1.510288_g32638_i0 PRJNA785164 33103 316 1.510288 4.77251008 Acer saccharum 4024 Plants Plants 115 1.15e-29   NR KAK0607069.1 4024 g32638 i0 72.2 0.683544303797468 72 20 68.4 0 71 286 1 72 KAK0607069.1 hypothetical protein LWI29_008801 [Acer saccharum] diamond 216 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Acer Acer saccharum
27496128 27496128 PRJNA785164_P_NODE_59143_length_244_cov_0.865497_g58678_i0 PRJNA785164 59143 244 0.865497 2.11181268 Daucus carota subsp. sativus 79200 Plants Plants 57.4 2.49e-7   NR XP_017218277.1 79200 g58678 i0 62.8 0.528688524590164 43 15 51.6 1 12 137 317 359 XP_017218277.1 importin subunit alpha-2 [Daucus carota subsp. sativus] diamond 129 57.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
28443472 28443472 PRJNA785164_P_NODE_63426_length_232_cov_3.446541_g62961_i0 PRJNA785164 63426 232 3.446541 7.99597512 Sphagnum balticum 128184 Plants Plants 84 3.19e-18   NR CAM6002141.1 128184 g62961 i0 88.2 0.65948275862069 51 6 65.9 0 231 79 120 170 CAM6002141.1 unnamed protein product [Sphagnum balticum] diamond 153 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
28538217 28538217 PRJNA785164_P_NODE_57747_length_245_cov_0.895349_g57282_i0 PRJNA785164 57747 245 0.895349 2.19360505 Lactuca saligna 75948 Plants Plants 120 2.9599999999999996e-31   NR CAI9287306.1 75948 g57282 i0 76 0.918367346938776 75 18 91.8 0 4 228 21 95 CAI9287306.1 unnamed protein product [Lactuca saligna] diamond 225 120 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca saligna
28664365 28664365 PRJNA785164_P_NODE_38607_length_290_cov_1.437788_g38142_i0 PRJNA785164 38607 290 1.437788 4.1695852 Sphagnum balticum 128184 Plants Plants 71.6 4.61e-12   NR CAM6004857.1 128184 g38142 i0 64.2 0.548275862068966 53 19 54.8 0 130 288 1 53 CAM6004857.1 unnamed protein product [Sphagnum balticum] diamond 159 71.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
28758934 28758934 PRJNA785164_P_NODE_35747_length_303_cov_1.004348_g35282_i0 PRJNA785164 35747 303 1.004348 3.04317444 Rhododendron molle 49168 Plants Plants 55.1 3.41e-6   NR KAI8553927.1 49168 g35282 i0 58.7 1.36633663366337 46 19 45.5 0 170 33 105 150 KAI8553927.1 hypothetical protein RHMOL_Rhmol05G0054700 [Rhododendron molle] diamond 414 55.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Rhododendron Rhododendron molle
29832524 29832524 PRJNA785164_P_NODE_64011_length_227_cov_4.233766_g63546_i0 PRJNA785164 64011 227 4.233766 9.61064882 Pinus taeda 3352 Plants Plants 45.4 4.8e-4   NR QDZ06024.1 3352 g63546 i0 39 2.0352422907489 77 38 92.5 2 222 13 10 84 QDZ06024.1 ALLW1950 [Pinus taeda] diamond 462 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus taeda
30496131 30496131 PRJNA785164_P_NODE_62073_length_241_cov_0.916667_g61608_i0 PRJNA785164 62073 241 0.916667 2.20916747 Kingdonia uniflora 39325 Plants Plants 77.4 2.26e-14   NR KAF6152607.1 39325 g61608 i0 54.8 0.771784232365145 62 28 77.2 0 19 204 33 94 KAF6152607.1 hypothetical protein GIB67_013054 [Kingdonia uniflora] diamond 186 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Circaeasteraceae Kingdonia Kingdonia uniflora
30505333 30505333 PRJNA785164_P_NODE_62593_length_239_cov_3.704819_g62128_i0 PRJNA785164 62593 239 3.704819 8.85451741 Eukaryota 2759 Plants Plants 40.8 0.0386   NR CAH9148963.1 186058 g62128 i0 61.3 0.853556485355649 31 12 38.9 0 25 117 56 86 CAH9148963.1 unnamed protein product [Cuscuta epithymum] diamond 204 41.2 0.990291262135922 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Convolvulaceae Cuscuta Cuscuta epithymum
30780337 30780337 PRJNA785164_P_NODE_38154_length_292_cov_1.351598_g37689_i0 PRJNA785164 38154 292 1.351598 3.94666616 Hibiscus sabdariffa 183260 Plants Plants 56.6 8.51e-7   NR KAK8477264.1 183260 g37689 i0 49.1 1.08904109589041 53 27 54.5 0 184 26 244 296 KAK8477264.1 hypothetical protein V6N11_047468 [Hibiscus sabdariffa] diamond 318 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Hibiscus Hibiscus sabdariffa
31665432 31665432 PRJNA785164_P_NODE_45397_length_267_cov_1.536082_g44932_i0 PRJNA785164 45397 267 1.536082 4.10133894 Gossypium hirsutum 3635 Plants Plants 49.7 1.15e-4   NR KAG4176636.1 3635 g44932 i0 40.6 1.78651685393258 64 33 67.4 2 192 13 101 163 KAG4176636.1 hypothetical protein ERO13_A11G258200v2 [Gossypium hirsutum] diamond 477 49.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
31728690 31728690 PRJNA785164_P_NODE_61057_length_242_cov_0.911243_g60592_i0 PRJNA785164 61057 242 0.911243 2.20520806 Alnus glutinosa 3517 Plants Plants 65.9 2.68e-10   NR XP_062151335.1 3517 g60592 i0 42.9 3.03719008264463 84 43 97.9 1 241 5 251 334 XP_062151335.1 DNA repair protein UVH3 isoform X2 [Alnus glutinosa] diamond 735 65.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Alnus Alnus glutinosa
32520028 32520028 PRJNA785164_P_NODE_51259_length_251_cov_0.865169_g50794_i0 PRJNA785164 51259 251 0.865169 2.17157419 Cucumis melo 3656 Plants Plants 80.5 6.42e-16   NR XP_050939356.1 3656 g50794 i0 55.7 2.50996015936255 70 30 83.7 1 40 249 12 80 XP_050939356.1 L10-interacting MYB domain-containing protein-like [Cucumis melo] diamond 630 80.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis melo
32677208 32677208 PRJNA785164_P_NODE_59980_length_243_cov_0.905882_g59515_i0 PRJNA785164 59980 243 0.905882 2.20129326 Cryptomeria japonica 3369 Plants Plants 112 8.590000000000001e-27   NR XP_059075428.1 3369 g59515 i0 60 3.95061728395062 80 32 98.8 0 2 241 469 548 XP_059075428.1 uncharacterized protein LOC131875347 [Cryptomeria japonica] diamond 960 112 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
32897652 32897652 PRJNA785164_P_NODE_51260_length_251_cov_0.865169_g50795_i0 PRJNA785164 51260 251 0.865169 2.17157419 Senna tora 362788 Plants Plants 49.3 1.95e-4   NR KAF7829145.1 362788 g50795 i0 37.9 1.48207171314741 58 36 69.3 0 12 185 346 403 KAF7829145.1 reverse transcriptase [Senna tora] diamond 372 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Senna Senna tora

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