contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_phylum = "Negarnaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26591028 | 26591028 | PRJNA1008624_P_NODE_33041_length_165_cov_0.896552_g32853_i0 | PRJNA1008624 | 33041 | 165 | 0.896552 | 1.4793108 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 83.6 | 5.19e-17 | NR | WLN26256.1 | 3065075 | g32853 | i0 | 66 | 0.963636363636364 | 53 | 18 | 96.4 | 0 | 163 | 5 | 774 | 826 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 159 | 83.6 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 27128868 | 27128868 | PRJNA1008624_P_NODE_12942_length_233_cov_1.489130_g12754_i0 | PRJNA1008624 | 12942 | 233 | 1.48913 | 3.4696729 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 80.1 | 3.26e-17 | NR | UNI74142.1 | 2900384 | g12754 | i0 | 89.7 | 0.502145922746781 | 39 | 4 | 50.2 | 0 | 118 | 2 | 1 | 39 | UNI74142.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 117 | 80.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 27287354 | 27287354 | PRJNA1008624_P_NODE_25383_length_174_cov_1.192000_g25195_i0 | PRJNA1008624 | 25383 | 174 | 1.192 | 2.07408 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 85.1 | 1.64e-17 | NR | UNI74141.1 | 2900384 | g25195 | i0 | 70.2 | 0.982758620689655 | 57 | 17 | 98.3 | 0 | 2 | 172 | 109 | 165 | UNI74141.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 171 | 85.1 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 27406542 | 27406542 | PRJNA1008624_P_NODE_7363_length_309_cov_1.938462_g7175_i0 | PRJNA1008624 | 7363 | 309 | 1.938462 | 5.98984758 | Lispiviridae | 2501987 | Viruses | Viruses | 179 | 2.22e-52 | NR | UNI74075.1 | 2900377 | g7175 | i0 | 87.1 | 1.97087378640777 | 101 | 13 | 98.1 | 0 | 2 | 304 | 296 | 396 | UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2] | diamond | 609 | 180 | 0.994444444444444 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasecalis | ||
| 27540140 | 27540140 | PRJNA1008624_P_NODE_44_length_3555_cov_11.155448_g28_i0 | PRJNA1008624 | 44 | 3555 | 11.155448 | 396.5761764 | Fusarium culmorum yue-like virus 1 | 3233859 | Viruses | Viruses | 345 | 1.49e-97 | NR | XCO56027.1 | 3233859 | g28 | i0 | 27.3 | 1.68945147679325 | 950 | 637 | 79.4 | 16 | 3137 | 315 | 86 | 990 | XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] | diamond | 6006 | 345 | 1 | Viruses | Orthornavirae | Negarnaviricota | Yunchangviricetes | Goujianvirales | Yueviridae | Fusarium culmorum yue-like virus 1 | |||
| 28171506 | 28171506 | PRJNA1008624_P_NODE_12526_length_236_cov_2.443850_g12338_i0 | PRJNA1008624 | 12526 | 236 | 2.44385 | 5.767486 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 155 | 1.1e-41 | NR | UNI74144.1 | 2900384 | g12338 | i0 | 97.4 | 0.978813559322034 | 77 | 2 | 97.9 | 0 | 3 | 233 | 1220 | 1296 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 231 | 155 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 29529331 | 29529331 | PRJNA1008624_P_NODE_9330_length_274_cov_1.462222_g9142_i0 | PRJNA1008624 | 9330 | 274 | 1.462222 | 4.00648828 | Salarius guttatus piscichuvirus | 2951531 | Viruses | Viruses | 54.3 | 4.67e-6 | NR | YP_010840939.1 | 2951531 | g9142 | i0 | 40.7 | 0.941605839416058 | 86 | 47 | 89.8 | 2 | 272 | 27 | 28 | 113 | YP_010840939.1 L protein [Hardyhead chuvirus] | diamond | 258 | 54.3 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | Salarius guttatus piscichuvirus | ||
| 29686810 | 29686810 | PRJNA1008624_P_NODE_7850_length_298_cov_1.642570_g7662_i0 | PRJNA1008624 | 7850 | 298 | 1.64257 | 4.8948586 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 164 | 1.26e-46 | NR | UNI74140.1 | 2900384 | g7662 | i0 | 83.3 | 1.93288590604027 | 96 | 16 | 96.6 | 0 | 292 | 5 | 1 | 96 | UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] | diamond | 576 | 164 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 29749963 | 29749963 | PRJNA1008624_P_NODE_4671_length_393_cov_1.648256_g4484_i0 | PRJNA1008624 | 4671 | 393 | 1.648256 | 6.47764608 | brine shrimp arlivirus 2 | 2900377 | Viruses | Viruses | 150 | 4.4e-40 | NR | UNI74076.1 | 2900377 | g4484 | i0 | 59.4 | 1.05343511450382 | 138 | 49 | 100 | 1 | 393 | 1 | 182 | 319 | UNI74076.1 MAG: hypothetical protein [brine shrimp arlivirus 2] | diamond | 414 | 150 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasecalis | ||
| 30097585 | 30097585 | PRJNA1008624_P_NODE_24892_length_175_cov_1.698413_g24704_i0 | PRJNA1008624 | 24892 | 175 | 1.698413 | 2.97222275 | brine shrimp arlivirus 2 | 2900377 | Viruses | Viruses | 112 | 7.5599999999999995e-28 | NR | UNI74075.1 | 2900377 | g24704 | i0 | 87.7 | 0.977142857142857 | 57 | 7 | 97.7 | 0 | 2 | 172 | 104 | 160 | UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2] | diamond | 171 | 112 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Artemvirus | Artemvirus bsasecalis | ||
| 30855951 | 30855951 | PRJNA1008624_P_NODE_25714_length_173_cov_1.209677_g25526_i0 | PRJNA1008624 | 25714 | 173 | 1.209677 | 2.09274121 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 120 | 6.1899999999999995e-30 | NR | UNI74144.1 | 2900384 | g25526 | i0 | 96.5 | 0.988439306358382 | 57 | 2 | 98.8 | 0 | 3 | 173 | 252 | 308 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 171 | 120 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 31203077 | 31203077 | PRJNA1008624_P_NODE_6035_length_342_cov_2.436860_g5847_i0 | PRJNA1008624 | 6035 | 342 | 2.43686 | 8.3340612 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 216 | 1.31e-62 | NR | UNI74144.1 | 2900384 | g5847 | i0 | 91.1 | 0.982456140350877 | 112 | 10 | 98.2 | 0 | 340 | 5 | 1050 | 1161 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 336 | 216 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 9 | ||
| 32152570 | 32152570 | PRJNA1008624_P_NODE_17378_length_204_cov_1.870968_g17190_i0 | PRJNA1008624 | 17378 | 204 | 1.870968 | 3.81677472 | African cichlid piscichuvirus | 3065075 | Viruses | Viruses | 63.2 | 1.4e-9 | NR | WLN26256.1 | 3065075 | g17190 | i0 | 51.8 | 0.823529411764706 | 56 | 27 | 82.4 | 0 | 200 | 33 | 179 | 234 | WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] | diamond | 168 | 63.2 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Piscichuvirus | African cichlid piscichuvirus | ||
| 32878670 | 32878670 | PRJNA1008624_P_NODE_10240_length_261_cov_1.339623_g10052_i0 | PRJNA1008624 | 10240 | 261 | 1.339623 | 3.49641603 | brine shrimp arlivirus 9 | 2900384 | Viruses | Viruses | 162 | 5.78e-44 | NR | UNI74144.1 | 2900384 | g10052 | i0 | 90.6 | 0.977011494252874 | 85 | 8 | 97.7 | 0 | 3 | 257 | 1741 | 1825 | UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] | diamond | 255 | 162 | 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);;