RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA397736" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 12 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA397736 · 12 ✖

analysis 1

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
1079939 1079939 PRJNA397736_S_NODE_1761_length_207_cov_8.601124_g1725_i0 PRJNA397736 1761 207 8.601124 17.80432668 Magnoliopsida 3398 Plants Plants 372 1.2199999999999997e-98   NTclustered gi|532227|gb|L28143.1|RIBRGEA 23283 g1725 i0 99.034 248.009661835749 207 2 100 0 1 207 1431 1637 Ribes aureum Pursh. 18S ribosomal RNA (18S rRNA) gene blastn 51338 372 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Saxifragales Grossulariaceae Ribes Ribes aureum
1686965 1686965 PRJNA397736_S_NODE_2202_length_182_cov_4.843137_g2166_i0 PRJNA397736 2202 182 4.843137 8.81450934 Prunus dulcis 3755 Plants Plants 248 1.84e-61   NTclustered gi|2699132188|emb|OZ022203.1| 3755 g2166 i0 91.62 5465.53296703297 179 15 100 0 1 179 5631608 5631786 Prunus dulcis genome assembly, chromosome: 7 blastn 994727 248 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus dulcis
1686966 1686966 PRJNA397736_S_NODE_2742_length_160_cov_4.000000_g2706_i0 PRJNA397736 2742 160 4 6.4 Cucumis sativus 3659 Plants Plants 279 5.59e-71   NTclustered gi|18288|emb|X69163.1| 3659 g2706 i0 98.137 6.025 161 2 100 1 1 160 274 114 C.sativus satellite DNA, type IV blastn 964 279 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis sativus
2962892 2962892 PRJNA397736_S_NODE_2843_length_157_cov_4.320312_g2807_i0 PRJNA397736 2843 157 4.320312 6.78288984 Malus domestica 3750 Plants Plants 52.8 0.013   NTclustered gi|2810943377|gb|CP168775.1| 3750 g2807 i0 100 0.178343949044586 28 0 18 0 127 154 18493915 18493888 Malus domestica cultivar Golden Delicious chromosome 11 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Malus Malus domestica
3630696 3630696 PRJNA397736_S_NODE_1723_length_210_cov_3.607735_g1687_i0 PRJNA397736 1723 210 3.607735 7.5762435 Fagales 3502 Plants Plants 388 1.24e-103   NTclustered gi|19919688|gb|AF479247.1| 3510 g1687 i0 100 100 210 0 100 0 1 210 1545 1754 Morella cerifera 26S ribosomal RNA gene, complete sequence blastn 21000 388 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Myricaceae Morella Morella cerifera
3630701 3630701 PRJNA397736_S_NODE_803_length_320_cov_10.986254_g767_i0 PRJNA397736 803 320 10.986254 35.1560128 Eukaryota 2759 Plants Plants 520 6.849999999999999e-143   NTclustered gi|2537639500|ref|XR_009146662.1| 3981 g767 i0 97.386 95.6375 306 7 96 1 1 306 713 1017 PREDICTED: Hevea brasiliensis 18S ribosomal RNA (LOC131176755), rRNA blastn 30604 525 0.990476190476191 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Hevea Hevea brasiliensis
4907910 4907910 PRJNA397736_S_NODE_2004_length_191_cov_11.450617_g1968_i0 PRJNA397736 2004 191 11.450617 21.87067847 Magnoliopsida 3398 Plants Plants 353 4.02e-93   NTclustered gi|30527332|gb|AY095469.1| 3422 g1968 i0 100 100 191 0 100 0 1 191 2621 2811 Tasmannia insipida 26S ribosomal RNA gene, partial sequence blastn 19100 353 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Canellales Winteraceae Tasmannia Tasmannia insipida
5515843 5515843 PRJNA397736_S_NODE_1705_length_211_cov_16.093407_g1669_i0 PRJNA397736 1705 211 16.093407 33.95708877 Cucumis sativus 3659 Plants Plants 368 1.6200000000000002e-97   NTclustered gi|212961018|gb|FJ410935.1| 3659 g1669 i0 98.104 9.58293838862559 211 4 100 0 1 211 293 83 Cucumis sativus satellite Csst1 sequence blastn 2022 368 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis sativus
6182981 6182981 PRJNA397736_S_NODE_1525_length_224_cov_8.056410_g1489_i0 PRJNA397736 1525 224 8.05641 18.0463584 Eukaryota 2759 Plants Plants 375 1.04e-99   NTclustered gi|391415363|gb|BT065681.2| 4577 g1489 i0 96.875 100.004464285714 224 7 100 0 1 224 666 889 Zea mays full-length cDNA clone ZM_BFc0017K02 mRNA, complete cds blastn 22401 375 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
7457836 7457836 PRJNA397736_S_NODE_2566_length_165_cov_7.073529_g2530_i0 PRJNA397736 2566 165 7.073529 11.67132285 Lamiaceae 4136 Plants Plants 294 2.08e-75   NTclustered gi|916445753|gb|KT179769.1| 39347 g2530 i0 99.383 98.4848484848485 162 1 98 0 1 162 2399 2560 Nepeta cataria voucher Aust 177 26S ribosomal RNA gene, partial sequence blastn 16250 294 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Nepeta Nepeta cataria
9340280 9340280 PRJNA397736_S_NODE_2808_length_158_cov_3.689922_g2772_i0 PRJNA397736 2808 158 3.689922 5.83007676 Cucumis metuliferus 61886 Plants Plants 230 5.619999999999999e-56   NTclustered gi|589308302|gb|KF947535.1| 61886 g2772 i0 97.059 5.73417721518987 136 4 86 0 3 138 16 151 Cucumis metuliferus clone CmetSatT2 microsatellite sequence blastn 906 230 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Cucurbitales Cucurbitaceae Cucumis Cucumis metuliferus
16382339 16382339 PRJNA397736_S_NODE_1113_length_270_cov_2.800830_g1077_i0 PRJNA397736 1113 270 2.80083 7.562241 Picea 3328 Plants Plants 462 9.65e-126   NTclustered gi|20467288|gb|AY056510.1| 100117 g1077 i0 97.407 95.062962962963 270 7 100 0 1 270 523 254 Picea breweriana 26S ribosomal RNA gene, partial sequence blastn 25667 466 0.991416309012876 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea breweriana

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