RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA188516" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 17 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA188516 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
365756 365756 PRJNA188516_P_NODE_1821_length_260_cov_0.966825_g1771_i0 PRJNA188516 1821 260 0.966825 2.513745 Eukaryota 2759 Plants Plants 142 2.17e-41   NR CAM6005785.1 128184 g1771 i0 76.7 2.96538461538462 86 20 99.2 0 1 258 49 134 CAM6005785.1 unnamed protein product [Sphagnum balticum] diamond 771 142 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
1055229 1055229 PRJNA188516_P_NODE_761_length_446_cov_9.302267_g711_i0 PRJNA188516 761 446 9.302267 41.48811082 Juncus effusus 13579 Plants Plants 153 9e-43   NR KAJ3679406.1 13579 g711 i0 65.9 3.40358744394619 126 43 84.8 0 442 65 119 244 KAJ3679406.1 hypothetical protein LUZ60_017417 [Juncus effusus] diamond 1518 153 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
24592032 24592032 PRJNA188516_P_NODE_1740_length_268_cov_1.159817_g1690_i0 PRJNA188516 1740 268 1.159817 3.10830956 Eukaryota 2759 Plants Plants 131 5.16e-36   NR CAC27136.1 3329 g1690 i0 70.5 330.033582089552 88 26 98.5 0 5 268 45 132 CAC27136.1 40S ribosomal protein S2 [Picea abies] diamond 88449 132 0.992424242424242 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
27136715 27136715 PRJNA188516_P_NODE_2462_length_219_cov_1.011765_g2412_i0 PRJNA188516 2462 219 1.011765 2.21576535 Salvia splendens 180675 Plants Plants 63.2 1.65e-9   NR KAG6408789.1 180675 g2412 i0 57.4 1.73972602739726 61 25 82.2 1 217 38 38 98 KAG6408789.1 hypothetical protein SASPL_131812 [Salvia splendens] diamond 381 63.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Salvia Salvia splendens
27344813 27344813 PRJNA188516_P_NODE_6083_length_162_cov_0.920354_g6033_i0 PRJNA188516 6083 162 0.920354 1.49097348 Eukaryota 2759 Plants Plants 75.9 2.32e-14   NR XP_020100862.1 4615 g6033 i0 63.5 4.85185185185185 52 19 96.3 0 4 159 298 349 XP_020100862.1 DDB1- and CUL4-associated factor 13 isoform X2 [Ananas comosus] diamond 786 75.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
27881378 27881378 PRJNA188516_P_NODE_4945_length_166_cov_0.888889_g4895_i0 PRJNA188516 4945 166 0.888889 1.47555574 Streptophyta 35493 Plants Plants 86.3 1.57e-18   NR KAG0562162.1 3225 g4895 i0 74.1 9.84939759036145 54 14 97.6 0 165 4 126 179 KAG0562162.1 hypothetical protein KC19_9G122700 [Ceratodon purpureus] diamond 1635 87 0.991954022988506 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
29852882 29852882 PRJNA188516_P_NODE_5771_length_163_cov_0.912281_g5721_i0 PRJNA188516 5771 163 0.912281 1.48701803 Nymphaea colorata 210225 Plants Plants 72 4.79e-14   NR VVW87744.1 210225 g5721 i0 65.4 3.86503067484663 52 18 95.7 0 5 160 30 81 VVW87744.1 unnamed protein product, partial [Nymphaea colorata] diamond 630 72 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Nymphaeales Nymphaeaceae Nymphaea Nymphaea colorata
29979152 29979152 PRJNA188516_P_NODE_2611_length_212_cov_1.269939_g2561_i0 PRJNA188516 2611 212 1.269939 2.69227068 Sphagnum balticum 128184 Plants Plants 64.3 4.67e-10   NR CAM5999666.1 128184 g2561 i0 45.7 1.99528301886792 70 38 99.1 0 3 212 185 254 CAM5999666.1 unnamed protein product [Sphagnum balticum] diamond 423 64.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
30010905 30010905 PRJNA188516_P_NODE_3191_length_191_cov_0.985915_g3141_i0 PRJNA188516 3191 191 0.985915 1.88309765 Camellia sinensis var. sinensis 542762 Plants Plants 43.1 0.00733   NR GMP76123.1 542762 g3141 i0 36.9 3.06282722513089 65 31 88 2 1 168 58 121 GMP76123.1 hypothetical protein CsSME_00032934 [Camellia sinensis var. sinensis] diamond 585 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
30010906 30010906 PRJNA188516_P_NODE_3451_length_183_cov_1.156716_g3401_i0 PRJNA188516 3451 183 1.156716 2.11679028 Daucus carota subsp. sativus 79200 Plants Plants 80.9 4.97e-16   NR XP_017247816.1 79200 g3401 i0 71.2 6.78688524590164 59 16 96.7 1 183 7 285 342 XP_017247816.1 large ribosomal subunit protein uL4 [Daucus carota subsp. sativus] diamond 1242 80.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
30105433 30105433 PRJNA188516_P_NODE_4872_length_166_cov_0.888889_g4822_i0 PRJNA188516 4872 166 0.888889 1.47555574 Zostera marina 29655 Plants Plants 77.4 7.6e-15   NR KMZ65940.1 29655 g4822 i0 64.8 11.710843373494 54 19 97.6 0 164 3 282 335 KMZ65940.1 Pre-mRNA-splicing factor CLF1 [Zostera marina] diamond 1944 77.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Zosteraceae Zostera Zostera marina
30231909 30231909 PRJNA188516_P_NODE_3492_length_181_cov_1.969697_g3442_i0 PRJNA188516 3492 181 1.969697 3.56515157 Taxus chinensis 29808 Plants Plants 71.2 2.04e-13   NR KAH9328155.1 29808 g3442 i0 60.4 0.878453038674033 53 21 87.8 0 23 181 1 53 KAH9328155.1 hypothetical protein KI387_000263 [Taxus chinensis] diamond 159 71.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
30263826 30263826 PRJNA188516_P_NODE_4072_length_169_cov_0.866667_g4022_i0 PRJNA188516 4072 169 0.866667 1.46466723 Ceratopteris richardii 49495 Plants Plants 70.9 1.67e-12   NR KAH7297056.1 49495 g4022 i0 52.7 5.85798816568047 55 26 97.6 0 1 165 867 921 KAH7297056.1 hypothetical protein KP509_26G051100 [Ceratopteris richardii] diamond 990 70.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
31274600 31274600 PRJNA188516_P_NODE_2055_length_241_cov_1.614583_g2005_i0 PRJNA188516 2055 241 1.614583 3.89114503 Physcomitrium patens 3218 Plants Plants 62.4 5.68e-10   NR NP_001365811.1 3218 g2005 i0 40.8 4.79253112033195 76 43 94.6 1 229 2 9 82 NP_001365811.1 40S ribosomal protein S15-like [Physcomitrium patens] diamond 1155 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
31608743 31608743 PRJNA188516_P_NODE_3656_length_177_cov_1.218750_g3606_i0 PRJNA188516 3656 177 1.21875 2.1571875 Eukaryota 2759 Plants Plants 83.6 1.63e-18   NR KAJ3669820.1 13579 g3606 i0 73.7 18.6949152542373 57 14 94.9 1 10 177 9 65 KAJ3669820.1 hypothetical protein LUZ60_010144 [Juncus effusus] diamond 3309 83.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Juncaceae Juncus Juncus effusus
32318896 32318896 PRJNA188516_P_NODE_5459_length_164_cov_0.904348_g5409_i0 PRJNA188516 5459 164 0.904348 1.48313072 Arabidopsis thaliana 3702 Plants Plants 56.6 1.6e-7   NR CAD5333473.1 3702 g5409 i0 48.9 12.4756097560976 47 24 86 0 5 145 225 271 CAD5333473.1 unnamed protein product [Arabidopsis thaliana] diamond 2046 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
32508682 32508682 PRJNA188516_P_NODE_4819_length_166_cov_0.888889_g4769_i0 PRJNA188516 4819 166 0.888889 1.47555574 Forsythia ovata 205694 Plants Plants 69.3 1.86e-13   NR KAL2500444.1 205694 g4769 i0 65.1 2.29518072289157 43 15 77.7 0 134 6 33 75 KAL2500444.1 ras-related protein RABA1f-like [Forsythia ovata] diamond 381 69.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Forsythia Forsythia ovata

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