contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_kingdom = "Orthornavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14440603 | 14440603 | PRJNA395690_P_NODE_312_length_1387_cov_2.143498_g252_i0 | PRJNA395690 | 312 | 1387 | 2.143498 | 29.73031726 | Mitovirus sp. | 2587224 | Viruses | Viruses | 577 | 2.85e-198 | NR | QDH87062.1 | 2587224 | g252 | i0 | 64.4 | 0.940879596250901 | 435 | 155 | 94.1 | 0 | 1374 | 70 | 227 | 661 | QDH87062.1 MAG: RNA-dependent RNA polymerase [Mitovirus sp.] | diamond | 1305 | 577 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 16989300 | 16989300 | PRJNA395690_P_NODE_74_length_2438_cov_3.685643_g63_i0 | PRJNA395690 | 74 | 2438 | 3.685643 | 89.85597634 | Rhizopus microsporus narnavirus 4 | 3156535 | Viruses | Viruses | 410 | 8.08e-127 | NR | BFM51652.1 | 3156535 | g63 | i0 | 38 | 0.964725184577523 | 784 | 431 | 91.8 | 24 | 2246 | 9 | 83 | 849 | BFM51652.1 RNA dependent RNA polymerase [Rhizopus microsporus narnavirus 4] | diamond | 2352 | 410 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Narnavirus | Rhizopus microsporus narnavirus 4 | ||
| 27043739 | 27043739 | PRJNA395690_P_NODE_2_length_9597_cov_5.203812_g1_i0 | PRJNA395690 | 2 | 9597 | 5.203812 | 499.40983764 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 3586 | 0 | NR | WWZ85593.1 | 3132542 | g1 | i0 | 60.9 | 0.945295404814004 | 3024 | 1026 | 91.1 | 32 | 9037 | 299 | 4 | 2981 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 9072 | 3586 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 27138090 | 27138090 | PRJNA395690_P_NODE_102_length_2162_cov_5.683389_g82_i0 | PRJNA395690 | 102 | 2162 | 5.683389 | 122.87487018 | Sopagox virus | 3131805 | Viruses | Viruses | 375 | 5.39e-116 | NR | WZH61965.1 | 3131805 | g82 | i0 | 36.9 | 0.947733580018501 | 683 | 396 | 93 | 17 | 2080 | 71 | 35 | 695 | WZH61965.1 MAG: RNA-dependent RNA polymerase, partial [Sopagox virus] | diamond | 2049 | 375 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sopagox virus | |||
| 28212121 | 28212121 | PRJNA395690_P_NODE_4346_length_379_cov_2.054545_g4197_i0 | PRJNA395690 | 4346 | 379 | 2.054545 | 7.78672555 | Mitovirus sp. | 2587224 | Viruses | Viruses | 50.4 | 2.78e-4 | NR | QDH86691.1 | 2587224 | g4197 | i0 | 53.2 | 0.744063324538259 | 47 | 22 | 37.2 | 0 | 143 | 3 | 15 | 61 | QDH86691.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] | diamond | 282 | 50.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 28307066 | 28307066 | PRJNA395690_P_NODE_13546_length_221_cov_1.482558_g13394_i0 | PRJNA395690 | 13546 | 221 | 1.482558 | 3.27645318 | Sonamoc virus | 3131588 | Viruses | Viruses | 50.4 | 5.36e-5 | NR | WZH61629.1 | 3131588 | g13394 | i0 | 45.2 | 0.990950226244344 | 73 | 38 | 99.1 | 2 | 3 | 221 | 348 | 418 | WZH61629.1 MAG: RNA-dependent RNA polymerase, partial [Sonamoc virus] | diamond | 219 | 50.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Sonamoc virus | |||
| 28686198 | 28686198 | PRJNA395690_P_NODE_20427_length_186_cov_1.007299_g20275_i0 | PRJNA395690 | 20427 | 186 | 1.007299 | 1.87357614 | Red mite associated cystovirus | 2936548 | Viruses | Viruses | 67.8 | 2.51e-11 | NR | UQT02510.1 | 2936548 | g20275 | i0 | 54.4 | 0.919354838709677 | 57 | 26 | 91.9 | 0 | 184 | 14 | 149 | 205 | UQT02510.1 P2 [Red mite associated cystovirus] | diamond | 171 | 67.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Cystovirus | Red mite associated cystovirus | ||
| 28749088 | 28749088 | PRJNA395690_P_NODE_17647_length_193_cov_1.416667_g17495_i0 | PRJNA395690 | 17647 | 193 | 1.416667 | 2.73416731 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 82.8 | 1.42e-16 | NR | UJQ92580.1 | 2809572 | g17495 | i0 | 67.9 | 0.823834196891192 | 53 | 17 | 82.4 | 0 | 161 | 3 | 339 | 391 | UJQ92580.1 MAG: putative RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 159 | 82.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 28797216 | 28797216 | PRJNA395690_P_NODE_2987_length_453_cov_1.581683_g2838_i0 | PRJNA395690 | 2987 | 453 | 1.581683 | 7.16502399 | Chuvivirus | 2842604 | Viruses | Viruses | 190 | 3.959999999999999e-55 | NR | WET19887.1 | 2842604 | g2838 | i0 | 62 | 1.98675496688742 | 150 | 57 | 99.3 | 0 | 4 | 453 | 243 | 392 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 900 | 190 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 29885988 | 29885988 | PRJNA395690_P_NODE_4951_length_357_cov_1.785714_g4802_i0 | PRJNA395690 | 4951 | 357 | 1.785714 | 6.37499898 | Mitovirus sp. | 2587224 | Viruses | Viruses | 139 | 7.979999999999999e-38 | NR | QDH86691.1 | 2587224 | g4802 | i0 | 58.1 | 1.96638655462185 | 117 | 48 | 98.3 | 1 | 1 | 351 | 108 | 223 | QDH86691.1 MAG: RNA-dependent RNA polymerase, partial [Mitovirus sp.] | diamond | 702 | 139 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitovirus | Mitovirus sp. | ||
| 30138171 | 30138171 | PRJNA395690_P_NODE_19612_length_187_cov_2.188406_g19460_i0 | PRJNA395690 | 19612 | 187 | 2.188406 | 4.09231922 | Tombusviridae sp. | 2583950 | Viruses | Viruses | 63.2 | 9.43e-10 | NR | USC30238.1 | 2583950 | g19460 | i0 | 59.6 | 2.66310160427807 | 52 | 20 | 81.8 | 1 | 9 | 161 | 82 | 133 | USC30238.1 MAG: putative RNA dependent RNA polymerase, partial [Tombusviridae sp.] | diamond | 498 | 63.2 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Tolucaviricetes | Tolivirales | Tombusviridae | Tombusviridae sp. | |||
| 30328666 | 30328666 | PRJNA395690_P_NODE_34532_length_162_cov_0.902655_g34380_i0 | PRJNA395690 | 34532 | 162 | 0.902655 | 1.4623011 | Chrocavint virus | 3129664 | Viruses | Viruses | 50.1 | 3.16e-5 | NR | WZH58685.1 | 3129664 | g34380 | i0 | 53.2 | 1.74074074074074 | 47 | 15 | 87 | 2 | 11 | 151 | 201 | 240 | WZH58685.1 MAG: RNA-dependent RNA polymerase, partial [Chrocavint virus] | diamond | 282 | 50.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Chrocavint virus | |||
| 31103063 | 31103063 | PRJNA395690_P_NODE_7515_length_294_cov_3.008163_g7363_i0 | PRJNA395690 | 7515 | 294 | 3.008163 | 8.84399922 | Viruses | 10239 | Viruses | Viruses | 53.9 | 5.51e-6 | NR | NP_690829.1 | 161736 | g7363 | i0 | 39.4 | 1.87755102040816 | 99 | 48 | 92.9 | 4 | 21 | 293 | 105 | 199 | NP_690829.1 muramidase [Pseudomonas phage phi12] | diamond | 552 | 53.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Vidaverviricetes | Mindivirales | Cystoviridae | Betacystovirus | Betacystovirus phi12 | ||
| 31497603 | 31497603 | PRJNA395690_P_NODE_11996_length_235_cov_1.370968_g11844_i0 | PRJNA395690 | 11996 | 235 | 1.370968 | 3.2217748 | Mitoviridae sp. | 2809572 | Viruses | Viruses | 81.3 | 9.18e-16 | NR | UJQ92580.1 | 2809572 | g11844 | i0 | 50.6 | 3.94468085106383 | 77 | 38 | 98.3 | 0 | 4 | 234 | 467 | 543 | UJQ92580.1 MAG: putative RNA-dependent RNA polymerase, partial [Mitoviridae sp.] | diamond | 927 | 81.3 | 1 | Viruses | Orthornavirae | Lenarviricota | Howeltoviricetes | Cryppavirales | Mitoviridae | Mitoviridae sp. | |||
| 32856388 | 32856388 | PRJNA395690_P_NODE_31900_length_164_cov_1.330435_g31748_i0 | PRJNA395690 | 31900 | 164 | 1.330435 | 2.1819134 | Chrocavint virus | 3129664 | Viruses | Viruses | 47.4 | 2.97e-4 | NR | WZH58685.1 | 3129664 | g31748 | i0 | 43.1 | 0.932926829268293 | 51 | 29 | 93.3 | 0 | 7 | 159 | 311 | 361 | WZH58685.1 MAG: RNA-dependent RNA polymerase, partial [Chrocavint virus] | diamond | 153 | 47.4 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Wolframvirales | Narnaviridae | Chrocavint virus |
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);;