RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA556842" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA556842 · 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
521762 521762 PRJNA556842_P_NODE_16981_length_157_cov_0.975000_g16476_i0 PRJNA556842 16981 157 0.975 1.53075 Triticum aestivum 4565 Plants Plants 231 1.55e-56   NTclustered gi|1359931138|gb|MG459162.1| 4565 g16476 i0 94.118 361.363057324841 153 8 97 1 1 153 39300 39149 Triticum aestivum isolate Dctg4 alpha-gliadin (Gli-D2) gene, complete cds blastn 56734 231 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
1124152 1124152 PRJNA556842_P_NODE_15101_length_172_cov_1.088889_g14596_i0 PRJNA556842 15101 172 1.088889 1.87288908 Magnoliopsida 3398 Plants Plants 313 5.989999999999998e-81   NTclustered gi|1894827180|gb|MN686110.1| 49666 g14596 i0 99.419 199 172 1 100 0 1 172 106453 106624 Paris polyphylla chloroplast, complete genome blastn 34228 313 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Liliales Melanthiaceae Paris Paris polyphylla
2399579 2399579 PRJNA556842_P_NODE_6442_length_343_cov_1.738562_g5939_i0 PRJNA556842 6442 343 1.738562 5.96326766 Quercus 3511 Plants Plants 617 2.55e-172   NTclustered gi|1878849207|gb|MT796543.1| 3512 g5939 i0 99.125 100 343 3 100 0 1 343 4301 3959 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 34300 617 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
3675477 3675477 PRJNA556842_P_NODE_13383_length_189_cov_1.348684_g12878_i0 PRJNA556842 13383 189 1.348684 2.54901276 Bryopsida 3214 Plants Plants 326 8.650000000000001e-85   NTclustered gi|311441638|gb|HM751532.1| 200727 g12878 i0 97.368 100.132275132275 190 4 100 1 1 189 416 605 Chenia leptophylla isolate MDP49 26S ribosomal RNA gene, partial sequence blastn 18925 326 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pottiales Pottiaceae Chenia Chenia leptophylla
3675483 3675483 PRJNA556842_P_NODE_16823_length_158_cov_0.975207_g16318_i0 PRJNA556842 16823 158 0.975207 1.54082706 Poaceae 4479 Plants Plants 276 7.120000000000001e-70   NTclustered gi|300681517|emb|FN564434.1| 4565 g16318 i0 98.101 413.025316455696 158 3 100 0 1 158 2660236 2660079 Triticum aestivum chromosome 3B-specific BAC library, contig ctg0954b blastn 65258 276 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
4952320 4952320 PRJNA556842_P_NODE_4084_length_469_cov_3.562500_g3591_i0 PRJNA556842 4084 469 3.5625 16.708125 Magnoliopsida 3398 Plants Plants 789 0   NTclustered gi|1878849207|gb|MT796543.1| 3512 g3591 i0 97.015 100 469 14 100 0 1 469 5372 4904 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 46900 795 0.992452830188679 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
6899701 6899701 PRJNA556842_P_NODE_14666_length_176_cov_1.064748_g14161_i0 PRJNA556842 14666 176 1.064748 1.87395648 Olea europaea 4146 Plants Plants 161 2.3599999999999997e-35   NTclustered gi|1279025397|ref|XM_023016129.1| 158386 g14161 i0 100 57.8409090909091 87 0 49 0 1 87 87 1 PREDICTED: Olea europaea var. sylvestris uncharacterized LOC111390994 (LOC111390994), mRNA blastn 10180 161 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
10052574 10052574 PRJNA556842_P_NODE_10028_length_242_cov_2.078049_g9523_i0 PRJNA556842 10028 242 2.078049 5.02887858 Pottiaceae 38586 Plants Plants 431 2.4e-116   NTclustered gi|109138760|gb|DQ629247.1| 81812 g9523 i0 98.76 175 242 3 100 0 1 242 521 762 Hymenostylium recurvirostre large subunit ribosomal RNA gene, partial sequence; chloroplast blastn 42350 431 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pottiales Pottiaceae Hymenostylium Hymenostylium recurvirostrum
10725959 10725959 PRJNA556842_P_NODE_15989_length_164_cov_1.724409_g15484_i0 PRJNA556842 15989 164 1.724409 2.82803076 Euphorbia drupifera 212879 Plants Plants 292 7.41e-75   NTclustered gi|1959393030|gb|MW514686.1| 212879 g15484 i0 98.78 100.341463414634 164 2 100 0 1 164 4411 4574 Euphorbia drupifera voucher RBGK2019-70 (Kew) 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 16456 292 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Euphorbia Euphorbia drupifera
13878113 13878113 PRJNA556842_P_NODE_17151_length_155_cov_3.067797_g16646_i0 PRJNA556842 17151 155 3.067797 4.75508535 root 1 Root_unresolved Root_unresolved 104 3.47e-18   NTclustered gi|2502671254|gb|OQ420599.1| 3559 g16646 i0 96.825 40.6451612903226 63 1 41 1 48 110 217 278 Chenopodium album GAPDH mRNA, complete cds blastn 6300 104 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Chenopodium Chenopodium album
17702091 17702091 PRJNA556842_P_NODE_12134_length_205_cov_10.517857_g11629_i0 PRJNA556842 12134 205 10.517857 21.56160685 Magnoliopsida 3398 Plants Plants 379 7.229999999999999e-101   NTclustered gi|1878849229|gb|MT796565.1| 3505 g11629 i0 100 100 205 0 100 0 1 205 1648 1444 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 20500 379 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Betula Betula pendula
17702097 17702097 PRJNA556842_P_NODE_4534_length_437_cov_3.002500_g4038_i0 PRJNA556842 4534 437 3.0025 13.120925 Poales 38820 Plants Plants 518 3.46e-142   NTclustered gi|1878849165|gb|MT796512.1| 29686 g4038 i0 96.497 90.0228832951945 314 10 72 1 3 316 313 1 Melica uniflora isolate DM392 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 39340 520 0.996153846153846 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Melica Melica uniflora
18373542 18373542 PRJNA556842_P_NODE_12295_length_203_cov_1.638554_g11790_i0 PRJNA556842 12295 203 1.638554 3.32626462 Tortula truncata 52995 Plants Plants 357 3.35e-94   NTclustered gi|12381822|emb|AJ271112.1| 52995 g11790 i0 98.522 99.3300492610837 203 2 100 1 1 203 2809 3010 Pottia truncata partial 25S rRNA gene blastn 20164 357 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pottiales Pottiaceae Tortula Tortula truncata
18373558 18373558 PRJNA556842_P_NODE_6955_length_325_cov_1.184028_g6452_i0 PRJNA556842 6955 325 1.184028 3.848091 Arabidopsis thaliana 3702 Plants Plants 54.7 0.008   NTclustered gi|1862939915|emb|LR797790.1| 3702 g6452 i0 96.875 0.295384615384615 32 1 10 0 150 181 7489738 7489769 Arabidopsis thaliana genome assembly, chromosome: 4 blastn 96 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
20250680 20250680 PRJNA556842_P_NODE_10896_length_225_cov_3.606383_g10391_i0 PRJNA556842 10896 225 3.606383 8.11436175 Magnoliopsida 3398 Plants Plants 411 2.869999999999999e-110   NTclustered gi|1878849160|gb|MT796507.1| 38942 g10391 i0 99.556 100 225 1 100 0 1 225 4813 5037 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 22500 411 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
20250684 20250684 PRJNA556842_P_NODE_16816_length_158_cov_1.173554_g16311_i0 PRJNA556842 16816 158 1.173554 1.85421532 Poaceae 4479 Plants Plants 259 7.17e-65   NTclustered gi|1282796720|gb|MG560140.1| 4565 g16311 i0 96.774 277 155 5 100 0 4 158 2807326 2807172 Triticum aestivum gamma gliadin-A1, gamma gliadin-A3, gamma gliadin-A4, and LMW-A2 genes, complete cds blastn 43766 259 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
20250686 20250686 PRJNA556842_P_NODE_6176_length_353_cov_3.813291_g5674_i0 PRJNA556842 6176 353 3.813291 13.46091723 Magnoliopsida 3398 Plants Plants 616 9.439999999999999e-172   NTclustered gi|2571153582|gb|OR493979.1| 46367 g5674 i0 98.563 90.5949008498584 348 5 99 0 1 348 5786 5439 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 31980 616 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Bupleurum Bupleurum falcatum
22198690 22198690 PRJNA556842_P_NODE_17958_length_150_cov_1.044248_g17453_i0 PRJNA556842 17958 150 1.044248 1.566372 Parapholis strigosa 1155346 Plants Plants 261 1.86e-65   NTclustered gi|1878849170|gb|MT796517.1| 1155346 g17453 i0 98 98.32 150 3 100 0 1 150 1664 1813 Parapholis strigosa isolate DM449 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 14748 261 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Parapholis Parapholis strigosa
22801337 22801337 PRJNA556842_P_NODE_16778_length_158_cov_1.595041_g16273_i0 PRJNA556842 16778 158 1.595041 2.52016478 Pinaceae 3318 Plants Plants 292 7.07e-75   NTclustered gi|1897213732|gb|MT937128.1| 3357 g16273 i0 100 106 158 0 100 0 1 158 1938 1781 Pseudotsuga menziesii isolate DM607 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 16748 292 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pseudotsuga Pseudotsuga menziesii
24076122 24076122 PRJNA556842_P_NODE_7039_length_322_cov_3.821053_g6536_i0 PRJNA556842 7039 322 3.821053 12.30379066 Magnoliopsida 3398 Plants Plants 579 1.1199999999999997e-160   NTclustered gi|1727580516|gb|MN364386.1| 63062 g6536 i0 99.068 108.670807453416 322 3 100 0 1 322 874 553 Pteroceltis tatarinowii isolate Xie 003 small subunit ribosomal RNA gene, partial sequence blastn 34992 579 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Pteroceltis Pteroceltis tatarinowii

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