RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA493632" and tax_phylum = "Preplasmiviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Preplasmiviricota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA493632 · 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
30961335 30961335 PRJNA493632_P_NODE_314394_length_291_cov_1.059633_g310955_i0 PRJNA493632 314394 291 1.059633 3.08353203 Mayetiola barley midge adintovirus 2609858 Viruses Viruses 94.4 2.79e-20   NR YP_010796966.1 2609858 g310955 i0 47.4 0.979381443298969 95 47 94.8 3 12 287 301 395 YP_010796966.1 PLA2X-adenain [Mayetiola barley midge adintovirus] diamond 285 94.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Amphintovirales Eupolintoviridae Alphadintovirus Alphadintovirus mayetiola
30961444 30961444 PRJNA493632_P_NODE_632654_length_243_cov_0.864706_g629213_i0 PRJNA493632 632654 243 0.864706 2.10123558 Mayetiola barley midge adintovirus 2609858 Viruses Viruses 60.1 2.74e-8   NR YP_010796966.1 2609858 g629213 i0 46.9 0.790123456790123 64 27 79 2 229 38 360 416 YP_010796966.1 PLA2X-adenain [Mayetiola barley midge adintovirus] diamond 192 60.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Amphintovirales Eupolintoviridae Alphadintovirus Alphadintovirus mayetiola
32384486 32384486 PRJNA493632_P_NODE_336459_length_286_cov_1.211268_g333020_i0 PRJNA493632 336459 286 1.211268 3.46422648 Adintovirus macaca128 3115921 Viruses Viruses 56.2 1.08e-6   NR DBA46384.1 3115921 g333020 i0 47.6 2.41258741258741 82 39 81.8 2 50 283 165 246 DBA46384.1 MAG TPA_asm: PLA2X-Adenain [Adintovirus macaca12800] diamond 690 56.2 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus macaca12800
32416336 32416336 PRJNA493632_P_NODE_553279_length_248_cov_0.880000_g549840_i0 PRJNA493632 553279 248 0.88 2.1824 Megastigmus wasp adintovirus 2609859 Viruses Viruses 56.2 6.07e-7   NR DAC81333.1 2609859 g549840 i0 54.9 0.616935483870968 51 22 61.7 1 94 246 230 279 DAC81333.1 TPA_asm: integrase [Megastigmus wasp adintovirus] diamond 153 56.2 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Megastigmus wasp adintovirus
32636980 32636980 PRJNA493632_P_NODE_301120_length_295_cov_2.063063_g297682_i0 PRJNA493632 301120 295 2.063063 6.08603585 Adintovirus puccinia15 3115942 Viruses Viruses 97.4 1.76e-22   NR DBA48638.1 3115942 g297682 i0 50 2.43050847457627 80 39 80.3 1 3 239 156 235 DBA48638.1 MAG TPA_asm: PacK [Adintovirus puccinia15046] diamond 717 97.4 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Adintovirus puccinia15046
32700126 32700126 PRJNA493632_P_NODE_383660_length_275_cov_4.450495_g380221_i0 PRJNA493632 383660 275 4.450495 12.23886125 Mayetiola barley midge adintovirus 2609858 Viruses Viruses 74.3 2.27e-13   NR YP_010796970.1 2609858 g380221 i0 44.3 1.76727272727273 79 44 86.2 0 34 270 2 80 YP_010796970.1 integrase [Mayetiola barley midge adintovirus] diamond 486 74.3 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Amphintovirales Eupolintoviridae Alphadintovirus Alphadintovirus mayetiola

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