RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA380660" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 6 ✖

bioproject 1

  • PRJNA380660 · 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
2349565 2349565 PRJNA380660_P_NODE_7182_length_271_cov_2.900826_g6782_i0 PRJNA380660 7182 271 2.900826 7.86123846 Viruses 10239 Viruses Viruses 298 2.89e-76   NTclustered gi|2214231626|gb|OM622299.1| 1955153 g6782 i0 98.802 2.03690036900369 167 2 100 0 105 271 5531 5697 MAG: Picornavirales sp. isolate HPLV-44 genomic sequence blastn 552 298 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Picornavirales sp.
7452205 7452205 PRJNA380660_P_NODE_7406_length_265_cov_1.766949_g7006_i0 PRJNA380660 7406 265 1.766949 4.68241485 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|1720276672|gb|MK959613.1| 10493 g7006 i0 96.97 5.8377358490566 33 0 12 1 180 212 51119 51088 Frog virus 3 strain Z920 blastn 1547 54.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Pimascovirales Iridoviridae Ranavirus Ranavirus rana1
10606005 10606005 PRJNA380660_P_NODE_6809_length_283_cov_1587.318898_g6409_i0 PRJNA380660 6809 283 1587.318898 4492.11248134 Betacoronavirus pandemicum 3418604 Viruses Viruses 54.7 0.007   NTclustered gi|2046846597|emb|OU077603.1| 2697049 g6409 i0 100 0.102473498233216 29 0 10 0 255 283 30001 30029 Severe acute respiratory syndrome coronavirus 2 genome assembly, chromosome: 1 blastn 29 54.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Nidovirales Coronaviridae Betacoronavirus Betacoronavirus pandemicum
13156006 13156006 PRJNA380660_P_NODE_8751_length_230_cov_2.034826_g8351_i0 PRJNA380660 8751 230 2.034826 4.6800998 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 265 2.42e-66   NTclustered gi|2214231626|gb|OM622299.1| 3003959 g8351 i0 97.419 1.34782608695652 155 4 67 0 1 155 3807 3653 MAG: Picornavirales sp. isolate HPLV-44 genomic sequence blastn 310 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
16979566 16979566 PRJNA380660_P_NODE_12774_length_153_cov_1.943548_g12374_i0 PRJNA380660 12774 153 1.943548 2.97362844 Totivirus sp. 2776824 Viruses Viruses 272 8.84e-69   NTclustered gi|1918615616|gb|MT949667.1| 2776824 g12374 i0 98.693 1.99346405228758 153 2 100 0 1 153 1259 1107 Totivirus sp. isolate sequence_5835 genomic sequence blastn 305 272 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Totivirus sp.
19528063 19528063 PRJNA380660_P_NODE_11976_length_169_cov_2.300000_g11576_i0 PRJNA380660 11976 169 2.3 3.887 Caudoviricetes sp. 2832643 Viruses Viruses 207 2.85e-49   NTclustered gi|2059905452|tpg|BK041391.1| 2832643 g11576 i0 88.757 1 169 19 100 0 1 169 13542 13710 MAG TPA_asm: Caudoviricetes sp. isolate ct2M34, partial genome blastn 169 207 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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