RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA283169" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Shotokuvirae · 10 ✖

bioproject 1

  • PRJNA283169 · 10 ✖

analysis 1

  • blastn · 10 ✖

tax_clade 0

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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;