RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB39269" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

analysis 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 6 ✖

bioproject 1

  • PRJEB39269 · 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
1331347 1331347 PRJEB39269_P_NODE_42_length_3133_cov_3.824822_g32_i0 PRJEB39269 42 3133 3.824822 119.83167326 Leviviridae sp. 2027243 Viruses Viruses 1472 0   NTclustered gi|2183424863|gb|MZ679833.1| 2027243 g32 i0 75.886 0.982125758059368 3077 635 96 82 13 3033 909 3934 MAG: Leviviridae sp. isolate 358R-k141_998760 genomic sequence blastn 3077 1472 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
14085334 14085334 PRJEB39269_P_NODE_1852_length_904_cov_5.208092_g1660_i0 PRJEB39269 1852 904 5.208092 47.08115168 Leviviridae sp. 2027243 Viruses Viruses 262 1.8e-80   NR UJQ85939.1 2027243 g1660 i0 53.9 0.899336283185841 271 124 89.9 1 89 901 6 275 UJQ85939.1 MAG: hypothetical protein 1 [Leviviridae sp.] diamond 813 262 1 Viruses   Orthornavirae Lenarviricota Leviviricetes Norzivirales Fiersviridae   Leviviridae sp.
26969934 26969934 PRJEB39269_P_NODE_53502_length_188_cov_1.375839_g53097_i0 PRJEB39269 53502 188 1.375839 2.58657732 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 76.6 2.01e-14   NR XCM68351.1 3003959 g53097 i0 56.5 0.98936170212766 62 27 98.9 0 2 187 534 595 XCM68351.1 MAG: polyprotein, partial [Picornavirales sp.] diamond 186 76.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27886152 27886152 PRJEB39269_P_NODE_25_length_3669_cov_5.486226_g17_i0 PRJEB39269 25 3669 5.486226 201.28963194 Tuatara cloaca-associated picornavirus-1 2970602 Viruses Viruses 139 1.4e-30   NR UUV42596.1 2970602 g17 i0 27.7 0.372035977105478 455 298 35.7 7 1482 175 6 448 UUV42596.1 MAG: polyprotein, partial [Tuatara cloaca-associated picornavirus-1] diamond 1365 139 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Tuatara cloaca-associated picornavirus-1
28675689 28675689 PRJEB39269_P_NODE_20747_length_308_cov_1.702602_g20342_i0 PRJEB39269 20747 308 1.702602 5.24401416 Tuatara cloaca-associated picornavirus-1 2970602 Viruses Viruses 59.3 1.17e-7   NR UUV42596.1 2970602 g20342 i0 38.5 0.75974025974026 78 46 74 1 53 280 6 83 UUV42596.1 MAG: polyprotein, partial [Tuatara cloaca-associated picornavirus-1] diamond 234 59.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Tuatara cloaca-associated picornavirus-1
30949767 30949767 PRJEB39269_P_NODE_24374_length_283_cov_1.930328_g23969_i0 PRJEB39269 24374 283 1.930328 5.46282824 Tuatara cloaca-associated picornavirus-1 2970602 Viruses Viruses 45.4 0.00664   NR UUV42596.1 2970602 g23969 i0 32.5 0.816254416961131 77 52 81.6 0 47 277 89 165 UUV42596.1 MAG: polyprotein, partial [Tuatara cloaca-associated picornavirus-1] diamond 231 45.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Tuatara cloaca-associated picornavirus-1

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