RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJEB11748" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
3840637 3840637 PRJEB11748_P_NODE_130044_length_362_cov_71.970100_g127867_i0 PRJEB11748 130044 362 71.9701 260.531762 Iflaviridae sp. 1955145 Viruses Viruses 132 2.04e-33   NR WWU04725.1 1955145 g127867 i0 56 2.74309392265193 109 48 90.3 0 26 352 206 314 WWU04725.1 MAG: polyprotein, partial [Iflaviridae sp.] diamond 993 132 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae   Iflaviridae sp.
3842729 3842729 PRJEB11748_P_NODE_23464_length_939_cov_3.243736_g21839_i0 PRJEB11748 23464 939 3.243736 30.45868104 Panax cryptic virus 4 2809267 Viruses Viruses 444 8.139999999999997e-152   NR QRG29207.1 2809267 g21839 i0 79.4 0.869009584664537 272 56 86.9 0 123 938 1 272 QRG29207.1 putative CP [Panax cryptic virus 4] diamond 816 444 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Panax cryptic virus 4
11497144 11497144 PRJEB11748_P_NODE_3910_length_2425_cov_25.147631_g3434_i0 PRJEB11748 3910 2425 25.147631 609.83005175 Dicistroviridae sp. 1955144 Viruses Viruses 321 3e-93   NR QXV86620.1 1955144 g3434 i0 33.5 1.81855670103093 719 344 85.9 16 83 2164 226 835 QXV86620.1 capsid protein [Dicistroviridae sp.] diamond 4410 321 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
13738922 13738922 PRJEB11748_P_NODE_9411_length_1571_cov_51.854967_g8467_i0 PRJEB11748 9411 1571 51.854967 814.64153157 Viruses 10239 Viruses Viruses 115 7.9399999999999994e-23   NR WFS39126.1 3038626 g8467 i0 26.6 2.00127307447486 350 196 65.7 9 510 1541 65 359 WFS39126.1 MAG: putative replicase polyprotein [StochSRVP_1 picorna-like virus] diamond 3144 115 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   StochSRVP_1 picorna-like virus
26906378 26906378 PRJEB11748_P_NODE_336362_length_204_cov_1.489510_g334179_i0 PRJEB11748 336362 204 1.48951 3.0386004 Grapevine nepovirus A 2789373 Viruses Viruses 56.6 2.85e-7   NR YP_010840350.1 2789373 g334179 i0 41 0.897058823529412 61 36 89.7 0 202 20 1275 1335 YP_010840350.1 polyprotein 1 [Grapevine nepovirus A] diamond 183 56.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Nepovirus Nepovirus alphavitis
27285619 27285619 PRJEB11748_P_NODE_130923_length_361_cov_8.633333_g128746_i0 PRJEB11748 130923 361 8.633333 31.16633213 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 78.2 5.64e-14   NR QJI53542.1 3003959 g128746 i0 54.1 0.506925207756233 61 28 50.7 0 24 206 1735 1795 QJI53542.1 MAG: hypothetical protein 1 [Picornavirales sp.] diamond 183 78.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28296066 28296066 PRJEB11748_P_NODE_234606_length_257_cov_2.051020_g232423_i0 PRJEB11748 234606 257 2.05102 5.2711214 Panax cryptic virus 4 2809267 Viruses Viruses 65.1 1.84e-11   NR WAQ73893.1 2809267 g232423 i0 88.2 0.793774319066148 34 4 39.7 0 3 104 63 96 WAQ73893.1 coat protein, partial [Panax cryptic virus 4] diamond 204 65.1 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Panax cryptic virus 4
28643793 28643793 PRJEB11748_P_NODE_376227_length_182_cov_9.528926_g374044_i0 PRJEB11748 376227 182 9.528926 17.34264532 Recilia dorsalis iflavirus 1 2944541 Viruses Viruses 97.8 6.66e-22   NR UQT67976.1 2944541 g374044 i0 79.6 1.78021978021978 54 11 89 0 20 181 2638 2691 UQT67976.1 polyprotein [Recilia dorsalis iflavirus 1] diamond 324 97.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Iflaviridae Iflavirus Recilia dorsalis iflavirus 1
29590521 29590521 PRJEB11748_P_NODE_79410_length_471_cov_37.829268_g77249_i0 PRJEB11748 79410 471 37.829268 178.17585228 Dicistroviridae sp. 1955144 Viruses Viruses 45.8 0.0322   NR ULF99807.1 1955144 g77249 i0 28.3 0.808917197452229 127 72 68.8 4 31 354 138 264 ULF99807.1 MAG: putative replicase polyprotein, partial [Dicistroviridae sp.] diamond 381 45.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
31170049 31170049 PRJEB11748_P_NODE_226495_length_262_cov_64.950249_g224312_i0 PRJEB11748 226495 262 64.950249 170.16965238 wugcerasp ifla-like virus 2 3116844 Viruses Viruses 53.5 7.43e-6   NR WVD52805.1 3116844 g224312 i0 48.7 0.927480916030534 39 20 44.7 0 26 142 543 581 WVD52805.1 RdRp [wugcerasp ifla-like virus 2] diamond 243 53.5 1 Viruses   Orthornavirae Pisuviricota         wugcerasp ifla-like virus 2
31385626 31385626 PRJEB11748_P_NODE_277736_length_231_cov_1.270588_g275553_i0 PRJEB11748 277736 231 1.270588 2.93505828 Viruses 10239 Viruses Viruses 123 2.07e-33   NR WVT45098.1 1955144 g275553 i0 75 1.97402597402597 76 19 98.7 0 2 229 31 106 WVT45098.1 MAG: RNA-dependent RNA polymerase, partial [Dicistroviridae sp.] diamond 456 123 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Dicistroviridae   Dicistroviridae sp.
32372469 32372469 PRJEB11748_P_NODE_142999_length_344_cov_5.600707_g140820_i0 PRJEB11748 142999 344 5.600707 19.26643208 Grapevine-associated partitivirus 1 2814403 Viruses Viruses 162 1.28e-46   NR QXN75420.1 2814403 g140820 i0 81.2 0.880813953488372 101 19 88.1 0 28 330 45 145 QXN75420.1 MAG: capsid protein, partial [Grapevine-associated partitivirus 1] diamond 303 162 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Grapevine-associated partitivirus 1

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