contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA811725" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1224138 | 1224138 | PRJNA811725_P_NODE_41881_length_241_cov_0.916667_g41635_i0 | PRJNA811725 | 41881 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 446 | 8.519999999999999e-121 | NTclustered | gi|717462921|gb|KM390026.1| | 11676 | g41635 | i0 | 100 | 99.9958506224066 | 241 | 0 | 100 | 0 | 1 | 241 | 6342 | 6102 | HIV-1 clone NL43I151V from USA, complete genome | blastn | 24099 | 446 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus humimdef1 | ||
| 3776095 | 3776095 | PRJNA811725_P_NODE_803_length_1307_cov_2.166126_g713_i0 | PRJNA811725 | 803 | 1307 | 2.166126 | 28.31126682 | root | 1 | Root_unresolved | Root_unresolved | 2403 | 0 | NTclustered | gi|6274514|gb|L03561.2|HL1RHK30X | 11908 | g713 | i0 | 99.847 | 99.9938791124713 | 1307 | 2 | 100 | 0 | 1 | 1307 | 3742 | 2436 | Human T Cell Lymphotropic Virus I complete genome | blastn | 130692 | 2403 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Deltaretrovirus | Deltaretrovirus priTlym1 | ||
| 5913363 | 5913363 | PRJNA811725_P_NODE_28245_length_291_cov_1.573394_g27999_i0 | PRJNA811725 | 28245 | 291 | 1.573394 | 4.57857654 | Meadowvirus AH04 | 3060193 | Viruses | Viruses | 217 | 9.03e-52 | NTclustered | gi|2438095778|ref|NC_070952.1| | 2869569 | g27999 | i0 | 84.071 | 2.02061855670103 | 226 | 34 | 77 | 2 | 67 | 291 | 242527 | 242303 | Erwinia phage AH04, complete genome | blastn | 588 | 217 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Chimalliviridae | Meadowvirus | Meadowvirus AH04 | |||
| 7188229 | 7188229 | PRJNA811725_P_NODE_30966_length_280_cov_1.743961_g30720_i0 | PRJNA811725 | 30966 | 280 | 1.743961 | 4.8830908 | Bacteriophage sp. | 38018 | Viruses | Viruses | 442 | 1.3099999999999994e-119 | NTclustered | gi|2050458957|tpg|BK016709.1| | 38018 | g30720 | i0 | 95.324 | 0.992857142857143 | 278 | 13 | 99 | 0 | 3 | 280 | 15171 | 14894 | MAG TPA_asm: Bacteriophage sp. isolate ctxSu10, partial genome | blastn | 278 | 442 | 1 | Viruses | Bacteriophage sp. | ||||||||
| 12289444 | 12289444 | PRJNA811725_P_NODE_9390_length_483_cov_1.553659_g9146_i0 | PRJNA811725 | 9390 | 483 | 1.553659 | 7.50417297 | Betanodavirus epinepheli | 3427237 | Viruses | Viruses | 893 | 0 | NTclustered | gi|156076357|gb|EF558368.1| | 43763 | g9146 | i0 | 100 | 98.0600414078675 | 483 | 0 | 100 | 0 | 1 | 483 | 2506 | 2988 | Redspotted grouper nervous necrosis virus isolate China 1 RNA-dependent RNA polymerase gene, complete cds | blastn | 47363 | 893 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Magsaviricetes | Nodamuvirales | Nodaviridae | Betanodavirus | Betanodavirus epinepheli | ||
| 13563620 | 13563620 | PRJNA811725_P_NODE_32391_length_273_cov_1.540000_g32145_i0 | PRJNA811725 | 32391 | 273 | 1.54 | 4.2042 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 353 | 6.14e-93 | NTclustered | gi|2053058458|tpg|BK024596.1| | 2832643 | g32145 | i0 | 90.11 | 57.2454212454212 | 273 | 26 | 100 | 1 | 1 | 273 | 5363 | 5092 | MAG TPA_asm: Caudoviricetes sp. isolate ctaIB11, partial genome | blastn | 15628 | 353 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 13977894 | 13977894 | PRJNA811725_P_NODE_32451_length_273_cov_1.210000_g32205_i0 | PRJNA811725 | 32451 | 273 | 1.21 | 3.3033 | Viruses | 10239 | Viruses | Viruses | 377 | 3.64e-100 | NTclustered | gi|2067460891|gb|MW677512.1| | 2835969 | g32205 | i0 | 91.667 | 10.6263736263736 | 276 | 17 | 100 | 4 | 1 | 273 | 41822 | 41550 | Rhodobacter phage RcFrancesLouise, complete genome | blastn | 2901 | 377 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodobacter phage RcFrancesLouise | |||||
| 14838069 | 14838069 | PRJNA811725_P_NODE_1632_length_1014_cov_1.851222_g1481_i0 | PRJNA811725 | 1632 | 1014 | 1.851222 | 18.77139108 | Deltaretrovirus priTlym1 | 3428212 | Viruses | Viruses | 1862 | 0 | NTclustered | gi|6274516|gb|L03562.2|HL1RHK34X | 11908 | g1481 | i0 | 99.803 | 99.9980276134122 | 1014 | 2 | 100 | 0 | 1 | 1014 | 2421 | 1408 | Human T cell lymphotrophic virus type I (HTLV-I) (gag, env, rex, tat) genes, complete cds; (pol) gene, 3' end | blastn | 101398 | 1862 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Deltaretrovirus | Deltaretrovirus priTlym1 | ||
| 14838152 | 14838152 | PRJNA811725_P_NODE_27152_length_296_cov_3.417040_g26906_i0 | PRJNA811725 | 27152 | 296 | 3.41704 | 10.1144384 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 143 | 1.59e-29 | NTclustered | gi|2914852300|gb|OR221708.1| | 2832643 | g26906 | i0 | 95.506 | 2.61824324324324 | 89 | 4 | 49 | 0 | 133 | 221 | 27661 | 27573 | MAG: Caudoviricetes sp. isolate MSP1326 genomic sequence | blastn | 775 | 143 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 17388340 | 17388340 | PRJNA811725_P_NODE_30474_length_282_cov_1.846890_g30228_i0 | PRJNA811725 | 30474 | 282 | 1.84689 | 5.2082298 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 499 | 7.729999999999999e-137 | NTclustered | gi|1939515391|gb|MT334616.1| | 39046 | g30228 | i0 | 98.582 | 17.6205673758865 | 282 | 4 | 100 | 0 | 1 | 282 | 2383 | 2102 | Cassava common mosaic virus isolate PisVera RdRp, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and CP genes, complete cds | blastn | 4969 | 499 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 19936669 | 19936669 | PRJNA811725_P_NODE_30816_length_281_cov_1.269231_g30570_i0 | PRJNA811725 | 30816 | 281 | 1.269231 | 3.56653911 | Rhodobacter phage RcKvothe | 2970517 | Viruses | Viruses | 385 | 2.25e-102 | NTclustered | gi|2284663167|gb|OP009275.1| | 2970517 | g30570 | i0 | 91.697 | 9.8576512455516 | 277 | 23 | 99 | 0 | 5 | 281 | 20077 | 19801 | Rhodobacter phage RcKvothe, complete genome | blastn | 2770 | 385 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Rhodobacter phage RcKvothe | |||||
| 23762571 | 23762571 | PRJNA811725_P_NODE_31839_length_276_cov_1.315271_g31593_i0 | PRJNA811725 | 31839 | 276 | 1.315271 | 3.63014796 | Potexvirus marmormanihotis | 3433851 | Viruses | Viruses | 505 | 1.62e-138 | NTclustered | gi|1939515391|gb|MT334616.1| | 39046 | g31593 | i0 | 99.638 | 9.01086956521739 | 276 | 1 | 100 | 0 | 1 | 276 | 231 | 506 | Cassava common mosaic virus isolate PisVera RdRp, triple gene block protein 1, triple gene block protein 2, triple gene block protein 3, and CP genes, complete cds | blastn | 2487 | 505 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus marmormanihotis | ||
| 23762614 | 23762614 | PRJNA811725_P_NODE_37199_length_249_cov_0.875000_g36953_i0 | PRJNA811725 | 37199 | 249 | 0.875 | 2.17875 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 270 | 5.72e-68 | NTclustered | gi|2056947620|tpg|BK022619.1| | 2832643 | g36953 | i0 | 89.352 | 1.85542168674699 | 216 | 21 | 86 | 2 | 1 | 215 | 13677 | 13463 | MAG TPA_asm: Caudoviricetes sp. isolate ctY7F3, partial genome | blastn | 462 | 270 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 24175630 | 24175630 | PRJNA811725_P_NODE_29579_length_286_cov_1.384977_g29333_i0 | PRJNA811725 | 29579 | 286 | 1.384977 | 3.96103422 | root | 1 | Root_unresolved | Root_unresolved | 156 | 1.96e-33 | NTclustered | gi|1147720577|gb|KX868451.1| | 10515 | g29333 | i0 | 87.879 | 45.3566433566434 | 132 | 16 | 46 | 0 | 1 | 132 | 759 | 890 | Human adenovirus 2 isolate GyK178 DNA polymerase, penton base, and hexon genes, partial cds | blastn | 12972 | 156 | 1 | Viruses | Bamfordvirae | Preplasmiviricota | Pharingeaviricetes | Rowavirales | Adenoviridae | Mastadenovirus | Mastadenovirus caesari |
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);;