contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJNA811714" and tax_phylum = "Negarnaviricota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26801010 | 26801010 | PRJNA811714_P_NODE_17181_length_258_cov_2.497297_g16988_i0 | PRJNA811714 | 17181 | 258 | 2.497297 | 6.44302626 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 114 | 2.1900000000000003e-27 | NR | NP_116748.1 | 696863 | g16988 | i0 | 69.4 | 0.988372093023256 | 85 | 26 | 98.8 | 0 | 3 | 257 | 1461 | 1545 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 255 | 114 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 27022634 | 27022634 | PRJNA811714_P_NODE_30982_length_207_cov_5.194030_g30789_i0 | PRJNA811714 | 30982 | 207 | 5.19403 | 10.7516421 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 107 | 3.0099999999999997e-25 | NR | NP_116748.1 | 696863 | g30789 | i0 | 74.6 | 0.971014492753623 | 67 | 17 | 97.1 | 0 | 7 | 207 | 1928 | 1994 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 201 | 107 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 27623129 | 27623129 | PRJNA811714_P_NODE_18344_length_253_cov_2.566667_g18151_i0 | PRJNA811714 | 18344 | 253 | 2.566667 | 6.49366751 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 137 | 1.67e-35 | NR | NP_116748.1 | 696863 | g18151 | i0 | 75.6 | 0.972332015810277 | 82 | 20 | 97.2 | 0 | 253 | 8 | 903 | 984 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 246 | 137 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 27812629 | 27812629 | PRJNA811714_P_NODE_23224_length_237_cov_2.817073_g23031_i0 | PRJNA811714 | 23224 | 237 | 2.817073 | 6.67646301 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 132 | 7.45e-36 | NR | NP_116745.1 | 696863 | g23031 | i0 | 76.9 | 0.987341772151899 | 78 | 18 | 98.7 | 0 | 235 | 2 | 89 | 166 | NP_116745.1 phosphoprotein [Sprivivirus cyprinus] | diamond | 234 | 132 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 28570105 | 28570105 | PRJNA811714_P_NODE_20027_length_247_cov_2.655172_g19834_i0 | PRJNA811714 | 20027 | 247 | 2.655172 | 6.55827484 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 141 | 9.37e-37 | NR | NP_116748.1 | 696863 | g19834 | i0 | 82.7 | 0.983805668016194 | 81 | 14 | 98.4 | 0 | 243 | 1 | 2007 | 2087 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 243 | 141 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 28696657 | 28696657 | PRJNA811714_P_NODE_24647_length_233_cov_2.887500_g24454_i0 | PRJNA811714 | 24647 | 233 | 2.8875 | 6.727875 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 108 | 3.8e-27 | NR | NP_116746.1 | 696863 | g24454 | i0 | 70.3 | 0.952789699570815 | 74 | 22 | 95.3 | 0 | 8 | 229 | 7 | 80 | NP_116746.1 matrix protein [Sprivivirus cyprinus] | diamond | 222 | 108 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 28791051 | 28791051 | PRJNA811714_P_NODE_17607_length_256_cov_2.524590_g17414_i0 | PRJNA811714 | 17607 | 256 | 2.52459 | 6.4629504 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 154 | 2.76e-41 | NR | NP_116748.1 | 696863 | g17414 | i0 | 78.8 | 0.99609375 | 85 | 18 | 99.6 | 0 | 256 | 2 | 1655 | 1739 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 255 | 154 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29012512 | 29012512 | PRJNA811714_P_NODE_22908_length_238_cov_2.800000_g22715_i0 | PRJNA811714 | 22908 | 238 | 2.8 | 6.664 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 112 | 7.73e-27 | NR | NP_116748.1 | 696863 | g22715 | i0 | 79.5 | 1.96638655462185 | 78 | 16 | 98.3 | 0 | 236 | 3 | 760 | 837 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 468 | 112 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29201776 | 29201776 | PRJNA811714_P_NODE_18269_length_253_cov_4.833333_g18076_i0 | PRJNA811714 | 18269 | 253 | 4.833333 | 12.22833249 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 85.5 | 3.94e-17 | NR | WLN26256.1 | 3065075 | g18076 | i0 | 46.4 | 0.99604743083004 | 84 | 45 | 99.6 | 0 | 2 | 253 | 147 | 230 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 252 | 85.5 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 29296378 | 29296378 | PRJNA811714_P_NODE_28309_length_222_cov_8.114094_g28116_i0 | PRJNA811714 | 28309 | 222 | 8.114094 | 18.01328868 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 123 | 1.08e-30 | NR | NP_116748.1 | 696863 | g28116 | i0 | 78.4 | 1 | 74 | 16 | 100 | 0 | 1 | 222 | 137 | 210 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 222 | 123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29833127 | 29833127 | PRJNA811714_P_NODE_21991_length_241_cov_2.732143_g21798_i0 | PRJNA811714 | 21991 | 241 | 2.732143 | 6.58446463 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 125 | 1.01e-31 | NR | NP_116747.1 | 696863 | g21798 | i0 | 69.6 | 2.95020746887967 | 79 | 24 | 98.3 | 0 | 239 | 3 | 54 | 132 | NP_116747.1 glycoprotein [Sprivivirus cyprinus] | diamond | 711 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29896414 | 29896414 | PRJNA811714_P_NODE_22071_length_240_cov_7.239521_g21878_i0 | PRJNA811714 | 22071 | 240 | 7.239521 | 17.3748504 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 130 | 7.06e-33 | NR | NP_116748.1 | 696863 | g21878 | i0 | 83.8 | 1 | 80 | 13 | 100 | 0 | 240 | 1 | 236 | 315 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 240 | 130 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 29959461 | 29959461 | PRJNA811714_P_NODE_22311_length_240_cov_2.766467_g22118_i0 | PRJNA811714 | 22311 | 240 | 2.766467 | 6.6395208 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 110 | 1.59e-26 | NR | NP_116744.1 | 696863 | g22118 | i0 | 73.8 | 1 | 80 | 21 | 100 | 0 | 1 | 240 | 5 | 84 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 240 | 110 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30117330 | 30117330 | PRJNA811714_P_NODE_25532_length_231_cov_2.924051_g25339_i0 | PRJNA811714 | 25532 | 231 | 2.924051 | 6.75455781 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 123 | 1.6e-30 | NR | NP_116748.1 | 696863 | g25339 | i0 | 72.2 | 0.935064935064935 | 72 | 20 | 93.5 | 0 | 6 | 221 | 1686 | 1757 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 216 | 123 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30117331 | 30117331 | PRJNA811714_P_NODE_30632_length_209_cov_4.632353_g30439_i0 | PRJNA811714 | 30632 | 209 | 4.632353 | 9.68161777 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 115 | 8.14e-28 | NR | NP_116748.1 | 696863 | g30439 | i0 | 77.3 | 0.947368421052632 | 66 | 15 | 94.7 | 0 | 11 | 208 | 1702 | 1767 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 198 | 115 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30875737 | 30875737 | PRJNA811714_P_NODE_15474_length_266_cov_2.393782_g15281_i0 | PRJNA811714 | 15474 | 266 | 2.393782 | 6.36746012 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 125 | 4.119999999999999e-31 | NR | NP_116748.1 | 696863 | g15281 | i0 | 72.7 | 0.992481203007519 | 88 | 24 | 99.2 | 0 | 264 | 1 | 1853 | 1940 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 264 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 30907546 | 30907546 | PRJNA811714_P_NODE_26754_length_228_cov_2.980645_g26561_i0 | PRJNA811714 | 26754 | 228 | 2.980645 | 6.7958706 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 125 | 1.7399999999999999e-31 | NR | NP_116748.1 | 696863 | g26561 | i0 | 78.7 | 0.986842105263158 | 75 | 16 | 98.7 | 0 | 227 | 3 | 1080 | 1154 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 225 | 125 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31381602 | 31381602 | PRJNA811714_P_NODE_15296_length_267_cov_2.381443_g15103_i0 | PRJNA811714 | 15296 | 267 | 2.381443 | 6.35845281 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 134 | 4.4199999999999985e-34 | NR | NP_116748.1 | 696863 | g15103 | i0 | 69 | 0.97752808988764 | 87 | 27 | 97.8 | 0 | 2 | 262 | 897 | 983 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 261 | 134 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31476505 | 31476505 | PRJNA811714_P_NODE_31636_length_203_cov_9.253846_g31443_i0 | PRJNA811714 | 31636 | 203 | 9.253846 | 18.78530738 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 103 | 8.46e-24 | NR | NP_116748.1 | 696863 | g31443 | i0 | 72.7 | 0.975369458128079 | 66 | 18 | 97.5 | 0 | 202 | 5 | 1100 | 1165 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 198 | 103 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31539753 | 31539753 | PRJNA811714_P_NODE_26876_length_228_cov_2.245161_g26683_i0 | PRJNA811714 | 26876 | 228 | 2.245161 | 5.11896708 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 112 | 6.810000000000001e-27 | NR | NP_116748.1 | 696863 | g26683 | i0 | 73 | 0.973684210526316 | 74 | 20 | 97.4 | 0 | 223 | 2 | 2000 | 2073 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 222 | 112 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31571421 | 31571421 | PRJNA811714_P_NODE_21936_length_241_cov_2.750000_g21743_i0 | PRJNA811714 | 21936 | 241 | 2.75 | 6.6275 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 108 | 2.47e-25 | NR | NP_116748.1 | 696863 | g21743 | i0 | 70.9 | 0.983402489626556 | 79 | 23 | 98.3 | 0 | 3 | 239 | 1747 | 1825 | NP_116748.1 polymerase [Sprivivirus cyprinus] | diamond | 237 | 108 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 31887464 | 31887464 | PRJNA811714_P_NODE_24697_length_233_cov_2.887500_g24504_i0 | PRJNA811714 | 24697 | 233 | 2.8875 | 6.727875 | Spring viraemia of carp virus | 696863 | Viruses | Viruses | 119 | 4.8899999999999994e-30 | NR | NP_116744.1 | 696863 | g24504 | i0 | 75.3 | 0.991416309012876 | 77 | 19 | 99.1 | 0 | 1 | 231 | 173 | 249 | NP_116744.1 nucleocapsid protein [Sprivivirus cyprinus] | diamond | 231 | 119 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Rhabdoviridae | Sprivivirus | Spring viraemia of carp virus | ||
| 32457242 | 32457242 | PRJNA811714_P_NODE_30759_length_208_cov_6.222222_g30566_i0 | PRJNA811714 | 30759 | 208 | 6.222222 | 12.94222176 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 74.7 | 1.3e-13 | NR | WLN26256.1 | 3065075 | g30566 | i0 | 56.1 | 0.951923076923077 | 66 | 29 | 95.2 | 0 | 207 | 10 | 237 | 302 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 198 | 74.7 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus |
Advanced export
JSON shape: default, array, newline-delimited
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);;