RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA798905" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA798905 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
8445460 8445460 PRJNA798905_S_NODE_4347_length_637_cov_22.289007_g3910_i0 PRJNA798905 4347 637 22.289007 141.98097459 Cressdnaviricota sp. 2748378 Viruses Viruses 253 1.58e-80   NR XNT20928.1 2748378 g3910 i0 61.2 0.970172684458399 206 78 96.5 2 617 3 19 223 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 618 253 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
27275284 27275284 PRJNA798905_S_NODE_26183_length_295_cov_3.337838_g25734_i0 PRJNA798905 26183 295 3.337838 9.8466221 Cressdnaviricota sp. 2748378 Viruses Viruses 96.7 1.6e-21   NR QJQ37761.1 2748378 g25734 i0 50 1.87118644067797 92 36 87.5 2 263 6 13 100 QJQ37761.1 replication-associated protein [Cressdnaviricota sp.] diamond 552 96.7 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
27568429 27568429 PRJNA798905_S_NODE_42064_length_230_cov_3.146497_g41615_i0 PRJNA798905 42064 230 3.146497 7.2369431 Viruses 10239 Viruses Viruses 69.3 1.04e-11   NR XNT21009.1 2748378 g41615 i0 48 2.93478260869565 75 34 96.5 2 226 5 77 147 XNT21009.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 675 69.3 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
27875178 27875178 PRJNA798905_S_NODE_17525_length_351_cov_4.651079_g17076_i0 PRJNA798905 17525 351 4.651079 16.32528729 Circovirus sp. 1964372 Viruses Viruses 88.2 2.14e-19   NR WQA29644.1 1964372 g17076 i0 54.2 0.709401709401709 83 36 69.2 1 107 349 11 93 WQA29644.1 MAG: rep protein, partial [Circovirus sp.] diamond 249 88.2 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae Circovirus Circovirus sp.
28348845 28348845 PRJNA798905_S_NODE_4006_length_665_cov_8.246622_g3572_i0 PRJNA798905 4006 665 8.246622 54.8400363 Cressdnaviricota sp. 2748378 Viruses Viruses 105 6.149999999999999e-23   NR XNT20928.1 2748378 g3572 i0 57 0.38796992481203 86 37 38.8 0 665 408 217 302 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 258 105 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29106738 29106738 PRJNA798905_S_NODE_15168_length_372_cov_6.481605_g14719_i0 PRJNA798905 15168 372 6.481605 24.1115706 Cressdnaviricota sp. 2748378 Viruses Viruses 80.1 6.18e-16   NR AXF52274.1 2748378 g14719 i0 38.5 0.943548387096774 117 63 90.3 4 369 34 57 169 AXF52274.1 MAG: putative capsid protein [Cressdnaviricota sp.] diamond 351 80.1 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29201502 29201502 PRJNA798905_S_NODE_36549_length_249_cov_1.732955_g36100_i0 PRJNA798905 36549 249 1.732955 4.31505795 Duck associated circular virus VC9 2781378 Viruses Viruses 71.6 2.04e-13   NR QOQ34601.1 2781378 g36100 i0 45.6 0.951807228915663 79 42 94 1 14 247 1 79 QOQ34601.1 capsid protein [Duck associated circular virus VC9] diamond 237 71.6 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Duck associated circular virus VC9
29233075 29233075 PRJNA798905_S_NODE_33369_length_260_cov_5.983957_g32920_i0 PRJNA798905 33369 260 5.983957 15.5582882 Cressdnaviricota sp. 2748378 Viruses Viruses 81.6 4.27e-16   NR XNT20928.1 2748378 g32920 i0 65.4 0.6 52 17 58.8 1 232 80 13 64 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 156 81.6 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29453604 29453604 PRJNA798905_S_NODE_40750_length_237_cov_2.347561_g40301_i0 PRJNA798905 40750 237 2.347561 5.56371957 Cressdnaviricota sp. 2748378 Viruses Viruses 108 1.5600000000000002e-26   NR XNT20928.1 2748378 g40301 i0 67.9 0.987341772151899 78 25 98.7 0 236 3 148 225 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 234 108 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
29896139 29896139 PRJNA798905_S_NODE_7831_length_482_cov_2.933985_g7382_i0 PRJNA798905 7831 482 2.933985 14.1418077 Cressdnaviricota sp. 2748378 Viruses Viruses 111 4.42e-26   NR XNT20928.1 2748378 g7382 i0 60 0.560165975103734 90 34 55.4 2 269 3 8 96 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 270 111 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
30125973 30125973 PRJNA798905_S_NODE_43692_length_217_cov_4.812500_g43243_i0 PRJNA798905 43692 217 4.8125 10.443125 Naryaviridae 2946188 Viruses Viruses 47 4.87e-4   NR WQA30166.1 2748378 g43243 i0 71 1.56221198156682 31 8 42.9 1 201 109 134 163 WQA30166.1 MAG: rep protein [Cressdnaviricota sp.] diamond 339 47 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
30189326 30189326 PRJNA798905_S_NODE_26972_length_291_cov_2.119266_g26523_i0 PRJNA798905 26972 291 2.119266 6.16706406 Cyclovirus 742914 Viruses Viruses 86.3 8.6e-18   NR XCO48057.1 1983780 g26523 i0 47.3 3.72164948453608 91 47 92.8 1 3 272 30 120 XCO48057.1 MAG: putative replication-associated protein [Cyclovirus sp.] diamond 1083 86.3 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae Cyclovirus Cyclovirus sp.
30685743 30685743 PRJNA798905_S_NODE_11113_length_419_cov_12.505780_g10664_i0 PRJNA798905 11113 419 12.50578 52.3992182 Cressdnaviricota sp. 2748378 Viruses Viruses 174 1.19e-50   NR XNT20928.1 2748378 g10664 i0 63 0.966587112171838 135 50 96.7 0 406 2 86 220 XNT20928.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 405 174 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
30843968 30843968 PRJNA798905_S_NODE_34534_length_255_cov_7.005495_g34085_i0 PRJNA798905 34534 255 7.005495 17.86401225 Cressdnaviricota sp. 2748378 Viruses Viruses 91.7 4.55e-20   NR XNT20546.1 2748378 g34085 i0 68.2 1.55294117647059 66 20 76.5 1 197 3 14 79 XNT20546.1 MAG: Rep protein [Cressdnaviricota sp.] diamond 396 91.7 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
31697460 31697460 PRJNA798905_S_NODE_29297_length_279_cov_3.364078_g28848_i0 PRJNA798905 29297 279 3.364078 9.38577762 Syrmaticus ellioti CRESS-DNA-virus sp. 2815058 Viruses Viruses 53.9 4.92e-6   NR QTE03432.1 2815058 g28848 i0 36.7 1.35483870967742 60 38 64.5 0 4 183 191 250 QTE03432.1 MAG: capsid protein [Syrmaticus ellioti CRESS-DNA-virus sp.] diamond 378 53.9 1 Viruses   Shotokuvirae Cressdnaviricota         Syrmaticus ellioti CRESS-DNA-virus sp.
32013845 32013845 PRJNA798905_S_NODE_29758_length_277_cov_2.083333_g29309_i0 PRJNA798905 29758 277 2.083333 5.77083241 Smacoviridae sp. 2715094 Viruses Viruses 57.8 7.38e-8   NR WCR62157.1 2715094 g29309 i0 42.5 1.61371841155235 73 40 79.1 1 44 262 36 106 WCR62157.1 MAG: capsid protein [Smacoviridae sp.] diamond 447 57.8 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cremevirales Smacoviridae   Smacoviridae sp.
32740860 32740860 PRJNA798905_S_NODE_15160_length_372_cov_7.377926_g14711_i0 PRJNA798905 15160 372 7.377926 27.44588472 Cressdnaviricota sp. 2748378 Viruses Viruses 109 1.53e-27   NR WQA30176.1 2748378 g14711 i0 48.7 0.92741935483871 115 52 88.7 2 364 35 43 155 WQA30176.1 MAG: rep protein [Cressdnaviricota sp.] diamond 345 109 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota 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);;