RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_kingdom = "Loebvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Loebvirae · 6 ✖

bioproject 1

  • PRJNA556992 · 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
26951698 26951698 PRJNA556992_P_NODE_236102_length_310_cov_2.924051_g233914_i0 PRJNA556992 236102 310 2.924051 9.0645581 Inoviridae sp. 2219103 Viruses Viruses 84 9.58e-17   NR XOE96987.1 2219103 g233914 i0 75.5 0.474193548387097 49 12 47.4 0 308 162 149 197 XOE96987.1 MAG: rolling circle DNA replication initiation [Inoviridae sp.] diamond 147 84 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
27268038 27268038 PRJNA556992_P_NODE_258863_length_301_cov_2.026316_g256674_i0 PRJNA556992 258863 301 2.026316 6.09921116 Inoviridae sp. 2219103 Viruses Viruses 55.1 6.33e-7   NR XOF04625.1 2219103 g256674 i0 40 0.79734219269103 80 47 78.7 1 34 270 1 80 XOF04625.1 MAG: hypothetical protein [Inoviridae sp.] diamond 240 55.1 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
27836588 27836588 PRJNA556992_P_NODE_594304_length_259_cov_2.715054_g592115_i0 PRJNA556992 594304 259 2.715054 7.03198986 Tubulavirales sp. 2833306 Viruses Viruses 104 6.98e-24   NR XOE94303.1 2833306 g592115 i0 69.8 0.996138996138996 86 19 99.6 1 258 1 351 429 XOE94303.1 MAG: hypothetical protein [Tubulavirales sp.] diamond 258 104 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales     Tubulavirales sp.
28720540 28720540 PRJNA556992_P_NODE_1023787_length_228_cov_2.793548_g1021597_i0 PRJNA556992 1023787 228 2.793548 6.36928944 Inoviridae sp. 2219103 Viruses Viruses 45.8 9.44e-4   NR XOE95940.1 2219103 g1021597 i0 51.1 0.592105263157895 45 21 59.2 1 228 94 84 127 XOE95940.1 MAG: hypothetical protein [Inoviridae sp.] diamond 135 45.8 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
29257062 29257062 PRJNA556992_P_NODE_1146549_length_202_cov_5.511628_g1144358_i0 PRJNA556992 1146549 202 5.511628 11.13348856 Inoviridae sp. 2219103 Viruses Viruses 95.5 3.5400000000000006e-21   NR AXH77622.1 2219103 g1144358 i0 63.5 0.935643564356436 63 23 93.6 0 12 200 159 221 AXH77622.1 MAG: replication protein [Inoviridae sp.] diamond 189 95.5 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae sp.
29384027 29384027 PRJNA556992_P_NODE_753789_length_248_cov_2.605714_g751600_i0 PRJNA556992 753789 248 2.605714 6.46217072 Inoviridae sp. 2219103 Viruses Viruses 123 5.48e-31   NR XOE94881.1 2219103 g751600 i0 73.2 1.98387096774194 82 22 99.2 0 247 2 166 247 XOE94881.1 MAG: Zot-like toxin [Inoviridae sp.] diamond 492 123 1 Viruses   Loebvirae Hofneiviricota Faserviricetes Tubulavirales Inoviridae   Inoviridae 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);;