RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJDB14274" 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 · 13 ✖

bioproject 1

  • PRJDB14274 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
15310626 15310626 PRJDB14274_S_NODE_2573_length_382_cov_1.006231_g2495_i0 PRJDB14274 2573 382 1.006231 3.84380242 Eukaryota 2759 Plants Plants 208 1.48e-59   NR KAH0935445.1 3708 g2495 i0 71 53.544502617801 124 36 97.4 0 374 3 207 330 KAH0935445.1 hypothetical protein HID58_012562, partial [Brassica napus] diamond 20454 210 0.990476190476191 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
27285272 27285272 PRJDB14274_S_NODE_5123_length_275_cov_2.579439_g5045_i0 PRJDB14274 5123 275 2.579439 7.09345725 Sphagnum balticum 128184 Plants Plants 145 1.4499999999999998e-42   NR CAM6001409.1 128184 g5045 i0 83.1 0.905454545454545 83 14 90.5 0 26 274 15 97 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 249 145 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
27506604 27506604 PRJDB14274_S_NODE_8943_length_212_cov_1.284768_g8865_i0 PRJDB14274 8943 212 1.284768 2.72370816 Zostera marina 29655 Plants Plants 45.8 0.00201   NR KMZ59453.1 29655 g8865 i0 42.2 0.905660377358491 64 33 84.9 1 32 211 224 287 KMZ59453.1 hypothetical protein ZOSMA_68G00390 [Zostera marina] diamond 192 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Zosteraceae Zostera Zostera marina
27696185 27696185 PRJDB14274_S_NODE_8544_length_217_cov_1.384615_g8466_i0 PRJDB14274 8544 217 1.384615 3.00461455 Adiantum nelumboides 2759587 Plants Plants 71.2 3.5e-13   NR MCO5577576.1 2759587 g8466 i0 58.3 0.829493087557604 60 25 82.9 0 187 8 116 175 MCO5577576.1 hypothetical protein [Adiantum nelumboides] diamond 180 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum nelumboides
27980044 27980044 PRJDB14274_S_NODE_7645_length_229_cov_1.553571_g7567_i0 PRJDB14274 7645 229 1.553571 3.55767759 Escallonia herrerae 1293975 Plants Plants 45.1 0.0048   NR KAK3035755.1 1293975 g7567 i0 28.3 1.61135371179039 60 43 78.6 0 229 50 327 386 KAK3035755.1 hypothetical protein RJ639_033457 [Escallonia herrerae] diamond 369 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Escalloniales Escalloniaceae Escallonia Escallonia herrerae
28700449 28700449 PRJDB14274_S_NODE_8447_length_218_cov_1.713376_g8369_i0 PRJDB14274 8447 218 1.713376 3.73515968 root 1 Root_unresolved Root_unresolved 83.6 8.63e-19   NR CAM5999351.1 128184 g8369 i0 79 2.55963302752294 62 10 85.3 1 187 2 1 59 CAM5999351.1 unnamed protein product [Sphagnum balticum] diamond 558 84.3 0.991696322657177 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
29369299 29369299 PRJDB14274_S_NODE_7469_length_232_cov_1.140351_g7391_i0 PRJDB14274 7469 232 1.140351 2.64561432 Selaginella moellendorffii 88036 Plants Plants 74.3 1.03e-14   NR XP_002963396.1 88036 g7391 i0 64.9 2.90948275862069 57 18 71.1 1 230 66 91 147 XP_002963396.1 60S ribosomal protein L26-2 [Selaginella moellendorffii] diamond 675 74.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
30063914 30063914 PRJDB14274_S_NODE_5232_length_273_cov_1.495283_g5154_i0 PRJDB14274 5232 273 1.495283 4.08212259 Cajanus cajan 3821 Plants Plants 49.3 2.72e-4   NR XP_020212151.1 3821 g5154 i0 45.2 1.97802197802198 62 26 67 3 192 10 699 753 XP_020212151.1 DEAD-box ATP-dependent RNA helicase 3, chloroplastic [Cajanus cajan] diamond 540 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Cajanus Cajanus cajan
30285583 30285583 PRJDB14274_S_NODE_6272_length_251_cov_1.736842_g6194_i0 PRJDB14274 6272 251 1.736842 4.35947342 Dioscorea alata 55571 Plants Plants 44.7 0.00822   NR KAH7655122.1 55571 g6194 i0 46.9 0.585657370517928 49 25 57.4 1 11 154 4 52 KAH7655122.1 pyruvate dehydrogenase phosphatase protein [Dioscorea alata] diamond 147 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Dioscoreales Dioscoreaceae Dioscorea Dioscorea alata
31201044 31201044 PRJDB14274_S_NODE_9195_length_210_cov_0.872483_g9117_i0 PRJDB14274 9195 210 0.872483 1.8322143 Glycine max 3847 Plants Plants 44.3 0.00695   NR KAG4977323.1 3847 g9117 i0 41.3 1.31428571428571 46 27 65.7 0 163 26 481 526 KAG4977323.1 hypothetical protein JHK86_036797 [Glycine max] diamond 276 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
31258816 31258816 PRJDB14274_S_NODE_10295_length_202_cov_0.886525_g10217_i0 PRJDB14274 10295 202 0.886525 1.7907805 Magnoliopsida 3398 Plants Plants 99 1.5399999999999999e-24   NR KDO54608.1 2711 g10217 i0 68.8 64.6485148514851 64 20 95 0 5 196 34 97 KDO54608.1 hypothetical protein CISIN_1g032124mg [Citrus sinensis] diamond 13059 100 0.99 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
31865459 31865459 PRJDB14274_S_NODE_697_length_708_cov_2.267388_g632_i0 PRJDB14274 697 708 2.267388 16.05310704 Ziziphus jujuba var. spinosa 714518 Plants Plants 45.1 0.0368   NR KAH7521916.1 714518 g632 i0 28.4 0.402542372881356 95 65 39.4 2 630 352 22 115 KAH7521916.1 hypothetical protein FEM48_Zijuj07G0082700 [Ziziphus jujuba var. spinosa] diamond 285 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
31992202 31992202 PRJDB14274_S_NODE_2718_length_372_cov_1.041801_g2640_i0 PRJDB14274 2718 372 1.041801 3.87549972 Eutrema salsugineum 72664 Plants Plants 45.8 0.00916   NR ESQ29963.1 72664 g2640 i0 34.8 0.92741935483871 115 70 92.7 2 364 20 60 169 ESQ29963.1 hypothetical protein EUTSA_v10011750mg [Eutrema salsugineum] diamond 345 45.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Eutrema Eutrema salsugineum

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