contig_metadata
7 rows where bioproject = "PRJNA358490" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 399053 | 399053 | PRJNA358490_P_NODE_1_length_6607_cov_23.984318_g0_i0 | PRJNA358490 | 1 | 6607 | 23.984318 | 1584.64389026 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 3030 | 0 | NR | XCO49569.1 | 3003959 | g0 | i0 | 67.3 | 1.9692750113516 | 2206 | 642 | 97.4 | 8 | 3 | 6440 | 178 | 2364 | XCO49569.1 MAG: putative ORF1 protein, partial [Picornavirales sp.] | diamond | 13011 | 3030 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 2949540 | 2949540 | PRJNA358490_P_NODE_13143_length_217_cov_2.719101_g12799_i0 | PRJNA358490 | 13143 | 217 | 2.719101 | 5.90044917 | Carlavirus latensallii | 3427762 | Viruses | Viruses | 351 | 1.69e-92 | NTclustered | gi|1722559511|gb|MN059109.1| | 47900 | g12799 | i0 | 98.98 | 45.7142857142857 | 196 | 2 | 90 | 0 | 22 | 217 | 8387 | 8582 | Garlic common latent virus isolate G35, complete genome | blastn | 9920 | 351 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Carlavirus | Carlavirus latensallii | ||
| 16976329 | 16976329 | PRJNA358490_P_NODE_1194_length_1214_cov_8.765957_g1105_i0 | PRJNA358490 | 1194 | 1214 | 8.765957 | 106.41871798 | Bromovirus BMV | 3427622 | Viruses | Viruses | 2119 | 0 | NTclustered | gi|320091636|gb|GU584129.1| | 12302 | g1105 | i0 | 98.743 | 39.4423393739703 | 1193 | 13 | 98 | 2 | 23 | 1214 | 1 | 1192 | Brome mosaic virus strain BMV-CZ segment RNA3, complete sequence | blastn | 47883 | 2119 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Bromovirus | Bromovirus BMV | ||
| 18250558 | 18250558 | PRJNA358490_P_NODE_10715_length_298_cov_1.583012_g10373_i0 | PRJNA358490 | 10715 | 298 | 1.583012 | 4.71737576 | Viruses | 10239 | Viruses | Viruses | 171 | 5.829999999999999e-47 | NR | QZZ63321.1 | 2874395 | g10373 | i0 | 77.8 | 1.99328859060403 | 99 | 22 | 99.7 | 0 | 1 | 297 | 408 | 506 | QZZ63321.1 hypothetical protein [Nelson Picorna-like virus 4] | diamond | 594 | 171 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Nelson Picorna-like virus 4 | ||||
| 19524770 | 19524770 | PRJNA358490_P_NODE_13156_length_217_cov_2.089888_g12812_i0 | PRJNA358490 | 13156 | 217 | 2.089888 | 4.53505696 | Ripabiq virus | 3130194 | Viruses | Viruses | 292 | 1.04e-74 | NTclustered | gi|2717319120|gb|PP172496.1| | 3130194 | g12812 | i0 | 94.271 | 89.2672811059908 | 192 | 10 | 88 | 1 | 5 | 195 | 682 | 491 | MAG: Ripabiq virus isolate DRCP1_k141_78731 genomic sequence | blastn | 19371 | 292 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Ripabiq virus | |||||
| 27738591 | 27738591 | PRJNA358490_P_NODE_9564_length_355_cov_3.132911_g9222_i0 | PRJNA358490 | 9564 | 355 | 3.132911 | 11.12183405 | Lycopersicon esculentum picorna-like virus | 2739854 | Viruses | Viruses | 54.7 | 9.01e-6 | NR | QKK82959.1 | 2739854 | g9222 | i0 | 34.7 | 0.802816901408451 | 95 | 53 | 72.7 | 2 | 272 | 15 | 10 | 104 | QKK82959.1 hypothetical protein, partial [Lycopersicon esculentum picorna-like virus] | diamond | 285 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Lycopersicon esculentum picorna-like virus | ||||
| 28906282 | 28906282 | PRJNA358490_P_NODE_16208_length_168_cov_1.263566_g15864_i0 | PRJNA358490 | 16208 | 168 | 1.263566 | 2.12279088 | Plantago mottle virus | 312274 | Viruses | Viruses | 90.5 | 1.98e-19 | NR | YP_002308445.1 | 312274 | g15864 | i0 | 74.5 | 0.982142857142857 | 55 | 14 | 98.2 | 0 | 167 | 3 | 420 | 474 | YP_002308445.1 polyprotein [Plantago mottle virus] | diamond | 165 | 90.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Tymoviridae | Tymovirus | Tymovirus plantagonis |
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);;