contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1068513" and tax_kingdom = "Bamfordvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1456474 | 1456474 | PRJNA1068513_S_NODE_10562_length_274_cov_2.447761_g10516_i0 | PRJNA1068513 | 10562 | 274 | 2.447761 | 6.70686514 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 73.1 | 1.93e-8 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g10516 | i0 | 95.556 | 15.1569343065693 | 45 | 2 | 16 | 0 | 224 | 268 | 67583 | 67627 | Orf virus isolate FX10, partial genome | blastn | 4153 | 73.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 7834437 | 7834437 | PRJNA1068513_S_NODE_7147_length_341_cov_2.078358_g7101_i0 | PRJNA1068513 | 7147 | 341 | 2.078358 | 7.08720078 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 67.6 | 1.15e-6 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g7101 | i0 | 97.5 | 10.2785923753666 | 40 | 0 | 11 | 1 | 303 | 341 | 121089 | 121050 | Orf virus isolate FX17, partial genome | blastn | 3505 | 67.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 8666796 | 8666796 | PRJNA1068513_S_NODE_1027_length_689_cov_6.258117_g988_i0 | PRJNA1068513 | 1027 | 689 | 6.258117 | 43.11842613 | root | 1 | Root_unresolved | Root_unresolved | 110 | 4.02e-19 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g988 | i0 | 95.588 | 11.3541364296081 | 68 | 3 | 10 | 0 | 1 | 68 | 67757 | 67824 | Orf virus isolate FX10, partial genome | blastn | 7823 | 110 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 9941767 | 9941767 | PRJNA1068513_S_NODE_6168_length_367_cov_15.588435_g6122_i0 | PRJNA1068513 | 6168 | 367 | 15.588435 | 57.20955645 | Viruses | 10239 | Viruses | Viruses | 95.3 | 5.71e-15 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g6122 | i0 | 93.75 | 20.1961852861035 | 64 | 2 | 17 | 2 | 305 | 367 | 67824 | 67762 | Orf virus isolate FX10, partial genome | blastn | 7412 | 95.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 10385166 | 10385166 | PRJNA1068513_S_NODE_4309_length_433_cov_3.477778_g4264_i0 | PRJNA1068513 | 4309 | 433 | 3.477778 | 15.05877874 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 95.3 | 6.85e-15 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g4264 | i0 | 93.651 | 16.2147806004619 | 63 | 4 | 15 | 0 | 1 | 63 | 67766 | 67828 | Orf virus isolate FX10, partial genome | blastn | 7021 | 95.3 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 12492458 | 12492458 | PRJNA1068513_S_NODE_2470_length_531_cov_23.368996_g2427_i0 | PRJNA1068513 | 2470 | 531 | 23.368996 | 124.08936876 | root | 1 | Root_unresolved | Root_unresolved | 73.1 | 4e-8 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g2427 | i0 | 93.75 | 8.48775894538606 | 48 | 3 | 9 | 0 | 484 | 531 | 67824 | 67777 | Orf virus isolate FX10, partial genome | blastn | 4507 | 73.1 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 12492463 | 12492463 | PRJNA1068513_S_NODE_3610_length_466_cov_2.081425_g3565_i0 | PRJNA1068513 | 3610 | 466 | 2.081425 | 9.6994405 | Viruses | 10239 | Viruses | Viruses | 65.8 | 5.82e-6 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g3565 | i0 | 100 | 8.36695278969957 | 35 | 0 | 8 | 0 | 432 | 466 | 67588 | 67622 | Orf virus isolate FX10, partial genome | blastn | 3899 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 15041303 | 15041303 | PRJNA1068513_S_NODE_2532_length_528_cov_5.474725_g2488_i0 | PRJNA1068513 | 2532 | 528 | 5.474725 | 28.906548 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.004 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g2488 | i0 | 96.97 | 6.14015151515152 | 33 | 1 | 6 | 0 | 496 | 528 | 67588 | 67620 | Orf virus isolate FX10, partial genome | blastn | 3242 | 56.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 17591408 | 17591408 | PRJNA1068513_S_NODE_2214_length_551_cov_18.416318_g2172_i0 | PRJNA1068513 | 2214 | 551 | 18.416318 | 101.47391218 | Viruses | 10239 | Viruses | Viruses | 67.6 | 1.94e-6 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g2172 | i0 | 95.238 | 7.51905626134301 | 42 | 2 | 8 | 0 | 13 | 54 | 67622 | 67581 | Orf virus isolate FX10, partial genome | blastn | 4143 | 67.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 17591413 | 17591413 | PRJNA1068513_S_NODE_4194_length_438_cov_6.441096_g4149_i0 | PRJNA1068513 | 4194 | 438 | 6.441096 | 28.21200048 | Viruses | 10239 | Viruses | Viruses | 65.8 | 5.44e-6 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g4149 | i0 | 97.368 | 8.71232876712329 | 38 | 1 | 9 | 0 | 401 | 438 | 67588 | 67625 | Orf virus isolate FX10, partial genome | blastn | 3816 | 65.8 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 20140042 | 20140042 | PRJNA1068513_S_NODE_12616_length_248_cov_1.337143_g12570_i0 | PRJNA1068513 | 12616 | 248 | 1.337143 | 3.31611464 | Viruses | 10239 | Viruses | Viruses | 67.6 | 8.01e-7 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g12570 | i0 | 91.837 | 16.6491935483871 | 49 | 2 | 19 | 2 | 201 | 248 | 67824 | 67777 | Orf virus isolate FX10, partial genome | blastn | 4129 | 67.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 20140059 | 20140059 | PRJNA1068513_S_NODE_6416_length_360_cov_8.867596_g6370_i0 | PRJNA1068513 | 6416 | 360 | 8.867596 | 31.9233456 | root | 1 | Root_unresolved | Root_unresolved | 63.9 | 1.58e-5 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g6370 | i0 | 100 | 10.1138888888889 | 34 | 0 | 9 | 0 | 1 | 34 | 121048 | 121081 | Orf virus isolate FX17, partial genome | blastn | 3641 | 63.9 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 20582988 | 20582988 | PRJNA1068513_S_NODE_13877_length_225_cov_4.460526_g13831_i0 | PRJNA1068513 | 13877 | 225 | 4.460526 | 10.0361835 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 67.6 | 7.15e-7 | NTclustered | gi|2755084565|gb|PP943426.1| | 10258 | g13831 | i0 | 97.436 | 18.72 | 39 | 1 | 17 | 0 | 1 | 39 | 121050 | 121088 | Orf virus isolate FX17, partial genome | blastn | 4212 | 67.6 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 23134155 | 23134155 | PRJNA1068513_S_NODE_13799_length_228_cov_3.716129_g13753_i0 | PRJNA1068513 | 13799 | 228 | 3.716129 | 8.47277412 | Parapoxvirus orf | 3431389 | Viruses | Viruses | 69.4 | 2.02e-7 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g13753 | i0 | 97.5 | 19.5131578947368 | 40 | 1 | 18 | 0 | 188 | 227 | 67584 | 67623 | Orf virus isolate FX10, partial genome | blastn | 4449 | 69.4 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf | ||
| 23965998 | 23965998 | PRJNA1068513_S_NODE_2319_length_543_cov_4.076596_g2277_i0 | PRJNA1068513 | 2319 | 543 | 4.076596 | 22.13591628 | Viruses | 10239 | Viruses | Viruses | 93.5 | 3.15e-14 | NTclustered | gi|2755084441|gb|PP943425.1| | 10258 | g2277 | i0 | 93.651 | 13.4014732965009 | 63 | 2 | 11 | 2 | 482 | 543 | 67824 | 67763 | Orf virus isolate FX10, partial genome | blastn | 7277 | 93.5 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Pokkesviricetes | Chitovirales | Poxviridae | Parapoxvirus | Parapoxvirus orf |
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);;