RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA773778" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA773778 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
27147751 27147751 PRJNA773778_S_NODE_26722_length_296_cov_1.183857_g26572_i0 PRJNA773778 26722 296 1.183857 3.50421672 Herophile durna-like virus 2912704 Viruses Viruses 87.4 1.4e-17   NR DAZ87252.1 2912704 g26572 i0 46.4 0.983108108108108 97 52 98.3 0 294 4 380 476 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 291 87.4 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
27337941 27337941 PRJNA773778_S_NODE_38083_length_257_cov_1.179348_g37933_i0 PRJNA773778 38083 257 1.179348 3.03092436 Herophile durna-like virus 2912704 Viruses Viruses 73.2 8.5e-13   NR DAZ87252.1 2912704 g37933 i0 47.3 0.863813229571984 74 38 86.4 1 225 4 266 338 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 222 73.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
27622176 27622176 PRJNA773778_S_NODE_2664_length_679_cov_2.671617_g2522_i0 PRJNA773778 2664 679 2.671617 18.14027943 Herophile durna-like virus 2912704 Viruses Viruses 65.1 3.52e-8   NR DAZ87252.1 2912704 g2522 i0 32.9 0.764359351988218 173 108 73.8 7 177 677 13 183 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 519 65.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
28095645 28095645 PRJNA773778_S_NODE_32065_length_276_cov_1.073892_g31915_i0 PRJNA773778 32065 276 1.073892 2.96394192 Herophile durna-like virus 2912704 Viruses Viruses 47.8 9.42e-4   NR DAZ87252.1 2912704 g31915 i0 40.8 0.826086956521739 76 42 81.5 2 9 233 434 507 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 228 47.8 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
28190113 28190113 PRJNA773778_S_NODE_35126_length_266_cov_1.113990_g34976_i0 PRJNA773778 35126 266 1.11399 2.9632134 Herophile durna-like virus 2912704 Viruses Viruses 73.2 9.56e-13   NR DAZ87252.1 2912704 g34976 i0 46.6 0.992481203007519 88 45 99.2 1 266 3 202 287 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 264 73.2 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
28569175 28569175 PRJNA773778_S_NODE_547_length_1210_cov_2.139842_g487_i0 PRJNA773778 547 1210 2.139842 25.8920882 Herophile durna-like virus 2912704 Viruses Viruses 285 4.71e-86   NR DAZ87252.1 2912704 g487 i0 43.8 0.872727272727273 352 191 87 4 4 1056 208 553 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 1056 285 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
29484619 29484619 PRJNA773778_S_NODE_430_length_1326_cov_6.120511_g380_i0 PRJNA773778 430 1326 6.120511 81.15797586 Herophile durna-like virus 2912704 Viruses Viruses 59.7 2e-5   NR DAZ87252.1 2912704 g380 i0 33.6 0.343891402714932 152 88 32.6 7 868 1299 13 159 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 456 59.7 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
29484620 29484620 PRJNA773778_S_NODE_43270_length_247_cov_1.316092_g43120_i0 PRJNA773778 43270 247 1.316092 3.25074724 Herophile durna-like virus 2912704 Viruses Viruses 54.3 3.32e-6   NR DAZ87252.1 2912704 g43120 i0 36.7 0.959514170040486 79 48 96 1 10 246 483 559 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 237 54.3 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
30432871 30432871 PRJNA773778_S_NODE_39493_length_253_cov_1.211111_g39343_i0 PRJNA773778 39493 253 1.211111 3.06411083 Herophile durna-like virus 2912704 Viruses Viruses 60.1 3.18e-8   NR DAZ87252.1 2912704 g39343 i0 35.6 0.865612648221344 73 45 85.4 2 36 251 128 199 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 219 60.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
30906629 30906629 PRJNA773778_S_NODE_44914_length_245_cov_1.156977_g44764_i0 PRJNA773778 44914 245 1.156977 2.83459365 Herophile durna-like virus 2912704 Viruses Viruses 49.3 1.86e-4   NR DAZ87252.1 2912704 g44764 i0 34.2 0.96734693877551 79 52 96.7 0 245 9 183 261 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 237 49.3 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus
31602132 31602132 PRJNA773778_S_NODE_356_length_1419_cov_5.556464_g313_i0 PRJNA773778 356 1419 5.556464 78.84622416 Herophile durna-like virus 2912704 Viruses Viruses 270 4.2900000000000005e-79   NR DAZ87252.1 2912704 g313 i0 37 0.959830866807611 454 252 92.4 8 1417 107 230 666 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 1362 270 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus

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