RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJEB28589", tax_kingdom = "Orthornavirae" and tax_phylum = "Kitrinoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Kitrinoviricota · 23 ✖

tax_kingdom 1

  • Orthornavirae · 23 ✖

bioproject 1

  • PRJEB28589 · 23 ✖

tax_clade 0

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
2575819 2575819 PRJEB28589_S_NODE_14443_length_193_cov_1.143836_g14335_i0 PRJEB28589 14443 193 1.143836 2.20760348 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g14335 i0 96.97 0.896373056994819 33 0 17 1 162 193 45 13 Carnation latent virus isolate KL, complete genome blastn 173 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
2575821 2575821 PRJEB28589_S_NODE_15043_length_187_cov_1.307143_g14935_i0 PRJEB28589 15043 187 1.307143 2.44435741 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.004   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g14935 i0 100 0.304812834224599 29 0 16 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
2575833 2575833 PRJEB28589_S_NODE_2103_length_406_cov_11.944290_g1995_i0 PRJEB28589 2103 406 11.94429 48.4938174 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.011   NTclustered gi|1995060321|gb|MN450069.1| 12164 g1995 i0 100 0.357142857142857 29 0 7 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 145 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
3852091 3852091 PRJEB28589_S_NODE_13144_length_207_cov_1.150000_g13036_i0 PRJEB28589 13144 207 1.15 2.3805 Carlavirus latensdianthi 3427766 Viruses Viruses 58.4 3.89e-4   NTclustered gi|1995060321|gb|MN450069.1| 12164 g13036 i0 94.737 0.859903381642512 38 0 18 2 171 207 49 13 Carnation latent virus isolate KL, complete genome blastn 178 58.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
5128358 5128358 PRJEB28589_S_NODE_2565_length_385_cov_3.254438_g2457_i0 PRJEB28589 2565 385 3.254438 12.5295863 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.01   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g2457 i0 100 0.148051948051948 29 0 8 0 357 385 34 6 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
6404151 6404151 PRJEB28589_S_NODE_13466_length_203_cov_2.019231_g13358_i0 PRJEB28589 13466 203 2.019231 4.09903893 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g13358 i0 100 0.694581280788177 29 0 14 0 175 203 41 13 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
7678173 7678173 PRJEB28589_S_NODE_1267_length_481_cov_6.534562_g1163_i0 PRJEB28589 1267 481 6.534562 31.43124322 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.004   NTclustered gi|1995060321|gb|MN450069.1| 12164 g1163 i0 100 0.30977130977131 30 0 6 0 452 481 42 13 Carnation latent virus isolate KL, complete genome blastn 149 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
7678189 7678189 PRJEB28589_S_NODE_15607_length_182_cov_1.511111_g15499_i0 PRJEB28589 15607 182 1.511111 2.75022202 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.004   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g15499 i0 100 0.313186813186813 29 0 16 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
7678207 7678207 PRJEB28589_S_NODE_2687_length_380_cov_5.126126_g2579_i0 PRJEB28589 2687 380 5.126126 19.4792788 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.01   NTclustered gi|1995060321|gb|MN450069.1| 12164 g2579 i0 100 0.371052631578947 29 0 8 0 352 380 41 13 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
10228714 10228714 PRJEB28589_S_NODE_16149_length_177_cov_1.176923_g16041_i0 PRJEB28589 16149 177 1.176923 2.08315371 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.004   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g16041 i0 94.444 0.361581920903955 36 1 20 1 1 35 6 41 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 64 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
10228796 10228796 PRJEB28589_S_NODE_9769_length_251_cov_3.137255_g9661_i0 PRJEB28589 9769 251 3.137255 7.87451005 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.006   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g9661 i0 100 0.338645418326693 29 0 12 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 85 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
11504059 11504059 PRJEB28589_S_NODE_4590_length_334_cov_1.484321_g4482_i0 PRJEB28589 4590 334 1.484321 4.95763214 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.009   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g4482 i0 100 0.170658682634731 29 0 9 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
11504086 11504086 PRJEB28589_S_NODE_9290_length_258_cov_2.862559_g9182_i0 PRJEB28589 9290 258 2.862559 7.38540222 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.007   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g9182 i0 100 0.22093023255814 29 0 11 0 230 258 34 6 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
14054116 14054116 PRJEB28589_S_NODE_13212_length_206_cov_1.603774_g13104_i0 PRJEB28589 13212 206 1.603774 3.30377444 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.005   NTclustered gi|1995060321|gb|MN450069.1| 12164 g13104 i0 100 0.684466019417476 29 0 14 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
16602810 16602810 PRJEB28589_S_NODE_6354_length_303_cov_2.789062_g6246_i0 PRJEB28589 6354 303 2.789062 8.45085786 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.008   NTclustered gi|1995060321|gb|MN450069.1| 12164 g6246 i0 100 0.465346534653465 29 0 10 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
19151505 19151505 PRJEB28589_S_NODE_2636_length_382_cov_4.334328_g2528_i0 PRJEB28589 2636 382 4.334328 16.55713296 Jujube closterovirus 1 3043313 Viruses Viruses 54.7 0.01   NTclustered gi|2496749738|gb|OP673405.1| 3043313 g2528 i0 100 0.149214659685864 29 0 8 0 1 29 6 34 Jujube closterovirus 1 isolate AKS15-20, complete genome blastn 57 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Closteroviridae   Jujube closterovirus 1
20426721 20426721 PRJEB28589_S_NODE_9017_length_262_cov_1.265116_g8909_i0 PRJEB28589 9017 262 1.265116 3.31460392 Carlavirus latensdianthi 3427766 Viruses Viruses 60.2 1.43e-4   NTclustered gi|1995060321|gb|MN450069.1| 12164 g8909 i0 100 0.549618320610687 32 0 12 0 231 262 44 13 Carnation latent virus isolate KL, complete genome blastn 144 60.2 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
21702660 21702660 PRJEB28589_S_NODE_10278_length_244_cov_3.116751_g10170_i0 PRJEB28589 10278 244 3.116751 7.60487244 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.006   NTclustered gi|1995060321|gb|MN450069.1| 12164 g10170 i0 100 0.577868852459016 29 0 12 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
22977992 22977992 PRJEB28589_S_NODE_6619_length_299_cov_2.539683_g6511_i0 PRJEB28589 6619 299 2.539683 7.59365217 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.002   NTclustered gi|1995060321|gb|MN450069.1| 12164 g6511 i0 100 0.474916387959866 30 0 10 0 270 299 42 13 Carnation latent virus isolate KL, complete genome blastn 142 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
24251749 24251749 PRJEB28589_S_NODE_12760_length_211_cov_2.048780_g12652_i0 PRJEB28589 12760 211 2.04878 4.3229258 Carlavirus latensdianthi 3427766 Viruses Viruses 56.5 0.001   NTclustered gi|1995060321|gb|MN450069.1| 12164 g12652 i0 96.97 0.691943127962085 33 1 16 0 179 211 45 13 Carnation latent virus isolate KL, complete genome blastn 146 56.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
24251828 24251828 PRJEB28589_S_NODE_8500_length_269_cov_4.117117_g8392_i0 PRJEB28589 8500 269 4.117117 11.07504473 Carlavirus latensdianthi 3427766 Viruses Viruses 54.7 0.007   NTclustered gi|1995060321|gb|MN450069.1| 12164 g8392 i0 100 0.524163568773234 29 0 11 0 1 29 13 41 Carnation latent virus isolate KL, complete genome blastn 141 54.7 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Betaflexiviridae Carlavirus Carlavirus latensdianthi
28644061 28644061 PRJEB28589_S_NODE_11547_length_227_cov_2.588889_g11439_i0 PRJEB28589 11547 227 2.588889 5.87677803 Nanning tick virus 2 2972366 Viruses Viruses 48.1 2.13e-4   NR UYL95419.1 2972366 g11439 i0 44.3 0.806167400881057 61 33 79.3 1 225 46 117 177 UYL95419.1 MAG: hypothetical protein [Nanning tick virus 2] diamond 183 48.1 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Tymoviridae   Nanning tick virus 2
31012693 31012693 PRJEB28589_S_NODE_4435_length_336_cov_12.013841_g4327_i0 PRJEB28589 4435 336 12.013841 40.36650576 Plasmopara viticola lesion associated alpha-like virus 1 2692080 Viruses Viruses 58.5 9.18e-8   NR QHD64750.1 2692080 g4327 i0 46.3 0.482142857142857 54 29 48.2 0 4 165 130 183 QHD64750.1 ORF2 [Plasmopara viticola lesion associated alpha-like virus 1] diamond 162 58.5 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Togaviridae Alphavirus Plasmopara viticola lesion associated alpha-like virus 1

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