contig_metadata
12 rows where bioproject = "PRJNA561212", tax_phylum = "Negarnaviricota" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14574200 | 14574200 | PRJNA561212_P_NODE_10392_length_342_cov_2.193309_g10181_i0 | PRJNA561212 | 10392 | 342 | 2.193309 | 7.50111678 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 616 | 9.139999999999999e-172 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g10181 | i0 | 100 | 4.86842105263158 | 333 | 0 | 97 | 0 | 1 | 333 | 1079 | 1411 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 1665 | 616 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574253 | 14574253 | PRJNA561212_P_NODE_1312_length_944_cov_2.814007_g1146_i0 | PRJNA561212 | 1312 | 944 | 2.814007 | 26.56422608 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 1729 | 0 | NTclustered | gi|2209095278|gb|OL472843.1| | 2900459 | g1146 | i0 | 100 | 4.98940677966102 | 936 | 0 | 99 | 0 | 1 | 936 | 993 | 58 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 2 hypothetical protein gene, complete cds | blastn | 4710 | 1729 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574454 | 14574454 | PRJNA561212_P_NODE_24692_length_244_cov_1.011696_g24481_i0 | PRJNA561212 | 24692 | 244 | 1.011696 | 2.46853824 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 403 | 5.27e-108 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g24481 | i0 | 97.458 | 4.83606557377049 | 236 | 6 | 97 | 0 | 9 | 244 | 6545 | 6310 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1180 | 403 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 14574533 | 14574533 | PRJNA561212_P_NODE_5852_length_457_cov_0.765625_g5641_i0 | PRJNA561212 | 5852 | 457 | 0.765625 | 3.49890625 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g5641 | i0 | 99.093 | 14.4748358862144 | 441 | 4 | 96 | 0 | 8 | 448 | 6501 | 6061 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 6615 | 793 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 19671863 | 19671863 | PRJNA561212_P_NODE_18156_length_267_cov_1.128866_g17945_i0 | PRJNA561212 | 18156 | 267 | 1.128866 | 3.01407222 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 449 | 7.410000000000001e-122 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g17945 | i0 | 99.593 | 13.8202247191011 | 246 | 1 | 92 | 0 | 10 | 255 | 1553 | 1798 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 3690 | 449 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 19671941 | 19671941 | PRJNA561212_P_NODE_22796_length_248_cov_0.891429_g22585_i0 | PRJNA561212 | 22796 | 248 | 0.891429 | 2.21074392 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 431 | 2.47e-116 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g22585 | i0 | 100 | 4.69758064516129 | 233 | 0 | 94 | 0 | 9 | 241 | 6709 | 6477 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1165 | 431 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 19672052 | 19672052 | PRJNA561212_P_NODE_7176_length_410_cov_3.824926_g6965_i0 | PRJNA561212 | 7176 | 410 | 3.824926 | 15.6821966 | brine shrimp yue-like virus 7 | 2900459 | Viruses | Viruses | 734 | 0 | NTclustered | gi|2209095276|gb|OL472842.1| | 2900459 | g6965 | i0 | 99.751 | 4.89024390243902 | 401 | 0 | 98 | 1 | 10 | 410 | 7452 | 7851 | MAG: Brine shrimp yue-like virus 7 isolate BH/15 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 2005 | 734 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | brine shrimp yue-like virus 7 | |||
| 20947406 | 20947406 | PRJNA561212_P_NODE_12077_length_320_cov_0.910931_g11866_i0 | PRJNA561212 | 12077 | 320 | 0.910931 | 2.9149792 | Artemvirus bsafialis | 3426459 | Viruses | Viruses | 525 | 1.4699999999999994e-144 | NTclustered | gi|2209095102|gb|OL472401.1| | 2900376 | g11866 | i0 | 97.712 | 14.34375 | 306 | 6 | 95 | 1 | 10 | 314 | 624 | 319 | MAG: Brine shrimp arlivirus 1 isolate GSL/15 hypothetical protein and RNA-dependent RNA polymerase genes, complete cds | blastn | 4590 | 525 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsafialis | ||
| 30710972 | 30710972 | PRJNA561212_P_NODE_16334_length_280_cov_1.091787_g16123_i0 | PRJNA561212 | 16334 | 280 | 1.091787 | 3.0570036 | Hangzhou nephotettix cincticeps phenuivirus 1 | 2905447 | Viruses | Viruses | 71.2 | 5.74e-12 | NR | UHK03292.1 | 2905447 | g16123 | i0 | 45.3 | 0.685714285714286 | 64 | 35 | 68.6 | 0 | 208 | 17 | 1554 | 1617 | UHK03292.1 MAG: RNA-dependent RNA polymerase [Hangzhou nephotettix cincticeps phenuivirus 1] | diamond | 192 | 71.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Hangzhou nephotettix cincticeps phenuivirus 1 | |||
| 31975656 | 31975656 | PRJNA561212_P_NODE_1898_length_787_cov_30.278711_g1707_i0 | PRJNA561212 | 1898 | 787 | 30.278711 | 238.29345557 | Frijoles virus VP-161A | 426788 | Viruses | Viruses | 71.6 | 1.52e-11 | NR | YP_009665189.1 | 426788 | g1707 | i0 | 38.7 | 1.13214739517154 | 111 | 66 | 42.3 | 1 | 158 | 490 | 27 | 135 | YP_009665189.1 N protein, partial [Frijoles virus VP-161A] | diamond | 891 | 71.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Bunyaviricetes | Hareavirales | Phenuiviridae | Phlebovirus | Phlebovirus limboense | ||
| 32292475 | 32292475 | PRJNA561212_P_NODE_2199_length_735_cov_1.321752_g2002_i0 | PRJNA561212 | 2199 | 735 | 1.321752 | 9.7148772 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 89 | 4.23e-16 | NR | XCO56027.1 | 3233859 | g2002 | i0 | 30.4 | 1.66530612244898 | 204 | 130 | 83.3 | 2 | 114 | 725 | 575 | 766 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 1224 | 89 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 32418748 | 32418748 | PRJNA561212_P_NODE_5659_length_465_cov_0.920918_g5448_i0 | PRJNA561212 | 5659 | 465 | 0.920918 | 4.2822687 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 284 | 1.13e-92 | NR | UNI74140.1 | 2900384 | g5448 | i0 | 92.8 | 1.96129032258065 | 152 | 11 | 98.1 | 0 | 10 | 465 | 198 | 349 | UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 912 | 284 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 |
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);;