contig_metadata
10 rows where bioproject = "PRJNA715462", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1981841 | 1981841 | PRJNA715462_P_NODE_3522_length_1379_cov_6.535988_g3058_i0 | PRJNA715462 | 3522 | 1379 | 6.535988 | 90.13127452 | Nepovirus avii | 3047741 | Viruses | Viruses | 1029 | 0 | NTclustered | gi|1229202697|emb|LT883166.1| | 12615 | g3058 | i0 | 87.889 | 59.9260333575054 | 900 | 78 | 92 | 10 | 486 | 1379 | 5314 | 6188 | Cherry leaf roll virus Polyprotein 2 gene for polyprotein, 2A, 2B, movement protein, coat protein region, segment RNA2, isolate E327 | blastn | 82638 | 1029 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 1982601 | 1982601 | PRJNA715462_P_NODE_9802_length_682_cov_12.371100_g3058_i3 | PRJNA715462 | 9802 | 682 | 12.3711 | 84.370902 | Nepovirus avii | 3047741 | Viruses | Viruses | 998 | 0 | NTclustered | gi|2108668857|gb|MZ291951.1| | 12615 | g3058 | i3 | 93.235 | 83.0366568914956 | 680 | 43 | 99 | 3 | 2 | 678 | 6350 | 5671 | Cherry leaf roll virus isolate 19SP057 segment RNA2, complete sequence | blastn | 56631 | 998 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 3257780 | 3257780 | PRJNA715462_P_NODE_6823_length_887_cov_3.998771_g3058_i1 | PRJNA715462 | 6823 | 887 | 3.998771 | 35.46909877 | Nepovirus avii | 3047741 | Viruses | Viruses | 652 | 0 | NTclustered | gi|2073341497|gb|MW854282.1| | 12615 | g3058 | i1 | 92.06 | 29.2356257046223 | 466 | 34 | 98 | 2 | 407 | 870 | 6753 | 6289 | Cherry leaf roll virus isolate DSMZ PV-0797 segment RNA 1, partial sequence | blastn | 25932 | 652 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 4534327 | 4534327 | PRJNA715462_P_NODE_41024_length_278_cov_1.248780_g40228_i0 | PRJNA715462 | 41024 | 278 | 1.24878 | 3.4716084 | Nepovirus avii | 3047741 | Viruses | Viruses | 318 | 2.2899999999999995e-82 | NTclustered | gi|378406127|gb|JN104385.1| | 12615 | g40228 | i0 | 87.41 | 9.49640287769784 | 278 | 33 | 99 | 2 | 2 | 278 | 4378 | 4654 | Cherry leaf roll virus isolate Olm1 segment RNA2, complete sequence | blastn | 2640 | 318 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 4534388 | 4534388 | PRJNA715462_P_NODE_43844_length_269_cov_1.964286_g43048_i0 | PRJNA715462 | 43844 | 269 | 1.964286 | 5.28392934 | Nepovirus avii | 3047741 | Viruses | Viruses | 335 | 2.18e-87 | NTclustered | gi|1723623683|gb|MK402281.1| | 12615 | g43048 | i0 | 89.179 | 26.3011152416357 | 268 | 29 | 99 | 0 | 1 | 268 | 4829 | 4562 | Cherry leaf roll virus isolate CLRV_BpenGer407526 segment RNA1 putative polyprotein gene, partial cds | blastn | 7075 | 335 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 13460273 | 13460273 | PRJNA715462_P_NODE_8511_length_758_cov_7.430657_g3058_i2 | PRJNA715462 | 8511 | 758 | 7.430657 | 56.32438006 | Nepovirus avii | 3047741 | Viruses | Viruses | 1114 | 0 | NTclustered | gi|2520246190|gb|OQ731914.1| | 12615 | g3058 | i2 | 93.272 | 80.9406332453826 | 758 | 47 | 99 | 4 | 3 | 758 | 6833 | 7588 | Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence | blastn | 61353 | 1114 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 14734131 | 14734131 | PRJNA715462_P_NODE_10412_length_655_cov_12.403780_g3058_i4 | PRJNA715462 | 10412 | 655 | 12.40378 | 81.244759 | Nepovirus avii | 3047741 | Viruses | Viruses | 957 | 0 | NTclustered | gi|2520246190|gb|OQ731914.1| | 12615 | g3058 | i4 | 93.364 | 81.7465648854962 | 648 | 42 | 99 | 1 | 5 | 651 | 7858 | 7211 | Cherry leaf roll virus isolate DSMZ PV-1382 segment RNA1, complete sequence | blastn | 53544 | 957 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 18557424 | 18557424 | PRJNA715462_P_NODE_24455_length_366_cov_1.051195_g23659_i0 | PRJNA715462 | 24455 | 366 | 1.051195 | 3.8473737 | Nepovirus avii | 3047741 | Viruses | Viruses | 429 | 1.37e-115 | NTclustered | gi|2419396262|gb|ON924206.1| | 12615 | g23659 | i0 | 88.825 | 14.4535519125683 | 349 | 39 | 95 | 0 | 18 | 366 | 5734 | 5386 | Cherry leaf roll virus isolate DSMZ PV-0200 segment RNA 1, complete sequence | blastn | 5290 | 429 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii | ||
| 31885098 | 31885098 | PRJNA715462_P_NODE_2657_length_1618_cov_2.382524_g2273_i0 | PRJNA715462 | 2657 | 1618 | 2.382524 | 38.54923832 | brine shrimp partitivirus 1 | 2900392 | Viruses | Viruses | 536 | 2.7999999999999996e-185 | NR | UNI73932.1 | 2900392 | g2273 | i0 | 60 | 1.68726823238566 | 430 | 166 | 79.7 | 1 | 1322 | 33 | 1 | 424 | UNI73932.1 MAG: coat protein [brine shrimp partitivirus 1] | diamond | 2730 | 536 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partitivirus 1 | |||
| 32738868 | 32738868 | PRJNA715462_P_NODE_55740_length_248_cov_1.114286_g54944_i0 | PRJNA715462 | 55740 | 248 | 1.114286 | 2.76342928 | Cherry leaf roll virus | 12615 | Viruses | Viruses | 145 | 4.19e-38 | NR | WWV46533.1 | 12615 | g54944 | i0 | 81.9 | 1.00403225806452 | 83 | 14 | 99.2 | 1 | 1 | 246 | 1956 | 2038 | WWV46533.1 MAG: polyprotein, partial [Cherry leaf roll virus] | diamond | 249 | 145 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Secoviridae | Nepovirus | Nepovirus avii |
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);;