contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2879795 | 2879795 | PRJNA1204310_P_NODE_23103_length_380_cov_1.524430_g22806_i0 | PRJNA1204310 | 23103 | 380 | 1.52443 | 5.792834 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 697 | 0 | NTclustered | gi|1571847414|ref|NC_040800.1| | 2560282 | g22806 | i0 | 99.737 | 3 | 380 | 1 | 100 | 0 | 1 | 380 | 2671 | 2292 | Actinidia seed-borne latent virus isolate 01227, complete genome | blastn | 1140 | 697 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 2880029 | 2880029 | PRJNA1204310_P_NODE_33123_length_324_cov_1.864542_g32826_i0 | PRJNA1204310 | 33123 | 324 | 1.864542 | 6.04111608 | Iflavirus sp. | 1916690 | Viruses | Viruses | 571 | 1.8899999999999993e-158 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g32826 | i0 | 98.457 | 35.4351851851852 | 324 | 5 | 100 | 0 | 1 | 324 | 9283 | 8960 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 11481 | 571 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 2880200 | 2880200 | PRJNA1204310_P_NODE_40063_length_293_cov_0.850000_g39766_i0 | PRJNA1204310 | 40063 | 293 | 0.85 | 2.4905 | brine shrimp arlivirus 7 | 2900382 | Viruses | Viruses | 520 | 6.2e-143 | NTclustered | gi|2209095168|gb|OL472412.1| | 2900382 | g39766 | i0 | 98.635 | 1 | 293 | 4 | 100 | 0 | 1 | 293 | 2792 | 3084 | MAG: Brine shrimp arlivirus 7 isolate XZ/98-19 hypothetical protein, RNA-dependent RNA polymerase, and hypothetical protein genes, complete cds | blastn | 293 | 520 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Mononegavirales | Lispiviridae | Arlivirus | brine shrimp arlivirus 7 | ||
| 2880373 | 2880373 | PRJNA1204310_P_NODE_4783_length_772_cov_1.988555_g4526_i0 | PRJNA1204310 | 4783 | 772 | 1.988555 | 15.3516446 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 1404 | 0 | NTclustered | gi|1571847414|ref|NC_040800.1| | 2560282 | g4526 | i0 | 99.482 | 16.4779792746114 | 772 | 4 | 100 | 0 | 1 | 772 | 7749 | 6978 | Actinidia seed-borne latent virus isolate 01227, complete genome | blastn | 12721 | 1404 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 4155903 | 4155903 | PRJNA1204310_P_NODE_23544_length_377_cov_1.279605_g23247_i0 | PRJNA1204310 | 23544 | 377 | 1.279605 | 4.82411085 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 691 | 0 | NTclustered | gi|1571847414|ref|NC_040800.1| | 2560282 | g23247 | i0 | 99.735 | 3 | 377 | 1 | 100 | 0 | 1 | 377 | 2128 | 1752 | Actinidia seed-borne latent virus isolate 01227, complete genome | blastn | 1131 | 691 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 6707212 | 6707212 | PRJNA1204310_P_NODE_45166_length_275_cov_1.158416_g44869_i0 | PRJNA1204310 | 45166 | 275 | 1.158416 | 3.185644 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 508 | 1.2499999999999999e-139 | NTclustered | gi|1571847414|ref|NC_040800.1| | 2560282 | g44869 | i0 | 100 | 4.93090909090909 | 275 | 0 | 100 | 0 | 1 | 275 | 426 | 700 | Actinidia seed-borne latent virus isolate 01227, complete genome | blastn | 1356 | 508 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 7982934 | 7982934 | PRJNA1204310_P_NODE_48087_length_263_cov_1.642105_g47790_i0 | PRJNA1204310 | 48087 | 263 | 1.642105 | 4.31873615 | Iflavirus sp. | 1916690 | Viruses | Viruses | 442 | 1.2199999999999994e-119 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g47790 | i0 | 96.958 | 7.97338403041825 | 263 | 8 | 100 | 0 | 1 | 263 | 5488 | 5750 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 2097 | 442 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 10533338 | 10533338 | PRJNA1204310_P_NODE_49029_length_259_cov_1.876344_g48732_i0 | PRJNA1204310 | 49029 | 259 | 1.876344 | 4.85973096 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 479 | 9.13e-131 | NTclustered | gi|1534861450|dbj|LC438404.1| | 2560282 | g48732 | i0 | 100 | 3 | 259 | 0 | 100 | 0 | 1 | 259 | 6818 | 6560 | Actinidia seed borne latent virus JN-BS4 RNA, complete genome | blastn | 777 | 479 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 10533351 | 10533351 | PRJNA1204310_P_NODE_49769_length_256_cov_1.704918_g49472_i0 | PRJNA1204310 | 49769 | 256 | 1.704918 | 4.36459008 | Iflavirus sp. | 1916690 | Viruses | Viruses | 435 | 1.98e-117 | NTclustered | gi|2895513723|tpg|BK068482.1| | 1916690 | g49472 | i0 | 97.266 | 6.99609375 | 256 | 7 | 100 | 0 | 1 | 256 | 1547 | 1292 | TPA_asm: Iflavirus sp. isolate WUR11 polyprotein gene, complete cds | blastn | 1791 | 435 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 13082447 | 13082447 | PRJNA1204310_P_NODE_21031_length_396_cov_0.866873_g20734_i0 | PRJNA1204310 | 21031 | 396 | 0.866873 | 3.43281708 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 643 | 4.919999999999999e-180 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g20734 | i0 | 95.96 | 3 | 396 | 16 | 100 | 0 | 1 | 396 | 7046 | 7441 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 1188 | 643 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14357647 | 14357647 | PRJNA1204310_P_NODE_13412_length_483_cov_1.056098_g13115_i0 | PRJNA1204310 | 13412 | 483 | 1.056098 | 5.10095334 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 793 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13115 | i0 | 96.273 | 3 | 483 | 18 | 100 | 0 | 1 | 483 | 4430 | 3948 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1449 | 793 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 14358304 | 14358304 | PRJNA1204310_P_NODE_39732_length_294_cov_1.085973_g39435_i0 | PRJNA1204310 | 39732 | 294 | 1.085973 | 3.19276062 | Iflavirus sp. | 1916690 | Viruses | Viruses | 516 | 8.05e-142 | NTclustered | gi|2895513721|tpg|BK068481.1| | 1916690 | g39435 | i0 | 98.299 | 9.3265306122449 | 294 | 5 | 100 | 0 | 1 | 294 | 3172 | 2879 | TPA_asm: Iflavirus sp. isolate WUR10 polyprotein gene, complete cds | blastn | 2742 | 516 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 15632292 | 15632292 | PRJNA1204310_P_NODE_47453_length_266_cov_1.212435_g47156_i0 | PRJNA1204310 | 47453 | 266 | 1.212435 | 3.2250771 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 481 | 2.62e-131 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g47156 | i0 | 99.248 | 3.00375939849624 | 266 | 2 | 100 | 0 | 1 | 266 | 641 | 376 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 799 | 481 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 15632706 | 15632706 | PRJNA1204310_P_NODE_8273_length_604_cov_1.011299_g7987_i0 | PRJNA1204310 | 8273 | 604 | 1.011299 | 6.10824596 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 1072 | 0 | NTclustered | gi|1534861450|dbj|LC438404.1| | 2560282 | g7987 | i0 | 98.675 | 3 | 604 | 8 | 100 | 0 | 1 | 604 | 3696 | 4299 | Actinidia seed borne latent virus JN-BS4 RNA, complete genome | blastn | 1812 | 1072 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 16905946 | 16905946 | PRJNA1204310_P_NODE_19694_length_407_cov_1.398204_g19397_i0 | PRJNA1204310 | 19694 | 407 | 1.398204 | 5.69069028 | Prunevirus actinidiae | 3241185 | Viruses | Viruses | 752 | 0 | NTclustered | gi|1571847414|ref|NC_040800.1| | 2560282 | g19397 | i0 | 100 | 3 | 407 | 0 | 100 | 0 | 1 | 407 | 5166 | 4760 | Actinidia seed-borne latent virus isolate 01227, complete genome | blastn | 1221 | 752 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Tymovirales | Betaflexiviridae | Prunevirus | Prunevirus actinidiae | ||
| 18180976 | 18180976 | PRJNA1204310_P_NODE_44455_length_277_cov_1.549020_g44158_i0 | PRJNA1204310 | 44455 | 277 | 1.54902 | 4.2907854 | Iflavirus sp. | 1916690 | Viruses | Viruses | 466 | 7.68e-127 | NTclustered | gi|2895513725|tpg|BK068483.1| | 1916690 | g44158 | i0 | 97.101 | 8.94945848375451 | 276 | 8 | 99 | 0 | 1 | 276 | 8143 | 7868 | TPA_asm: Iflavirus sp. isolate WUR12 polyprotein gene, complete cds | blastn | 2479 | 466 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 19455875 | 19455875 | PRJNA1204310_P_NODE_6696_length_665_cov_1.471284_g6416_i0 | PRJNA1204310 | 6696 | 665 | 1.471284 | 9.7840386 | Iflavirus sp. | 1916690 | Viruses | Viruses | 1157 | 0 | NTclustered | gi|2895513727|tpg|BK068484.1| | 1916690 | g6416 | i0 | 98.045 | 7.97894736842105 | 665 | 13 | 100 | 0 | 1 | 665 | 5739 | 6403 | TPA_asm: Iflavirus sp. isolate WUR13 polyprotein gene, complete cds | blastn | 5306 | 1157 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Iflaviridae | Iflavirus | Iflavirus sp. | ||
| 23281496 | 23281496 | PRJNA1204310_P_NODE_43039_length_283_cov_0.952381_g42742_i0 | PRJNA1204310 | 43039 | 283 | 0.952381 | 2.69523823 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 451 | 2.1999999999999995e-122 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g42742 | i0 | 95.406 | 3 | 283 | 13 | 100 | 0 | 1 | 283 | 5061 | 5343 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 849 | 451 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 24554786 | 24554786 | PRJNA1204310_P_NODE_14120_length_472_cov_0.892231_g13823_i0 | PRJNA1204310 | 14120 | 472 | 0.892231 | 4.21133032 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 806 | 0 | NTclustered | gi|2500378199|ref|NC_076245.1| | 2304617 | g13823 | i0 | 97.458 | 3 | 472 | 12 | 100 | 0 | 1 | 472 | 6524 | 6053 | Zebrafish picornavirus 1 strain IDEXX/ZfPV-1/2017/USA, complete genome | blastn | 1416 | 806 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 |
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);;