RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 32 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA642647 · 32 ✖

analysis 1

  • blastn · 32 ✖
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
1158549 1158549 PRJNA642647_P_NODE_1841_length_256_cov_1.698630_g1791_i0 PRJNA642647 1841 256 1.69863 4.3484928 Magnoliopsida 3398 Plants Plants 119 2.26e-22   NTclustered gi|2646013110|ref|XR_009880020.1| 3486 g1791 i0 82.353 15.13671875 136 24 53 0 13 148 1198 1333 PREDICTED: Humulus lupulus 28S ribosomal RNA (LOC133808192), rRNA blastn 3875 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
1158553 1158553 PRJNA642647_P_NODE_2201_length_232_cov_1.538462_g2151_i0 PRJNA642647 2201 232 1.538462 3.56923184 Poaceae 4479 Plants Plants 56.5 0.002   NTclustered gi|2922465810|ref|XM_051371856.2| 4522 g2151 i0 96.97 0.689655172413793 33 1 14 0 41 73 470 438 PREDICTED: Lolium perenne protein H2A.5 (LOC127345379), mRNA blastn 160 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium perenne
3710347 3710347 PRJNA642647_P_NODE_2463_length_220_cov_1.825137_g2413_i0 PRJNA642647 2463 220 1.825137 4.0153014 Solanum 4107 Plants Plants 291 3.79e-74   NTclustered gi|971579629|ref|XM_015303522.1| 4113 g2413 i0 90 109.090909090909 240 2 99 1 3 220 855 616 PREDICTED: Solanum tuberosum uncharacterized LOC107058156 (LOC107058156), transcript variant X1, mRNA blastn 24000 291 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum tuberosum
4445672 4445672 PRJNA642647_P_NODE_2804_length_207_cov_4.823529_g2754_i0 PRJNA642647 2804 207 4.823529 9.98470503 Persea americana 3435 Plants Plants 377 2.63e-100   NTclustered gi|2249528608|gb|ON685429.1| 3435 g2754 i0 100 99.280193236715 204 0 99 0 4 207 2173 2376 Persea americana isolate BPTPS118 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 20551 377 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Persea Persea americana
4986913 4986913 PRJNA642647_P_NODE_4564_length_170_cov_2.511278_g4514_i0 PRJNA642647 4564 170 2.511278 4.2691726 Eukaryota 2759 Plants Plants 91.6 3.01e-14   NTclustered gi|2571391326|ref|XR_009110824.2| 3369 g4514 i0 92.188 32.6058823529412 64 5 38 0 106 169 791 854 PREDICTED: Cryptomeria japonica 28S ribosomal RNA (LOC131062223), rRNA blastn 5543 91.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
6262238 6262238 PRJNA642647_P_NODE_1465_length_288_cov_2.179283_g1415_i0 PRJNA642647 1465 288 2.179283 6.27633504 Streptophyta 35493 Plants Plants 161 4.24e-35   NTclustered gi|2571321288|ref|XR_009368823.1| 3369 g1415 i0 87.77 36.5416666666667 139 15 48 2 4 141 849 986 PREDICTED: Cryptomeria japonica 28S ribosomal RNA (LOC131870516), rRNA blastn 10524 161 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
7536452 7536452 PRJNA642647_P_NODE_1566_length_278_cov_2.224066_g1516_i0 PRJNA642647 1566 278 2.224066 6.18290348 Magnoliopsida 3398 Plants Plants 503 5.88e-138   NTclustered gi|2273789310|gb|MZ391807.1| 3635 g1516 i0 99.636 191.906474820144 275 1 99 0 1 275 112056 111782 Gossypium hirsutum voucher L_oaxbrown4 chloroplast, complete genome blastn 53350 503 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
8271284 8271284 PRJNA642647_P_NODE_4367_length_173_cov_2.919118_g4317_i0 PRJNA642647 4367 173 2.919118 5.05007414 Prunus dulcis 3755 Plants Plants 174 2.97e-39   NTclustered gi|1841613357|ref|XM_034351076.1| 3755 g4317 i0 98 2.97109826589595 100 2 92 0 1 100 237 138 PREDICTED: Prunus dulcis late embryogenesis abundant protein 2-like (LOC117620835), mRNA blastn 514 174 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
10087055 10087055 PRJNA642647_P_NODE_1848_length_255_cov_2.733945_g1798_i0 PRJNA642647 1848 255 2.733945 6.97155975 Magnoliopsida 3398 Plants Plants 424 4.26e-114   NTclustered gi|2806629351|gb|PQ214322.1| 3435 g1798 i0 96.032 125.223529411765 252 8 99 1 1 252 558273 558522 Persea americana chromosome 1 mitochondrion, complete sequence blastn 31932 424 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Persea Persea americana
10087087 10087087 PRJNA642647_P_NODE_908_length_372_cov_2.298507_g858_i0 PRJNA642647 908 372 2.298507 8.55044604 Prunus 3754 Plants Plants 348 4.03e-91   NTclustered gi|2699132190|emb|OZ022205.1| 3755 g858 i0 98.485 108.91935483871 198 2 93 1 89 285 5877693 5877890 Prunus dulcis genome assembly, segment: 0 blastn 40518 348 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
11361969 11361969 PRJNA642647_P_NODE_449_length_521_cov_25.454545_g400_i0 PRJNA642647 449 521 25.454545 132.61817945 Cucurbita 3660 Plants Plants 510 7.01e-140   NTclustered gi|1281066824|ref|XR_002716478.1| 3661 g400 i0 98.611 66.9654510556622 288 4 55 0 122 409 919 632 PREDICTED: Cucurbita maxima Eukaryotic 18S ribosomal RNA (LOC111475404), rRNA blastn 34889 510 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucurbita Cucurbita maxima
12637722 12637722 PRJNA642647_P_NODE_2170_length_233_cov_3.959184_g2120_i0 PRJNA642647 2170 233 3.959184 9.22489872 Triticum 4564 Plants Plants 425 1.07e-114   NTclustered gi|2123569754|ref|XR_006489792.1| 4565 g2120 i0 100 2378.30472103004 230 0 99 0 4 233 572 343 PREDICTED: Triticum aestivum uncharacterized LOC123178712 (LOC123178712), misc_RNA blastn 554145 425 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
12637737 12637737 PRJNA642647_P_NODE_4810_length_167_cov_1.923077_g4760_i0 PRJNA642647 4810 167 1.923077 3.21153859 Magnoliopsida 3398 Plants Plants 300 4.53e-77   NTclustered gi|2878722096|gb|PQ839730.1| 3489 g4760 i0 99.394 143.634730538922 165 1 99 0 1 165 392459 392623 Artocarpus heterophyllus isolate YNHBLM mitochondrion, complete genome blastn 23987 300 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Artocarpus Artocarpus heterophyllus
12637741 12637741 PRJNA642647_P_NODE_5430_length_163_cov_1.936508_g5380_i0 PRJNA642647 5430 163 1.936508 3.15650804 Zygnematophyceae 131209 Plants Plants 124 2.84e-24   NTclustered gi|215541049|emb|AM919445.1| 98433 g5380 i0 93.902 116.950920245399 82 5 50 0 4 85 36 117 Cosmarium granatum chloroplast partial 23S rRNA gene, strain M 2127 blastn 19063 124 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Desmidiaceae Cosmarium Cosmarium granatum
13371996 13371996 PRJNA642647_P_NODE_1431_length_291_cov_16.307087_g1381_i0 PRJNA642647 1431 291 16.307087 47.45362317 Whipplea modesta 123682 Plants Plants 414 2.9799999999999998e-111   NTclustered gi|325071852|gb|JF321118.1| 123682 g1381 i0 92.466 100.965635738832 292 18 99 3 1 289 2670 2380 Whipplea modesta 26S ribosomal RNA gene, partial sequence blastn 29381 414 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Hydrangeaceae Whipplea Whipplea modesta
13912536 13912536 PRJNA642647_P_NODE_1611_length_274_cov_5.388186_g1561_i0 PRJNA642647 1611 274 5.388186 14.76362964 Magnoliopsida 3398 Plants Plants 239 1.7999999999999993e-58   NTclustered gi|2292905072|gb|ON931349.1| 3635 g1561 i0 100 122.905109489051 129 0 93 0 143 271 39157 39285 Gossypium hirsutum chromosome SI3Amt_1 mitochondrion sequence blastn 33676 239 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium hirsutum
13912539 13912539 PRJNA642647_P_NODE_2411_length_222_cov_1.897297_g2361_i0 PRJNA642647 2411 222 1.897297 4.21199934 Lauraceae 3433 Plants Plants 403 4.72e-108   NTclustered gi|1858740925|gb|MT628628.1| 3435 g2361 i0 100 99.4594594594595 218 0 98 0 4 221 4526 4743 Persea americana voucher YL01 sequence blastn 22080 403 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Laurales Lauraceae Persea Persea americana
15187045 15187045 PRJNA642647_P_NODE_5712_length_159_cov_3.368852_g5662_i0 PRJNA642647 5712 159 3.368852 5.35647468 Magnoliopsida 3398 Plants Plants 285 1.1899999999999998e-72   NTclustered gi|2130419157|gb|MW413894.1| 3486 g5662 i0 100 153.433962264151 154 0 97 0 4 157 117312 117159 Humulus lupulus mitochondrion, complete genome blastn 24396 287 0.993031358885017 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
16461342 16461342 PRJNA642647_P_NODE_2993_length_202_cov_2.569697_g2943_i0 PRJNA642647 2993 202 2.569697 5.19078794 Characeae 3146 Plants Plants 99 2.23e-16   NTclustered gi|992074060|gb|KR080236.1| 37934 g2943 i0 82.203 46.9455445544554 118 18 57 3 4 118 4968 5085 Tolypella porteri voucher BUT3316 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence blastn 9483 99 1 Eukaryota   Viridiplantae Streptophyta Charophyceae Charales Characeae Tolypella Tolypella porteri
17195929 17195929 PRJNA642647_P_NODE_2714_length_211_cov_1.304598_g2664_i0 PRJNA642647 2714 211 1.304598 2.75270178 Quercus robur 38942 Plants Plants 135 1.79e-27   NTclustered gi|2293041412|ref|XR_007650327.1| 38942 g2664 i0 79.091 57.5308056872038 220 29 99 12 1 208 2649 2435 PREDICTED: Quercus robur 28S ribosomal RNA (LOC126711350), rRNA blastn 12139 135 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
18470264 18470264 PRJNA642647_P_NODE_835_length_386_cov_13.237822_g785_i0 PRJNA642647 835 386 13.237822 51.09799292 Bupleurum falcatum 46367 Plants Plants 647 0   NTclustered gi|2571153582|gb|OR493979.1| 46367 g785 i0 97.128 104.150259067358 383 11 99 0 1 383 5799 5417 Bupleurum falcatum voucher 2009100601 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 40202 647 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Bupleurum Bupleurum falcatum
19010036 19010036 PRJNA642647_P_NODE_1075_length_341_cov_4.927632_g1025_i0 PRJNA642647 1075 341 4.927632 16.80322512 Liriodendron 3413 Plants Plants 466 9.71e-127   NTclustered gi|1842045221|gb|MN990597.1| 3414 g1025 i0 91.74 195.33137829912 339 22 99 5 2 338 109779 109445 Liriodendron chinense chloroplast, complete genome blastn 66608 466 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Magnoliales Magnoliaceae Liriodendron Liriodendron chinense
19010050 19010050 PRJNA642647_P_NODE_3075_length_200_cov_2.159509_g3025_i0 PRJNA642647 3075 200 2.159509 4.319018 Eukaryota 2759 Plants Plants 359 9.14e-95   NTclustered gi|391415363|gb|BT065681.2| 4577 g3025 i0 99.495 99.64 198 0 99 1 4 200 868 671 Zea mays full-length cDNA clone ZM_BFc0017K02 mRNA, complete cds blastn 19928 359 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
19010051 19010051 PRJNA642647_P_NODE_3295_length_194_cov_2.777070_g3245_i0 PRJNA642647 3295 194 2.77707 5.3875158 Magnoliopsida 3398 Plants Plants 195 2.6299999999999997e-45   NTclustered gi|2130419157|gb|MW413894.1| 3486 g3245 i0 100 115.814432989691 105 0 93 0 4 108 119723 119619 Humulus lupulus mitochondrion, complete genome blastn 22468 196 0.994897959183674 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
19744856 19744856 PRJNA642647_P_NODE_4096_length_178_cov_2.000000_g4046_i0 PRJNA642647 4096 178 2 3.56 Cylindrocystis brebissonii 102167 Plants Plants 89.8 1.15e-13   NTclustered gi|1878849184|gb|MT796587.1| 102167 g4046 i0 77.215 0.887640449438202 158 32 87 4 1 155 2083 1927 Cylindrocystis brebissonii internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 158 89.8 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Zygnematales Mesotaeniaceae Cylindrocystis Cylindrocystis brebissonii
19744858 19744858 PRJNA642647_P_NODE_4196_length_176_cov_2.482014_g4146_i0 PRJNA642647 4196 176 2.482014 4.36834464 Eragrostis tef 110835 Plants Plants 95.3 2.43e-15   NTclustered gi|2710185553|gb|CP137582.1| 110835 g4146 i0 81.197 3.01704545454545 117 22 73 0 46 162 30372399 30372283 Eragrostis tef cultivar Dabbi chromosome 1A blastn 531 95.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Eragrostis Eragrostis tef
20284951 20284951 PRJNA642647_P_NODE_2296_length_226_cov_27.523810_g2246_i0 PRJNA642647 2296 226 27.52381 62.2038106 Rosaceae 3745 Plants Plants 407 3.73e-109   NTclustered gi|1777714|gb|U42800.1|PFU42800 23200 g2246 i0 99.111 102.526548672566 225 2 99 0 1 225 50 274 Photinia fraseri 18S ribosomal RNA gene, partial sequence blastn 23171 407 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Photinia Photinia x fraseri
21560522 21560522 PRJNA642647_P_NODE_3277_length_194_cov_6.254777_g3227_i0 PRJNA642647 3277 194 6.254777 12.13426738 Cedrus 3321 Plants Plants 191 3.3999999999999997e-44   NTclustered gi|109138948|gb|DQ629435.1| 3322 g3227 i0 99.057 53.659793814433 106 1 55 0 87 192 677 782 Cedrus deodara 18S ribosomal RNA gene, partial sequence blastn 10410 191 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Cedrus Cedrus deodara
23570713 23570713 PRJNA642647_P_NODE_3659_length_186_cov_1.315436_g3609_i0 PRJNA642647 3659 186 1.315436 2.44671096 Cucurbita maxima 3661 Plants Plants 322 1.1e-83   NTclustered gi|1281066069|ref|XR_002716109.1| 3661 g3609 i0 98.361 98.3870967741936 183 3 98 0 1 183 3336 3154 PREDICTED: Cucurbita maxima Eukaryotic 28S ribosomal RNA (LOC111474643), rRNA blastn 18300 322 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucurbita Cucurbita maxima
23570733 23570733 PRJNA642647_P_NODE_5539_length_161_cov_3.846774_g5489_i0 PRJNA642647 5539 161 3.846774 6.19330614 Selaginella selaginoides 69996 Plants Plants 73.1 1.03e-8   NTclustered gi|2484062556|gb|OQ799646.1| 69996 g5489 i0 93.75 0.521739130434783 48 3 30 0 114 161 4523 4570 Selaginella selaginoides voucher J-C Bertier Tour09165 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 84 73.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella selaginoides
25384945 25384945 PRJNA642647_P_NODE_5260_length_165_cov_11.812500_g5210_i0 PRJNA642647 5260 165 11.8125 19.490625 Magnoliopsida 3398 Plants Plants 300 4.46e-77   NTclustered gi|498915483|emb|HF969275.1| 3755 g5210 i0 100 98.2060606060606 162 0 98 0 1 162 429 268 Prunus dulcis genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene and ITS2, cultivar Chellaston blastn 16204 300 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
25384949 25384949 PRJNA642647_P_NODE_5940_length_156_cov_2.722689_g5890_i0 PRJNA642647 5940 156 2.722689 4.24739484 Poaceae 4479 Plants Plants 52.8 0.013   NTclustered gi|2922430717|ref|XR_011750549.1| 4522 g5890 i0 100 1.43589743589744 28 0 18 0 4 31 1924 1951 PREDICTED: Lolium perenne 28S ribosomal RNA (LOC139834882), rRNA blastn 224 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium perenne

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