contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax_kingdom = "Pararnavirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2054139 | 2054139 | PRJNA793147_P_NODE_57762_length_229_cov_1.437500_g57496_i0 | PRJNA793147 | 57762 | 229 | 1.4375 | 3.291875 | Lentivirus capartenc | 3418647 | Viruses | Viruses | 195 | 3.21e-45 | NTclustered | gi|1009428314|gb|KT898826.1| | 254355 | g57496 | i0 | 82.231 | 27.5414847161572 | 242 | 28 | 100 | 10 | 1 | 229 | 8802 | 9041 | Small ruminant lentivirus isolate Jord1, complete genome | blastn | 6307 | 195 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus capartenc | ||
| 4606063 | 4606063 | PRJNA793147_P_NODE_31284_length_299_cov_2.004348_g31018_i0 | PRJNA793147 | 31284 | 299 | 2.004348 | 5.99300052 | Lentivirus capartenc | 3418647 | Viruses | Viruses | 318 | 2.48e-82 | NTclustered | gi|1669294867|gb|MK503987.1| | 254355 | g31018 | i0 | 92.727 | 58.7190635451505 | 220 | 16 | 74 | 0 | 1 | 220 | 220 | 1 | Small ruminant lentivirus gag protein gene, partial cds | blastn | 17557 | 318 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus capartenc | ||
| 7156472 | 7156472 | PRJNA793147_P_NODE_51426_length_235_cov_0.867470_g51160_i0 | PRJNA793147 | 51426 | 235 | 0.86747 | 2.0385545 | Badnavirus alphananas | 3048270 | Viruses | Viruses | 407 | 3.9e-109 | NTclustered | gi|1827635586|dbj|LC507821.1| | 2033633 | g51160 | i0 | 97.872 | 5.34042553191489 | 235 | 5 | 100 | 0 | 1 | 235 | 5073 | 4839 | Pineapple bacilliform CO virus PBCOV genomic RNA, complete genome | blastn | 1255 | 407 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Badnavirus alphananas | ||
| 8430933 | 8430933 | PRJNA793147_P_NODE_36867_length_277_cov_1.216346_g36601_i0 | PRJNA793147 | 36867 | 277 | 1.216346 | 3.36927842 | Badnavirus alphananas | 3048270 | Viruses | Viruses | 462 | 9.929999999999999e-126 | NTclustered | gi|1827635586|dbj|LC507821.1| | 2033633 | g36601 | i0 | 96.751 | 3.93140794223827 | 277 | 9 | 100 | 0 | 1 | 277 | 4112 | 3836 | Pineapple bacilliform CO virus PBCOV genomic RNA, complete genome | blastn | 1089 | 462 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Badnavirus | Badnavirus alphananas | ||
| 8431174 | 8431174 | PRJNA793147_P_NODE_50007_length_237_cov_1.154762_g49741_i0 | PRJNA793147 | 50007 | 237 | 1.154762 | 2.73678594 | Lentivirus capartenc | 3418647 | Viruses | Viruses | 276 | 1.16e-69 | NTclustered | gi|2872231180|gb|PP278022.1| | 254355 | g49741 | i0 | 88.261 | 38.8607594936709 | 230 | 27 | 97 | 0 | 6 | 235 | 283 | 512 | Small ruminant lentivirus isolate 13 gag polyprotein gene, partial cds | blastn | 9210 | 276 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus capartenc | ||
| 10981460 | 10981460 | PRJNA793147_P_NODE_21549_length_359_cov_1.700000_g21283_i0 | PRJNA793147 | 21549 | 359 | 1.7 | 6.103 | Lentivirus ovivismae | 3418652 | Viruses | Viruses | 431 | 3.74e-116 | NTclustered | gi|2716369137|gb|PP591900.1| | 2169971 | g21283 | i0 | 88.301 | 2.008356545961 | 359 | 42 | 100 | 0 | 1 | 359 | 5590 | 5948 | Visna-maedi virus isolate MVV-NM1, complete genome | blastn | 721 | 431 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus ovivismae | ||
| 10982365 | 10982365 | PRJNA793147_P_NODE_9_length_7916_cov_21.465273_g8_i0 | PRJNA793147 | 9 | 7916 | 21.465273 | 1699.19101068 | RD114 retrovirus | 11834 | Viruses | Viruses | 14229 | 0 | NTclustered | gi|306482054|dbj|AB559882.1| | 11834 | g8 | i0 | 99.922 | 63.7623799898939 | 7723 | 6 | 100 | 0 | 1 | 7723 | 593 | 8315 | RD114 retrovirus proviral DNA, complete genome, strain: CRT1 | blastn | 504743 | 14229 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | RD114 retrovirus | ||
| 13969795 | 13969795 | PRJNA793147_P_NODE_30011_length_305_cov_1.525424_g29745_i0 | PRJNA793147 | 30011 | 305 | 1.525424 | 4.6525432 | root | 1 | Root_unresolved | Root_unresolved | 503 | 6.53e-138 | NTclustered | gi|6911273|gb|AF228550.1|AF228550 | 114183 | g29745 | i0 | 96.393 | 23.2754098360656 | 305 | 11 | 100 | 0 | 1 | 305 | 3657 | 3353 | Endogenous mouse mammary tumor virus Mtv1 complete proviral genome | blastn | 7099 | 503 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 16080407 | 16080407 | PRJNA793147_P_NODE_42733_length_258_cov_1.338624_g42467_i0 | PRJNA793147 | 42733 | 258 | 1.338624 | 3.45364992 | Lentivirus capartenc | 3418647 | Viruses | Viruses | 219 | 2.19e-52 | NTclustered | gi|1009428314|gb|KT898826.1| | 254355 | g42467 | i0 | 82.946 | 1 | 258 | 28 | 95 | 11 | 3 | 247 | 9054 | 8800 | Small ruminant lentivirus isolate Jord1, complete genome | blastn | 258 | 219 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus capartenc | ||
| 18628972 | 18628972 | PRJNA793147_P_NODE_14055_length_454_cov_2.296104_g13789_i0 | PRJNA793147 | 14055 | 454 | 2.296104 | 10.42431216 | Lentivirus ovivismae | 3418652 | Viruses | Viruses | 529 | 1.6699999999999992e-145 | NTclustered | gi|2716369137|gb|PP591900.1| | 2169971 | g13789 | i0 | 87.665 | 2 | 454 | 56 | 100 | 0 | 1 | 454 | 6742 | 7195 | Visna-maedi virus isolate MVV-NM1, complete genome | blastn | 908 | 529 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus ovivismae | ||
| 19904200 | 19904200 | PRJNA793147_P_NODE_16696_length_412_cov_1.848397_g16430_i0 | PRJNA793147 | 16696 | 412 | 1.848397 | 7.61539564 | Lentivirus ovivismae | 3418652 | Viruses | Viruses | 318 | 3.54e-82 | NTclustered | gi|2029767964|gb|MW248464.1| | 2169971 | g16430 | i0 | 83.578 | 0.827669902912621 | 341 | 54 | 83 | 2 | 64 | 403 | 6127 | 6466 | Visna-maedi virus strain NM1111, complete genome | blastn | 341 | 318 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus ovivismae | ||
| 21180222 | 21180222 | PRJNA793147_P_NODE_32437_length_294_cov_1.751111_g32171_i0 | PRJNA793147 | 32437 | 294 | 1.751111 | 5.14826634 | Lentivirus ovivismae | 3418652 | Viruses | Viruses | 433 | 8.34e-117 | NTclustered | gi|2716369137|gb|PP591900.1| | 2169971 | g32171 | i0 | 93.197 | 10.608843537415 | 294 | 20 | 100 | 0 | 1 | 294 | 8313 | 8020 | Visna-maedi virus isolate MVV-NM1, complete genome | blastn | 3119 | 433 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus ovivismae | ||
| 23730800 | 23730800 | PRJNA793147_P_NODE_45639_length_249_cov_1.600000_g45373_i0 | PRJNA793147 | 45639 | 249 | 1.6 | 3.984 | Lentivirus ovivismae | 3418652 | Viruses | Viruses | 326 | 1.2e-84 | NTclustered | gi|2716369137|gb|PP591900.1| | 2169971 | g45373 | i0 | 90.323 | 0.995983935742972 | 248 | 24 | 99 | 0 | 2 | 249 | 5612 | 5365 | Visna-maedi virus isolate MVV-NM1, complete genome | blastn | 248 | 326 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Lentivirus | Lentivirus ovivismae |
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);;