RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1034994" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 21 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1034994 · 21 ✖

analysis 1

  • diamond · 21 ✖
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
5271094 5271094 PRJNA1034994_P_NODE_3585_length_286_cov_1.262911_g3501_i0 PRJNA1034994 3585 286 1.262911 3.61192546 Rhynchospora tenuis 198213 Plants Plants 122 6.3000000000000005e-30   NR KAJ3689265.1 198213 g3501 i0 57.4 3.92307692307692 94 40 98.6 0 284 3 994 1087 KAJ3689265.1 hypothetical protein LUZ61_018429 [Rhynchospora tenuis] diamond 1122 122 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Cyperaceae Rhynchospora Rhynchospora tenuis
9095788 9095788 PRJNA1034994_P_NODE_4888_length_270_cov_1.456853_g4804_i0 PRJNA1034994 4888 270 1.456853 3.9335031 Adiantum nelumboides 2759587 Plants Plants 165 8.29e-49   NR MCO5597125.1 2759587 g4804 i0 82.2 10.9777777777778 90 16 100 0 1 270 58 147 MCO5597125.1 hypothetical protein [Adiantum nelumboides] diamond 2964 165 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum nelumboides
12921963 12921963 PRJNA1034994_P_NODE_5171_length_267_cov_1.252577_g5087_i0 PRJNA1034994 5171 267 1.252577 3.34438059 Panicum miliaceum 4540 Plants Plants 111 9.78e-28   NR RLN08232.1 4540 g5087 i0 72.2 0.887640449438202 79 22 88.8 0 28 264 2 80 RLN08232.1 hypothetical protein C2845_PM11G00090 [Panicum miliaceum] diamond 237 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum miliaceum
21845135 21845135 PRJNA1034994_P_NODE_4738_length_272_cov_1.175879_g4654_i0 PRJNA1034994 4738 272 1.175879 3.19839088 Ceratopteris richardii 49495 Plants Plants 135 4.079999999999999e-37   NR KAH7437899.1 49495 g4654 i0 89 0.805147058823529 73 8 80.5 0 4 222 180 252 KAH7437899.1 hypothetical protein KP509_05G094300 [Ceratopteris richardii] diamond 219 135 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
26655003 26655003 PRJNA1034994_P_NODE_6821_length_251_cov_0.865169_g6737_i0 PRJNA1034994 6821 251 0.865169 2.17157419 Ceratopteris richardii 49495 Plants Plants 60.1 3.14e-8   NR KAH7292053.1 49495 g6737 i0 55 0.717131474103586 60 24 69.3 2 175 2 15 73 KAH7292053.1 hypothetical protein KP509_29G049500 [Ceratopteris richardii] diamond 180 60.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
27256348 27256348 PRJNA1034994_P_NODE_3483_length_287_cov_1.364486_g3399_i0 PRJNA1034994 3483 287 1.364486 3.91607482 Ceratopteris richardii 49495 Plants Plants 140 1.82e-36   NR KAH7300934.1 49495 g3399 i0 69.5 0.993031358885017 95 29 99.3 0 2 286 161 255 KAH7300934.1 hypothetical protein KP509_23G004200 [Ceratopteris richardii] diamond 285 140 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
27919521 27919521 PRJNA1034994_P_NODE_3165_length_291_cov_2.055046_g3081_i0 PRJNA1034994 3165 291 2.055046 5.98018386 Ceratopteris richardii 49495 Plants Plants 93.6 1.62e-20   NR KAH7428482.1 49495 g3081 i0 50.5 1.02061855670103 99 36 88.7 2 263 6 132 230 KAH7428482.1 hypothetical protein KP509_09G003800 [Ceratopteris richardii] diamond 297 93.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
28448576 28448576 PRJNA1034994_P_NODE_3226_length_290_cov_1.419355_g3142_i0 PRJNA1034994 3226 290 1.419355 4.1161295 Pteridaceae 13819 Plants Plants 44.7 0.0139   NR KAI5063253.1 13818 g3142 i0 81.8 0.796551724137931 22 4 22.8 0 223 288 407 428 KAI5063253.1 hypothetical protein GOP47_0021800 [Adiantum capillus-veneris] diamond 231 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum capillus-veneris
29877332 29877332 PRJNA1034994_P_NODE_7691_length_248_cov_0.880000_g7607_i0 PRJNA1034994 7691 248 0.88 2.1824 Ceratopteris richardii 49495 Plants Plants 85.9 2.48e-17   NR KAH7298234.1 49495 g7607 i0 69.1 1.99596774193548 55 17 66.5 0 166 2 289 343 KAH7298234.1 hypothetical protein KP509_25G033000 [Ceratopteris richardii] diamond 495 85.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
29908942 29908942 PRJNA1034994_P_NODE_7211_length_249_cov_1.704545_g7127_i0 PRJNA1034994 7211 249 1.704545 4.24431705 Digitaria exilis 1010633 Plants Plants 43.9 0.014   NR KAF8758118.1 1010633 g7127 i0 44.2 1.01204819277108 43 19 49.4 2 121 243 87 126 KAF8758118.1 hypothetical protein HU200_010716 [Digitaria exilis] diamond 252 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Digitaria Digitaria exilis
30288295 30288295 PRJNA1034994_P_NODE_2052_length_356_cov_2.713781_g1968_i0 PRJNA1034994 2052 356 2.713781 9.66106036 Morus notabilis 981085 Plants Plants 164 1.04e-49   NR EXC00007.1 981085 g1968 i0 93.9 0.691011235955056 82 5 69.1 0 246 1 1 82 EXC00007.1 hypothetical protein L484_005820 [Morus notabilis] diamond 246 164 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Morus Morus notabilis
30477617 30477617 PRJNA1034994_P_NODE_7733_length_248_cov_0.880000_g7649_i0 PRJNA1034994 7733 248 0.88 2.1824 Ceratopteris richardii 49495 Plants Plants 65.9 2.8e-10   NR KAH7365037.1 49495 g7649 i0 49.3 0.810483870967742 67 34 81 0 7 207 227 293 KAH7365037.1 hypothetical protein KP509_18G005900 [Ceratopteris richardii] diamond 201 65.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
30603763 30603763 PRJNA1034994_P_NODE_8733_length_245_cov_0.895349_g8649_i0 PRJNA1034994 8733 245 0.895349 2.19360505 Adiantum nelumboides 2759587 Plants Plants 57.8 1.9e-7   NR MCO5575423.1 2759587 g8649 i0 54.3 3.83265306122449 46 21 56.3 0 179 42 239 284 MCO5575423.1 hypothetical protein [Adiantum nelumboides] diamond 939 57.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Adiantum Adiantum nelumboides
30793350 30793350 PRJNA1034994_P_NODE_3974_length_281_cov_1.365385_g3890_i0 PRJNA1034994 3974 281 1.365385 3.83673185 Ceratopteris richardii 49495 Plants Plants 100 7.1e-23   NR KAH7437270.1 49495 g3890 i0 90.7 1.15302491103203 54 4 57.7 1 162 1 70 122 KAH7437270.1 hypothetical protein KP509_05G063200 [Ceratopteris richardii] diamond 324 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
30983182 30983182 PRJNA1034994_P_NODE_5394_length_264_cov_1.612565_g5310_i0 PRJNA1034994 5394 264 1.612565 4.2571716 Ceratopteris richardii 49495 Plants Plants 127 4.53e-33   NR KAH7387954.1 49495 g5310 i0 85.3 6.85227272727273 75 9 85.2 1 264 40 58 130 KAH7387954.1 hypothetical protein KP509_16G050300 [Ceratopteris richardii] diamond 1809 127 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
31140577 31140577 PRJNA1034994_P_NODE_3755_length_284_cov_1.246445_g3671_i0 PRJNA1034994 3755 284 1.246445 3.5399038 Ceratopteris richardii 49495 Plants Plants 53.5 1.96e-6   NR KAH7278129.1 49495 g3671 i0 51.6 0.654929577464789 62 29 65.5 1 14 199 76 136 KAH7278129.1 hypothetical protein KP509_38G025600 [Ceratopteris richardii] diamond 186 53.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
31994992 31994992 PRJNA1034994_P_NODE_4198_length_278_cov_1.502439_g4114_i0 PRJNA1034994 4198 278 1.502439 4.17678042 Ceratopteris richardii 49495 Plants Plants 170 1.0099999999999999e-47   NR KAH7433199.1 49495 g4114 i0 90.2 1.98561151079137 92 9 99.3 0 278 3 60 151 KAH7433199.1 hypothetical protein KP509_07G059000 [Ceratopteris richardii] diamond 552 170 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
32184914 32184914 PRJNA1034994_P_NODE_4058_length_280_cov_1.367150_g3974_i0 PRJNA1034994 4058 280 1.36715 3.82802 Citrus sinensis 2711 Plants Plants 137 4.51e-35   NR KAH9650032.1 2711 g3974 i0 81.7 0.996428571428571 93 17 99.6 0 280 2 66 158 KAH9650032.1 hypothetical protein KPL70_026211 [Citrus sinensis] diamond 279 137 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
32658649 32658649 PRJNA1034994_P_NODE_2260_length_341_cov_2.055970_g2176_i0 PRJNA1034994 2260 341 2.05597 7.0108577 Quillaja saponaria 32244 Plants Plants 42.4 0.0316   NR KAJ7940951.1 32244 g2176 i0 42.9 0.73900293255132 84 43 73.9 2 254 3 7 85 KAJ7940951.1 hypothetical protein O6P43_035999 [Quillaja saponaria] diamond 252 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Quillajaceae Quillaja Quillaja saponaria
32816356 32816356 PRJNA1034994_P_NODE_3320_length_289_cov_1.347222_g3236_i0 PRJNA1034994 3320 289 1.347222 3.89347158 Ceratopteris richardii 49495 Plants Plants 58.9 2.38e-9   NR KAH7435865.1 49495 g3236 i0 48.3 0.622837370242215 60 16 62.3 2 263 84 5 49 KAH7435865.1 hypothetical protein KP509_06G082200 [Ceratopteris richardii] diamond 180 58.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii
32816359 32816359 PRJNA1034994_P_NODE_6720_length_251_cov_0.865169_g6636_i0 PRJNA1034994 6720 251 0.865169 2.17157419 Ceratopteris richardii 49495 Plants Plants 58.5 2.99e-8   NR KAH7315073.1 49495 g6636 i0 57.8 0.872509960159363 45 19 53.8 0 7 141 125 169 KAH7315073.1 hypothetical protein KP509_21G032600 [Ceratopteris richardii] diamond 219 58.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Polypodiopsida Polypodiales Pteridaceae Ceratopteris Ceratopteris richardii

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