contig_metadata
15 rows where bioproject = "PRJNA283169" and tax_kingdom = "Shotokuvirae"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 28148125 | 28148125 | PRJNA283169_P_NODE_7085_length_166_cov_0.871795_g7022_i0 | PRJNA283169 | 7085 | 166 | 0.871795 | 1.4471797 | Genomoviridae sp. | 2202565 | Viruses | Viruses | 65.5 | 9.08e-11 | NR | QJB18634.1 | 2202565 | g7022 | i0 | 59.6 | 0.849397590361446 | 47 | 18 | 84.9 | 1 | 3 | 143 | 230 | 275 | QJB18634.1 MAG: replication-associated protein [Genomoviridae sp.] | diamond | 141 | 65.5 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Repensiviricetes | Geplafuvirales | Genomoviridae | Genomoviridae sp. | |||
| 29221684 | 29221684 | PRJNA283169_S_NODE_1049_length_260_cov_0.132701_g1035_i0 | PRJNA283169 | 1049 | 260 | 0.132701 | 0.3450226 | Psittacidae aveparvovirus | 2794556 | Viruses | Viruses | 152 | 1.06e-41 | NR | QTE03752.1 | 2794556 | g1035 | i0 | 82.4 | 0.980769230769231 | 85 | 15 | 98.1 | 0 | 5 | 259 | 334 | 418 | QTE03752.1 MAG: hypothetical protein [Psittacidae aveparvovirus] | diamond | 255 | 152 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Aveparvovirus | Psittacidae aveparvovirus | ||
| 29442249 | 29442249 | PRJNA283169_P_NODE_7450_length_164_cov_1.330435_g7387_i0 | PRJNA283169 | 7450 | 164 | 1.330435 | 2.1819134 | Fish-associated parvo-like hybrid virus | 3003968 | Viruses | Viruses | 115 | 3.74e-29 | NR | QTE03928.1 | 3003968 | g7387 | i0 | 92.6 | 0.98780487804878 | 54 | 4 | 98.8 | 0 | 162 | 1 | 91 | 144 | QTE03928.1 MAG: replication protein [Grus japonensis parvo-like hybrid virus] | diamond | 162 | 115 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Arfiviricetes | Lineavirales | Oomyviridae | Nicoomyvirus | Fish-associated parvo-like hybrid virus | ||
| 31464822 | 31464822 | PRJNA283169_P_NODE_5896_length_176_cov_1.598425_g5833_i0 | PRJNA283169 | 5896 | 176 | 1.598425 | 2.813228 | Skomarfal virus 49 | 3063507 | Viruses | Viruses | 97.8 | 8.159999999999999e-23 | NR | WPR18784.1 | 3063507 | g5833 | i0 | 77.6 | 1.97727272727273 | 58 | 13 | 98.9 | 0 | 2 | 175 | 26 | 83 | WPR18784.1 MAG: hypothetical protein [Skomarfal virus 49] | diamond | 348 | 97.8 | 1 | Viruses | Shotokuvirae | Cressdnaviricota | Skomarfal virus 49 | ||||||
| 32223936 | 32223936 | PRJNA283169_S_NODE_2458_length_183_cov_0.104478_g2444_i0 | PRJNA283169 | 2458 | 183 | 0.104478 | 0.19119474 | Chestnut teal chaphamaparvovirus | 2759402 | Viruses | Viruses | 47 | 5.18e-4 | NR | QMI57875.1 | 2759402 | g2444 | i0 | 48.9 | 1.63934426229508 | 47 | 23 | 77 | 1 | 145 | 5 | 294 | 339 | QMI57875.1 nonstructural protein 1, partial [Chestnut teal chaphamaparvovirus] | diamond | 300 | 47 | 1 | Viruses | Shotokuvirae | Cossaviricota | Quintoviricetes | Piccovirales | Parvoviridae | Chaphamaparvovirus | Chestnut teal chaphamaparvovirus |
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);;