RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Shotokuvirae · 6 ✖

bioproject 1

  • PRJNA841653 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3380904 3380904 PRJNA841653_P_NODE_14763_length_428_cov_1.259155_g14092_i0 PRJNA841653 14763 428 1.259155 5.3891834 Cressdnaviricota sp. 2748378 Viruses Viruses 309 2.22e-79   NTclustered gi|1436202143|gb|MH616828.1| 2748378 g14092 i0 80.835 0.950934579439252 407 66 94 12 8 408 401 1 MAG: Cressdnaviricota sp. isolate ctca551, complete genome blastn 407 309 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
5933910 5933910 PRJNA841653_P_NODE_4725_length_791_cov_1.619777_g4129_i0 PRJNA841653 4725 791 1.619777 12.81243607 Galvornvirus isengard 2955925 Viruses Viruses 736 0   NTclustered gi|1436204090|gb|MH616909.1| 1954248 g4129 i0 92.161 2.61820480404551 523 37 93 4 267 787 67 587 MAG: Circoviridae sp. isolate ctjb353, complete genome blastn 2071 736 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
8483818 8483818 PRJNA841653_P_NODE_667_length_3736_cov_3.811903_g582_i0 PRJNA841653 667 3736 3.811903 142.41269608 Avon-Heathcote Estuary associated circular virus 13 1618236 Viruses Viruses 894 0   NTclustered gi|761263250|gb|KM874331.1| 1618236 g582 i0 75.499 2.8948072805139198 2004 398 95 75 12 1972 1955 2 Avon-Heathcote Estuary associated circular virus 13 isolate AHEaCV-13-NZ-4754GA-2012, complete genome blastn 10815 894 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Avon-Heathcote Estuary associated circular virus 13
13583764 13583764 PRJNA841653_P_NODE_16671_length_401_cov_1.856707_g15999_i0 PRJNA841653 16671 401 1.856707 7.44539507 Galvornvirus isengard 2955925 Viruses Viruses 627 5.0199999999999986e-175   NTclustered gi|1436204090|gb|MH616909.1| 1954248 g15999 i0 98.319 1.54862842892768 357 6 89 0 1 357 962 1318 MAG: Circoviridae sp. isolate ctjb353, complete genome blastn 621 627 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
16133314 16133314 PRJNA841653_P_NODE_40453_length_259_cov_1.634409_g39779_i0 PRJNA841653 40453 259 1.634409 4.23311931 Cressdnaviricota sp. 2748378 Viruses Viruses 200 7.959999999999999e-47   NTclustered gi|1436202143|gb|MH616828.1| 2748378 g39779 i0 83.111 0.868725868725869 225 32 86 4 32 253 617 396 MAG: Cressdnaviricota sp. isolate ctca551, complete genome blastn 225 200 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
21232745 21232745 PRJNA841653_P_NODE_44097_length_251_cov_0.865169_g43423_i0 PRJNA841653 44097 251 0.865169 2.17157419 Galvornvirus isengard 2955925 Viruses Viruses 183 7.73e-42   NTclustered gi|1436212649|gb|MH617400.1| 1954248 g43423 i0 80.8 0.99601593625498 250 34 96 12 1 240 676 921 MAG: Circoviridae sp. isolate ctdb445, complete genome blastn 250 183 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard

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