RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "blastn", bioproject = "PRJNA1233317" 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 · 25 ✖

bioproject 1

  • PRJNA1233317 · 25 ✖

analysis 1

  • blastn · 25 ✖
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
335704 335704 PRJNA1233317_S_NODE_8881_length_260_cov_1.761194_g8845_i0 PRJNA1233317 8881 260 1.761194 4.5791044 Cannabis sativa 3483 Plants Plants 56.5 0.002   NTclustered gi|2748541970|gb|CP158650.1| 3483 g8845 i0 100 0.573076923076923 30 0 12 0 229 258 23894409 23894380 Cannabis sativa cultivar ERBxHO40_23 chromosome 9 blastn 149 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
1047101 1047101 PRJNA1233317_S_NODE_13321_length_212_cov_1.196078_g13285_i0 PRJNA1233317 13321 212 1.196078 2.53568536 Streptophyta 35493 Plants Plants 52.8 0.019   NTclustered gi|2835530370|dbj|LC777197.1| 3329 g13285 i0 100 0.39622641509434 28 0 13 0 185 212 57 30 Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds blastn 84 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
1047148 1047148 PRJNA1233317_S_NODE_7061_length_286_cov_2.572687_g7025_i0 PRJNA1233317 7061 286 2.572687 7.35788482 Ananas 4614 Plants Plants 180 1.16e-40   NTclustered gi|1147546582|ref|XM_020225337.1| 4615 g7025 i0 78.495 53.6573426573427 279 56 97 4 9 285 449 173 PREDICTED: Ananas comosus 60S ribosomal protein L26-1-like (LOC109704578), mRNA blastn 15346 180 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
2886549 2886549 PRJNA1233317_S_NODE_3143_length_357_cov_3.010067_g3107_i0 PRJNA1233317 3143 357 3.010067 10.74593919 Populus nigra 3691 Plants Plants 52.8 0.034   NTclustered gi|2645379251|ref|XM_062106216.1| 3691 g3107 i0 100 0.0784313725490196 28 0 8 0 106 133 2220 2193 PREDICTED: Populus nigra uncharacterized LOC133682722 (LOC133682722), mRNA blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus nigra
6713400 6713400 PRJNA1233317_S_NODE_7606_length_277_cov_47.532110_g7570_i0 PRJNA1233317 7606 277 47.53211 131.6639447 Luculia yunnanensis 1043446 Plants Plants 52.8 0.025   NTclustered gi|363453795|gb|JN871303.1| 1043446 g7570 i0 96.774 0.111913357400722 31 1 11 0 40 70 59 89 Luculia yunnanensis clone MH8 microsatellite sequence blastn 31 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Gentianales Rubiaceae Luculia Luculia yunnanensis
7425025 7425025 PRJNA1233317_S_NODE_13846_length_207_cov_2.472973_g13810_i0 PRJNA1233317 13846 207 2.472973 5.11905411 Eukaryota 2759 Plants Plants 52.8 0.018   NTclustered gi|1963662117|emb|LR861820.1| 4565 g13810 i0 100 0.405797101449275 28 0 14 0 180 207 33 6 Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a blastn 84 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
8700166 8700166 PRJNA1233317_S_NODE_2107_length_388_cov_2.647416_g2071_i0 PRJNA1233317 2107 388 2.647416 10.27197408 Eukaryota 2759 Plants Plants 52.8 0.037   NTclustered gi|1963662117|emb|LR861820.1| 4565 g2071 i0 100 0.216494845360825 28 0 7 0 361 388 33 6 Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a blastn 84 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
9263674 9263674 PRJNA1233317_S_NODE_1768_length_401_cov_15.181287_g1732_i0 PRJNA1233317 1768 401 15.181287 60.87696087 Oryza sativa 4530 Plants Plants 680 0   NTclustered gi|32995479|dbj|AK110270.1| 39947 g1732 i0 97.052 2.61845386533666 407 6 100 3 1 401 680 1086 Oryza sativa Japonica Group cDNA clone:002-163-C08, full insert sequence blastn 1050 680 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
10539470 10539470 PRJNA1233317_S_NODE_12769_length_217_cov_1.746835_g12733_i0 PRJNA1233317 12769 217 1.746835 3.79063195 Ziziphus jujuba 326968 Plants Plants 52.8 0.019   NTclustered gi|2739574730|gb|CP157404.1| 326968 g12733 i0 100 0.129032258064516 28 0 13 0 92 119 28168461 28168434 Ziziphus jujuba isolate TW-2024b chromosome 02 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
11250518 11250518 PRJNA1233317_S_NODE_8489_length_265_cov_4.305825_g8453_i0 PRJNA1233317 8489 265 4.305825 11.41043625 Plantago 26867 Plants Plants 484 2.0199999999999998e-132   NTclustered gi|2050192475|gb|MW877582.1| 39414 g8453 i0 99.623 198 265 1 100 0 1 265 101385 101649 Plantago lanceolata plastid, complete genome blastn 52470 484 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Plantago Plantago lanceolata
11814316 11814316 PRJNA1233317_S_NODE_9210_length_256_cov_1.238579_g9174_i0 PRJNA1233317 9210 256 1.238579 3.17076224 Picea abies 3329 Plants Plants 54.7 0.006   NTclustered gi|2835530376|dbj|LC777199.1| 3329 g9174 i0 100 0.22265625 29 0 11 0 228 256 405 377 Picea abies Pa-Kumamoto-2022 PaDdl mRNA for D-alanine-D-alanine ligase, complete cds blastn 57 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
13089253 13089253 PRJNA1233317_S_NODE_10191_length_243_cov_8.978261_g10155_i0 PRJNA1233317 10191 243 8.978261 21.81717423 Carica papaya 3649 Plants Plants 449 6.65e-122   NTclustered gi|1227949510|ref|XM_022055155.1| 3649 g10155 i0 100 1126.47325102881 243 0 100 0 1 243 1098 856 PREDICTED: Carica papaya uncharacterized LOC110824615 (LOC110824615), partial mRNA blastn 273733 449 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Caricaceae Carica Carica papaya
13800496 13800496 PRJNA1233317_S_NODE_14671_length_200_cov_5.226950_g14635_i0 PRJNA1233317 14671 200 5.22695 10.4539 Magnoliopsida 3398 Plants Plants 368 1.52e-97   NTclustered gi|2396003214|ref|XR_008051474.1| 2711 g14635 i0 100 99.505 199 0 99 0 2 200 747 945 PREDICTED: Citrus sinensis 18S ribosomal RNA (LOC127899596), rRNA blastn 19901 370 0.994594594594595 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
15638521 15638521 PRJNA1233317_S_NODE_11613_length_228_cov_2.218935_g11577_i0 PRJNA1233317 11613 228 2.218935 5.0591718 Picea abies 3329 Plants Plants 58.4 4.37e-4   NTclustered gi|2835530364|dbj|LC777194.1| 3329 g11577 i0 100 0.258771929824561 31 0 14 0 1 31 29 59 Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds blastn 59 58.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
15638546 15638546 PRJNA1233317_S_NODE_14753_length_200_cov_1.297872_g14717_i0 PRJNA1233317 14753 200 1.297872 2.595744 Trifolium pratense 57577 Plants Plants 58.4 3.73e-4   NTclustered gi|2179019731|ref|XM_045970165.1| 57577 g14717 i0 100 1.15 31 0 16 0 116 146 737 707 PREDICTED: Trifolium pratense uncharacterized LOC123918190 (LOC123918190), transcript variant X1, mRNA blastn 230 58.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium pratense
15638633 15638633 PRJNA1233317_S_NODE_7653_length_277_cov_3.642202_g7617_i0 PRJNA1233317 7653 277 3.642202 10.08889954 Picea abies 3329 Plants Plants 52.8 0.025   NTclustered gi|2835530393|dbj|LC777203.1| 3329 g7617 i0 96.875 0.115523465703971 32 0 12 1 246 277 55 25 Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds blastn 32 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
18187201 18187201 PRJNA1233317_S_NODE_5535_length_309_cov_3.088000_g5499_i0 PRJNA1233317 5535 309 3.088 9.54192 Musa acuminata 4641 Plants Plants 54.7 0.008   NTclustered gi|2729589955|ref|XM_065179946.1| 214697 g5499 i0 96.875 0.310679611650485 32 1 10 0 34 65 5042 5073 PREDICTED: Musa acuminata AAA Group protein ESSENTIAL FOR POTEXVIRUS ACCUMULATION 1-like (LOC135671762), mRNA blastn 96 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Musaceae Musa Musa acuminata
19461600 19461600 PRJNA1233317_S_NODE_11136_length_233_cov_2.063218_g11100_i0 PRJNA1233317 11136 233 2.063218 4.80729794 Picea abies 3329 Plants Plants 52.8 0.021   NTclustered gi|2835530393|dbj|LC777203.1| 3329 g11100 i0 100 0.120171673819742 28 0 12 0 1 28 29 56 Picea abies Pa-Kumamoto-2022 PaMurJ mRNA for lipid II transferase, complete cds blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
19461636 19461636 PRJNA1233317_S_NODE_18376_length_168_cov_47.256881_g18340_i0 PRJNA1233317 18376 168 47.256881 79.39156008 Ziziphus jujuba 326968 Plants Plants 52.8 0.014   NTclustered gi|2739574740|gb|CP157414.1| 326968 g18340 i0 100 0.166666666666667 28 0 17 0 122 149 17663010 17662983 Ziziphus jujuba isolate TW-2024b chromosome 12 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
19461705 19461705 PRJNA1233317_S_NODE_936_length_469_cov_13.382927_g900_i0 PRJNA1233317 936 469 13.382927 62.76592763 Hordeum vulgare 4513 Plants Plants 833 0   NTclustered gi|151426205|dbj|AK252797.1| 112509 g900 i0 98.723 69.543710021322 470 5 100 1 1 469 646 1115 Hordeum vulgare subsp. vulgare cDNA clone: FLbaf172m04, mRNA sequence blastn 32616 833 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
20737045 20737045 PRJNA1233317_S_NODE_11997_length_224_cov_2.218182_g11961_i0 PRJNA1233317 11997 224 2.218182 4.96872768 Picea abies 3329 Plants Plants 56.5 0.002   NTclustered gi|2835530364|dbj|LC777194.1| 3329 g11961 i0 100 0.258928571428571 30 0 13 0 1 30 29 58 Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds blastn 58 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
23287938 23287938 PRJNA1233317_S_NODE_5419_length_311_cov_3.841270_g5383_i0 PRJNA1233317 5419 311 3.84127 11.9463497 Ananas comosus 4615 Plants Plants 52.8 0.029   NTclustered gi|1885248565|emb|LR862131.1| 296719 g5383 i0 96.875 0.102893890675241 32 0 10 1 220 250 9206637 9206606 Ananas comosus var. bracteatus genome assembly, chromosome: 3 blastn 32 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
24561778 24561778 PRJNA1233317_S_NODE_10400_length_241_cov_3.686813_g10364_i0 PRJNA1233317 10400 241 3.686813 8.88521933 Picea sitchensis 3332 Plants Plants 320 5.39e-83   NTclustered gi|116791046|gb|EF086580.1| 3332 g10364 i0 90.833 1.99170124481328 240 21 99 1 1 239 579 340 Picea sitchensis clone WS02917_F19 unknown mRNA blastn 480 320 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
24561835 24561835 PRJNA1233317_S_NODE_3340_length_352_cov_2.092150_g3304_i0 PRJNA1233317 3340 352 2.09215 7.364368 Hordeum vulgare 4513 Plants Plants 628 1.2099999999999999e-175   NTclustered gi|326533901|dbj|AK362520.1| 112509 g3304 i0 100 1.88920454545455 340 0 97 0 1 340 1475 1814 Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2006M01 blastn 665 628 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
25273312 25273312 PRJNA1233317_S_NODE_6920_length_288_cov_1.598253_g6884_i0 PRJNA1233317 6920 288 1.598253 4.60296864 Eukaryota 2759 Plants Plants 52.8 0.027   NTclustered gi|2835530366|dbj|LC777195.1| 3329 g6884 i0 100 0.680555555555556 28 0 10 0 261 288 55 28 Picea abies Pa-Kumamoto-2022 PaMurB mRNA for UDP-N-acetylmuramate dehydrogenase, complete cds blastn 196 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies

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