contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA283169" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646579 | 1646579 | PRJNA283169_P_NODE_4922_length_192_cov_1.090909_g4859_i0 | PRJNA283169 | 4922 | 192 | 1.090909 | 2.09454528 | clidnopec virus 68 | 3368040 | Viruses | Viruses | 255 | 1.17e-63 | NTclustered | gi|2836328225|gb|PQ161857.1| | 3368040 | g4859 | i0 | 90.625 | 1 | 192 | 18 | 100 | 0 | 1 | 192 | 4788 | 4597 | MAG: Clidnopec virus 68 isolate CS09 hypothetical protein, capsid protein, and hypothetical protein genes, complete cds | blastn | 192 | 255 | 1 | Viruses | clidnopec virus 68 | ||||||||
| 1646586 | 1646586 | PRJNA283169_P_NODE_5682_length_179_cov_2.430769_g5619_i0 | PRJNA283169 | 5682 | 179 | 2.430769 | 4.35107651 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 3.26e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5619 | i0 | 100 | 16.0949720670391 | 31 | 0 | 17 | 0 | 24 | 54 | 30034 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2881 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 1646620 | 1646620 | PRJNA283169_S_NODE_1562_length_220_cov_0.140351_g1548_i0 | PRJNA283169 | 1562 | 220 | 0.140351 | 0.3087722 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 187 | 5.12e-43 | NTclustered | gi|2015373061|gb|MW046496.1| | 3003968 | g1548 | i0 | 82.569 | 1.96818181818182 | 218 | 32 | 98 | 6 | 1 | 215 | 877 | 663 | MAG: Grus japonensis parvo-like hybrid virus isolate cra70par052 genomic sequence, sequence | blastn | 433 | 187 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 2922471 | 2922471 | PRJNA283169_P_NODE_8263_length_152_cov_2.077670_g8200_i0 | PRJNA283169 | 8263 | 152 | 2.07767 | 3.1580584 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 7.43e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g8200 | i0 | 97.222 | 18.9868421052632 | 36 | 0 | 24 | 1 | 113 | 148 | 30004 | 30038 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2886 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 2922478 | 2922478 | PRJNA283169_S_NODE_3_length_2092_cov_0.433186_g2_i0 | PRJNA283169 | 3 | 2092 | 0.433186 | 9.06225112 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 1954 | 0 | NTclustered | gi|2814138529|gb|PQ313127.1| | 3367306 | g2 | i0 | 93.895 | 1.48087954110899 | 1294 | 79 | 86 | 0 | 799 | 2092 | 2056 | 763 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 3098 | 1954 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 4198904 | 4198904 | PRJNA283169_P_NODE_4304_length_203_cov_1.012987_g4241_i0 | PRJNA283169 | 4304 | 203 | 1.012987 | 2.05636361 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 370 | 4.3e-98 | NTclustered | gi|2413975758|gb|OP933682.1| | 3003968 | g4241 | i0 | 99.507 | 1.95566502463054 | 203 | 1 | 100 | 0 | 1 | 203 | 2064 | 1862 | MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds | blastn | 397 | 370 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Fish-associated parvo-like hybrid virus | |||
| 5475186 | 5475186 | PRJNA283169_P_NODE_5365_length_185_cov_0.963235_g5302_i0 | PRJNA283169 | 5365 | 185 | 0.963235 | 1.78198475 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 63.9 | 7.3e-6 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5302 | i0 | 100 | 15.5891891891892 | 34 | 0 | 18 | 0 | 137 | 170 | 30004 | 30037 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2884 | 63.9 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 5475231 | 5475231 | PRJNA283169_S_NODE_2065_length_197_cov_0.108108_g2051_i0 | PRJNA283169 | 2065 | 197 | 0.108108 | 0.21297276 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 239 | 1.22e-58 | NTclustered | gi|2015373061|gb|MW046496.1| | 3003968 | g2051 | i0 | 92.262 | 1.61928934010152 | 168 | 13 | 85 | 0 | 2 | 169 | 450 | 617 | MAG: Grus japonensis parvo-like hybrid virus isolate cra70par052 genomic sequence, sequence | blastn | 319 | 239 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 6749483 | 6749483 | PRJNA283169_P_NODE_5886_length_176_cov_2.157480_g5823_i0 | PRJNA283169 | 5886 | 176 | 2.15748 | 3.7971648 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.87e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5823 | i0 | 100 | 16.375 | 32 | 0 | 18 | 0 | 135 | 166 | 30004 | 30035 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2882 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6749492 | 6749492 | PRJNA283169_P_NODE_6806_length_167_cov_0.872881_g6743_i0 | PRJNA283169 | 6806 | 167 | 0.872881 | 1.45771127 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 3.01e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g6743 | i0 | 100 | 21.562874251497 | 31 | 0 | 19 | 0 | 13 | 43 | 30034 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3601 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 6749506 | 6749506 | PRJNA283169_P_NODE_7906_length_163_cov_0.885965_g7843_i0 | PRJNA283169 | 7906 | 163 | 0.885965 | 1.44412295 | Caudoviricetes sp. | 2832643 | Viruses | Viruses | 302 | 1.22e-77 | NTclustered | gi|2054725468|tpg|BK038613.1| | 2832643 | g7843 | i0 | 100 | 99.638036809816 | 163 | 0 | 100 | 0 | 1 | 163 | 14278 | 14116 | MAG TPA_asm: Caudoviricetes sp. isolate ctIBy10, partial genome | blastn | 16241 | 302 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 9299894 | 9299894 | PRJNA283169_S_NODE_128_length_695_cov_1.243034_g117_i0 | PRJNA283169 | 128 | 695 | 1.243034 | 8.6390863 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 987 | 0 | NTclustered | gi|2814138529|gb|PQ313127.1| | 2794556 | g117 | i0 | 92.086 | 1.94532374100719 | 695 | 55 | 100 | 0 | 1 | 695 | 64 | 758 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 1352 | 987 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittacidae aveparvovirus | |||
| 9299899 | 9299899 | PRJNA283169_S_NODE_388_length_400_cov_0.683761_g374_i0 | PRJNA283169 | 388 | 400 | 0.683761 | 2.735044 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 152 | 3.67e-32 | NTclustered | gi|2814138529|gb|PQ313127.1| | 2794556 | g374 | i0 | 95.652 | 0.23 | 92 | 4 | 23 | 0 | 292 | 383 | 1 | 92 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 92 | 152 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittacidae aveparvovirus | |||
| 10575719 | 10575719 | PRJNA283169_P_NODE_3649_length_217_cov_1.613095_g3586_i0 | PRJNA283169 | 3649 | 217 | 1.613095 | 3.50041615 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 1.15e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g3586 | i0 | 100 | 13.2811059907834 | 32 | 0 | 15 | 0 | 135 | 166 | 30004 | 30035 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2882 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 10575723 | 10575723 | PRJNA283169_P_NODE_4289_length_203_cov_1.331169_g4226_i0 | PRJNA283169 | 4289 | 203 | 1.331169 | 2.70227307 | parvo-like hybrid virus | 3367306 | Viruses | Viruses | 355 | 1.2e-93 | NTclustered | gi|2814138529|gb|PQ313127.1| | 3367306 | g4226 | i0 | 98.03 | 1 | 203 | 4 | 100 | 0 | 1 | 203 | 2515 | 2313 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 203 | 355 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | parvo-like hybrid virus | |||
| 11262193 | 11262193 | PRJNA283169_S_NODE_3269_length_164_cov_0.147826_g3255_i0 | PRJNA283169 | 3269 | 164 | 0.147826 | 0.24243464 | Viruses | 10239 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2057987678|tpg|BK046881.1| | 2832643 | g3255 | i0 | 100 | 0.585365853658537 | 30 | 0 | 18 | 0 | 94 | 123 | 4652 | 4681 | MAG TPA_asm: Caudoviricetes sp. isolate ctckW2, partial genome | blastn | 96 | 56.5 | 1 | Viruses | Heunggongvirae | Uroviricota | Caudoviricetes | Caudoviricetes sp. | |||||
| 11850425 | 11850425 | PRJNA283169_P_NODE_4070_length_207_cov_4.265823_g4007_i0 | PRJNA283169 | 4070 | 207 | 4.265823 | 8.83025361 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 67.6 | 6.47e-7 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g4007 | i0 | 93.478 | 13.9903381642512 | 46 | 2 | 22 | 1 | 7 | 52 | 30045 | 30001 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2896 | 67.6 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11850443 | 11850443 | PRJNA283169_P_NODE_5510_length_182_cov_1.278195_g5447_i0 | PRJNA283169 | 5510 | 182 | 1.278195 | 2.3263149 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 9.25e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g5447 | i0 | 100 | 16.3571428571429 | 32 | 0 | 18 | 0 | 45 | 76 | 30033 | 30002 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2977 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 11850472 | 11850472 | PRJNA283169_P_NODE_8070_length_162_cov_0.920354_g8007_i0 | PRJNA283169 | 8070 | 162 | 0.920354 | 1.49097348 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 2.9e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g8007 | i0 | 97.143 | 17.8086419753086 | 35 | 0 | 22 | 1 | 5 | 39 | 30037 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2885 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 13125597 | 13125597 | PRJNA283169_P_NODE_31_length_1982_cov_12.799793_g23_i0 | PRJNA283169 | 31 | 1982 | 12.799793 | 253.69189726 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 1162 | 0 | NTclustered | gi|2814138529|gb|PQ313127.1| | 2794556 | g23 | i0 | 92.839 | 1.59434914228052 | 796 | 56 | 78 | 1 | 970 | 1764 | 796 | 1 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 3160 | 1162 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittacidae aveparvovirus | |||
| 14400733 | 14400733 | PRJNA283169_P_NODE_132_length_1119_cov_5.658879_g94_i0 | PRJNA283169 | 132 | 1119 | 5.658879 | 63.32285601 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 1221 | 0 | NTclustered | gi|2814138529|gb|PQ313127.1| | 2794556 | g94 | i0 | 91.705 | 1.57462019660411 | 880 | 73 | 79 | 0 | 1 | 880 | 1177 | 2056 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 1762 | 1221 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittacidae aveparvovirus | |||
| 14400811 | 14400811 | PRJNA283169_P_NODE_7732_length_163_cov_1.342105_g7669_i0 | PRJNA283169 | 7732 | 163 | 1.342105 | 2.18763115 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 58.4 | 2.92e-4 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g7669 | i0 | 100 | 17.6748466257669 | 31 | 0 | 19 | 0 | 12 | 42 | 30033 | 30003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2881 | 58.4 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 19497687 | 19497687 | PRJNA283169_P_NODE_2156_length_279_cov_1.304348_g2094_i0 | PRJNA283169 | 2156 | 279 | 1.304348 | 3.63913092 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 486 | 5.939999999999999e-133 | NTclustered | gi|2814138529|gb|PQ313127.1| | 2794556 | g2094 | i0 | 98.201 | 1.99641577060932 | 278 | 5 | 99 | 0 | 1 | 278 | 848 | 1125 | Parvo-like hybrid virus isolate SpinColumn12, partial genome | blastn | 557 | 486 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Psittacidae aveparvovirus | |||
| 20773288 | 20773288 | PRJNA283169_P_NODE_6097_length_173_cov_1.467742_g6034_i0 | PRJNA283169 | 6097 | 173 | 1.467742 | 2.53919366 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 56.5 | 0.001 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g6034 | i0 | 100 | 16.0982658959538 | 30 | 0 | 17 | 0 | 18 | 47 | 30032 | 30003 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 2785 | 56.5 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum | ||
| 24597927 | 24597927 | PRJNA283169_P_NODE_7540_length_164_cov_0.904348_g7477_i0 | PRJNA283169 | 7540 | 164 | 0.904348 | 1.48313072 | Betacoronavirus pandemicum | 3418604 | Viruses | Viruses | 60.2 | 8.18e-5 | NTclustered | gi|2046846597|emb|OU077603.1| | 2697049 | g7477 | i0 | 100 | 23.3658536585366 | 32 | 0 | 20 | 0 | 10 | 41 | 30035 | 30004 | Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 | blastn | 3832 | 60.2 | 1 | Viruses | Orthornavirae | Pisuviricota | Pisoniviricetes | Nidovirales | Coronaviridae | Betacoronavirus | Betacoronavirus pandemicum |
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);;