contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB15333" and tax_phylum = "Artverviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 985830 | 985830 | PRJEB15333_P_NODE_11461_length_201_cov_1.572368_g11377_i0 | PRJEB15333 | 11461 | 201 | 1.572368 | 3.16045968 | Alpharetrovirus | 153057 | Viruses | Viruses | 366 | 5.5e-97 | NTclustered | gi|407979|gb|L10923.1|MAVTYP1A2A | 31668 | g11377 | i0 | 99.502 | 99.6417910447761 | 201 | 1 | 100 | 0 | 1 | 201 | 1984 | 1784 | Myeloblastosis-associated virus type 1/2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds | blastn | 20028 | 366 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian myeloblastosis-associated virus | ||
| 2261124 | 2261124 | PRJEB15333_P_NODE_13782_length_185_cov_2.139706_g13698_i0 | PRJEB15333 | 13782 | 185 | 2.139706 | 3.9584561 | Alpharetrovirus | 153057 | Viruses | Viruses | 302 | 1.42e-77 | NTclustered | gi|308053557|gb|HM235670.1| | 11864 | g13698 | i0 | 96.196 | 98.6054054054054 | 184 | 7 | 99 | 0 | 2 | 185 | 2654 | 2471 | Avian leukosis virus isolate YZ9902, complete genome | blastn | 18242 | 302 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 2261128 | 2261128 | PRJEB15333_P_NODE_3382_length_343_cov_2.255102_g3298_i0 | PRJEB15333 | 3382 | 343 | 2.255102 | 7.73499986 | Alpharetrovirus | 153057 | Viruses | Viruses | 592 | 1.5499999999999996e-164 | NTclustered | gi|449139009|gb|KC149971.1| | 11864 | g3298 | i0 | 97.947 | 99.4256559766764 | 341 | 7 | 99 | 0 | 1 | 341 | 2011 | 2351 | Avian leukosis virus strain SCAU11-XG, complete genome | blastn | 34103 | 592 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 2571488 | 2571488 | PRJEB15333_P_NODE_14123_length_183_cov_2.328358_g14039_i0 | PRJEB15333 | 14123 | 183 | 2.328358 | 4.26089514 | Alpharetrovirus avileu | 3426267 | Viruses | Viruses | 329 | 6.43e-86 | NTclustered | gi|1041529576|gb|KU500038.1| | 11864 | g14039 | i0 | 99.448 | 98.9071038251366 | 181 | 1 | 99 | 0 | 3 | 183 | 4147 | 3967 | Avian leukosis virus isolate GD1411-1 envelope protein (env) and gag protein (gag) genes, complete cds; and pol protein (pol) gene, partial cds | blastn | 18100 | 329 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 3536435 | 3536435 | PRJEB15333_P_NODE_15583_length_175_cov_1.658730_g15499_i0 | PRJEB15333 | 15583 | 175 | 1.65873 | 2.9027775 | Alpharetrovirus | 153057 | Viruses | Viruses | 300 | 4.77e-77 | NTclustered | gi|345050319|dbj|AB522906.1| | 11864 | g15499 | i0 | 97.701 | 99.4285714285714 | 174 | 4 | 99 | 0 | 1 | 174 | 4539 | 4366 | Avian leukosis virus proviral DNA, complete genome | blastn | 17400 | 300 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 3847803 | 3847803 | PRJEB15333_P_NODE_1464_length_486_cov_5.249428_g1384_i0 | PRJEB15333 | 1464 | 486 | 5.249428 | 25.51222008 | Tasmanian devil retrovirus | 1332312 | Viruses | Viruses | 787 | 0 | NTclustered | gi|618757818|gb|KC845928.1| | 1332312 | g1384 | i0 | 95.902 | 100.954732510288 | 488 | 17 | 99 | 2 | 2 | 486 | 2063 | 1576 | Tasmanian devil retrovirus strain DRV2010 polymerase (pol) and envelope protein (env) genes, partial cds | blastn | 49064 | 787 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Tasmanian devil retrovirus | ||
| 5124023 | 5124023 | PRJEB15333_P_NODE_9285_length_221_cov_8.500000_g9201_i0 | PRJEB15333 | 9285 | 221 | 8.5 | 18.785 | Avian myeloblastosis-associated virus | 11960 | Viruses | Viruses | 298 | 2.28e-76 | NTclustered | gi|407987|gb|L10924.1|MAVTYP2AAA | 31670 | g9201 | i0 | 91.855 | 30.262443438914 | 221 | 6 | 100 | 1 | 1 | 221 | 7512 | 7304 | Myeloblastosis-associated virus type 2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds | blastn | 6688 | 298 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian myeloblastosis-associated virus | ||
| 7363537 | 7363537 | PRJEB15333_P_NODE_866_length_602_cov_4.054250_g793_i0 | PRJEB15333 | 866 | 602 | 4.05425 | 24.406585 | Alpharetrovirus | 153057 | Viruses | Viruses | 1042 | 0 | NTclustered | gi|407979|gb|L10923.1|MAVTYP1A2A | 31668 | g793 | i0 | 97.851 | 100.5 | 605 | 10 | 100 | 1 | 1 | 602 | 1342 | 738 | Myeloblastosis-associated virus type 1/2 env gene, complete cds; gag gene, complete cds; pol gene, 3' end of cds | blastn | 60501 | 1042 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian myeloblastosis-associated virus | ||
| 8948623 | 8948623 | PRJEB15333_P_NODE_7268_length_247_cov_1.919192_g7184_i0 | PRJEB15333 | 7268 | 247 | 1.919192 | 4.74040424 | Alpharetrovirus avileu | 3426267 | Viruses | Viruses | 429 | 8.83e-116 | NTclustered | gi|2654355796|gb|OR670961.1| | 11864 | g7184 | i0 | 97.976 | 99.9959514170041 | 247 | 5 | 100 | 0 | 1 | 247 | 2608 | 2854 | Avian leukosis virus strain CH/JXND2101, complete genome | blastn | 24699 | 429 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 9914005 | 9914005 | PRJEB15333_P_NODE_21948_length_151_cov_20.303922_g21864_i0 | PRJEB15333 | 21948 | 151 | 20.303922 | 30.65892222 | root | 1 | Root_unresolved | Root_unresolved | 278 | 1.87e-70 | NTclustered | gi|699361943|gb|KM376510.1| | 11864 | g21864 | i0 | 100 | 99.3509933774834 | 150 | 0 | 99 | 0 | 2 | 151 | 4560 | 4709 | Avian leukosis virus isolate HLJ13SH01, complete genome | blastn | 15002 | 278 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avileu | ||
| 10224371 | 10224371 | PRJEB15333_P_NODE_9289_length_221_cov_6.843023_g9205_i0 | PRJEB15333 | 9289 | 221 | 6.843023 | 15.12308083 | Alpharetrovirus avimyebla | 3426268 | Viruses | Viruses | 344 | 2.8899999999999993e-90 | NTclustered | gi|210085|gb|M24159.1|ALMAMV | 11866 | g9205 | i0 | 96.618 | 93.6018099547511 | 207 | 7 | 94 | 0 | 3 | 209 | 402 | 196 | Avian myeloblastosis virus polymerase gene, 3' end and transforming protein gene, complete cds | blastn | 20686 | 344 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Alpharetrovirus avimyebla | ||
| 12465004 | 12465004 | PRJEB15333_P_NODE_21990_length_151_cov_4.166667_g21906_i0 | PRJEB15333 | 21990 | 151 | 4.166667 | 6.29166717 | Alpharetrovirus | 153057 | Viruses | Viruses | 261 | 1.88e-65 | NTclustered | gi|407983|gb|L10922.1|MAVTYP1AAA | 31669 | g21906 | i0 | 98.639 | 93.7483443708609 | 147 | 2 | 97 | 0 | 5 | 151 | 7152 | 7006 | Avian myeloblastosis-associated virus type 1 env (env) and gag (gag) genes, complete cds; and pol (pol) gene, partial cds | blastn | 14156 | 261 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Alpharetrovirus | Avian myeloblastosis-associated 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);;