RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA385064" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA385064 · 18 ✖

analysis 1

  • diamond · 18 ✖
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
10609177 10609177 PRJNA385064_P_NODE_6649_length_167_cov_0.864407_g6524_i0 PRJNA385064 6649 167 0.864407 1.44355969 Tanacetum cinerariifolium 118510 Plants Plants 94.7 5.9400000000000005e-21   NR GFA47803.1 118510 g6524 i0 81.8 14.8203592814371 55 10 98.8 0 165 1 79 133 GFA47803.1 reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 2475 94.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
26885513 26885513 PRJNA385064_P_NODE_7581_length_163_cov_0.894737_g7456_i0 PRJNA385064 7581 163 0.894737 1.45842131 Tanacetum cinerariifolium 118510 Plants Plants 85.5 6.04e-18   NR GEZ20559.1 118510 g7456 i0 60.6 17.7791411042945 66 14 99.4 1 2 163 28 93 GEZ20559.1 putative reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 2898 85.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
28338515 28338515 PRJNA385064_P_NODE_8106_length_161_cov_0.910714_g7981_i0 PRJNA385064 8106 161 0.910714 1.46624954 Tanacetum cinerariifolium 118510 Plants Plants 111 9.06e-27   NR GEU51216.1 118510 g7981 i0 94.3 11.8509316770186 53 3 98.8 0 2 160 465 517 GEU51216.1 reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 1908 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
28433247 28433247 PRJNA385064_P_NODE_7786_length_162_cov_0.902655_g7661_i0 PRJNA385064 7786 162 0.902655 1.4623011 Manihot esculenta 3983 Plants Plants 51.6 9.51e-6   NR XP_043809052.1 3983 g7661 i0 91.3 9.7962962962963 23 2 42.6 0 1 69 866 888 XP_043809052.1 uncharacterized protein LOC122722418 [Manihot esculenta] diamond 1587 51.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Manihot Manihot esculenta
28987112 28987112 PRJNA385064_P_NODE_4788_length_196_cov_1.122449_g4663_i0 PRJNA385064 4788 196 1.122449 2.20000004 Magnoliopsida 3398 Plants Plants 119 4.44e-31   NR XP_011084824.1 4182 g4663 i0 87.5 25.469387755102 64 8 98 0 3 194 203 266 XP_011084824.1 expansin-A2 [Sesamum indicum] diamond 4992 120 0.991666666666667 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum indicum
29096366 29096366 PRJNA385064_P_NODE_5008_length_191_cov_4.309859_g4883_i0 PRJNA385064 5008 191 4.309859 8.23183069 Cannabis sativa 3483 Plants Plants 44.3 0.0054   NR KAF4368741.1 3483 g4883 i0 37.7 2.87434554973822 61 29 84.8 2 17 178 485 543 KAF4368741.1 hypothetical protein G4B88_003614 [Cannabis sativa] diamond 549 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
29727453 29727453 PRJNA385064_P_NODE_8010_length_161_cov_0.910714_g7885_i0 PRJNA385064 8010 161 0.910714 1.46624954 Picea sitchensis 3332 Plants Plants 66.6 5.82e-12   NR ABR17632.1 3332 g7885 i0 62.3 0.987577639751553 53 20 98.8 0 161 3 8 60 ABR17632.1 unknown [Picea sitchensis] diamond 159 66.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
29759154 29759154 PRJNA385064_P_NODE_8131_length_161_cov_0.910714_g8006_i0 PRJNA385064 8131 161 0.910714 1.46624954 Rhamnella rubrinervis 2594499 Plants Plants 88.2 1.16e-18   NR KAF3436603.1 2594499 g8006 i0 79.2 2.96273291925466 53 11 98.8 0 160 2 108 160 KAF3436603.1 hypothetical protein FNV43_RR23695 [Rhamnella rubrinervis] diamond 477 88.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Rhamnella Rhamnella rubrinervis
29980419 29980419 PRJNA385064_P_NODE_6511_length_167_cov_0.864407_g6386_i0 PRJNA385064 6511 167 0.864407 1.44355969 Tanacetum cinerariifolium 118510 Plants Plants 98.6 2.86e-22   NR GEW32383.1 118510 g6386 i0 78.2 22.7065868263473 55 12 98.8 0 3 167 275 329 GEW32383.1 putative ribonuclease H-like domain-containing protein [Tanacetum cinerariifolium] diamond 3792 98.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
30075033 30075033 PRJNA385064_P_NODE_7812_length_162_cov_0.902655_g7687_i0 PRJNA385064 7812 162 0.902655 1.4623011 Tanacetum cinerariifolium 118510 Plants Plants 86.3 4.31e-20   NR GFC55550.1 118510 g7687 i0 72.5 71.7407407407407 51 14 94.4 0 6 158 21 71 GFC55550.1 putative reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 11622 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
30643728 30643728 PRJNA385064_P_NODE_3233_length_243_cov_8.520619_g3108_i0 PRJNA385064 3233 243 8.520619 20.70510417 Sesamum angolense 2727404 Plants Plants 74.3 2.5e-15   NR KAK4386805.1 2727404 g3108 i0 62.5 1.34567901234568 56 21 69.1 0 75 242 3 58 KAK4386805.1 hypothetical protein Sango_2551100 [Sesamum angolense] diamond 327 74.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Pedaliaceae Sesamum Sesamum angolense
30675332 30675332 PRJNA385064_P_NODE_3313_length_240_cov_29.513089_g3188_i0 PRJNA385064 3313 240 29.513089 70.8314136 Ricinus communis 3988 Plants Plants 67.8 1.41e-12   NR EEF34889.1 3988 g3188 i0 54.2 0.9 72 31 87.5 2 15 224 17 88 EEF34889.1 conserved hypothetical protein [Ricinus communis] diamond 216 67.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Ricinus Ricinus communis
30801797 30801797 PRJNA385064_P_NODE_3294_length_241_cov_9.598958_g3169_i0 PRJNA385064 3294 241 9.598958 23.13348878 Perilla frutescens var. hirtella 608512 Plants Plants 77.8 7.11e-17   NR KAH6786495.1 608512 g3169 i0 63.9 0.759336099585062 61 21 74.7 1 9 188 2 62 KAH6786495.1 hypothetical protein C2S52_006047 [Perilla frutescens var. hirtella] diamond 183 77.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Lamiaceae Perilla Perilla frutescens
31307425 31307425 PRJNA385064_P_NODE_3395_length_237_cov_4.255319_g3270_i0 PRJNA385064 3395 237 4.255319 10.08510603 Olea europaea subsp. europaea 158383 Plants Plants 79.3 5.39e-17   NR CAA3007604.1 158383 g3270 i0 57.1 0.974683544303797 77 32 96.2 1 6 233 1 77 CAA3007604.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 231 79.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31908478 31908478 PRJNA385064_P_NODE_4897_length_194_cov_0.917241_g4772_i0 PRJNA385064 4897 194 0.917241 1.77944754 Carpinus fangiana 176857 Plants Plants 47.4 8.21e-5   NR KAE8126165.1 176857 g4772 i0 62.1 0.448453608247423 29 11 44.8 0 186 100 17 45 KAE8126165.1 hypothetical protein FH972_020909 [Carpinus fangiana] diamond 87 47.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
32288525 32288525 PRJNA385064_P_NODE_3439_length_236_cov_0.823529_g3314_i0 PRJNA385064 3439 236 0.823529 1.94352844 Tanacetum cinerariifolium 118510 Plants Plants 153 8.719999999999999e-43   NR GFA30128.1 118510 g3314 i0 92.2 12.8516949152542 77 6 97.9 0 234 4 338 414 GFA30128.1 retrovirus-related Pol polyprotein from transposon TNT 1-94 [Tanacetum cinerariifolium] diamond 3033 153 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
32320162 32320162 PRJNA385064_P_NODE_6179_length_171_cov_0.655738_g6054_i0 PRJNA385064 6179 171 0.655738 1.12131198 Lactuca virosa 75947 Plants Plants 39.7 0.0458   NR CAH1430493.1 75947 g6054 i0 48.7 0.684210526315789 39 18 64.9 1 18 128 13 51 CAH1430493.1 unnamed protein product [Lactuca virosa] diamond 117 39.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca virosa
32368613 32368613 PRJNA385064_P_NODE_7139_length_165_cov_0.879310_g7014_i0 PRJNA385064 7139 165 0.87931 1.4508615 Streptophyta 35493 Plants Plants 41.6 0.0331   NR XP_059066406.1 3369 g7014 i0 43.4 1.90909090909091 53 30 96.4 0 161 3 509 561 XP_059066406.1 uncharacterized protein LOC131857717 [Cryptomeria japonica] diamond 315 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica

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