RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA557436" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Shotokuvirae · 4 ✖

bioproject 1

  • PRJNA557436 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
1811299 1811299 PRJNA557436_S_NODE_1322_length_317_cov_2.411348_g1274_i0 PRJNA557436 1322 317 2.411348 7.64397316 Humpback whale blow-associated circo-like virus 2 2217875 Viruses Viruses 189 2.1699999999999992e-43   NTclustered gi|2080100052|gb|MZ244281.1| 2217875 g1274 i0 100 0.55205047318612 102 0 54 0 216 317 193 92 MAG: Humpback whale blow-associated circo-like virus 2 isolate 357circoc2 sequence blastn 175 189 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Humpback whale blow-associated circo-like virus 2
3086661 3086661 PRJNA557436_S_NODE_6343_length_169_cov_7.902985_g6295_i0 PRJNA557436 6343 169 7.902985 13.35604465 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 143 8.139999999999998e-30   NTclustered gi|1836405723|gb|MT138265.1| 3003968 g6295 i0 88.43 1.71005917159763 121 11 72 3 24 144 120 3 MAG: Parvo-like hybrid virus UC4 isolate par077par1 genomic sequence blastn 289 143 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Lineavirales Oomyviridae Nicoomyvirus Fish-associated parvo-like hybrid virus
5639555 5639555 PRJNA557436_S_NODE_8345_length_155_cov_5.283333_g8297_i0 PRJNA557436 8345 155 5.283333 8.18916615 Fish-associated parvo-like hybrid virus 3003968 Viruses Viruses 97.1 5.8e-16   NTclustered gi|2413975758|gb|OP933682.1| 3003968 g8297 i0 96.61 0.651612903225806 59 0 37 2 46 103 79 136 MAG: Fish-associated parvo-like hybrid virus isolate fi099par4 replication protein and capsid protein genes, complete cds blastn 101 97.1 1 Viruses   Shotokuvirae Cossaviricota Quintoviricetes Piccovirales Parvoviridae   Fish-associated parvo-like hybrid virus
15838481 15838481 PRJNA557436_S_NODE_5833_length_174_cov_2.258993_g5785_i0 PRJNA557436 5833 174 2.258993 3.93064782 Humpback whale blow-associated circo-like virus 2 2217875 Viruses Viruses 100 5.15e-17   NTclustered gi|2080100052|gb|MZ244281.1| 2217875 g5785 i0 98.246 0.327586206896552 57 1 33 0 1 57 233 289 MAG: Humpback whale blow-associated circo-like virus 2 isolate 357circoc2 sequence blastn 57 100 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Humpback whale blow-associated circo-like virus 2

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