contig_metadata
9 rows where bioproject = "PRJNA376117" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 399777 | 399777 | PRJNA376117_P_NODE_20741_length_303_cov_1.982609_g20439_i0 | PRJNA376117 | 20741 | 303 | 1.982609 | 6.00730527 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 560 | 3.79e-155 | NTclustered | gi|566129537|gb|KF709431.1| | 11636 | g20439 | i0 | 100 | 74.009900990099 | 303 | 0 | 100 | 0 | 1 | 303 | 4696 | 4394 | Reticuloendotheliosis virus strain GD1210, complete genome | blastn | 22425 | 560 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 2950761 | 2950761 | PRJNA376117_P_NODE_5083_length_605_cov_1.148496_g4789_i0 | PRJNA376117 | 5083 | 605 | 1.148496 | 6.9484008 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 1081 | 0 | NTclustered | gi|1061489859|gb|KX278301.1| | 11636 | g4789 | i0 | 99.008 | 121.659504132231 | 605 | 2 | 100 | 1 | 1 | 605 | 8353 | 7753 | Reticuloendotheliosis virus strain IBD-C1605, complete genome | blastn | 73604 | 1081 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 4226937 | 4226937 | PRJNA376117_P_NODE_2144_length_1029_cov_1.839958_g1902_i0 | PRJNA376117 | 2144 | 1029 | 1.839958 | 18.93316782 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 1901 | 0 | NTclustered | gi|71980392|gb|DQ003591.1| | 11636 | g1902 | i0 | 100 | 75.488824101069 | 1029 | 0 | 100 | 0 | 1 | 1029 | 2564 | 1536 | Reticuloendotheliosis virus strain SNV from USA, complete genome | blastn | 77678 | 1901 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 4227321 | 4227321 | PRJNA376117_P_NODE_6084_length_546_cov_1.816068_g5784_i0 | PRJNA376117 | 6084 | 546 | 1.816068 | 9.91573128 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 1003 | 0 | NTclustered | gi|1230848978|gb|MF372700.1| | 11636 | g5784 | i0 | 99.817 | 100.001831501832 | 546 | 1 | 100 | 0 | 1 | 546 | 989 | 444 | Reticuloendotheliosis virus strain SDAURS10 envelope glycoprotein (env) gene, complete cds | blastn | 54601 | 1003 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 4901772 | 4901772 | PRJNA376117_P_NODE_6504_length_527_cov_1.691630_g6204_i0 | PRJNA376117 | 6504 | 527 | 1.69163 | 8.9148901 | Gammaretrovirus | 153135 | Viruses | Viruses | 974 | 0 | NTclustered | gi|1493074649|gb|MH186051.1| | 11636 | g6204 | i0 | 100 | 99.988614800759 | 527 | 0 | 100 | 0 | 1 | 527 | 1175 | 1701 | Reticuloendotheliosis virus strain REV-Hebei2 envelope glycoprotein (env) gene, complete cds | blastn | 52694 | 974 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 10603387 | 10603387 | PRJNA376117_P_NODE_10949_length_407_cov_1.607784_g10647_i0 | PRJNA376117 | 10949 | 407 | 1.607784 | 6.54368088 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 752 | 0 | NTclustered | gi|71980392|gb|DQ003591.1| | 11636 | g10647 | i0 | 100 | 87.2334152334152 | 407 | 0 | 100 | 0 | 1 | 407 | 3298 | 2892 | Reticuloendotheliosis virus strain SNV from USA, complete genome | blastn | 35504 | 752 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 16977287 | 16977287 | PRJNA376117_P_NODE_32754_length_254_cov_2.209945_g32452_i0 | PRJNA376117 | 32754 | 254 | 2.209945 | 5.6132603 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 470 | 5.37e-128 | NTclustered | gi|566129537|gb|KF709431.1| | 11636 | g32452 | i0 | 100 | 81.9685039370079 | 254 | 0 | 100 | 0 | 1 | 254 | 4859 | 5112 | Reticuloendotheliosis virus strain GD1210, complete genome | blastn | 20820 | 470 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 24025422 | 24025422 | PRJNA376117_P_NODE_27019_length_276_cov_1.137931_g26717_i0 | PRJNA376117 | 27019 | 276 | 1.137931 | 3.14068956 | Gammaretrovirus | 153135 | Viruses | Viruses | 510 | 3.48e-140 | NTclustered | gi|71980392|gb|DQ003591.1| | 11636 | g26717 | i0 | 100 | 80.9710144927536 | 276 | 0 | 100 | 0 | 1 | 276 | 3804 | 4079 | Reticuloendotheliosis virus strain SNV from USA, complete genome | blastn | 22348 | 510 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend | ||
| 24626268 | 24626268 | PRJNA376117_P_NODE_37260_length_248_cov_0.880000_g36958_i0 | PRJNA376117 | 37260 | 248 | 0.88 | 2.1824 | Gammaretrovirus aviretend | 3428948 | Viruses | Viruses | 459 | 1.13e-124 | NTclustered | gi|71980392|gb|DQ003591.1| | 11636 | g36958 | i0 | 100 | 80.9758064516129 | 248 | 0 | 100 | 0 | 1 | 248 | 5668 | 5421 | Reticuloendotheliosis virus strain SNV from USA, complete genome | blastn | 20082 | 459 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus aviretend |
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);;