RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA938397 · 17 ✖

analysis 1

  • blastn · 17 ✖
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
3808018 3808018 PRJNA938397_S_NODE_40743_length_172_cov_3.111111_g40502_i0 PRJNA938397 40743 172 3.111111 5.35111092 Eukaryota 2759 Plants Plants 52.8 0.014   NTclustered gi|2583740234|ref|XM_059784070.1| 4283 g40502 i0 100 0.488372093023256 28 0 16 0 82 109 1173 1200 PREDICTED: Cornus florida nucleosome assembly protein 1;4-like (LOC132282399), mRNA blastn 84 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cornales Cornaceae Cornus Cornus florida
4741081 4741081 PRJNA938397_S_NODE_21764_length_236_cov_113.718593_g21523_i0 PRJNA938397 21764 236 113.718593 268.37587948 Quercus lobata 97700 Plants Plants 58.4 4.55e-4   NTclustered gi|1757525123|ref|XM_031086011.1| 97700 g21523 i0 100 0.13135593220339 31 0 13 0 88 118 473 503 PREDICTED: Quercus lobata uncharacterized LOC115966867 (LOC115966867), mRNA blastn 31 58.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus lobata
6016163 6016163 PRJNA938397_S_NODE_26845_length_213_cov_3.732955_g26604_i0 PRJNA938397 26845 213 3.732955 7.95119415 Taxillus matsudae 2805424 Plants Plants 126 1.09e-24   NTclustered gi|1970150767|gb|MW555625.1| 2805424 g26604 i0 84.375 9.64788732394366 128 20 60 0 63 190 3022 2895 Taxillus matsudae voucher Su138 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 2055 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Santalales Loranthaceae Taxillus Taxillus matsudae
7292121 7292121 PRJNA938397_S_NODE_52766_length_151_cov_0.982456_g52525_i0 PRJNA938397 52766 151 0.982456 1.48350856 Mesembryanthemum crystallinum 3544 Plants Plants 176 7.009999999999999e-40   NTclustered gi|167269|gb|M38316.1|CIPRBCS2 3544 g52525 i0 88.811 40.9933774834437 143 16 95 0 6 148 416 558 Mesembryanthemum crystallinum ribulose-1,5- bisphosphate carboxylase/oxygenase small subunit (rbcS-2) mRNA, complete cds blastn 6190 176 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Aizoaceae Mesembryanthemum Mesembryanthemum crystallinum
7634156 7634156 PRJNA938397_S_NODE_53166_length_150_cov_3.398230_g52925_i0 PRJNA938397 53166 150 3.39823 5.097345 Magnoliopsida 3398 Plants Plants 272 8.609999999999998e-69   NTclustered gi|910750164|gb|KR336549.1| 4615 g52925 i0 99.333 198 150 1 100 0 1 150 109178 109029 Ananas comosus cultivar MD-2 chloroplast, complete genome blastn 29700 272 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
9840915 9840915 PRJNA938397_S_NODE_25988_length_216_cov_13.474860_g25747_i0 PRJNA938397 25988 216 13.47486 29.1056976 Phragmites australis 29695 Plants Plants 63.9 8.81e-6   NTclustered gi|2649485551|ref|XM_062339634.1| 29695 g25747 i0 95 0.574074074074074 40 2 19 0 161 200 440 401 PREDICTED: Phragmites australis metallothionein-like protein 3A (LOC133898847), mRNA blastn 124 63.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phragmites Phragmites australis
11117109 11117109 PRJNA938397_S_NODE_39249_length_175_cov_8.514493_g39008_i0 PRJNA938397 39249 175 8.514493 14.90036275 Solanum lycopersicum 4081 Plants Plants 52.8 0.015   NTclustered gi|452682627|gb|AC254170.3| 4081 g39008 i0 100 0.32 28 0 16 0 90 117 96951 96924 Solanum lycopersicum strain Heinz 1706 chromosome 9 clone sle-19b10 map 9, complete sequence blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum lycopersicum
16216466 16216466 PRJNA938397_S_NODE_40313_length_173_cov_2.676471_g40072_i0 PRJNA938397 40313 173 2.676471 4.63029483 Cannabis sativa 3483 Plants Plants 54.7 0.004   NTclustered gi|2748541970|gb|CP158650.1| 3483 g40072 i0 100 0.335260115606936 29 0 17 0 135 163 46059358 46059330 Cannabis sativa cultivar ERBxHO40_23 chromosome 9 blastn 58 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
16558509 16558509 PRJNA938397_S_NODE_43493_length_166_cov_5.271318_g43252_i0 PRJNA938397 43493 166 5.271318 8.75038788 Eukaryota 2759 Plants Plants 265 1.64e-66   NTclustered gi|1484650212|ref|XR_003349481.1| 3469 g43252 i0 99.315 87.9698795180723 146 1 88 0 5 150 987 1132 PREDICTED: Papaver somniferum 18S ribosomal RNA (LOC113328623), rRNA blastn 14603 265 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ranunculales Papaveraceae Papaver Papaver somniferum
17491113 17491113 PRJNA938397_S_NODE_24434_length_223_cov_9.983871_g24193_i0 PRJNA938397 24434 223 9.983871 22.26403233 Brassica rapa 3711 Plants Plants 54.7 0.006   NTclustered gi|1516499363|emb|LR031568.1| 3711 g24193 i0 100 0.130044843049327 29 0 13 0 38 66 42526557 42526529 Brassica rapa genome, scaffold: A09 blastn 29 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
17491795 17491795 PRJNA938397_S_NODE_40954_length_171_cov_11.022388_g40713_i0 PRJNA938397 40954 171 11.022388 18.84828348 Solanum verrucosum 315347 Plants Plants 54.7 0.004   NTclustered gi|2276298343|ref|XM_049510000.1| 315347 g40713 i0 96.875 0.187134502923977 32 1 19 0 16 47 430 461 PREDICTED: Solanum verrucosum protein HOTHEAD-like (LOC125830822), mRNA blastn 32 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum verrucosum
18765818 18765818 PRJNA938397_S_NODE_7975_length_365_cov_8.521341_g7734_i0 PRJNA938397 7975 365 8.521341 31.10289465 Cannabis sativa 3483 Plants Plants 54.7 0.01   NTclustered gi|2748540810|gb|CP158644.1| 3483 g7734 i0 92.105 0.208219178082192 38 3 10 0 302 339 53988832 53988795 Cannabis sativa cultivar ERBxHO40_23 chromosome 5 blastn 76 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
21314806 21314806 PRJNA938397_S_NODE_21637_length_237_cov_11.950000_g21396_i0 PRJNA938397 21637 237 11.95 28.3215 Chenopodium quinoa 63459 Plants Plants 52.8 0.021   NTclustered gi|1219161595|ref|XR_002509158.1| 63459 g21396 i0 96.774 0.392405063291139 31 1 13 0 99 129 3049 3019 PREDICTED: Chenopodium quinoa uncharacterized LOC110710381 (LOC110710381), transcript variant X1, misc_RNA blastn 93 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Chenopodium Chenopodium quinoa
22590289 22590289 PRJNA938397_S_NODE_34578_length_187_cov_8.793333_g34337_i0 PRJNA938397 34578 187 8.793333 16.44353271 Brassica rapa 3711 Plants Plants 52.8 0.016   NTclustered gi|1516499363|emb|LR031568.1| 3711 g34337 i0 96.875 0.171122994652406 32 0 17 1 138 168 36933071 36933040 Brassica rapa genome, scaffold: A09 blastn 32 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
25138940 25138940 PRJNA938397_S_NODE_23100_length_230_cov_3.248705_g22859_i0 PRJNA938397 23100 230 3.248705 7.4720215 Maltebrunia leersioides 2057683 Plants Plants 425 1.05e-114   NTclustered gi|2879580938|emb|OZ217168.1| 2057683 g22859 i0 100 191 230 0 100 0 1 230 80539 80768 Maltebrunia leersioides genome assembly, organelle: plastid:chloroplast blastn 43930 425 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Maltebrunia Maltebrunia leersioides
25482530 25482530 PRJNA938397_S_NODE_34800_length_187_cov_2.946667_g34559_i0 PRJNA938397 34800 187 2.946667 5.51026729 Glycine 3846 Plants Plants 52.8 0.016   NTclustered gi|2027512976|ref|XM_003547482.5| 3847 g34559 i0 100 0.299465240641711 28 0 15 0 93 120 2349 2322 PREDICTED: Glycine max probable receptor-like protein kinase At1g11050 (LOC100806560), mRNA blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
25482552 25482552 PRJNA938397_S_NODE_51260_length_153_cov_2.258621_g51019_i0 PRJNA938397 51260 153 2.258621 3.45569013 Caryophyllales 3524 Plants Plants 267 4.1099999999999994e-67   NTclustered gi|19919534|gb|AF479093.1| 3583 g51019 i0 98.039 100.21568627451 153 3 100 0 1 153 1673 1521 Portulaca grandiflora 26S ribosomal RNA gene, complete sequence blastn 15333 267 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Portulacaceae Portulaca Portulaca grandiflora

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