contig_metadata
13 rows where bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2972832 | 2972832 | PRJNA421571_P_NODE_16063_length_922_cov_2.661955_g14060_i0 | PRJNA421571 | 16063 | 922 | 2.661955 | 24.5432251 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 1703 | 0 | NTclustered | gi|2550532683|gb|OR269938.1| | 3062848 | g14060 | i0 | 100 | 3.76030368763557 | 922 | 0 | 100 | 0 | 1 | 922 | 520 | 1441 | MAG: Endogenous cotton pararetrovirus isolate MAY17 genomic sequence | blastn | 3467 | 1703 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 4913409 | 4913409 | PRJNA421571_P_NODE_14264_length_989_cov_3.264192_g12398_i0 | PRJNA421571 | 14264 | 989 | 3.264192 | 32.28285888 | Caulimovirus | 10639 | Viruses | Viruses | 1827 | 0 | NTclustered | gi|2550532687|gb|OR269942.1| | 3062848 | g12398 | i0 | 100 | 21.6167846309403 | 989 | 0 | 100 | 0 | 1 | 989 | 4471 | 5459 | MAG: Endogenous cotton pararetrovirus isolate APR19 genomic sequence | blastn | 21379 | 1827 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 6799612 | 6799612 | PRJNA421571_P_NODE_10326_length_1180_cov_13.818428_g8869_i0 | PRJNA421571 | 10326 | 1180 | 13.818428 | 163.0574504 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 2163 | 0 | NTclustered | gi|2550532685|gb|OR269940.1| | 3062848 | g8869 | i0 | 100 | 16.4313559322034 | 1171 | 0 | 99 | 0 | 1 | 1171 | 7898 | 9068 | MAG: Endogenous cotton pararetrovirus isolate CLR01 genomic sequence | blastn | 19389 | 2163 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 8075450 | 8075450 | PRJNA421571_P_NODE_15687_length_934_cov_10.016260_g13714_i0 | PRJNA421571 | 15687 | 934 | 10.01626 | 93.5518684 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 1557 | 0 | NTclustered | gi|2550532685|gb|OR269940.1| | 3062848 | g13714 | i0 | 100 | 2.49892933618844 | 843 | 0 | 90 | 0 | 1 | 843 | 843 | 1 | MAG: Endogenous cotton pararetrovirus isolate CLR01 genomic sequence | blastn | 2334 | 1557 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 14451827 | 14451827 | PRJNA421571_P_NODE_39072_length_476_cov_0.955335_g36525_i0 | PRJNA421571 | 39072 | 476 | 0.955335 | 4.5473946 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 874 | 0 | NTclustered | gi|2550532687|gb|OR269942.1| | 3062848 | g36525 | i0 | 99.79 | 21.5693277310924 | 476 | 1 | 100 | 0 | 1 | 476 | 3355 | 2880 | MAG: Endogenous cotton pararetrovirus isolate APR19 genomic sequence | blastn | 10267 | 874 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 15113576 | 15113576 | PRJNA421571_P_NODE_45932_length_417_cov_2.223837_g43384_i0 | PRJNA421571 | 45932 | 417 | 2.223837 | 9.27340029 | Caulimovirus | 10639 | Viruses | Viruses | 771 | 0 | NTclustered | gi|2795441695|gb|PP943205.1| | 3062848 | g43384 | i0 | 100 | 8 | 417 | 0 | 100 | 0 | 1 | 417 | 515 | 99 | Endogenous cotton pararetrovirus isolate EVE-GA_MitS5-Sy genomic sequence | blastn | 3336 | 771 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 15724832 | 15724832 | PRJNA421571_P_NODE_16653_length_900_cov_27.447400_g13714_i1 | PRJNA421571 | 16653 | 900 | 27.4474 | 247.0266 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 905 | 0 | NTclustered | gi|2550532685|gb|OR269940.1| | 3062848 | g13714 | i1 | 100 | 3.26222222222222 | 490 | 0 | 89 | 0 | 320 | 809 | 490 | 1 | MAG: Endogenous cotton pararetrovirus isolate CLR01 genomic sequence | blastn | 2936 | 905 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 16388139 | 16388139 | PRJNA421571_P_NODE_30173_length_587_cov_1.675097_g27651_i0 | PRJNA421571 | 30173 | 587 | 1.675097 | 9.83281939 | Caulimovirus | 10639 | Viruses | Viruses | 1085 | 0 | NTclustered | gi|2550532687|gb|OR269942.1| | 3062848 | g27651 | i0 | 100 | 19 | 587 | 0 | 100 | 0 | 1 | 587 | 1116 | 530 | MAG: Endogenous cotton pararetrovirus isolate APR19 genomic sequence | blastn | 11153 | 1085 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 17000761 | 17000761 | PRJNA421571_P_NODE_55014_length_362_cov_1.256055_g52465_i0 | PRJNA421571 | 55014 | 362 | 1.256055 | 4.5469191 | cotton virus A | 3072933 | Viruses | Viruses | 327 | 5.09e-85 | NTclustered | gi|2571356282|gb|OR184923.1| | 3072933 | g52465 | i0 | 88.278 | 16.5580110497238 | 273 | 32 | 75 | 0 | 71 | 343 | 3776 | 4048 | Cotton virus A isolate MS2022, complete genome | blastn | 5994 | 327 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Caulimovirus | cotton virus A | ||
| 18274003 | 18274003 | PRJNA421571_P_NODE_22655_length_732_cov_1.336874_g20259_i0 | PRJNA421571 | 22655 | 732 | 1.336874 | 9.78591768 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 1347 | 0 | NTclustered | gi|2550532687|gb|OR269942.1| | 3062848 | g20259 | i0 | 99.863 | 22.5833333333333 | 732 | 1 | 100 | 0 | 1 | 732 | 4164 | 3433 | MAG: Endogenous cotton pararetrovirus isolate APR19 genomic sequence | blastn | 16531 | 1347 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 24037697 | 24037697 | PRJNA421571_P_NODE_5119_length_1616_cov_2.100454_g4314_i0 | PRJNA421571 | 5119 | 1616 | 2.100454 | 33.94333664 | Caulimovirus | 10639 | Viruses | Viruses | 2976 | 0 | NTclustered | gi|2550532687|gb|OR269942.1| | 3062848 | g4314 | i0 | 99.876 | 20.4659653465347 | 1618 | 0 | 100 | 1 | 1 | 1616 | 2761 | 1144 | MAG: Endogenous cotton pararetrovirus isolate APR19 genomic sequence | blastn | 33073 | 2976 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 29443824 | 29443824 | PRJNA421571_P_NODE_86870_length_261_cov_1.638298_g84321_i0 | PRJNA421571 | 86870 | 261 | 1.638298 | 4.27595778 | Endogenous cotton pararetrovirus | 3062848 | Viruses | Viruses | 67.8 | 1.05e-12 | NR | WLW14337.1 | 3062848 | g84321 | i0 | 84.8 | 0.379310344827586 | 33 | 5 | 37.9 | 0 | 3 | 101 | 46 | 78 | WLW14337.1 MAG: RNase H protein [Endogenous cotton pararetrovirus] | diamond | 99 | 67.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Endogenous cotton pararetrovirus | ||||
| 30423550 | 30423550 | PRJNA421571_P_NODE_57733_length_349_cov_1.376812_g55184_i0 | PRJNA421571 | 57733 | 349 | 1.376812 | 4.80507388 | Dahlia mosaic virus D1 | 213888 | Viruses | Viruses | 72.8 | 3.75e-12 | NR | AEB54984.1 | 1006328 | g55184 | i0 | 46.6 | 0.627507163323782 | 73 | 39 | 62.8 | 0 | 2 | 220 | 735 | 807 | AEB54984.1 polyprotein [Dahlia mosaic virus D10] | diamond | 219 | 72.8 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Caulimoviridae | Caulimovirus | Caulimovirus tessellodahliae |
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);;