contig_metadata
11 rows where bioproject = "PRJNA675042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2443419 | 2443419 | PRJNA675042_P_NODE_262_length_2325_cov_2.270426_g90_i1 | PRJNA675042 | 262 | 2325 | 2.270426 | 52.7874045 | root | 1 | Root_unresolved | Root_unresolved | 2784 | 0 | NTclustered | gi|57547625|tpd|BR000031.1| | 10654 | g90 | i1 | 88.119 | 99.5152688172043 | 2323 | 276 | 99 | 0 | 1 | 2323 | 5362 | 3040 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C | blastn | 231373 | 2802 | 0.993576017130621 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 3719768 | 3719768 | PRJNA675042_P_NODE_21403_length_406_cov_0.969970_g20953_i0 | PRJNA675042 | 21403 | 406 | 0.96997 | 3.9380782 | root | 1 | Root_unresolved | Root_unresolved | 414 | 4.3099999999999996e-111 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g20953 | i0 | 84.938 | 16.935960591133 | 405 | 61 | 99 | 0 | 2 | 406 | 6968 | 6564 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 6876 | 416 | 0.995192307692308 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 3719884 | 3719884 | PRJNA675042_P_NODE_38263_length_348_cov_1.036364_g37813_i0 | PRJNA675042 | 38263 | 348 | 1.036364 | 3.60654672 | root | 1 | Root_unresolved | Root_unresolved | 248 | 3.92e-61 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g37813 | i0 | 86.404 | 17.75 | 228 | 30 | 66 | 1 | 121 | 348 | 7000 | 7226 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 6177 | 248 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 4996400 | 4996400 | PRJNA675042_P_NODE_1864_length_977_cov_1.922566_g1532_i0 | PRJNA675042 | 1864 | 977 | 1.922566 | 18.78346982 | root | 1 | Root_unresolved | Root_unresolved | 1288 | 0 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g1532 | i0 | 90.349 | 80.4493346980553 | 974 | 94 | 99 | 0 | 4 | 977 | 2261 | 1288 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 78599 | 1290 | 0.998449612403101 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 8820780 | 8820780 | PRJNA675042_P_NODE_113067_length_250_cov_0.870056_g112617_i0 | PRJNA675042 | 113067 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 182 | 2.769999999999999e-41 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g112617 | i0 | 94.118 | 39.14 | 119 | 7 | 48 | 0 | 1 | 119 | 945 | 1063 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 9785 | 182 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 8821213 | 8821213 | PRJNA675042_P_NODE_3787_length_701_cov_1.832803_g3377_i0 | PRJNA675042 | 3787 | 701 | 1.832803 | 12.84794903 | root | 1 | Root_unresolved | Root_unresolved | 1020 | 0 | NTclustered | gi|57547625|tpd|BR000031.1| | 10654 | g3377 | i0 | 92.725 | 59.2154065620542 | 701 | 51 | 100 | 0 | 1 | 701 | 3106 | 2406 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-C | blastn | 41510 | 1024 | 0.99609375 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 11371999 | 11371999 | PRJNA675042_P_NODE_869_length_1386_cov_1.570449_g638_i0 | PRJNA675042 | 869 | 1386 | 1.570449 | 21.76642314 | root | 1 | Root_unresolved | Root_unresolved | 1888 | 0 | NTclustered | gi|57547621|tpd|BR000030.1| | 10654 | g638 | i0 | 91.226 | 63.3694083694084 | 1379 | 121 | 99 | 0 | 1 | 1379 | 2427 | 1049 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-B | blastn | 87830 | 1890 | 0.998941798941799 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 13922371 | 13922371 | PRJNA675042_P_NODE_89451_length_270_cov_0.913706_g89001_i0 | PRJNA675042 | 89451 | 270 | 0.913706 | 2.4670062 | root | 1 | Root_unresolved | Root_unresolved | 285 | 2.24e-72 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g89001 | i0 | 85.556 | 17.1851851851852 | 270 | 39 | 100 | 0 | 1 | 270 | 5189 | 4920 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 4640 | 285 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 19020170 | 19020170 | PRJNA675042_P_NODE_875_length_1382_cov_1.644767_g644_i0 | PRJNA675042 | 875 | 1382 | 1.644767 | 22.73067994 | root | 1 | Root_unresolved | Root_unresolved | 1271 | 0 | NTclustered | gi|57547621|tpd|BR000030.1| | 10654 | g644 | i0 | 84.515 | 55.5463096960926 | 1298 | 186 | 93 | 10 | 80 | 1368 | 5836 | 7127 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-B | blastn | 76765 | 1275 | 0.996862745098039 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 21570651 | 21570651 | PRJNA675042_P_NODE_90957_length_268_cov_1.164103_g90507_i0 | PRJNA675042 | 90957 | 268 | 1.164103 | 3.11979604 | root | 1 | Root_unresolved | Root_unresolved | 361 | 3.59e-95 | NTclustered | gi|57547617|tpd|BR000029.1| | 10654 | g90507 | i0 | 91.571 | 93.8619402985075 | 261 | 22 | 97 | 0 | 4 | 264 | 4175 | 3915 | TPA_inf: Rice tungro bacilliform virus orf x, orf y and orf z genes for hypothetical proteins, isolate:ERTBV-A | blastn | 25155 | 361 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae | ||
| 29272431 | 29272431 | PRJNA675042_P_NODE_30749_length_370_cov_1.191919_g30299_i0 | PRJNA675042 | 30749 | 370 | 1.191919 | 4.4101003 | root | 1 | Root_unresolved | Root_unresolved | 89 | 1.56e-18 | NR | FAA00013.1 | 10654 | g30299 | i0 | 53.6 | 1.78378378378378 | 110 | 51 | 89.2 | 0 | 364 | 35 | 164 | 273 | FAA00013.1 TPA: hypothetical protein [Rice tungro bacilliform virus] | diamond | 660 | 89.7 | 0.992196209587514 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Tungrovirus | Tungrovirus oryzae |
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);;