contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1693469 | 1693469 | PRJNA414036_P_NODE_11242_length_420_cov_6.002597_g9673_i0 | PRJNA414036 | 11242 | 420 | 6.002597 | 25.2109074 | Leviviridae sp. | 2027243 | Viruses | Viruses | 73.1 | 3.1e-8 | NTclustered | gi|2245488133|gb|ON163175.1| | 2027243 | g9673 | i0 | 95.556 | 0.214285714285714 | 45 | 2 | 11 | 0 | 366 | 410 | 513 | 469 | MAG: Leviviridae sp. isolate 216-k141_148721 RNA dependent RNA polymerase gene, partial cds | blastn | 90 | 73.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 4245876 | 4245876 | PRJNA414036_P_NODE_59424_length_218_cov_722.207650_g57685_i0 | PRJNA414036 | 59424 | 218 | 722.20765 | 1574.412677 | Chrocagost virus | 3129398 | Viruses | Viruses | 278 | 2.92e-70 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g57685 | i0 | 89.862 | 131.54128440367 | 217 | 21 | 99 | 1 | 1 | 216 | 5642 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 28676 | 278 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 5522556 | 5522556 | PRJNA414036_P_NODE_47745_length_231_cov_2.647959_g46006_i0 | PRJNA414036 | 47745 | 231 | 2.647959 | 6.11678529 | Ilarvirus PDV | 3429929 | Viruses | Viruses | 122 | 1.55e-23 | NTclustered | gi|2313615853|gb|MZ443800.1| | 33760 | g46006 | i0 | 100 | 18.6363636363636 | 66 | 0 | 29 | 0 | 10 | 75 | 297 | 362 | Prune dwarf virus isolate Zvin38 movement protein gene, partial cds | blastn | 4305 | 122 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Bromoviridae | Ilarvirus | Ilarvirus PDV | ||
| 6796489 | 6796489 | PRJNA414036_P_NODE_37526_length_241_cov_2.456311_g35787_i0 | PRJNA414036 | 37526 | 241 | 2.456311 | 5.91970951 | Qianjiang picorna-like virus 58 | 3348785 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2806504082|gb|PQ055384.1| | 3348785 | g35787 | i0 | 100 | 0.120331950207469 | 29 | 0 | 12 | 0 | 91 | 119 | 7502 | 7530 | MAG: Qianjiang picorna-like virus 58 isolate QJ5MG2125 genomic sequence | blastn | 29 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Qianjiang picorna-like virus 58 | ||||
| 8071956 | 8071956 | PRJNA414036_P_NODE_18347_length_350_cov_869.266667_g16630_i0 | PRJNA414036 | 18347 | 350 | 869.266667 | 3042.4333345 | Chrocagost virus | 3129398 | Viruses | Viruses | 355 | 2.25e-93 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g16630 | i0 | 85.227 | 98.28 | 352 | 45 | 99 | 7 | 1 | 348 | 5510 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 34398 | 355 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 11897497 | 11897497 | PRJNA414036_P_NODE_11250_length_420_cov_5.283117_g9680_i0 | PRJNA414036 | 11250 | 420 | 5.283117 | 22.1890914 | Leviviridae sp. | 2027243 | Viruses | Viruses | 73.1 | 3.1e-8 | NTclustered | gi|2245488133|gb|ON163175.1| | 2027243 | g9680 | i0 | 95.556 | 0.214285714285714 | 45 | 2 | 11 | 0 | 366 | 410 | 513 | 469 | MAG: Leviviridae sp. isolate 216-k141_148721 RNA dependent RNA polymerase gene, partial cds | blastn | 90 | 73.1 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 13172389 | 13172389 | PRJNA414036_P_NODE_1571_length_666_cov_4.564184_g1247_i0 | PRJNA414036 | 1571 | 666 | 4.564184 | 30.39746544 | Chronagark virus | 3129972 | Viruses | Viruses | 65.8 | 8.52e-6 | NTclustered | gi|2717318772|gb|PP172369.1| | 3129972 | g1247 | i0 | 97.368 | 0.0570570570570571 | 38 | 1 | 6 | 0 | 438 | 475 | 1467 | 1430 | MAG: Chronagark virus isolate CN1C_k141_71069 genomic sequence | blastn | 38 | 65.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronagark virus | |||||
| 19544535 | 19544535 | PRJNA414036_P_NODE_33876_length_255_cov_505.886364_g32140_i0 | PRJNA414036 | 33876 | 255 | 505.886364 | 1290.0102282 | Chrocagost virus | 3129398 | Viruses | Viruses | 302 | 2.08e-77 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g32140 | i0 | 88.189 | 1006.9568627451 | 254 | 29 | 99 | 1 | 3 | 255 | 5858 | 5605 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 256774 | 302 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 20820421 | 20820421 | PRJNA414036_P_NODE_37257_length_242_cov_2.647343_g35518_i0 | PRJNA414036 | 37257 | 242 | 2.647343 | 6.40657006 | Leviviridae sp. | 2027243 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2245489310|gb|ON163778.1| | 2027243 | g35518 | i0 | 96.875 | 0.132231404958678 | 32 | 0 | 13 | 1 | 180 | 211 | 790 | 760 | MAG: Leviviridae sp. isolate 16-k141_697099 RNA dependent RNA polymerase gene, partial cds | blastn | 32 | 52.8 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Norzivirales | Fiersviridae | Leviviridae sp. | |||
| 22095150 | 22095150 | PRJNA414036_P_NODE_33878_length_255_cov_432.422727_g32142_i0 | PRJNA414036 | 33878 | 255 | 432.422727 | 1102.67795385 | Chrocagost virus | 3129398 | Viruses | Viruses | 296 | 9.69e-76 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g32142 | i0 | 87.795 | 73.843137254902 | 254 | 30 | 99 | 1 | 1 | 253 | 5605 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 18830 | 296 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 23370805 | 23370805 | PRJNA414036_P_NODE_33879_length_255_cov_354.318182_g32143_i0 | PRJNA414036 | 33879 | 255 | 354.318182 | 903.5113641 | Chrocagost virus | 3129398 | Viruses | Viruses | 274 | 4.54e-69 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g32143 | i0 | 86.275 | 28.6901960784314 | 255 | 32 | 99 | 3 | 1 | 253 | 5605 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 7316 | 274 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus | |||||
| 23370912 | 23370912 | PRJNA414036_P_NODE_70319_length_182_cov_410.367347_g68580_i0 | PRJNA414036 | 70319 | 182 | 410.367347 | 746.86857154 | Chrocagost virus | 3129398 | Viruses | Viruses | 183 | 5.259999999999998e-42 | NTclustered | gi|2717317482|gb|PP171846.1| | 3129398 | g68580 | i0 | 85.083 | 19.7802197802198 | 181 | 26 | 99 | 1 | 1 | 180 | 5678 | 5858 | MAG: Chrocagost virus isolate CC1A_k141_84256 genomic sequence | blastn | 3600 | 183 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagost virus |
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);;