RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB66218" and tax_phylum = "Nucleocytoviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nucleocytoviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJEB66218 · 6 ✖

analysis 1

  • diamond · 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
28360393 28360393 PRJEB66218_P_NODE_27206_length_716_cov_2.806107_g24938_i0 PRJEB66218 27206 716 2.806107 20.09172612 Edafosvirus sp. 2487765 Viruses Viruses 47.4 0.0249   NR AYV78547.1 2487765 g24938 i0 25.2 0.955307262569832 107 70 42.3 2 544 242 160 262 AYV78547.1 MAG: hypothetical protein Edafosvirus17_23 [Edafosvirus sp.] diamond 684 47.4 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
28865700 28865700 PRJEB66218_P_NODE_8488_length_1531_cov_3.948299_g7235_i0 PRJEB66218 8488 1531 3.948299 60.44845769 Barrevirus sp. 2487763 Viruses Viruses 211 7.060000000000001e-58   NR AYV77035.1 2487763 g7235 i0 34.4 0.860222077073808 439 193 84.5 9 222 1514 20 371 AYV77035.1 MAG: hypothetical protein Barrevirus9_4 [Barrevirus sp.] diamond 1317 211 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Barrevirus sp.
28897108 28897108 PRJEB66218_P_NODE_116568_length_279_cov_3.917431_g114139_i0 PRJEB66218 116568 279 3.917431 10.92963249 Hyperionvirus sp. 2487770 Viruses Viruses 69.3 1.33e-12   NR AYV84473.1 2487770 g114139 i0 40.8 0.763440860215054 71 41 76.3 1 215 3 8 77 AYV84473.1 MAG: hypothetical protein Hyperionvirus26_28 [Hyperionvirus sp.] diamond 213 69.3 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Hyperionvirus sp.
30444949 30444949 PRJEB66218_P_NODE_29873_length_673_cov_2.553922_g27569_i0 PRJEB66218 29873 673 2.553922 17.18789506 Edafosvirus sp. 2487765 Viruses Viruses 52.8 3.18e-4   NR AYV78547.1 2487765 g27569 i0 33.9 0.512630014858841 115 63 48.1 5 133 456 166 274 AYV78547.1 MAG: hypothetical protein Edafosvirus17_23 [Edafosvirus sp.] diamond 345 52.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
30634209 30634209 PRJEB66218_P_NODE_58733_length_431_cov_1.967568_g56313_i0 PRJEB66218 58733 431 1.967568 8.48021808 Edafosvirus sp. 2487765 Viruses Viruses 53.9 2.58e-5   NR AYV78547.1 2487765 g56313 i0 29.6 0.80046403712297 115 68 75.9 4 430 104 161 268 AYV78547.1 MAG: hypothetical protein Edafosvirus17_23 [Edafosvirus sp.] diamond 345 53.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Edafosvirus sp.
31709230 31709230 PRJEB66218_P_NODE_88077_length_332_cov_1.656827_g85650_i0 PRJEB66218 88077 332 1.656827 5.50066564 Faunusvirus sp. 2487766 Viruses Viruses 55.8 1.87e-7   NR AYV79271.1 2487766 g85650 i0 45.2 0.560240963855422 62 34 56 0 107 292 5 66 AYV79271.1 MAG: vesicle-associated membrane protein 7 [Faunusvirus sp.] diamond 186 55.8 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Faunusvirus 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);;