RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA299585 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1649923 1649923 PRJNA299585_S_NODE_2562_length_595_cov_5.856890_g2362_i0 PRJNA299585 2562 595 5.85689 34.8484955 Oryza sativa 4530 Plants Plants 791 0   NTclustered gi|32995791|dbj|AK110582.1| 39947 g2362 i0 91.096 92.8 584 52 98 0 4 587 402 985 Oryza sativa Japonica Group cDNA clone:002-168-E10, full insert sequence blastn 55216 791 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
1650042 1650042 PRJNA299585_S_NODE_782_length_1191_cov_5.536145_g697_i0 PRJNA299585 782 1191 5.536145 65.93548695 Triticum aestivum 4565 Plants Plants 1890 0   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g697 i0 98.153 4.40134340890008 1083 20 91 0 109 1191 1 1083 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 5242 1890 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
2925778 2925778 PRJNA299585_S_NODE_14823_length_158_cov_3.356589_g14593_i0 PRJNA299585 14823 158 3.356589 5.30341062 Triticum aestivum 4565 Plants Plants 270 3.3099999999999996e-68   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g14593 i0 97.468 1 158 4 100 0 1 158 4002 3845 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 158 270 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
6752708 6752708 PRJNA299585_S_NODE_10926_length_198_cov_2.852071_g10696_i0 PRJNA299585 10926 198 2.852071 5.64710058 Plantago ovata 185002 Plants Plants 62.1 2.85e-5   NTclustered gi|2473932891|ref|NC_072975.1| 185002 g10696 i0 100 0.333333333333333 33 0 17 0 133 165 265892 265860 Plantago ovata cultivar Vallabh Isabgol-1 mitochondrion, complete genome blastn 66 62.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Plantaginaceae Plantago Plantago ovata
6752864 6752864 PRJNA299585_S_NODE_486_length_1502_cov_6.928038_g434_i0 PRJNA299585 486 1502 6.928038 104.05913076 Triticum aestivum 4565 Plants Plants 2680 0   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g434 i0 98.869 94.6577896138482 1503 16 100 1 1 1502 3725 2223 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 142176 2680 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
8028354 8028354 PRJNA299585_S_NODE_10087_length_210_cov_3.701657_g9857_i0 PRJNA299585 10087 210 3.701657 7.7734797 Brassica oleracea 3712 Plants Plants 388 1.24e-103   NTclustered gi|1516606607|emb|LR031881.1| 3712 g9857 i0 100 76135.3095238095 210 0 100 0 1 210 3712 3921 Brassica oleracea HDEM genome, scaffold: Boleracea_scaffold_21 blastn 15988415 388 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica oleracea
8714373 8714373 PRJNA299585_S_NODE_13667_length_167_cov_3.891304_g13437_i0 PRJNA299585 13667 167 3.891304 6.49847768 Pinus 3337 Plants Plants 309 7.53e-80   NTclustered gi|1878849209|gb|MT796545.1| 3339 g13437 i0 100 103.479041916168 167 0 100 0 1 167 72 238 Pinus contorta isolate DM604 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 17281 309 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Pinus Pinus contorta
15677833 15677833 PRJNA299585_S_NODE_113_length_2652_cov_7.623332_g99_i0 PRJNA299585 113 2652 7.623332 202.17076464 Triticum aestivum 4565 Plants Plants 3694 0   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g99 i0 98.888 75.3363499245852 2069 23 78 0 584 2652 6461 4393 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 199792 3694 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
18226769 18226769 PRJNA299585_S_NODE_13035_length_173_cov_2.729167_g12805_i0 PRJNA299585 13035 173 2.729167 4.72145891 Triticum aestivum 4565 Plants Plants 320 3.61e-83   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g12805 i0 100 1 173 0 100 0 1 173 4419 4247 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 173 320 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
20776793 20776793 PRJNA299585_S_NODE_797_length_1174_cov_6.956332_g710_i0 PRJNA299585 797 1174 6.956332 81.66733768 Triticum aestivum 4565 Plants Plants 1965 0   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g710 i0 97.006 4.64650766609881 1169 35 99 0 3 1171 1061 2229 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 5455 1965 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
24601123 24601123 PRJNA299585_S_NODE_10000_length_211_cov_4.835165_g9770_i0 PRJNA299585 10000 211 4.835165 10.20219815 Triticum aestivum 4565 Plants Plants 374 3.4799999999999995e-99   NTclustered gi|1251765982|dbj|AK447493.1| 4565 g9770 i0 98.578 1 211 3 100 0 1 211 4064 4274 Triticum aestivum mRNA, clone: tplb0033a11, cultivar Chinese Spring blastn 211 374 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum

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