RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA229468 · 20 ✖

analysis 1

  • blastn · 20 ✖
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
2917902 2917902 PRJNA229468_S_NODE_503_length_224_cov_0.868571_g490_i0 PRJNA229468 503 224 0.868571 1.94559904 Oryza sativa 4530 Plants Plants 130 8.94e-26   NTclustered gi|116641716|emb|CT837055.1| 39946 g490 i0 88.182 0.491071428571429 110 11 49 2 65 173 852 744 Oryza sativa (indica cultivar-group) cDNA clone:OSIGCRA209C05, full insert sequence blastn 110 130 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
3607069 3607069 PRJNA229468_S_NODE_523_length_219_cov_5.176471_g510_i0 PRJNA229468 523 219 5.176471 11.33647149 Quercus 3511 Plants Plants 405 1.29e-108   NTclustered gi|1878849207|gb|MT796543.1| 3512 g510 i0 100 100 219 0 100 0 1 219 3741 3523 Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 21900 405 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
3607070 3607070 PRJNA229468_S_NODE_823_length_183_cov_2.947761_g810_i0 PRJNA229468 823 183 2.947761 5.39440263 Magnoliopsida 3398 Plants Plants 52.8 0.016   NTclustered gi|1147609247|ref|XM_020253053.1| 4615 g810 i0 100 0.306010928961749 28 0 15 0 93 120 840 813 PREDICTED: Ananas comosus uncharacterized LOC109724280 (LOC109724280), mRNA blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
4194373 4194373 PRJNA229468_S_NODE_604_length_208_cov_3.433962_g591_i0 PRJNA229468 604 208 3.433962 7.14264096 Quercus robur 38942 Plants Plants 385 1.58e-102   NTclustered gi|1878849160|gb|MT796507.1| 38942 g591 i0 100 100 208 0 100 0 1 208 4819 5026 Quercus robur isolate DM325 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 20800 385 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
4194377 4194377 PRJNA229468_S_NODE_984_length_171_cov_2.467213_g971_i0 PRJNA229468 984 171 2.467213 4.21893423 Phyllostachys edulis 38705 Plants Plants 311 2.14e-80   NTclustered gi|242386712|emb|FP099117.1| 38705 g971 i0 99.415 18.4327485380117 171 1 100 0 1 171 615 785 Phyllostachys edulis cDNA clone: bphyem207e20, full insert sequence blastn 3152 311 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
4884539 4884539 PRJNA229468_S_NODE_1184_length_163_cov_0.894737_g1171_i0 PRJNA229468 1184 163 0.894737 1.45842131 Magnoliopsida 3398 Plants Plants 296 5.68e-76   NTclustered gi|2742370619|gb|PP274534.1| 3694 g1171 i0 99.387 199 163 1 100 0 1 163 106787 106949 Populus trichocarpa chloroplast, complete genome blastn 32437 296 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus trichocarpa
7434485 7434485 PRJNA229468_S_NODE_506_length_222_cov_2.635838_g493_i0 PRJNA229468 506 222 2.635838 5.85156036 Fagaceae 3503 Plants Plants 407 3.65e-109   NTclustered gi|7578500|gb|AF132892.1|AF132892 3512 g493 i0 99.55 100.004504504505 222 1 100 0 1 222 80 301 Quercus rubra 18S ribosomal RNA gene, partial sequence blastn 22201 411 0.990267639902676 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
9295361 9295361 PRJNA229468_S_NODE_688_length_197_cov_1.722973_g675_i0 PRJNA229468 688 197 1.722973 3.39425681 Phyllostachys edulis 38705 Plants Plants 364 1.929999999999999e-96   NTclustered gi|242386712|emb|FP099117.1| 38705 g675 i0 100 30.0152284263959 197 0 100 0 1 197 1110 914 Phyllostachys edulis cDNA clone: bphyem207e20, full insert sequence blastn 5913 364 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
11845849 11845849 PRJNA229468_S_NODE_450_length_234_cov_1.378378_g437_i0 PRJNA229468 450 234 1.378378 3.22540452 Phyllostachys edulis 38705 Plants Plants 422 1.39e-113   NTclustered gi|242386712|emb|FP099117.1| 38705 g437 i0 99.145 12.3974358974359 234 2 100 0 1 234 1181 1414 Phyllostachys edulis cDNA clone: bphyem207e20, full insert sequence blastn 2901 422 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
11845851 11845851 PRJNA229468_S_NODE_710_length_195_cov_2.178082_g697_i0 PRJNA229468 710 195 2.178082 4.2472599 Quercus robur 38942 Plants Plants 344 2.48e-90   NTclustered gi|2293049806|ref|XR_007645197.1| 38942 g697 i0 98.462 100 195 3 100 0 1 195 3128 3322 PREDICTED: Quercus robur 28S ribosomal RNA (LOC126693076), rRNA blastn 19500 344 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
13121082 13121082 PRJNA229468_S_NODE_551_length_214_cov_1.236364_g538_i0 PRJNA229468 551 214 1.236364 2.64581896 Nymphaea colorata 210225 Plants Plants 147 8.41e-31   NTclustered gi|2286260120|ref|XM_031620569.2| 210225 g538 i0 79.808 14.2570093457944 208 37 95 4 10 213 1107 1313 PREDICTED: Nymphaea colorata adenosylhomocysteinase (LOC116248019), mRNA blastn 3051 147 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
15670087 15670087 PRJNA229468_S_NODE_193_length_348_cov_2.311037_g180_i0 PRJNA229468 193 348 2.311037 8.04240876 Hordeum vulgare 4513 Plants Plants 187 8.659999999999998e-43   NTclustered gi|326505249|dbj|AK371814.1| 112509 g180 i0 78.873 25.9712643678161 284 55 81 5 66 346 1008 727 Hordeum vulgare subsp. vulgare mRNA for predicted protein, complete cds, clone: NIASHv2141N06 blastn 9038 187 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
18908031 18908031 PRJNA229468_S_NODE_655_length_202_cov_1.411765_g642_i0 PRJNA229468 655 202 1.411765 2.8517653 Eukaryota 2759 Plants Plants 298 2.05e-76   NTclustered gi|391415363|gb|BT065681.2| 4577 g642 i0 99.394 81.5544554455445 165 0 82 1 1 165 696 859 Zea mays full-length cDNA clone ZM_BFc0017K02 mRNA, complete cds blastn 16474 298 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
18908032 18908032 PRJNA229468_S_NODE_75_length_556_cov_4.698225_g65_i0 PRJNA229468 75 556 4.698225 26.122131 Quercus 3511 Plants Plants 1005 0   NTclustered gi|1878849207|gb|MT796543.1| 3512 g65 i0 99.281 100 556 4 100 0 1 556 4278 3723 Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 55600 1005 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
21458299 21458299 PRJNA229468_S_NODE_157_length_383_cov_9.973054_g144_i0 PRJNA229468 157 383 9.973054 38.19679682 Fagaceae 3503 Plants Plants 708 0   NTclustered gi|1878849207|gb|MT796543.1| 3512 g144 i0 100 100 383 0 100 0 1 383 5312 4930 Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 38300 708 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
22733348 22733348 PRJNA229468_S_NODE_798_length_185_cov_4.147059_g785_i0 PRJNA229468 798 185 4.147059 7.67205915 Magnoliopsida 3398 Plants Plants 342 8.369999999999999e-90   NTclustered gi|1878849229|gb|MT796565.1| 3505 g785 i0 100 100 185 0 100 0 1 185 1448 1632 Betula pendula isolate DM301 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 18500 342 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Betula Betula pendula
24008529 24008529 PRJNA229468_S_NODE_879_length_179_cov_1.176923_g866_i0 PRJNA229468 879 179 1.176923 2.10669217 Magnoliopsida 3398 Plants Plants 331 1.74e-86   NTclustered gi|1198229794|emb|LT855379.1| 3505 g866 i0 100 111.184357541899 179 0 100 0 1 179 263626 263448 Betula pendula genome assembly, organelle: mitochondrion blastn 19902 331 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Betula Betula pendula
24593511 24593511 PRJNA229468_S_NODE_1120_length_165_cov_1.112069_g1107_i0 PRJNA229468 1120 165 1.112069 1.83491385 Herrania umbratica 108875 Plants Plants 108 2.9e-19   NTclustered gi|1204921545|ref|XM_021438016.1| 108875 g1107 i0 78.528 37.9939393939394 163 35 99 0 1 163 506 344 PREDICTED: Herrania umbratica ras-related protein RABA1f (LOC110423708), mRNA blastn 6269 108 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Herrania Herrania umbratica
25282654 25282654 PRJNA229468_S_NODE_260_length_310_cov_5.842912_g247_i0 PRJNA229468 260 310 5.842912 18.1130272 Eukaryota 2759 Plants Plants 573 4.999999999999998e-159   NTclustered gi|1878849207|gb|MT796543.1| 3512 g247 i0 100 100 310 0 100 0 1 310 1676 1985 Quercus rubra isolate DM598 small subunit ribosomal RNA gene, 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 31000 573 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
25282655 25282655 PRJNA229468_S_NODE_500_length_224_cov_6.782857_g487_i0 PRJNA229468 500 224 6.782857 15.19359968 Fagaceae 3503 Plants Plants 411 2.8499999999999995e-110   NTclustered gi|19919548|gb|AF479107.1| 28927 g487 i0 99.554 100.004464285714 224 1 100 0 1 224 1886 2109 Chrysolepis sempervirens 26S ribosomal RNA gene, complete sequence blastn 22401 414 0.992753623188406 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Chrysolepis Chrysolepis sempervirens

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