RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA610520" 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

  • PRJNA610520 · 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
5692026 5692026 PRJNA610520_S_NODE_36845_length_303_cov_3.008696_g36755_i0 PRJNA610520 36845 303 3.008696 9.11634888 Streptophyta 35493 Plants Plants 108 1.49e-26   NR PON44735.1 3476 g36755 i0 67.5 13.8118811881188 83 26 82.2 1 303 55 192 273 PON44735.1 Triosephosphate isomerase [Parasponia andersonii] diamond 4185 109 0.990825688073395 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Parasponia Parasponia andersonii
8800303 8800303 PRJNA610520_S_NODE_12987_length_396_cov_17.792570_g12897_i0 PRJNA610520 12987 396 17.79257 70.4585772 Eukaryota 2759 Plants Plants 106 5.17e-26   NR AFK43985.1 34305 g12897 i0 53.8 2.08333333333333 91 42 68.9 0 394 122 83 173 AFK43985.1 unknown [Lotus japonicus] diamond 825 107 0.990654205607477 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
17166123 17166123 PRJNA610520_S_NODE_10414_length_415_cov_17.681287_g10324_i0 PRJNA610520 10414 415 17.681287 73.37734105 Magnoliopsida 3398 Plants Plants 173 2.38e-50   NR KAJ0212394.1 4236 g10324 i0 69.4 23.0096385542169 111 34 80.2 0 1 333 228 338 KAJ0212394.1 hypothetical protein LSAT_V11C400222320 [Lactuca sativa] diamond 9549 173 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
27396386 27396386 PRJNA610520_S_NODE_64823_length_246_cov_1.780347_g64733_i0 PRJNA610520 64823 246 1.780347 4.37965362 Panicum miliaceum 4540 Plants Plants 48.1 1.03e-4   NR RLM84721.1 4540 g64733 i0 58.7 0.560975609756098 46 18 54.9 1 209 75 40 85 RLM84721.1 uncharacterized protein C2845_PM04G19390 [Panicum miliaceum] diamond 138 48.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum miliaceum
27428018 27428018 PRJNA610520_S_NODE_49703_length_273_cov_1.385000_g49613_i0 PRJNA610520 49703 273 1.385 3.78105 Parasponia andersonii 3476 Plants Plants 72 4.38e-14   NR PON44404.1 3476 g49613 i0 86.5 0.813186813186813 37 5 40.7 0 272 162 59 95 PON44404.1 hypothetical protein PanWU01x14_267120 [Parasponia andersonii] diamond 222 72 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Parasponia Parasponia andersonii
27756908 27756908 PRJNA610520_S_NODE_56224_length_260_cov_1.235294_g56134_i0 PRJNA610520 56224 260 1.235294 3.2117644 Eukaryota 2759 Plants Plants 103 1.32e-26   NR KAG0606970.1 3225 g56134 i0 81 10.8461538461538 58 11 66.9 0 260 87 28 85 KAG0606970.1 hypothetical protein M758_9G183100 [Ceratodon purpureus] diamond 2820 103 1 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Pseudoditrichales Ditrichaceae Ceratodon Ceratodon purpureus
28154213 28154213 PRJNA610520_S_NODE_59225_length_254_cov_1.701657_g59135_i0 PRJNA610520 59225 254 1.701657 4.32220878 Humulus lupulus 3486 Plants Plants 49.7 1.23e-4   NR XP_062103837.1 3486 g59135 i0 80.6 0.366141732283465 31 6 36.6 0 3 95 220 250 XP_062103837.1 cytochrome b561 and DOMON domain-containing protein At3g25290-like [Humulus lupulus] diamond 93 49.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus lupulus
28280075 28280075 PRJNA610520_S_NODE_14766_length_386_cov_1.565495_g14676_i0 PRJNA610520 14766 386 1.565495 6.0428107 Humulus scandens 228586 Plants Plants 83.2 2.17e-17   NR AVY54510.1 228586 g14676 i0 57.1 0.435233160621762 56 23 43.5 1 1 168 88 142 AVY54510.1 Hum s 3 allergen [Humulus scandens] diamond 168 83.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus scandens
28880085 28880085 PRJNA610520_S_NODE_29988_length_323_cov_2.212000_g29898_i0 PRJNA610520 29988 323 2.212 7.14476 Cephalotus follicularis 3775 Plants Plants 99 6.88e-22   NR GAV77068.1 3775 g29898 i0 68.2 1.20743034055728 66 21 61.3 0 1 198 325 390 GAV77068.1 Cation_efflux domain-containing protein [Cephalotus follicularis] diamond 390 99 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Oxalidales Cephalotaceae Cephalotus Cephalotus follicularis
29448267 29448267 PRJNA610520_S_NODE_39950_length_295_cov_2.135135_g39860_i0 PRJNA610520 39950 295 2.135135 6.29864825 Humulus scandens 228586 Plants Plants 47.8 1.01e-4   NR AVY54507.1 228586 g39860 i0 43.1 0.51864406779661 51 29 51.9 0 8 160 23 73 AVY54507.1 Hum s 3 allergen [Humulus scandens] diamond 153 47.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Humulus Humulus scandens
29479784 29479784 PRJNA610520_S_NODE_14550_length_387_cov_2.452229_g14460_i0 PRJNA610520 14550 387 2.452229 9.49012623 Castilleja foliolosa 1961234 Plants Plants 49.3 1.08e-4   NR KAL3654363.1 1961234 g14460 i0 63.6 0.255813953488372 33 12 25.6 0 333 235 66 98 KAL3654363.1 hypothetical protein CASFOL_004044 [Castilleja foliolosa] diamond 99 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Castilleja Castilleja foliolosa
29966948 29966948 PRJNA610520_S_NODE_16191_length_378_cov_1.731148_g16101_i0 PRJNA610520 16191 378 1.731148 6.54373944 Cannabaceae 3481 Plants Plants 87.4 6.71e-19   NR PON63770.1 3476 g16101 i0 48.2 1.34920634920635 85 43 67.5 1 378 124 74 157 PON63770.1 Self-incompatibility protein [Parasponia andersonii] diamond 510 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Parasponia Parasponia andersonii
30693552 30693552 PRJNA610520_S_NODE_55633_length_261_cov_1.446809_g55543_i0 PRJNA610520 55633 261 1.446809 3.77617149 Magnoliopsida 3398 Plants Plants 54.3 3.08e-7   NR KAK6120339.1 99300 g55543 i0 59 1.41379310344828 39 16 44.8 0 256 140 50 88 KAK6120339.1 hypothetical protein DH2020_046030 [Rehmannia glutinosa] diamond 369 54.7 0.992687385740402 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Orobanchaceae Rehmannia Rehmannia glutinosa
30743661 30743661 PRJNA610520_S_NODE_16094_length_378_cov_4.724590_g16004_i0 PRJNA610520 16094 378 4.72459 17.8589502 Cannabis sativa 3483 Plants Plants 60.8 2.06e-9   NR KAF4379259.1 3483 g16004 i0 56.6 0.420634920634921 53 17 41.3 3 369 214 30 77 KAF4379259.1 hypothetical protein G4B88_010653 [Cannabis sativa] diamond 159 60.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
31009505 31009505 PRJNA610520_S_NODE_44094_length_285_cov_2.174528_g44004_i0 PRJNA610520 44094 285 2.174528 6.1974048 Eukaryota 2759 Plants Plants 67.4 7.61e-11   NR BAJ98081.1 112509 g44004 i0 58.5 2.26315789473684 53 22 55.8 0 283 125 233 285 BAJ98081.1 predicted protein [Hordeum vulgare subsp. vulgare] diamond 645 67.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
31091215 31091215 PRJNA610520_S_NODE_15175_length_383_cov_5.090323_g15085_i0 PRJNA610520 15175 383 5.090323 19.49593709 Cannabis sativa 3483 Plants Plants 54.7 1.04e-5   NR KAF4355341.1 3483 g15085 i0 40.9 0.556135770234987 44 26 34.5 0 377 246 169 212 KAF4355341.1 hypothetical protein F8388_026611 [Cannabis sativa] diamond 213 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
31357350 31357350 PRJNA610520_S_NODE_15096_length_384_cov_1.733119_g15006_i0 PRJNA610520 15096 384 1.733119 6.65517696 Magnoliopsida 3398 Plants Plants 56.2 1.18e-7   NR CAL8999823.1 151428 g15006 i0 61.5 0.890625 39 15 30.5 0 6 122 29 67 CAL8999823.1 unnamed protein product [Prunus brigantina] diamond 342 56.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
31565744 31565744 PRJNA610520_S_NODE_14376_length_388_cov_2.092063_g14286_i0 PRJNA610520 14376 388 2.092063 8.11720444 Cannabis sativa 3483 Plants Plants 105 1.75e-23   NR XP_030497248.2 3483 g14286 i0 78 0.958762886597938 59 13 45.6 0 2 178 501 559 XP_030497248.2 pectinesterase [Cannabis sativa] diamond 372 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
31610337 31610337 PRJNA610520_S_NODE_41556_length_291_cov_2.174312_g41466_i0 PRJNA610520 41556 291 2.174312 6.32724792 Magnoliopsida 3398 Plants Plants 52 1.41e-5   NR XP_010672114.1 3555 g41466 i0 50 18.1340206185567 66 31 66 1 5 196 74 139 XP_010672114.1 uncharacterized protein At2g34160 [Beta vulgaris subsp. vulgaris] diamond 5277 52.4 0.99236641221374 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Beta Beta vulgaris
31628755 31628755 PRJNA610520_S_NODE_6936_length_452_cov_6.672823_g6848_i0 PRJNA610520 6936 452 6.672823 30.16115996 Panicum virgatum 38727 Plants Plants 55.8 5.89e-7   NR XP_039821950.1 38727 g6848 i0 35.1 2.15044247787611 74 46 49.1 1 32 253 2 73 XP_039821950.1 very-long-chain 3-oxoacyl-CoA reductase 1-like [Panicum virgatum] diamond 972 55.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Panicum Panicum virgatum
32905701 32905701 PRJNA610520_S_NODE_49960_length_272_cov_2.638191_g49870_i0 PRJNA610520 49960 272 2.638191 7.17587952 Fabaceae 3803 Plants Plants 56.6 6.77e-7   NR KAG2399806.1 3914 g49870 i0 48.4 7.11397058823529 62 29 68.4 1 3 188 58 116 KAG2399806.1 uncharacterized protein HKW66_Vig0103410 [Vigna angularis] diamond 1935 56.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna angularis

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