RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_kingdom = "Bamfordvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bamfordvirae · 6 ✖

bioproject 1

  • PRJNA690592 · 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
5007315 5007315 PRJNA690592_S_NODE_180224_length_255_cov_0.934066_g179210_i0 PRJNA690592 180224 255 0.934066 2.3818683 Prasinovirus 181084 Viruses Viruses 87.9 6.35e-13   NTclustered gi|378706107|gb|JN225873.1| 1120767 g179210 i0 94.643 0.87843137254902 56 3 22 0 7 62 119840 119785 Ostreococcus tauri virus RT-2011, complete genome blastn 224 87.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Prasinovirus Ostreococcus tauri virus RT-2011
5774581 5774581 PRJNA690592_S_NODE_148005_length_278_cov_2.853659_g146991_i0 PRJNA690592 148005 278 2.853659 7.93317202 Chlorovirus sp. 2809302 Viruses Viruses 71.3 7.06e-8   NTclustered gi|2719858449|gb|PP681894.1| 2809302 g146991 i0 100 0.514388489208633 38 0 17 0 106 143 163556 163593 Chlorovirus sp. isolate O-NE-18, complete genome blastn 143 71.3 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Chlorovirus Chlorovirus sp.
8324715 8324715 PRJNA690592_S_NODE_25487_length_596_cov_2.323136_g24495_i0 PRJNA690592 25487 596 2.323136 13.84589056 Chlorovirus sp. 2809302 Viruses Viruses 63.9 2.72e-5   NTclustered gi|2719856141|gb|PP681888.1| 2809302 g24495 i0 100 1.92785234899329 34 0 6 0 44 77 115539 115572 Chlorovirus sp. isolate O-NE-12, complete genome blastn 1149 63.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Chlorovirus Chlorovirus sp.
12658335 12658335 PRJNA690592_S_NODE_139510_length_286_cov_1.075117_g138496_i0 PRJNA690592 139510 286 1.075117 3.07483462 Mastadenovirus 10509 Viruses Viruses 52.8 0.026   NTclustered gi|2209111155|gb|MZ882380.1| 129951 g138496 i0 96.875 0.20979020979021 32 0 11 1 168 199 23896 23926 Human mastadenovirus C isolate AdV-lumc003, complete genome blastn 60 52.8 1 Viruses   Bamfordvirae Preplasmiviricota Pharingeaviricetes Rowavirales Adenoviridae Mastadenovirus Mastadenovirus caesari
19798765 19798765 PRJNA690592_S_NODE_55596_length_420_cov_1.201729_g54582_i0 PRJNA690592 55596 420 1.201729 5.0472618 Hokovirus HKV1 1977638 Viruses Viruses 58.4 8.69e-4   NTclustered gi|1174571674|gb|KY684104.1| 1977638 g54582 i0 100 0.157142857142857 31 0 7 0 263 293 254996 255026 Hokovirus HKV1 isolate HKV1 clone Hokovirus_2, sequence blastn 66 58.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Hokovirus Hokovirus HKV1
21073746 21073746 PRJNA690592_S_NODE_186497_length_251_cov_0.865169_g185483_i0 PRJNA690592 186497 251 0.865169 2.17157419 Mimivirus U306 1932880 Viruses Viruses 56.5 0.002   NTclustered gi|1572561086|emb|LT717347.1| 1932880 g185483 i0 100 0.617529880478088 30 0 12 0 123 152 113065 113036 Mimivirus U306 genome assembly, complete genome: monopartite blastn 155 56.5 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Mimivirus Mimivirus U306

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