RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA290839", tax_clade = "Embryophyta" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 27 ✖

tax_kingdom 1

tax_clade 1

  • Embryophyta · 27 ✖

bioproject 1

  • PRJNA290839 · 27 ✖
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
372910 372910 PRJNA290839_P_NODE_601_length_330_cov_1.684825_g580_i0 PRJNA290839 601 330 1.684825 5.5599225 Oryza sativa 4530 Plants Plants 510 4.26e-140   NTclustered gi|32993583|dbj|AK108374.1| 39947 g580 i0 94.545 66.9727272727273 330 18 100 0 1 330 671 342 Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence blastn 22101 510 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
6750613 6750613 PRJNA290839_P_NODE_926_length_265_cov_1.208333_g905_i0 PRJNA290839 926 265 1.208333 3.20208245 Sphagnum 13804 Plants Plants 132 3.05e-36   NR KAH8954072.1 53036 g905 i0 82.4 5.79622641509434 85 15 96.2 0 259 5 126 210 KAH8954072.1 hypothetical protein BDL97_08G060800 [Sphagnum fallax] diamond 1536 132 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum fallax
9300978 9300978 PRJNA290839_P_NODE_448_length_387_cov_0.987261_g427_i0 PRJNA290839 448 387 0.987261 3.82070007 Picea mariana 3335 Plants Plants 220 1.02e-70   NR O65082.1 3335 g427 i0 84 5.81395348837209 125 20 96.9 0 11 385 1 125 O65082.1 RecName: Full=Large ribosomal subunit protein eL15y; AltName: Full=60S ribosomal protein L15-2 [Picea mariana] diamond 2250 220 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea mariana
9300980 9300980 PRJNA290839_P_NODE_728_length_300_cov_3.409692_g707_i0 PRJNA290839 728 300 3.409692 10.229076 Oryza sativa 4530 Plants Plants 481 2.999999999999999e-131   NTclustered gi|116641691|emb|CT837030.1| 39946 g707 i0 95.652 0.996666666666667 299 13 99 0 1 299 16 314 Oryza sativa (indica cultivar-group) cDNA clone:OSIGCPI012C10, full insert sequence blastn 299 481 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
11851579 11851579 PRJNA290839_P_NODE_50_length_1372_cov_3.555812_g33_i0 PRJNA290839 50 1372 3.555812 48.78574064 Oryza sativa 4530 Plants Plants 1105 0   NTclustered gi|32993583|dbj|AK108374.1| 39947 g33 i0 91.076 48.7463556851312 818 72 60 1 555 1372 1 817 Oryza sativa Japonica Group cDNA clone:002-142-D11, full insert sequence blastn 66880 1105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
12537998 12537998 PRJNA290839_P_NODE_890_length_271_cov_1.570707_g869_i0 PRJNA290839 890 271 1.570707 4.25661597 Poaceae 4479 Plants Plants 501 2.05e-137   NTclustered gi|1214171912|gb|KY636002.1| 4483 g869 i0 100 192 271 0 100 0 1 271 97769 97499 Aegilops bicornis voucher AE 788 chloroplast, partial genome blastn 52032 501 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops bicornis
13126718 13126718 PRJNA290839_P_NODE_311_length_482_cov_1.542787_g290_i0 PRJNA290839 311 482 1.542787 7.43623334 Magnoliopsida 3398 Plants Plants 235 1.6299999999999996e-74   NR KAH9801912.1 2711 g290 i0 76 112.269709543568 154 37 95.9 0 21 482 2 155 KAH9801912.1 KH type-2 domain-containing protein [Citrus sinensis] diamond 54114 237 0.991561181434599 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
14401868 14401868 PRJNA290839_P_NODE_472_length_376_cov_1.260726_g451_i0 PRJNA290839 472 376 1.260726 4.74032976 Magnoliopsida 3398 Plants Plants 171 5.29e-49   NR KAF4359047.1 3483 g451 i0 72.6 41.3856382978723 117 28 90.2 1 373 35 270 386 KAF4359047.1 hypothetical protein G4B88_008530 [Cannabis sativa] diamond 15561 172 0.994186046511628 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
16361968 16361968 PRJNA290839_P_NODE_973_length_257_cov_1.684783_g952_i0 PRJNA290839 973 257 1.684783 4.32989231 Streptophyta 35493 Plants Plants 161 3.72e-35   NTclustered gi|1173203591|dbj|AK407401.1| 3369 g952 i0 78.175 58.0972762645914 252 55 98 0 2 253 307 558 Cryptomeria japonica mRNA, clone: CFFL011_E08, expressed in female strobili blastn 14931 161 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
16950287 16950287 PRJNA290839_P_NODE_1234_length_249_cov_0.880682_g1213_i0 PRJNA290839 1234 249 0.880682 2.19289818 root 1 Root_unresolved Root_unresolved 114 3.79e-28   NR BAJ95005.1 112509 g1213 i0 80 1.56626506024096 65 13 78.3 0 240 46 8 72 BAJ95005.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 390 115 0.991304347826087 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
18224558 18224558 PRJNA290839_P_NODE_1475_length_245_cov_0.901163_g1454_i0 PRJNA290839 1475 245 0.901163 2.20784935 Sphagnum balticum 128184 Plants Plants 133 5.98e-36   NR CAM5999666.1 128184 g1454 i0 81.5 0.991836734693878 81 15 99.2 0 1 243 2 82 CAM5999666.1 unnamed protein product [Sphagnum balticum] diamond 243 133 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
18910935 18910935 PRJNA290839_P_NODE_495_length_366_cov_1.928328_g474_i0 PRJNA290839 495 366 1.928328 7.05768048 Eukaryota 2759 Plants Plants 171 8.31e-50   NR KAL4294614.1 3818 g474 i0 75.7 77.6967213114754 107 26 87.7 0 44 364 27 133 KAL4294614.1 hypothetical protein AHAS_Ahas18G0245700 [Arachis hypogaea] diamond 28437 171 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
19498821 19498821 PRJNA290839_P_NODE_656_length_316_cov_1.917695_g635_i0 PRJNA290839 656 316 1.917695 6.0599162 Magnoliopsida 3398 Plants Plants 168 1.13e-49   NR KAK5803956.1 29729 g635 i0 75.2 29.7626582278481 101 25 95.9 0 305 3 1 101 KAK5803956.1 hypothetical protein PVK06_031605 [Gossypium arboreum] diamond 9405 169 0.994082840236686 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium arboreum
20774378 20774378 PRJNA290839_P_NODE_857_length_278_cov_1.234146_g836_i0 PRJNA290839 857 278 1.234146 3.43092588 Streptophyta 35493 Plants Plants 160 1.19e-47   NR O65082.1 3335 g836 i0 84.8 21.841726618705 92 14 99.3 0 2 277 11 102 O65082.1 RecName: Full=Large ribosomal subunit protein eL15y; AltName: Full=60S ribosomal protein L15-2 [Picea mariana] diamond 6072 160 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea mariana
21461252 21461252 PRJNA290839_P_NODE_957_length_259_cov_1.344086_g936_i0 PRJNA290839 957 259 1.344086 3.48118274 Poaceae 4479 Plants Plants 479 9.13e-131   NTclustered gi|1214171912|gb|KY636002.1| 4483 g936 i0 100 196 259 0 100 0 1 259 96521 96779 Aegilops bicornis voucher AE 788 chloroplast, partial genome blastn 50764 479 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Aegilops Aegilops bicornis
23324952 23324952 PRJNA290839_P_NODE_1299_length_248_cov_0.885714_g1278_i0 PRJNA290839 1299 248 0.885714 2.19657072 Populus nigra 3691 Plants Plants 145 3.6e-30   NTclustered gi|2645385715|ref|XM_062107710.1| 3691 g1278 i0 80.952 52.2661290322581 189 30 75 6 49 234 331 146 PREDICTED: Populus nigra large ribosomal subunit protein uL15x-like (LOC133688281), mRNA blastn 12962 145 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus nigra
24599000 24599000 PRJNA290839_P_NODE_1140_length_250_cov_1.757062_g1119_i0 PRJNA290839 1140 250 1.757062 4.392655 Eukaryota 2759 Plants Plants 107 1.41e-27   NR KAH9617267.1 39905 g1119 i0 61.3 10.608 80 30 96 1 243 4 4 82 KAH9617267.1 hypothetical protein KSS87_006893 [Heliosperma pusillum] diamond 2652 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Heliosperma Heliosperma pusillum
26933601 26933601 PRJNA290839_P_NODE_1282_length_248_cov_0.885714_g1261_i0 PRJNA290839 1282 248 0.885714 2.19657072 Magnoliopsida 3398 Plants Plants 71.6 2.66e-12   NR KAH0872548.1 3708 g1261 i0 48.8 1.81451612903226 80 27 79.8 2 198 1 412 491 KAH0872548.1 hypothetical protein HID58_069910 [Brassica napus] diamond 450 71.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
27453622 27453622 PRJNA290839_P_NODE_1243_length_249_cov_0.875000_g1222_i0 PRJNA290839 1243 249 0.875 2.17875 Nymphaea colorata 210225 Plants Plants 88.6 2.46e-19   NR XP_031472586.1 210225 g1222 i0 60.3 0.879518072289157 73 27 88 1 223 5 9 79 XP_031472586.1 uncharacterized protein LOC116244932 [Nymphaea colorata] diamond 219 88.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
28211002 28211002 PRJNA290839_P_NODE_346_length_455_cov_1.492147_g325_i0 PRJNA290839 346 455 1.492147 6.78926885 Citrus sinensis 2711 Plants Plants 201 2.24e-62   NR KDO58080.1 2711 g325 i0 65.1 2.94725274725275 149 52 98.2 0 447 1 1 149 KDO58080.1 hypothetical protein CISIN_1g027063mg [Citrus sinensis] diamond 1341 201 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
28702537 28702537 PRJNA290839_P_NODE_1247_length_249_cov_0.875000_g1226_i0 PRJNA290839 1247 249 0.875 2.17875 Magnoliopsida 3398 Plants Plants 122 3.2999999999999996e-33   NR XP_057532735.1 29722 g1226 i0 66.7 11.6506024096386 81 26 96.4 1 240 1 3 83 XP_057532735.1 SUMO-conjugating enzyme SCE1-like [Amaranthus tricolor] diamond 2901 123 0.991869918699187 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Amaranthaceae Amaranthus Amaranthus tricolor
29127085 29127085 PRJNA290839_P_NODE_729_length_300_cov_1.713656_g708_i0 PRJNA290839 729 300 1.713656 5.140968 Lotus japonicus 34305 Plants Plants 157 1.54e-46   NR AFK43985.1 34305 g708 i0 71.7 1.96 99 28 99 0 299 3 1 99 AFK43985.1 unknown [Lotus japonicus] diamond 588 157 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
29712395 29712395 PRJNA290839_P_NODE_570_length_341_cov_1.156716_g549_i0 PRJNA290839 570 341 1.156716 3.94440156 Streptophyta 35493 Plants Plants 114 8.32e-30   NR NP_001365255.1 3218 g549 i0 66.3 4.29325513196481 98 31 86.2 1 340 47 31 126 NP_001365255.1 40S ribosomal protein S24-1 [Physcomitrium patens] diamond 1464 115 0.991304347826087 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
31464889 31464889 PRJNA290839_P_NODE_916_length_267_cov_1.268041_g895_i0 PRJNA290839 916 267 1.268041 3.38566947 Helianthus annuus 4232 Plants Plants 46.6 0.00123   NR KAJ0743249.1 4232 g895 i0 52.1 0.539325842696629 48 23 53.9 0 11 154 79 126 KAJ0743249.1 putative non-specific serine/threonine protein kinase [Helianthus annuus] diamond 144 46.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus annuus
32160818 32160818 PRJNA290839_P_NODE_378_length_433_cov_2.563889_g357_i0 PRJNA290839 378 433 2.563889 11.10163937 Lotus japonicus 34305 Plants Plants 159 5.05e-45   NR AFK37198.1 34305 g357 i0 61.7 0.976905311778291 141 50 95.6 2 416 3 5 144 AFK37198.1 unknown [Lotus japonicus] diamond 423 159 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
32305099 32305099 PRJNA290839_P_NODE_1499_length_244_cov_1.789474_g1478_i0 PRJNA290839 1499 244 1.789474 4.36631656 Eukaryota 2759 Plants Plants 116 2.6e-29   NR GER48018.1 4170 g1478 i0 77.3 34.7950819672131 75 17 92.2 0 18 242 189 263 GER48018.1 40S ribosomal protein S13 [Striga asiatica] diamond 8490 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Striga Striga asiatica
32715416 32715416 PRJNA290839_P_NODE_1040_length_252_cov_0.871508_g1019_i0 PRJNA290839 1040 252 0.871508 2.19620016 Streptophyta 35493 Plants Plants 117 3.4099999999999995e-31   NR KAJ7946775.1 32244 g1019 i0 69.7 12.6547619047619 76 23 90.5 0 228 1 1 76 KAJ7946775.1 AP complex subunit sigma [Quillaja saponaria] diamond 3189 118 0.991525423728814 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria

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