contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA690592" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4499119 | 4499119 | PRJNA690592_S_NODE_154244_length_273_cov_22.050000_g153230_i0 | PRJNA690592 | 154244 | 273 | 22.05 | 60.1965 | Chronazanb virus | 3129852 | Viruses | Viruses | 147 | 1.12e-30 | NTclustered | gi|2717318485|gb|PP172249.1| | 3129852 | g153230 | i0 | 96.591 | 21.5714285714286 | 88 | 3 | 32 | 0 | 40 | 127 | 4485 | 4398 | MAG: Chronazanb virus isolate CN1B_k141_35798 genomic sequence | blastn | 5889 | 147 | 1 | Viruses | Orthornavirae | Lenarviricota | Leviviricetes | Chronazanb virus | |||||
| 5775625 | 5775625 | PRJNA690592_S_NODE_91425_length_339_cov_3.687970_g90411_i0 | PRJNA690592 | 91425 | 339 | 3.68797 | 12.5022183 | Chrocagosk virus | 3129397 | Viruses | Viruses | 215 | 3.86e-51 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g90411 | i0 | 98.361 | 36.3038348082596 | 122 | 2 | 36 | 0 | 1 | 122 | 205 | 326 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 12307 | 215 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 8832028 | 8832028 | PRJNA690592_S_NODE_51507_length_434_cov_1.279778_g50493_i0 | PRJNA690592 | 51507 | 434 | 1.279778 | 5.55423652 | Viruses | 10239 | Viruses | Viruses | 54.7 | 0.012 | NTclustered | gi|2906904862|gb|PQ805454.1| | 2461425 | g50493 | i0 | 100 | 0.200460829493088 | 29 | 0 | 7 | 0 | 185 | 213 | 5931 | 5959 | Goat astrovirus isolate GX/HC/C10/2024, complete genome | blastn | 87 | 54.7 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Goat astrovirus | |||
| 10875110 | 10875110 | PRJNA690592_S_NODE_153289_length_274_cov_1.890547_g152275_i0 | PRJNA690592 | 153289 | 274 | 1.890547 | 5.18009878 | Agrostis stolonifera deltaflexivirus 1 | 2794416 | Viruses | Viruses | 462 | 9.81e-126 | NTclustered | gi|2288523301|gb|ON811607.1| | 2794416 | g152275 | i0 | 97.08 | 6.99270072992701 | 274 | 8 | 100 | 0 | 1 | 274 | 7027 | 7300 | MAG: Agrostis stolonifera deltaflexivirus 1 isolate TIGMIC_2, complete genome | blastn | 1916 | 462 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Agrostis stolonifera deltaflexivirus 1 | ||
| 12149981 | 12149981 | PRJNA690592_S_NODE_10150_length_903_cov_3.580723_g9395_i0 | PRJNA690592 | 10150 | 903 | 3.580723 | 32.33392869 | Agrostis stolonifera deltaflexivirus 1 | 2794416 | Viruses | Viruses | 1580 | 0 | NTclustered | gi|2288523294|gb|ON811605.1| | 2794416 | g9395 | i0 | 98.546 | 7.89590254706534 | 894 | 13 | 99 | 0 | 1 | 894 | 7471 | 8364 | MAG: Agrostis stolonifera deltaflexivirus 1 isolate TIGMIC_1, complete genome | blastn | 7130 | 1580 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Agrostis stolonifera deltaflexivirus 1 | ||
| 12150331 | 12150331 | PRJNA690592_S_NODE_150_length_4216_cov_8.450157_g70_i0 | PRJNA690592 | 150 | 4216 | 8.450157 | 356.25861912 | Solanum melongena bastro-like virus | 2740136 | Viruses | Viruses | 5999 | 0 | NTclustered | gi|1848664429|gb|MN841288.1| | 2740136 | g70 | i0 | 92.416 | 2.98885199240987 | 4206 | 318 | 99 | 1 | 1 | 4205 | 3631 | 7836 | Solanum melongena bastro-like virus strain pt065-phy-4-plant 65, complete genome | blastn | 12601 | 5999 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Solanum melongena bastro-like virus | |||
| 12150856 | 12150856 | PRJNA690592_S_NODE_27230_length_577_cov_2.638889_g26235_i0 | PRJNA690592 | 27230 | 577 | 2.638889 | 15.22638953 | Agrostis stolonifera deltaflexivirus 1 | 2794416 | Viruses | Viruses | 1027 | 0 | NTclustered | gi|2288523301|gb|ON811607.1| | 2794416 | g26235 | i0 | 98.787 | 9.02253032928943 | 577 | 7 | 100 | 0 | 1 | 577 | 7059 | 6483 | MAG: Agrostis stolonifera deltaflexivirus 1 isolate TIGMIC_2, complete genome | blastn | 5206 | 1027 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Deltaflexiviridae | Deltaflexivirus | Agrostis stolonifera deltaflexivirus 1 | ||
| 12151153 | 12151153 | PRJNA690592_S_NODE_670_length_2358_cov_3.538293_g507_i0 | PRJNA690592 | 670 | 2358 | 3.538293 | 83.43294894 | Solanum melongena bastro-like virus | 2740136 | Viruses | Viruses | 3249 | 0 | NTclustered | gi|2819064396|gb|PQ150499.1| | 2740136 | g507 | i0 | 91.553 | 2.99745547073791 | 2356 | 199 | 99 | 0 | 1 | 2356 | 902 | 3257 | MAG: Solanum melongena bastro-like virus isolate Hebei_128 genomic sequence | blastn | 7068 | 3249 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Solanum melongena bastro-like virus | |||
| 13424735 | 13424735 | PRJNA690592_S_NODE_136271_length_288_cov_10.967442_g135257_i0 | PRJNA690592 | 136271 | 288 | 10.967442 | 31.58623296 | Chrocagosk virus | 3129397 | Viruses | Viruses | 364 | 3.0099999999999993e-96 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g135257 | i0 | 92.857 | 19.3854166666667 | 252 | 17 | 88 | 1 | 1 | 252 | 251 | 1 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 5583 | 364 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus | |||||
| 14699750 | 14699750 | PRJNA690592_S_NODE_12072_length_839_cov_1.629243_g11261_i0 | PRJNA690592 | 12072 | 839 | 1.629243 | 13.66934877 | Solanum melongena bastro-like virus | 2740136 | Viruses | Viruses | 1301 | 0 | NTclustered | gi|2819064396|gb|PQ150499.1| | 2740136 | g11261 | i0 | 94.636 | 3.48986889153754 | 839 | 45 | 100 | 0 | 1 | 839 | 862 | 24 | MAG: Solanum melongena bastro-like virus isolate Hebei_128 genomic sequence | blastn | 2928 | 1301 | 1 | Viruses | Orthornavirae | Pisuviricota | Stelpaviricetes | Stellavirales | Astroviridae | Solanum melongena bastro-like virus | |||
| 17248794 | 17248794 | PRJNA690592_S_NODE_136454_length_288_cov_2.102326_g135440_i0 | PRJNA690592 | 136454 | 288 | 2.102326 | 6.05469888 | brine shrimp arlivirus 7 | 2900382 | Viruses | Viruses | 527 | 3.63e-145 | NTclustered | gi|2209095168|gb|OL472412.1| | 2900382 | g135440 | i0 | 99.653 | 1 | 288 | 1 | 100 | 0 | 1 | 288 | 4126 | 4413 | MAG: Brine shrimp arlivirus 7 isolate XZ/98-19 hypothetical protein, RNA-dependent RNA polymerase, and hypothetical protein genes, complete cds | blastn | 288 | 527 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 7 | ||
| 18523331 | 18523331 | PRJNA690592_S_NODE_192115_length_249_cov_0.875000_g191101_i0 | PRJNA690592 | 192115 | 249 | 0.875 | 2.17875 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 339 | 1.5399999999999998e-88 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g191101 | i0 | 91.532 | 0.995983935742972 | 248 | 18 | 98 | 3 | 1 | 245 | 2923 | 3170 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 248 | 339 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 21073709 | 21073709 | PRJNA690592_S_NODE_183517_length_252_cov_1.832402_g182503_i0 | PRJNA690592 | 183517 | 252 | 1.832402 | 4.61765304 | Sopidub virus | 3131684 | Viruses | Viruses | 185 | 2.16e-42 | NTclustered | gi|2717323145|gb|PP173985.1| | 3131684 | g182503 | i0 | 85.185 | 4.10714285714286 | 189 | 18 | 72 | 7 | 47 | 227 | 2076 | 2262 | MAG: Sopidub virus isolate SP1B_k141_213983 genomic sequence | blastn | 1035 | 185 | 1 | Viruses | Orthornavirae | Pisuviricota | Duplopiviricetes | Durnavirales | Picobirnaviridae | Sopidub virus | |||
| 23623691 | 23623691 | PRJNA690592_S_NODE_126719_length_297_cov_2.745536_g125705_i0 | PRJNA690592 | 126719 | 297 | 2.745536 | 8.15424192 | Chrocagosk virus | 3129397 | Viruses | Viruses | 228 | 4.269999999999999e-55 | NTclustered | gi|2717317479|gb|PP171845.1| | 3129397 | g125705 | i0 | 83.142 | 28.023569023569 | 261 | 33 | 88 | 7 | 38 | 297 | 1 | 251 | MAG: Chrocagosk virus isolate CC1A_k141_83719 genomic sequence | blastn | 8323 | 228 | 1 | Viruses | Orthornavirae | Lenarviricota | Amabiliviricetes | Chrocagosk virus |
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);;