contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax_superkingdom = "Viruses"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 740368 | 740368 | PRJNA758770_S_NODE_14321_length_309_cov_1.322034_g14195_i0 | PRJNA758770 | 14321 | 309 | 1.322034 | 4.08508506 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 571 | 1.7899999999999995e-158 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g14195 | i0 | 100 | 86.0097087378641 | 309 | 0 | 100 | 0 | 1 | 309 | 4159 | 3851 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 26577 | 571 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 3292149 | 3292149 | PRJNA758770_S_NODE_663_length_1277_cov_3.324751_g603_i0 | PRJNA758770 | 663 | 1277 | 3.324751 | 42.45707027 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 2313 | 0 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g603 | i0 | 99.373 | 94.4244322631167 | 1276 | 8 | 99 | 0 | 1 | 1276 | 6235 | 7510 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 120580 | 2313 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 3292182 | 3292182 | PRJNA758770_S_NODE_7983_length_385_cov_1.362179_g7857_i0 | PRJNA758770 | 7983 | 385 | 1.362179 | 5.24438915 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 695 | 0 | NTclustered | gi|1214997675|gb|KX156739.1| | 1214459 | g7857 | i0 | 99.221 | 83 | 385 | 3 | 100 | 0 | 1 | 385 | 1236 | 1620 | Citrus yellow vein clearing virus isolate GD-STJ, complete genome | blastn | 31955 | 695 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 4569227 | 4569227 | PRJNA758770_S_NODE_5604_length_447_cov_1.104278_g5478_i0 | PRJNA758770 | 5604 | 447 | 1.104278 | 4.93612266 | Mus musculus mobilized endogenous polytropic provirus | 590745 | Viruses | Viruses | 809 | 0 | NTclustered | gi|221326511|gb|FJ544576.1| | 590745 | g5478 | i0 | 99.329 | 101.959731543624 | 447 | 3 | 100 | 0 | 1 | 447 | 3250 | 2804 | Mus musculus mobilized endogenous polytropic provirus clone 5 truncated gag-pol polyprotein (gag) gene, complete cds | blastn | 45576 | 809 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Mus musculus mobilized endogenous polytropic provirus | ||
| 8393870 | 8393870 | PRJNA758770_S_NODE_23587_length_253_cov_0.866667_g23461_i0 | PRJNA758770 | 23587 | 253 | 0.866667 | 2.19266751 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 468 | 1.92e-127 | NTclustered | gi|6911285|gb|AF228552.1|AF228552 | 46608 | g23461 | i0 | 100 | 22.2687747035573 | 253 | 0 | 100 | 0 | 1 | 253 | 2266 | 2518 | Exogenous mouse mammary tumor virus C3H complete proviral genome | blastn | 5634 | 468 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 9668944 | 9668944 | PRJNA758770_S_NODE_18048_length_283_cov_1.147619_g17922_i0 | PRJNA758770 | 18048 | 283 | 1.147619 | 3.24776177 | Apscaviroid alphaflavivitis | 3416569 | Viruses | Viruses | 462 | 1.02e-125 | NTclustered | gi|2053420969|gb|MW732682.1| | 12904 | g17922 | i0 | 96.763 | 81.4876325088339 | 278 | 8 | 98 | 1 | 6 | 283 | 1 | 277 | Grapevine yellow speckle viroid 1 isolate BIO6-25J_GYSVd-1, complete genome | blastn | 23061 | 462 | 1 | Viruses | Pospiviroidae | Apscaviroid | Apscaviroid alphaflavivitis | ||||||
| 10944735 | 10944735 | PRJNA758770_S_NODE_2489_length_655_cov_2.314433_g2369_i0 | PRJNA758770 | 2489 | 655 | 2.314433 | 15.15953615 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 1210 | 0 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g2369 | i0 | 100 | 80.7465648854962 | 655 | 0 | 100 | 0 | 1 | 655 | 5383 | 4729 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 52889 | 1210 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 13494352 | 13494352 | PRJNA758770_S_NODE_22691_length_255_cov_3.510989_g22565_i0 | PRJNA758770 | 22691 | 255 | 3.510989 | 8.95302195 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 462 | 9.03e-126 | NTclustered | gi|1214997668|gb|KX156738.1| | 1214459 | g22565 | i0 | 99.605 | 81.4235294117647 | 253 | 1 | 99 | 0 | 3 | 255 | 4679 | 4427 | Citrus yellow vein clearing virus isolate GD-JG, complete genome | blastn | 20763 | 462 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 13958727 | 13958727 | PRJNA758770_S_NODE_28891_length_246_cov_1.473988_g28765_i0 | PRJNA758770 | 28891 | 246 | 1.473988 | 3.62601048 | Tobamovirus | 12234 | Viruses | Viruses | 453 | 5.2100000000000006e-123 | NTclustered | gi|1782797563|gb|MK933286.1| | 12235 | g28765 | i0 | 100 | 99.5975609756098 | 245 | 0 | 99 | 0 | 2 | 246 | 4397 | 4153 | Cucumber green mottle mosaic virus isolate GDLZ, complete genome | blastn | 24501 | 453 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Martellivirales | Virgaviridae | Tobamovirus | Tobamovirus viridimaculae | ||
| 14769434 | 14769434 | PRJNA758770_S_NODE_21132_length_264_cov_1.617801_g21006_i0 | PRJNA758770 | 21132 | 264 | 1.617801 | 4.27099464 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 488 | 1.5499999999999999e-133 | NTclustered | gi|2866530880|gb|PQ567901.1| | 1214459 | g21006 | i0 | 100 | 83.6666666666667 | 264 | 0 | 100 | 0 | 1 | 264 | 1277 | 1014 | Citrus yellow vein clearing virus isolate CYVCV-FL-15, complete genome | blastn | 22088 | 488 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 16043113 | 16043113 | PRJNA758770_S_NODE_17313_length_288_cov_1.027907_g17187_i0 | PRJNA758770 | 17313 | 288 | 1.027907 | 2.96037216 | Betaretrovirus murmamtum | 3427295 | Viruses | Viruses | 377 | 3.87e-100 | NTclustered | gi|6911279|gb|AF228551.1|AF228551 | 46608 | g17187 | i0 | 99.517 | 50.2083333333333 | 207 | 1 | 72 | 0 | 80 | 286 | 1277 | 1483 | Exogenous mouse mammary tumor virus HeJ complete proviral genome | blastn | 14460 | 377 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus murmamtum | ||
| 19867649 | 19867649 | PRJNA758770_S_NODE_30936_length_244_cov_0.912281_g30810_i0 | PRJNA758770 | 30936 | 244 | 0.912281 | 2.22596564 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 189 | 1.6099999999999996e-43 | NTclustered | gi|2057119259|tpg|BK057927.1| | 2832643 | g30810 | i0 | 81.938 | 0.930327868852459 | 227 | 38 | 93 | 3 | 4 | 229 | 22001 | 22225 | MAG TPA_asm: Caudoviricetes sp. isolate ctw9w9, partial genome | blastn | 227 | 189 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 21142907 | 21142907 | PRJNA758770_S_NODE_1397_length_858_cov_3.033121_g1301_i0 | PRJNA758770 | 1397 | 858 | 3.033121 | 26.02417818 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 1580 | 0 | NTclustered | gi|1214997710|gb|KX156744.1| | 1214459 | g1301 | i0 | 99.883 | 81.7097902097902 | 858 | 1 | 100 | 0 | 1 | 858 | 5363 | 6220 | Citrus yellow vein clearing virus isolate HN-GXP, complete genome | blastn | 70107 | 1580 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 21143492 | 21143492 | PRJNA758770_S_NODE_9477_length_360_cov_1.560976_g9351_i0 | PRJNA758770 | 9477 | 360 | 1.560976 | 5.6195136 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 599 | 9.72e-167 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g9351 | i0 | 99.694 | 76.1722222222222 | 327 | 1 | 91 | 0 | 1 | 327 | 3511 | 3185 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 27422 | 599 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 22417617 | 22417617 | PRJNA758770_S_NODE_10638_length_344_cov_1.435424_g10512_i0 | PRJNA758770 | 10638 | 344 | 1.435424 | 4.93785856 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 636 | 7.059999999999998e-178 | NTclustered | gi|1822142639|gb|MK415926.1| | 1214459 | g10512 | i0 | 100 | 89.6191860465116 | 344 | 0 | 100 | 0 | 1 | 344 | 26 | 369 | Citrus yellow vein clearing virus isolate HP-MRJ, complete genome | blastn | 30829 | 636 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae | ||
| 22417689 | 22417689 | PRJNA758770_S_NODE_13858_length_313_cov_1.104167_g13732_i0 | PRJNA758770 | 13858 | 313 | 1.104167 | 3.45604271 | Potexvirus citriflavivenae | 3433772 | Viruses | Viruses | 569 | 6.539999999999998e-158 | NTclustered | gi|764160352|ref|NC_026592.1| | 1214459 | g13732 | i0 | 99.678 | 94.8753993610224 | 311 | 1 | 99 | 0 | 3 | 313 | 960 | 650 | Citrus yellow vein clearing virus isolate CQ, complete genome | blastn | 29696 | 569 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Alphaflexiviridae | Potexvirus | Potexvirus citriflavivenae |
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);;