contig_metadata
24 rows where bioproject = "PRJEB7366" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135245 | 135245 | PRJEB7366_P_NODE_14901_length_203_cov_1.904762_g14467_i0 | PRJEB7366 | 14901 | 203 | 1.904762 | 3.86666686 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 348 | 2.0100000000000006e-91 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g14467 | i0 | 97.537 | 1 | 203 | 5 | 100 | 0 | 1 | 203 | 1937 | 2139 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 203 | 348 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 135265 | 135265 | PRJEB7366_P_NODE_2201_length_657_cov_2.440514_g1837_i0 | PRJEB7366 | 2201 | 657 | 2.440514 | 16.03417698 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 702 | 0 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g1837 | i0 | 85.997 | 1 | 657 | 90 | 99 | 2 | 2 | 657 | 3802 | 3147 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 657 | 702 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 9062504 | 9062504 | PRJEB7366_P_NODE_12708_length_225_cov_1.631579_g12274_i0 | PRJEB7366 | 12708 | 225 | 1.631579 | 3.67105275 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 399 | 6.199999999999999e-107 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g12274 | i0 | 99.099 | 0.986666666666667 | 222 | 2 | 99 | 0 | 4 | 225 | 1541 | 1762 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 222 | 399 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 11613753 | 11613753 | PRJEB7366_P_NODE_18490_length_178_cov_1.398601_g18056_i0 | PRJEB7366 | 18490 | 178 | 1.398601 | 2.48950978 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 307 | 2.91e-79 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g18056 | i0 | 97.753 | 1.15730337078652 | 178 | 4 | 100 | 0 | 1 | 178 | 574 | 751 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 206 | 307 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 11613755 | 11613755 | PRJEB7366_P_NODE_190_length_1803_cov_3.829186_g139_i0 | PRJEB7366 | 190 | 1803 | 3.829186 | 69.04022358 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 1081 | 0 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g139 | i0 | 77.772 | 1.01053799223516 | 1822 | 361 | 99 | 37 | 1 | 1801 | 7734 | 5936 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 1822 | 1081 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 12888784 | 12888784 | PRJEB7366_P_NODE_10991_length_247_cov_1.816038_g10557_i0 | PRJEB7366 | 10991 | 247 | 1.816038 | 4.48561386 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 418 | 1.9099999999999998e-112 | NTclustered | gi|2780183578|gb|PP818844.1| | 1530251 | g10557 | i0 | 97.166 | 1 | 247 | 7 | 100 | 0 | 1 | 247 | 982 | 1228 | Picornaviridae sp. polyprotein and capsid protein genes, complete cds | blastn | 247 | 418 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 26939049 | 26939049 | PRJEB7366_P_NODE_8702_length_287_cov_1.416667_g8268_i0 | PRJEB7366 | 8702 | 287 | 1.416667 | 4.06583429 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 43.5 | 0.0335 | NR | WAY16457.1 | 2809460 | g8268 | i0 | 40.4 | 0.491289198606272 | 47 | 28 | 49.1 | 0 | 139 | 279 | 102 | 148 | WAY16457.1 hypothetical protein [Hepelivirales sp.] | diamond | 141 | 43.5 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27192029 | 27192029 | PRJEB7366_P_NODE_462_length_1356_cov_3.040121_g327_i0 | PRJEB7366 | 462 | 1356 | 3.040121 | 41.22404076 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 201 | 5.8899999999999984e-55 | NR | WAY16471.1 | 2809460 | g327 | i0 | 39.3 | 1.33407079646018 | 313 | 169 | 67.9 | 5 | 1086 | 166 | 185 | 482 | WAY16471.1 hypothetical protein [Hepelivirales sp.] | diamond | 1809 | 201 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 27634562 | 27634562 | PRJEB7366_P_NODE_22704_length_158_cov_1.300813_g22270_i0 | PRJEB7366 | 22704 | 158 | 1.300813 | 2.05528454 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 55.1 | 5.2e-7 | NR | WWZ85593.1 | 3132542 | g22270 | i0 | 60.4 | 1.00632911392405 | 53 | 18 | 98.7 | 2 | 3 | 158 | 1271 | 1321 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 159 | 55.1 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 28139873 | 28139873 | PRJEB7366_P_NODE_9725_length_267_cov_1.780172_g9291_i0 | PRJEB7366 | 9725 | 267 | 1.780172 | 4.75305924 | Hepelivirales sp. | 2809460 | Viruses | Viruses | 77 | 4.08e-14 | NR | WAY16439.1 | 2809460 | g9291 | i0 | 46.3 | 1.8876404494382 | 82 | 42 | 89.9 | 1 | 242 | 3 | 1 | 82 | WAY16439.1 hypothetical protein [Hepelivirales sp.] | diamond | 504 | 77 | 1 | Viruses | Orthornavirae | Kitrinoviricota | Alsuviricetes | Hepelivirales | Hepelivirales sp. | ||||
| 28423925 | 28423925 | PRJEB7366_P_NODE_6426_length_348_cov_1.523962_g5992_i0 | PRJEB7366 | 6426 | 348 | 1.523962 | 5.30338776 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 223 | 5.6e-65 | NR | XDJ26655.1 | 1530251 | g5992 | i0 | 97.4 | 1 | 116 | 3 | 100 | 0 | 348 | 1 | 525 | 640 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 348 | 223 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 28581799 | 28581799 | PRJEB7366_P_NODE_23227_length_156_cov_1.256198_g22793_i0 | PRJEB7366 | 23227 | 156 | 1.256198 | 1.95966888 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 73.9 | 1.11e-13 | NR | WWZ85593.1 | 3132542 | g22793 | i0 | 66 | 0.961538461538462 | 50 | 17 | 96.2 | 0 | 154 | 5 | 1343 | 1392 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 150 | 73.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 28771033 | 28771033 | PRJEB7366_P_NODE_5927_length_366_cov_1.924471_g5494_i0 | PRJEB7366 | 5927 | 366 | 1.924471 | 7.04356386 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 214 | 1.18e-61 | NR | XDJ26655.1 | 1530251 | g5494 | i0 | 80 | 0.983606557377049 | 120 | 24 | 98.4 | 0 | 365 | 6 | 1302 | 1421 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 360 | 214 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 29307775 | 29307775 | PRJEB7366_P_NODE_14149_length_210_cov_1.371429_g13715_i0 | PRJEB7366 | 14149 | 210 | 1.371429 | 2.8800009 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 115 | 5.98e-28 | NR | WWZ85593.1 | 3132542 | g13715 | i0 | 74.6 | 0.957142857142857 | 67 | 17 | 95.7 | 0 | 6 | 206 | 1113 | 1179 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 201 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 29465325 | 29465325 | PRJEB7366_P_NODE_22850_length_157_cov_1.639344_g22416_i0 | PRJEB7366 | 22850 | 157 | 1.639344 | 2.57377008 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 112 | 3.41e-27 | NR | XDJ26655.1 | 1530251 | g22416 | i0 | 98.1 | 0.993630573248408 | 52 | 1 | 99.4 | 0 | 157 | 2 | 1178 | 1229 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 156 | 112 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 29812923 | 29812923 | PRJEB7366_P_NODE_9851_length_265_cov_1.565217_g9417_i0 | PRJEB7366 | 9851 | 265 | 1.565217 | 4.14782505 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 180 | 2.12e-50 | NR | XDJ26655.1 | 1530251 | g9417 | i0 | 98.9 | 0.99622641509434 | 88 | 1 | 99.6 | 0 | 1 | 264 | 641 | 728 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 264 | 180 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 30065610 | 30065610 | PRJEB7366_P_NODE_6012_length_362_cov_1.834862_g5579_i0 | PRJEB7366 | 6012 | 362 | 1.834862 | 6.64220044 | Fish-associated picorna-like virus 3 | 3003959 | Viruses | Viruses | 63.2 | 1.08e-8 | NR | XCM67768.1 | 3003959 | g5579 | i0 | 35.7 | 0.812154696132597 | 98 | 57 | 79.6 | 3 | 14 | 301 | 1936 | 2029 | XCM67768.1 MAG: polyprotein [Picornavirales sp.] | diamond | 294 | 63.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Fish-associated picorna-like virus 3 | ||||
| 30382106 | 30382106 | PRJEB7366_P_NODE_10413_length_256_cov_1.226244_g9979_i0 | PRJEB7366 | 10413 | 256 | 1.226244 | 3.13918464 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 68.9 | 2.73e-11 | NR | WWZ85593.1 | 3132542 | g9979 | i0 | 64.4 | 0.52734375 | 45 | 16 | 52.7 | 0 | 1 | 135 | 2937 | 2981 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 135 | 68.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 30508084 | 30508084 | PRJEB7366_P_NODE_9873_length_264_cov_3.349345_g9439_i0 | PRJEB7366 | 9873 | 264 | 3.349345 | 8.8422708 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 179 | 3.95e-50 | NR | XDJ26655.1 | 1530251 | g9439 | i0 | 97.7 | 1 | 88 | 2 | 100 | 0 | 1 | 264 | 1221 | 1308 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 264 | 179 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 30563746 | 30563746 | PRJEB7366_P_NODE_10613_length_253_cov_1.233945_g10179_i0 | PRJEB7366 | 10613 | 253 | 1.233945 | 3.12188085 | Chuvivirus | 2842604 | Viruses | Viruses | 99 | 5.17e-22 | NR | WET19887.1 | 2842604 | g10179 | i0 | 63.1 | 1.99209486166008 | 84 | 31 | 99.6 | 0 | 252 | 1 | 259 | 342 | WET19887.1 MAG: nucleoprotein [Freshwater turtle neural virus 1] | diamond | 504 | 99 | 1 | Viruses | Orthornavirae | Negarnaviricota | Monjiviricetes | Jingchuvirales | Chuviridae | Chuvivirus | Chuvivirus | ||
| 30792397 | 30792397 | PRJEB7366_P_NODE_5834_length_370_cov_1.432836_g5401_i0 | PRJEB7366 | 5834 | 370 | 1.432836 | 5.3014932 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 147 | 2.61e-38 | NR | WWZ85593.1 | 3132542 | g5401 | i0 | 64 | 1.01351351351351 | 125 | 35 | 99.7 | 3 | 2 | 370 | 2382 | 2498 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 375 | 147 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 31076935 | 31076935 | PRJEB7366_P_NODE_575_length_1234_cov_2.860717_g421_i0 | PRJEB7366 | 575 | 1234 | 2.860717 | 35.30124778 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 645 | 2.19e-207 | NR | WWZ85593.1 | 3132542 | g421 | i0 | 72.3 | 0.991896272285251 | 408 | 111 | 98.7 | 1 | 1223 | 6 | 2516 | 2923 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 1224 | 645 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 31234669 | 31234669 | PRJEB7366_P_NODE_9495_length_272_cov_1.240506_g9061_i0 | PRJEB7366 | 9495 | 272 | 1.240506 | 3.37417632 | Macrobrachium rosenbergii picorna-like virus 4 | 3132542 | Viruses | Viruses | 141 | 1.32e-36 | NR | WWZ85593.1 | 3132542 | g9061 | i0 | 72.2 | 0.992647058823529 | 90 | 25 | 99.3 | 0 | 271 | 2 | 1720 | 1809 | WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] | diamond | 270 | 141 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Macrobrachium rosenbergii picorna-like virus 4 | ||||
| 32532057 | 32532057 | PRJEB7366_P_NODE_1939_length_704_cov_1.995516_g1590_i0 | PRJEB7366 | 1939 | 704 | 1.995516 | 14.04843264 | Picornaviridae sp. | 1530251 | Viruses | Viruses | 445 | 5.88e-141 | NR | XDJ26655.1 | 1530251 | g1590 | i0 | 90.2 | 0.997159090909091 | 234 | 23 | 99.7 | 0 | 703 | 2 | 1448 | 1681 | XDJ26655.1 polyprotein [Picornaviridae sp.] | diamond | 702 | 445 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. |
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);;