contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA800053" and tax_phylum = "Cossaviricota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2071921 | 2071921 | PRJNA800053_P_NODE_10542_length_301_cov_4.118421_g10378_i0 | PRJNA800053 | 10542 | 301 | 4.118421 | 12.39644721 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 529 | 1.0599999999999996e-145 | NTclustered | gi|2814138522|gb|PQ313124.1| | 3367306 | g10378 | i0 | 98.658 | 2.95016611295681 | 298 | 4 | 99 | 0 | 4 | 301 | 1193 | 896 | Parvo-like hybrid virus isolate SpinColumn09, partial genome | blastn | 888 | 529 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 4624570 | 4624570 | PRJNA800053_P_NODE_10244_length_305_cov_1.413793_g10080_i0 | PRJNA800053 | 10244 | 305 | 1.413793 | 4.31206865 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 564 | 2.95e-156 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g10080 | i0 | 100 | 1 | 305 | 0 | 100 | 0 | 1 | 305 | 3114 | 2810 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 305 | 564 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 4624596 | 4624596 | PRJNA800053_P_NODE_13564_length_275_cov_9.247525_g13400_i0 | PRJNA800053 | 13564 | 275 | 9.247525 | 25.43069375 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 499 | 7.51e-137 | NTclustered | gi|2814138508|gb|PQ313119.1| | 3367306 | g13400 | i0 | 100 | 3.40363636363636 | 270 | 0 | 98 | 0 | 3 | 272 | 709 | 440 | Parvo-like hybrid virus isolate SpinColumn04, partial genome | blastn | 936 | 499 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 4624659 | 4624659 | PRJNA800053_P_NODE_21524_length_244_cov_2.146199_g21360_i0 | PRJNA800053 | 21524 | 244 | 2.146199 | 5.23672556 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 429 | 8.699999999999998e-116 | NTclustered | gi|2416706441|gb|OP933679.1| | 2794515 | g21360 | i0 | 99.16 | 1.95081967213115 | 238 | 2 | 98 | 0 | 4 | 241 | 1027 | 790 | MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence | blastn | 476 | 429 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 4624699 | 4624699 | PRJNA800053_P_NODE_4544_length_423_cov_1.374286_g4381_i0 | PRJNA800053 | 4544 | 423 | 1.374286 | 5.81322978 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 760 | 0 | NTclustered | gi|2814138508|gb|PQ313119.1| | 3367306 | g4381 | i0 | 99.52 | 1.97163120567376 | 417 | 2 | 99 | 0 | 4 | 420 | 1531 | 1947 | Parvo-like hybrid virus isolate SpinColumn04, partial genome | blastn | 834 | 760 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 7174580 | 7174580 | PRJNA800053_P_NODE_24906_length_226_cov_3.673203_g24742_i0 | PRJNA800053 | 24906 | 226 | 3.673203 | 8.30143878 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 298 | 2.34e-76 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g24742 | i0 | 90.95 | 0.97787610619469 | 221 | 20 | 98 | 0 | 4 | 224 | 2508 | 2288 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 221 | 298 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 7174589 | 7174589 | PRJNA800053_P_NODE_3086_length_498_cov_1.727059_g2926_i0 | PRJNA800053 | 3086 | 498 | 1.727059 | 8.60075382 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 915 | 0 | NTclustered | gi|2814138522|gb|PQ313124.1| | 3367306 | g2926 | i0 | 100 | 0.993975903614458 | 495 | 0 | 99 | 0 | 3 | 497 | 2923 | 2429 | Parvo-like hybrid virus isolate SpinColumn09, partial genome | blastn | 495 | 915 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 7174619 | 7174619 | PRJNA800053_P_NODE_926_length_813_cov_5.850000_g799_i0 | PRJNA800053 | 926 | 813 | 5.85 | 47.5605 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 1469 | 0 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g799 | i0 | 99.262 | 8.1869618696187 | 813 | 6 | 100 | 0 | 1 | 813 | 961 | 1773 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 6656 | 1469 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 8449193 | 8449193 | PRJNA800053_P_NODE_10647_length_300_cov_1.933921_g10483_i0 | PRJNA800053 | 10647 | 300 | 1.933921 | 5.801763 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 457 | 5.06e-124 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g10483 | i0 | 94.295 | 0.993333333333333 | 298 | 17 | 99 | 0 | 1 | 298 | 2815 | 2518 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 298 | 457 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 8449322 | 8449322 | PRJNA800053_P_NODE_24367_length_235_cov_6.759259_g24203_i0 | PRJNA800053 | 24367 | 235 | 6.759259 | 15.88425865 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 418 | 1.8e-112 | NTclustered | gi|2814138527|gb|PQ313126.1| | 2794515 | g24203 | i0 | 99.563 | 1.94893617021277 | 229 | 1 | 97 | 0 | 4 | 232 | 1136 | 1364 | Parvo-like hybrid virus isolate SpinColumn11, partial genome | blastn | 458 | 418 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 9724227 | 9724227 | PRJNA800053_P_NODE_11168_length_294_cov_2.298643_g11004_i0 | PRJNA800053 | 11168 | 294 | 2.298643 | 6.75801042 | Alphapapillomavirus 7 | 337042 | Viruses | Viruses | 538 | 1.7199999999999995e-148 | NTclustered | gi|1258167396|gb|MF288663.1| | 333761 | g11004 | i0 | 100 | 98.9795918367347 | 291 | 0 | 99 | 0 | 4 | 294 | 1699 | 1989 | Human papillomavirus 18 isolate C415154_R1_1138896_N-P, complete genome | blastn | 29100 | 538 | 1 | Viruses | Shotokuvirae | Cossaviricota | Papovaviricetes | Zurhausenvirales | Papillomaviridae | Alphapapillomavirus | Alphapapillomavirus 7 | ||
| 9724366 | 9724366 | PRJNA800053_P_NODE_25208_length_206_cov_4.067669_g25044_i0 | PRJNA800053 | 25208 | 206 | 4.067669 | 8.37939814 | Luscinia sibilans parvo-like hybrid virus | 2794515 | Viruses | Viruses | 322 | 1.24e-83 | NTclustered | gi|2416706441|gb|OP933679.1| | 2794515 | g25044 | i0 | 94.811 | 1.02912621359223 | 212 | 2 | 99 | 1 | 4 | 206 | 2938 | 2727 | MAG: Fish-associated parvo-like virus isolate fi099par1 genomic sequence, sequence | blastn | 212 | 322 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Luscinia sibilans parvo-like hybrid virus | |||
| 12275594 | 12275594 | PRJNA800053_P_NODE_10_length_3565_cov_20.172108_g8_i0 | PRJNA800053 | 10 | 3565 | 20.172108 | 719.1356502 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 761 | 0 | NTclustered | gi|2814138525|gb|PQ313125.1| | 3367306 | g8 | i0 | 78.145 | 0.474333800841515 | 1240 | 241 | 34 | 27 | 1647 | 2870 | 1753 | 528 | Parvo-like hybrid virus isolate SpinColumn10, partial genome | blastn | 1691 | 761 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 12275733 | 12275733 | PRJNA800053_P_NODE_5510_length_390_cov_2.596215_g5347_i0 | PRJNA800053 | 5510 | 390 | 2.596215 | 10.1252385 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 472 | 2.41e-128 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g5347 | i0 | 98.864 | 1.98717948717949 | 264 | 3 | 100 | 0 | 1 | 264 | 956 | 693 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 775 | 472 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 12275740 | 12275740 | PRJNA800053_P_NODE_7130_length_352_cov_2.784946_g6966_i0 | PRJNA800053 | 7130 | 352 | 2.784946 | 9.80300992 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 545 | 1.25e-150 | NTclustered | gi|2814138522|gb|PQ313124.1| | 3367306 | g6966 | i0 | 94.857 | 2.47159090909091 | 350 | 17 | 99 | 1 | 1 | 349 | 589 | 938 | Parvo-like hybrid virus isolate SpinColumn09, partial genome | blastn | 870 | 545 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 14824668 | 14824668 | PRJNA800053_P_NODE_6432_length_366_cov_7.040956_g6268_i0 | PRJNA800053 | 6432 | 366 | 7.040956 | 25.76989896 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 665 | 0 | NTclustered | gi|2814138508|gb|PQ313119.1| | 3367306 | g6268 | i0 | 100 | 2.2896174863388 | 360 | 0 | 98 | 0 | 4 | 363 | 1209 | 850 | Parvo-like hybrid virus isolate SpinColumn04, partial genome | blastn | 838 | 665 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 16098774 | 16098774 | PRJNA800053_P_NODE_2233_length_573_cov_3.264000_g2076_i0 | PRJNA800053 | 2233 | 573 | 3.264 | 18.70272 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 1042 | 0 | NTclustered | gi|2814138508|gb|PQ313119.1| | 3367306 | g2076 | i0 | 99.824 | 1.32286212914485 | 567 | 1 | 99 | 0 | 4 | 570 | 2853 | 2287 | Parvo-like hybrid virus isolate SpinColumn04, partial genome | blastn | 758 | 1042 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 22473395 | 22473395 | PRJNA800053_P_NODE_7218_length_351_cov_1.097122_g7054_i0 | PRJNA800053 | 7218 | 351 | 1.097122 | 3.85089822 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 436 | 7.839999999999999e-118 | NTclustered | gi|2814138511|gb|PQ313120.1| | 3042447 | g7054 | i0 | 99.174 | 2.01994301994302 | 242 | 2 | 69 | 0 | 109 | 350 | 2881 | 2640 | Parvo-like hybrid virus isolate SpinColumn05, partial genome | blastn | 709 | 436 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittaciform aveparvovirus | |||
| 23748841 | 23748841 | PRJNA800053_P_NODE_10879_length_297_cov_19.473214_g10715_i0 | PRJNA800053 | 10879 | 297 | 19.473214 | 57.83544558 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 534 | 2.25e-147 | NTclustered | gi|2814138508|gb|PQ313119.1| | 3367306 | g10715 | i0 | 99.658 | 0.983164983164983 | 292 | 1 | 98 | 0 | 3 | 294 | 3164 | 2873 | Parvo-like hybrid virus isolate SpinColumn04, partial genome | blastn | 292 | 534 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 23748924 | 23748924 | PRJNA800053_P_NODE_21839_length_244_cov_0.900585_g21675_i0 | PRJNA800053 | 21839 | 244 | 0.900585 | 2.1974274 | Psittaciform aveparvovirus | 3042447 | Viruses | Viruses | 329 | 9.08e-86 | NTclustered | gi|2496529060|gb|OP577480.1| | 3042447 | g21675 | i0 | 91.322 | 0.991803278688525 | 242 | 19 | 99 | 2 | 4 | 244 | 1965 | 2205 | Psittaciform aveparvovirus strain OBP1/FE1/49/2021, partial genome | blastn | 242 | 329 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittaciform aveparvovirus | ||
| 25022876 | 25022876 | PRJNA800053_P_NODE_5640_length_386_cov_4.162939_g5477_i0 | PRJNA800053 | 5640 | 386 | 4.162939 | 16.06894454 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 691 | 0 | NTclustered | gi|2814138522|gb|PQ313124.1| | 3367306 | g5477 | i0 | 98.956 | 4.19948186528497 | 383 | 4 | 99 | 0 | 4 | 386 | 2067 | 1685 | Parvo-like hybrid virus isolate SpinColumn09, partial genome | blastn | 1621 | 691 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid 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);;