contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA758770" and tax_kingdom = "Orthornavirae"
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 | ||
| 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 | ||
| 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);;