contig_metadata
11 rows where bioproject = "PRJNA1008624" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2704715 | 2704715 | PRJNA1008624_P_NODE_34483_length_164_cov_0.878261_g34295_i0 | PRJNA1008624 | 34483 | 164 | 0.878261 | 1.44034804 | brine shrimp partiti-like virus 2 | 2900389 | Viruses | Viruses | 294 | 2.06e-75 | NTclustered | gi|2209094841|gb|OL472492.1| | 2900389 | g34295 | i0 | 99.383 | 10.8231707317073 | 162 | 1 | 99 | 0 | 1 | 162 | 1306 | 1145 | MAG: Brine shrimp partiti-like virus 2 isolate SD/10-12 segment 4 hypothetical protein gene, complete cds | blastn | 1775 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 2 | |||
| 6532158 | 6532158 | PRJNA1008624_P_NODE_14926_length_218_cov_1.887574_g14738_i0 | PRJNA1008624 | 14926 | 218 | 1.887574 | 4.11491132 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 398 | 2.1499999999999996e-106 | NTclustered | gi|2209094901|gb|OL472522.1| | 2900391 | g14738 | i0 | 100 | 12.7752293577982 | 215 | 0 | 99 | 0 | 4 | 218 | 9 | 223 | MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2785 | 398 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 8654469 | 8654469 | PRJNA1008624_P_NODE_18367_length_199_cov_1.373333_g18179_i0 | PRJNA1008624 | 18367 | 199 | 1.373333 | 2.73293267 | Viruses | 10239 | Viruses | Viruses | 342 | 9.149999999999999e-90 | NTclustered | gi|2209094843|gb|OL472493.1| | 2900389 | g18179 | i0 | 98.454 | 9.74874371859296 | 194 | 3 | 97 | 0 | 4 | 197 | 1280 | 1473 | MAG: Brine shrimp partiti-like virus 2 isolate TJ/92-18 segment 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 1940 | 342 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 2 | |||
| 11204630 | 11204630 | PRJNA1008624_P_NODE_18449_length_199_cov_1.013333_g18261_i0 | PRJNA1008624 | 18449 | 199 | 1.013333 | 2.01653267 | Viruses | 10239 | Viruses | Viruses | 363 | 7.019999999999998e-96 | NTclustered | gi|2209094841|gb|OL472492.1| | 2900389 | g18261 | i0 | 100 | 10.7738693467337 | 196 | 0 | 98 | 0 | 1 | 196 | 948 | 753 | MAG: Brine shrimp partiti-like virus 2 isolate SD/10-12 segment 4 hypothetical protein gene, complete cds | blastn | 2144 | 363 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 2 | |||
| 11632985 | 11632985 | PRJNA1008624_P_NODE_28970_length_168_cov_0.873950_g28782_i0 | PRJNA1008624 | 28970 | 168 | 0.87395 | 1.468236 | brine shrimp partiti-like virus 4 | 2900391 | Viruses | Viruses | 294 | 2.12e-75 | NTclustered | gi|2209094901|gb|OL472522.1| | 2900391 | g28782 | i0 | 98.788 | 12.7678571428571 | 165 | 2 | 98 | 0 | 4 | 168 | 505 | 669 | MAG: Brine shrimp partiti-like virus 4 isolate SD/17-18 RNA-dependent RNA polymerase gene, complete cds | blastn | 2145 | 294 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Partitiviridae | brine shrimp partiti-like virus 4 | |||
| 27414009 | 27414009 | PRJNA1008624_P_NODE_18083_length_200_cov_2.410596_g17895_i0 | PRJNA1008624 | 18083 | 200 | 2.410596 | 4.821192 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 92.4 | 6.76e-20 | NR | XCM67741.1 | 3003959 | g17895 | i0 | 73 | 1.92 | 63 | 17 | 94.5 | 0 | 5 | 193 | 1934 | 1996 | XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 384 | 92.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 27666538 | 27666538 | PRJNA1008624_P_NODE_2724_length_523_cov_2.438819_g2544_i0 | PRJNA1008624 | 2724 | 523 | 2.438819 | 12.75502337 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 58.5 | 2.19e-6 | NR | XCM67741.1 | 3003959 | g2544 | i0 | 27 | 0.69980879541109 | 122 | 84 | 68.8 | 2 | 59 | 418 | 1060 | 1178 | XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] | diamond | 366 | 58.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 28266045 | 28266045 | PRJNA1008624_P_NODE_3866_length_436_cov_2.258398_g3680_i0 | PRJNA1008624 | 3866 | 436 | 2.258398 | 9.84661528 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 138 | 1.02e-34 | NR | UNY41988.1 | 3003959 | g3680 | i0 | 44.8 | 0.98394495412844 | 143 | 79 | 98.4 | 0 | 431 | 3 | 1173 | 1315 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 429 | 138 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 29560621 | 29560621 | PRJNA1008624_P_NODE_23930_length_178_cov_2.689922_g23742_i0 | PRJNA1008624 | 23930 | 178 | 2.689922 | 4.78806116 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 60.8 | 6.47e-9 | NR | XCM68142.1 | 3003959 | g23742 | i0 | 53.4 | 0.97752808988764 | 58 | 27 | 97.8 | 0 | 174 | 1 | 139 | 196 | XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 174 | 60.8 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31077305 | 31077305 | PRJNA1008624_P_NODE_11135_length_250_cov_1.711443_g10947_i0 | PRJNA1008624 | 11135 | 250 | 1.711443 | 4.2786075 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 127 | 6.749999999999999e-32 | NR | XCM68142.1 | 3003959 | g10947 | i0 | 71.3 | 1.92 | 80 | 23 | 96 | 0 | 248 | 9 | 237 | 316 | XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] | diamond | 480 | 127 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 31266856 | 31266856 | PRJNA1008624_P_NODE_9675_length_269_cov_1.527273_g9487_i0 | PRJNA1008624 | 9675 | 269 | 1.527273 | 4.10836437 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 62 | 8.78e-9 | NR | UNY41988.1 | 3003959 | g9487 | i0 | 44.9 | 1.97397769516729 | 89 | 40 | 93.7 | 4 | 257 | 6 | 85 | 169 | UNY41988.1 MAG: polyprotein [Picornavirales sp.] | diamond | 531 | 62 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 |
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);;