contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA482207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 448028 | 448028 | PRJNA482207_P_NODE_2261_length_611_cov_1.864312_g2161_i0 | PRJNA482207 | 2261 | 611 | 1.864312 | 11.39094632 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 1129 | 0 | NTclustered | gi|2500668202|ref|NC_078029.1| | 2029458 | g2161 | i0 | 100 | 2.72667757774141 | 611 | 0 | 100 | 0 | 1 | 611 | 45 | 655 | Colletotrichum camelliae filamentous virus 1 segment RNA 2, complete sequence | blastn | 1666 | 1129 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 2998624 | 2998624 | PRJNA482207_P_NODE_16643_length_271_cov_1.166667_g16533_i0 | PRJNA482207 | 16643 | 271 | 1.166667 | 3.16166757 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 484 | 2.07e-132 | NTclustered | gi|2500668202|ref|NC_078029.1| | 2029458 | g16533 | i0 | 98.893 | 1 | 271 | 3 | 100 | 0 | 1 | 271 | 1714 | 1984 | Colletotrichum camelliae filamentous virus 1 segment RNA 2, complete sequence | blastn | 271 | 484 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 2998629 | 2998629 | PRJNA482207_P_NODE_1683_length_699_cov_3.247604_g1594_i0 | PRJNA482207 | 1683 | 699 | 3.247604 | 22.70075196 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 1286 | 0 | NTclustered | gi|2500668191|ref|NC_078024.1| | 2029458 | g1594 | i0 | 99.857 | 1.19599427753934 | 699 | 1 | 100 | 0 | 1 | 699 | 717 | 19 | Colletotrichum camelliae filamentous virus 1 segment RNA 5, complete sequence | blastn | 836 | 1286 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 6825409 | 6825409 | PRJNA482207_P_NODE_13366_length_297_cov_1.343750_g13256_i0 | PRJNA482207 | 13366 | 297 | 1.34375 | 3.9909375 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 438 | 1.8099999999999998e-118 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g13256 | i0 | 93.266 | 1 | 297 | 20 | 100 | 0 | 1 | 297 | 4073 | 3777 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 297 | 438 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8100947 | 8100947 | PRJNA482207_P_NODE_14887_length_284_cov_1.791469_g14777_i0 | PRJNA482207 | 14887 | 284 | 1.791469 | 5.08777196 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 475 | 1.3099999999999999e-129 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g14777 | i0 | 96.831 | 1 | 284 | 9 | 100 | 0 | 1 | 284 | 5540 | 5823 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 284 | 475 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 8100984 | 8100984 | PRJNA482207_P_NODE_1727_length_690_cov_1.659643_g1635_i0 | PRJNA482207 | 1727 | 690 | 1.659643 | 11.4515367 | RD114 retrovirus | 11834 | Viruses | Viruses | 1264 | 0 | NTclustered | gi|306482054|dbj|AB559882.1| | 11834 | g1635 | i0 | 99.71 | 47.2521739130435 | 690 | 2 | 100 | 0 | 1 | 690 | 7555 | 8244 | RD114 retrovirus proviral DNA, complete genome, strain: CRT1 | blastn | 32604 | 1264 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | RD114 retrovirus | ||
| 8101294 | 8101294 | PRJNA482207_P_NODE_847_length_957_cov_7.555430_g778_i0 | PRJNA482207 | 847 | 957 | 7.55543 | 72.3054651 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 1751 | 0 | NTclustered | gi|2500668194|ref|NC_078025.1| | 2029458 | g778 | i0 | 99.79 | 1.99477533960293 | 954 | 2 | 99 | 0 | 4 | 957 | 969 | 16 | Colletotrichum camelliae filamentous virus 1 segment RNA 8, complete sequence | blastn | 1909 | 1751 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 8101295 | 8101295 | PRJNA482207_P_NODE_87_length_2707_cov_3.667426_g77_i0 | PRJNA482207 | 87 | 2707 | 3.667426 | 99.27722182 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 2481 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g77 | i0 | 91.807 | 0.872922053934245 | 1782 | 140 | 87 | 6 | 1 | 1779 | 7107 | 5329 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 2363 | 2481 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 11926815 | 11926815 | PRJNA482207_P_NODE_3430_length_508_cov_1.632184_g3320_i0 | PRJNA482207 | 3430 | 508 | 1.632184 | 8.29149472 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 440 | 9.079999999999996e-119 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g3320 | i0 | 95 | 0.718503937007874 | 280 | 14 | 72 | 0 | 223 | 502 | 5194 | 4915 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 365 | 440 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13201576 | 13201576 | PRJNA482207_P_NODE_2031_length_644_cov_1.252189_g1933_i0 | PRJNA482207 | 2031 | 644 | 1.252189 | 8.06409716 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1061 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1933 | i0 | 96.273 | 1 | 644 | 24 | 100 | 0 | 1 | 644 | 7019 | 6376 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 644 | 1061 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 14476489 | 14476489 | PRJNA482207_P_NODE_19092_length_251_cov_3.016854_g18982_i0 | PRJNA482207 | 19092 | 251 | 3.016854 | 7.57230354 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 464 | 2.47e-126 | NTclustered | gi|2500668191|ref|NC_078024.1| | 2029458 | g18982 | i0 | 100 | 1 | 251 | 0 | 100 | 0 | 1 | 251 | 994 | 744 | Colletotrichum camelliae filamentous virus 1 segment RNA 5, complete sequence | blastn | 251 | 464 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 14476619 | 14476619 | PRJNA482207_P_NODE_25972_length_245_cov_0.895349_g25862_i0 | PRJNA482207 | 25972 | 245 | 0.895349 | 2.19360505 | Rheavirus sinusmexicani | 3047716 | Viruses | Viruses | 233 | 7.36e-57 | NTclustered | gi|310830989|ref|NC_014637.1| | 693272 | g25862 | i0 | 84.211 | 2.73877551020408 | 247 | 31 | 99 | 8 | 3 | 245 | 518291 | 518049 | Cafeteria roenbergensis virus BV-PW1, complete genome | blastn | 671 | 233 | 1 | Viruses | Bamfordvirae | Nucleocytoviricota | Megaviricetes | Imitervirales | Mimiviridae | Rheavirus | Rheavirus sinusmexicani | ||
| 17025074 | 17025074 | PRJNA482207_P_NODE_10514_length_324_cov_1.227092_g10404_i0 | PRJNA482207 | 10514 | 324 | 1.227092 | 3.97577808 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 599 | 8.67e-167 | NTclustered | gi|2500668206|ref|NC_078031.1| | 2029458 | g10404 | i0 | 100 | 1 | 324 | 0 | 100 | 0 | 1 | 324 | 550 | 227 | Colletotrichum camelliae filamentous virus 1 segment RNA 3, complete sequence | blastn | 324 | 599 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 17025082 | 17025082 | PRJNA482207_P_NODE_10854_length_320_cov_2.157895_g10744_i0 | PRJNA482207 | 10854 | 320 | 2.157895 | 6.905264 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 592 | 1.4299999999999996e-164 | NTclustered | gi|2500668206|ref|NC_078031.1| | 2029458 | g10744 | i0 | 100 | 1 | 320 | 0 | 100 | 0 | 1 | 320 | 1533 | 1852 | Colletotrichum camelliae filamentous virus 1 segment RNA 3, complete sequence | blastn | 320 | 592 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 17025434 | 17025434 | PRJNA482207_P_NODE_494_length_1215_cov_4.555166_g450_i0 | PRJNA482207 | 494 | 1215 | 4.555166 | 55.3452669 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 2244 | 0 | NTclustered | gi|2500668196|ref|NC_078026.1| | 2029458 | g450 | i0 | 100 | 1.8 | 1215 | 0 | 100 | 0 | 1 | 1215 | 30 | 1244 | Colletotrichum camelliae filamentous virus 1 segment RNA 4, complete sequence | blastn | 2187 | 2244 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 18299493 | 18299493 | PRJNA482207_P_NODE_18115_length_259_cov_2.516129_g18005_i0 | PRJNA482207 | 18115 | 259 | 2.516129 | 6.51677411 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 473 | 4.25e-129 | NTclustered | gi|2500668206|ref|NC_078031.1| | 2029458 | g18005 | i0 | 99.614 | 1 | 259 | 1 | 100 | 0 | 1 | 259 | 942 | 684 | Colletotrichum camelliae filamentous virus 1 segment RNA 3, complete sequence | blastn | 259 | 473 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 19573677 | 19573677 | PRJNA482207_P_NODE_16496_length_272_cov_1.402010_g16386_i0 | PRJNA482207 | 16496 | 272 | 1.40201 | 3.8134672 | Zebrafish influenza-like virus | RQ12 | Viruses | Viruses | 401 | 2.1499999999999993e-107 | NTclustered | gi|1912436624|gb|MT926384.1| | RQ12 | g16386 | i0 | 93.358 | 0.996323529411765 | 271 | 18 | 99 | 0 | 1 | 271 | 565 | 835 | Siamese algae-eater influenza-like virus strain SAEILV/fish-T1K hemagglutinin (HA) gene, complete cds | blastn | 271 | 401 | 1 | Viruses | Orthornavirae | Negarnaviricota | Insthoviricetes | Articulavirales | Orthomyxoviridae | Zebrafish influenza-like virus | |||
| 22124484 | 22124484 | PRJNA482207_P_NODE_23458_length_247_cov_1.701149_g23348_i0 | PRJNA482207 | 23458 | 247 | 1.701149 | 4.20183803 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 435 | 1.9e-117 | NTclustered | gi|2500668200|ref|NC_078028.1| | 2029458 | g23348 | i0 | 98.381 | 1 | 247 | 4 | 100 | 0 | 1 | 247 | 855 | 1101 | Colletotrichum camelliae filamentous virus 1 segment RNA 1, complete sequence | blastn | 247 | 435 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 23400283 | 23400283 | PRJNA482207_P_NODE_24179_length_247_cov_0.885057_g24069_i0 | PRJNA482207 | 24179 | 247 | 0.885057 | 2.18609079 | Dalbergia cochinchinensis dicistro-like virus 1 | 2872414 | Viruses | Viruses | 398 | 2.4899999999999996e-106 | NTclustered | gi|2261582439|tpg|BK059251.1| | 2872414 | g24069 | i0 | 95.918 | 0.991902834008097 | 245 | 10 | 99 | 0 | 1 | 245 | 1100 | 1344 | TPA_asm: Dalbergia cochinchinensis dicistro-like virus 1 isolate Dc1 non-structural polyprotein gene, complete cds; and structural polyprotein gene, partial cds | blastn | 245 | 398 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Dicistroviridae | Dalbergia cochinchinensis dicistro-like virus 1 | |||
| 24674259 | 24674259 | PRJNA482207_P_NODE_30920_length_211_cov_4.079710_g30810_i0 | PRJNA482207 | 30920 | 211 | 4.07971 | 8.6081881 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 390 | 3.459999999999999e-104 | NTclustered | gi|2500668204|ref|NC_078030.1| | 2029458 | g30810 | i0 | 100 | 2.02843601895735 | 211 | 0 | 100 | 0 | 1 | 211 | 958 | 748 | Colletotrichum camelliae filamentous virus 1 segment RNA 7, complete sequence | blastn | 428 | 390 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi | ||||||
| 24674309 | 24674309 | PRJNA482207_P_NODE_820_length_968_cov_2.405587_g752_i0 | PRJNA482207 | 820 | 968 | 2.405587 | 23.28608216 | Polymycovirus colletotrichi | 3431808 | Viruses | Viruses | 1772 | 0 | NTclustered | gi|2500668198|ref|NC_078027.1| | 2029458 | g752 | i0 | 99.69 | 2.00619834710744 | 969 | 2 | 100 | 1 | 1 | 968 | 52 | 1020 | Colletotrichum camelliae filamentous virus 1 segment RNA 6, complete sequence | blastn | 1942 | 1772 | 1 | Viruses | Polymycoviridae | Polymycovirus | Polymycovirus colletotrichi |
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);;