contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA685607" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1942433 | 1942433 | PRJNA685607_P_NODE_80382_length_246_cov_0.890173_g80023_i0 | PRJNA685607 | 80382 | 246 | 0.890173 | 2.18982558 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g80023 | i0 | 100 | 0.341463414634146 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 84 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 2451758 | 2451758 | PRJNA685607_P_NODE_77002_length_247_cov_0.885057_g76643_i0 | PRJNA685607 | 77002 | 247 | 0.885057 | 2.18609079 | Picornavirales | 464095 | Viruses | Viruses | 444 | 3.15e-120 | NTclustered | gi|2245485642|gb|ON161938.1| | 1530251 | g76643 | i0 | 99.187 | 4.93117408906883 | 246 | 2 | 99 | 0 | 2 | 247 | 4088 | 3843 | MAG: Picornaviridae sp. isolate 81b-k141_69037_2 RNA dependent RNA polymerase gene, partial cds; and capsid protein gene, complete cds | blastn | 1218 | 444 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Picornaviridae sp. | |||
| 4494387 | 4494387 | PRJNA685607_P_NODE_82844_length_245_cov_0.895349_g82485_i0 | PRJNA685607 | 82844 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g82485 | i0 | 100 | 0.261224489795918 | 29 | 0 | 12 | 0 | 1 | 29 | 1 | 29 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 64 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 5770102 | 5770102 | PRJNA685607_P_NODE_90925_length_243_cov_0.876471_g90566_i0 | PRJNA685607 | 90925 | 243 | 0.876471 | 2.12982453 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g90566 | i0 | 100 | 0.234567901234568 | 29 | 0 | 12 | 0 | 215 | 243 | 29 | 1 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 7044896 | 7044896 | PRJNA685607_P_NODE_1186_length_1501_cov_2.228291_g1042_i0 | PRJNA685607 | 1186 | 1501 | 2.228291 | 33.44664791 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 760 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1042 | i0 | 93.529 | 0.62491672218521 | 510 | 33 | 62 | 0 | 219 | 728 | 4195 | 4704 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 938 | 760 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 7044945 | 7044945 | PRJNA685607_P_NODE_30606_length_328_cov_1.058824_g30247_i0 | PRJNA685607 | 30606 | 328 | 1.058824 | 3.47294272 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 56.5 | 0.002 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g30247 | i0 | 100 | 0.176829268292683 | 30 | 0 | 9 | 0 | 299 | 328 | 30 | 1 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 58 | 56.5 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 10870496 | 10870496 | PRJNA685607_P_NODE_87789_length_244_cov_0.900585_g87430_i0 | PRJNA685607 | 87789 | 244 | 0.900585 | 2.1974274 | Zebrafish picornavirus 1 | 2304617 | Viruses | Viruses | 392 | 1.14e-104 | NTclustered | gi|1812398529|gb|MN524064.1| | 2304617 | g87430 | i0 | 96.234 | 2.93852459016393 | 239 | 9 | 98 | 0 | 1 | 239 | 1860 | 2098 | Zebrafish picornavirus 1 isolate CZAR/ZfPV/2018/Utah/USA, complete genome | blastn | 717 | 392 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Zebrafish picornavirus 1 | |||
| 12145579 | 12145579 | PRJNA685607_P_NODE_18730_length_385_cov_1.307692_g18372_i0 | PRJNA685607 | 18730 | 385 | 1.307692 | 5.0346142 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 512 | 1.4000000000000001e-140 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g18372 | i0 | 93.586 | 0.890909090909091 | 343 | 22 | 89 | 0 | 43 | 385 | 2543 | 2201 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 343 | 512 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 13420361 | 13420361 | PRJNA685607_P_NODE_74311_length_248_cov_0.880000_g73952_i0 | PRJNA685607 | 74311 | 248 | 0.88 | 2.1824 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 58.4 | 4.82e-4 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g73952 | i0 | 100 | 0.237903225806452 | 31 | 0 | 13 | 0 | 1 | 31 | 1 | 31 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 59 | 58.4 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695296 | 14695296 | PRJNA685607_P_NODE_49572_length_279_cov_1.286408_g49213_i0 | PRJNA685607 | 49572 | 279 | 1.286408 | 3.58907832 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 63.9 | 1.19e-5 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g49213 | i0 | 100 | 0.222222222222222 | 34 | 0 | 12 | 0 | 1 | 34 | 1 | 34 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 62 | 63.9 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695370 | 14695370 | PRJNA685607_P_NODE_73632_length_248_cov_0.880000_g73273_i0 | PRJNA685607 | 73632 | 248 | 0.88 | 2.1824 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g73273 | i0 | 100 | 0.225806451612903 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 14695426 | 14695426 | PRJNA685607_P_NODE_83412_length_245_cov_0.895349_g83053_i0 | PRJNA685607 | 83412 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 54.7 | 0.006 | NTclustered | gi|2672713159|gb|OR645555.1| | 881914 | g83053 | i0 | 100 | 0.23265306122449 | 29 | 0 | 12 | 0 | 1 | 29 | 1972 | 1944 | MAG: Tribec virus isolate Romania segment 3, complete sequence | blastn | 57 | 54.7 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 15969014 | 15969014 | PRJNA685607_P_NODE_43633_length_291_cov_1.412844_g43274_i0 | PRJNA685607 | 43633 | 291 | 1.412844 | 4.11137604 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 115 | 3.39e-21 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g43274 | i0 | 91.566 | 0.285223367697594 | 83 | 7 | 29 | 0 | 209 | 291 | 1708 | 1626 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 83 | 115 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 18518333 | 18518333 | PRJNA685607_P_NODE_1875_length_1190_cov_3.471799_g1663_i0 | PRJNA685607 | 1875 | 1190 | 3.471799 | 41.3144081 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 1661 | 0 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g1663 | i0 | 91.919 | 0.998319327731092 | 1188 | 94 | 99 | 2 | 4 | 1190 | 6782 | 5596 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 1188 | 1661 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 19793437 | 19793437 | PRJNA685607_P_NODE_92776_length_242_cov_0.911243_g92417_i0 | PRJNA685607 | 92776 | 242 | 0.911243 | 2.20520806 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713155|gb|OR645553.1| | 881914 | g92417 | i0 | 100 | 0.115702479338843 | 28 | 0 | 12 | 0 | 215 | 242 | 28 | 1 | MAG: Tribec virus isolate Romania segment 1, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 21068654 | 21068654 | PRJNA685607_P_NODE_12117_length_456_cov_1.530026_g11760_i0 | PRJNA685607 | 12117 | 456 | 1.530026 | 6.97691856 | Danio blood picornavirus/Zebrafish picornavirus 2 | 3063761 | Viruses | Viruses | 370 | 1.07e-97 | NTclustered | gi|2551699335|gb|OK619588.1| | 3063761 | g11760 | i0 | 94.915 | 0.517543859649123 | 236 | 12 | 52 | 0 | 213 | 448 | 3703 | 3938 | Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds | blastn | 236 | 370 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Picornavirales | Picornaviridae | Danio blood picornavirus/Zebrafish picornavirus 2 | |||
| 21068888 | 21068888 | PRJNA685607_P_NODE_83997_length_245_cov_0.895349_g83638_i0 | PRJNA685607 | 83997 | 245 | 0.895349 | 2.19360505 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g83638 | i0 | 100 | 0.228571428571429 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 22343732 | 22343732 | PRJNA685607_P_NODE_78138_length_247_cov_0.885057_g77779_i0 | PRJNA685607 | 78138 | 247 | 0.885057 | 2.18609079 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.022 | NTclustered | gi|2672713167|gb|OR645559.1| | 881914 | g77779 | i0 | 100 | 0.226720647773279 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 7, complete sequence | blastn | 56 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae | ||
| 24892495 | 24892495 | PRJNA685607_P_NODE_69320_length_250_cov_0.870056_g68961_i0 | PRJNA685607 | 69320 | 250 | 0.870056 | 2.17514 | Orbivirus magninsulae | 3431249 | Viruses | Viruses | 52.8 | 0.023 | NTclustered | gi|2672713155|gb|OR645553.1| | 881914 | g68961 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 1 | 28 | 1 | 28 | MAG: Tribec virus isolate Romania segment 1, complete sequence | blastn | 28 | 52.8 | 1 | Viruses | Orthornavirae | Duplornaviricota | Resentoviricetes | Reovirales | Sedoreoviridae | Orbivirus | Orbivirus magninsulae |
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);;