RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJEB12366" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJEB12366 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26900212 26900212 PRJEB12366_P_NODE_121_length_1962_cov_3.115205_g98_i0 PRJEB12366 121 1962 3.115205 61.1203221 Cripavirus 144051 Viruses Viruses 354 2.759999999999999e-107   NR ULF99858.1 1955141 g98 i0 43.6 6.74923547400612 482 236 69.1 11 1962 607 78 553 ULF99858.1 MAG: hypothetical protein 2 [Cripavirus sp.] diamond 13242 354 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
26906448 26906448 PRJEB12366_P_NODE_11722_length_216_cov_1.447514_g11532_i0 PRJEB12366 11722 216 1.447514 3.12663024 Dicistroviridae sp. 1955144 Viruses Viruses 77 2.23e-14   NR XCO49231.1 1955144 g11532 i0 50.7 0.986111111111111 71 35 98.6 0 213 1 492 562 XCO49231.1 MAG: putative ORF1 protein, partial [Dicistroviridae sp.] diamond 213 77 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
27469256 27469256 PRJEB12366_P_NODE_10363_length_234_cov_1.608040_g10173_i0 PRJEB12366 10363 234 1.60804 3.7628136 Viruses 10239 Viruses Viruses 63.9 1.15e-9   NR QJI52214.1 1955144 g10173 i0 45.2 8.14102564102564 73 40 93.6 0 1 219 621 693 QJI52214.1 MAG: nonstructural polyprotein 2 [Dicistroviridae sp.] diamond 1905 64.3 0.993779160186625 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
28517473 28517473 PRJEB12366_P_NODE_6747_length_309_cov_1.605839_g6557_i0 PRJEB12366 6747 309 1.605839 4.96204251 Cripavirus sp. 1955141 Viruses Viruses 85.5 8.08e-17   NR ULF99876.1 1955141 g6557 i0 35.6 1.96116504854369 101 65 98.1 0 308 6 436 536 ULF99876.1 MAG: hypothetical protein 1 [Cripavirus sp.] diamond 606 85.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
31480700 31480700 PRJEB12366_P_NODE_14696_length_186_cov_3.172185_g14506_i0 PRJEB12366 14696 186 3.172185 5.9002641 Cripavirus 144051 Viruses Viruses 62.4 2.01e-9   NR ULF99846.1 1955141 g14506 i0 45.8 4.7741935483871 59 32 95.2 0 181 5 40 98 ULF99846.1 MAG: putative capsid polyprotein [Cripavirus sp.] diamond 888 62.8 0.993630573248408 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae Cripavirus Cripavirus sp.
31512242 31512242 PRJEB12366_P_NODE_2976_length_500_cov_1.449462_g2790_i0 PRJEB12366 2976 500 1.449462 7.24731 Viruses 10239 Viruses Viruses 117 7.73e-27   NR ULF99809.1 1955144 g2790 i0 42.7 3.96 171 82 94.2 6 30 500 1160 1328 ULF99809.1 MAG: replicase polyprotein [Dicistroviridae sp.] diamond 1980 117 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
31613213 31613213 PRJEB12366_P_NODE_10216_length_236_cov_2.293532_g10026_i0 PRJEB12366 10216 236 2.293532 5.41273552 Dicistroviridae sp. 1955144 Viruses Viruses 83.2 1.94e-16   NR QJI52214.1 1955144 g10026 i0 51.9 3.01271186440678 79 36 97.9 2 4 234 236 314 QJI52214.1 MAG: nonstructural polyprotein 2 [Dicistroviridae sp.] diamond 711 83.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae 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);;