RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA404067" and tax_phylum = "Cressdnaviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cressdnaviricota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA404067 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
11893269 11893269 PRJNA404067_P_NODE_1870_length_1838_cov_6.615082_g1691_i0 PRJNA404067 1870 1838 6.615082 121.58520716 Cressdnaviricota sp. 2748378 Viruses Viruses 322 3.45e-102   NR WAE42443.1 2748378 g1691 i0 53 1.46735582154516 302 131 49.1 5 1542 640 14 305 WAE42443.1 MAG: replication associated protein [Cressdnaviricota sp.] diamond 2697 322 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
26822423 26822423 PRJNA404067_P_NODE_3281_length_1031_cov_5.179381_g2997_i0 PRJNA404067 3281 1031 5.179381 53.39941811 Cressdnaviricota sp. 2748378 Viruses Viruses 80.1 1.82e-13   NR WAE43190.1 2748378 g2997 i0 30 0.590688651794374 203 131 56.2 4 363 941 21 222 WAE43190.1 MAG: capsid protein [Cressdnaviricota sp.] diamond 609 80.1 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
27154943 27154943 PRJNA404067_P_NODE_1362_length_2421_cov_62.047458_g1226_i0 PRJNA404067 1362 2421 62.047458 1502.16895818 Arfiviricetes 2732423 Viruses Viruses 242 4.8300000000000006e-70   NR YP_009116894.1 1592083 g1226 i0 64 3.71995043370508 172 62 21.3 0 212 727 90 261 YP_009116894.1 replication-associated protein [Sewage-associated circular DNA virus-16] diamond 9006 243 0.995884773662551 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Saturnivirales Kanorauviridae Kaiwanvirus Kaiwanvirus sewoxi
27833453 27833453 PRJNA404067_P_NODE_12304_length_300_cov_2.209205_g11918_i0 PRJNA404067 12304 300 2.209205 6.627615 Turdus naumanni CRESS-DNA-virus sp. 2815063 Viruses Viruses 112 2.44e-28   NR QTE03580.1 2815063 g11918 i0 57.6 0.99 99 42 99 0 299 3 95 193 QTE03580.1 MAG: capsid protein [Turdus naumanni CRESS-DNA-virus sp.] diamond 297 112 1 Viruses   Shotokuvirae Cressdnaviricota         Turdus naumanni CRESS-DNA-virus sp.
28717729 28717729 PRJNA404067_P_NODE_6187_length_509_cov_3.049107_g5814_i0 PRJNA404067 6187 509 3.049107 15.51995463 CRESS virus sp. ctin15 2656686 Viruses Viruses 237 4.02e-75   NR QGH73226.1 2656686 g5814 i0 67.3 0.990176817288802 168 55 99 0 1 504 137 304 QGH73226.1 MAG: Rep protein [CRESS virus sp. ctin15] diamond 504 237 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Gredzevirales Gandrviridae Meliavirus Meliavirus jackflis
29018785 29018785 PRJNA404067_P_NODE_27168_length_217_cov_5.448718_g26781_i0 PRJNA404067 27168 217 5.448718 11.82371806 Bacilladnavirus 674979 Viruses Viruses 90.5 2.5e-19   NR AXH77453.1 2267680 g26781 i0 58.2 1.89400921658986 67 28 92.6 0 14 214 117 183 AXH77453.1 MAG: putative viral replication protein [Bacilladnavirus sp.] diamond 411 91.3 0.991237677984666 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Baphyvirales Bacilladnaviridae Bacilladnavirus Bacilladnavirus sp.
29222985 29222985 PRJNA404067_P_NODE_45109_length_167_cov_4.226415_g44722_i0 PRJNA404067 45109 167 4.226415 7.05811305 Crogonang virus 31 3063426 Viruses Viruses 47.8 2.27e-4   NR WPR18629.1 3063426 g44722 i0 65.4 0.934131736526946 26 9 46.7 0 86 163 1 26 WPR18629.1 MAG: hypothetical protein [Crogonang virus 31] diamond 156 47.8 1 Viruses   Shotokuvirae Cressdnaviricota         Crogonang virus 31
29886049 29886049 PRJNA404067_P_NODE_29411_length_212_cov_4.344371_g29024_i0 PRJNA404067 29411 212 4.344371 9.21006652 Smacoviridae sp. 2715094 Viruses Viruses 52.8 5.3e-6   NR WQA30387.1 2715094 g29024 i0 43.5 1.78301886792453 69 34 96.2 3 8 211 134 198 WQA30387.1 MAG: rep protein, partial [Smacoviridae sp.] diamond 378 52.8 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cremevirales Smacoviridae   Smacoviridae sp.
30075304 30075304 PRJNA404067_P_NODE_20312_length_236_cov_1.154286_g19925_i0 PRJNA404067 20312 236 1.154286 2.72411496 Wigfec virus K19_668 2986018 Viruses Viruses 62.4 3.27e-9   NR UYD39137.1 2986018 g19925 i0 41.7 1.90677966101695 72 37 91.5 1 1 216 165 231 UYD39137.1 MAG: replication associated protein [Wigfec virus K19_668] diamond 450 62.4 1 Viruses   Shotokuvirae Cressdnaviricota         Wigfec virus K19_668
32130409 32130409 PRJNA404067_P_NODE_13998_length_278_cov_3.239631_g13611_i0 PRJNA404067 13998 278 3.239631 9.00617418 Circoviridae sp. 1954248 Viruses Viruses 56.6 5.87e-7   NR AXQ65675.1 1954248 g13611 i0 31 0.938848920863309 87 54 87.4 1 272 30 174 260 AXQ65675.1 MAG: putative capsid protein [Circoviridae sp.] diamond 261 56.6 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Rohanvirales Nenyaviridae Galvornvirus Galvornvirus isengard
32162039 32162039 PRJNA404067_P_NODE_29698_length_212_cov_1.225166_g29311_i0 PRJNA404067 29698 212 1.225166 2.59735192 Cressdnaviricota sp. 2748378 Viruses Viruses 46.2 0.00128   NR AYP28705.1 2748378 g29311 i0 40.8 1.07547169811321 76 38 99.1 4 211 2 124 198 AYP28705.1 MAG: coat protein [Cressdnaviricota sp.] diamond 228 46.2 1 Viruses   Shotokuvirae Cressdnaviricota         Cressdnaviricota sp.
32541804 32541804 PRJNA404067_P_NODE_37639_length_202_cov_0.907801_g37252_i0 PRJNA404067 37639 202 0.907801 1.83375802 Grus japonensis CRESS-DNA-virus sp. 2815045 Viruses Viruses 59.7 1.69e-8   NR QTE03495.1 2815045 g37252 i0 48.1 1.51485148514851 52 22 77.2 1 1 156 101 147 QTE03495.1 MAG: putative capsid protein [Grus japonensis CRESS-DNA-virus sp.] diamond 306 59.7 1 Viruses   Shotokuvirae Cressdnaviricota         Grus japonensis CRESS-DNA-virus sp.
32793322 32793322 PRJNA404067_P_NODE_42700_length_184_cov_4.300813_g42313_i0 PRJNA404067 42700 184 4.300813 7.91349592 Turdus naumanni CRESS-DNA-virus sp. 2815063 Viruses Viruses 98.6 1.74e-23   NR QTE03580.1 2815063 g42313 i0 70 0.978260869565217 60 18 97.8 0 183 4 25 84 QTE03580.1 MAG: capsid protein [Turdus naumanni CRESS-DNA-virus sp.] diamond 180 98.6 1 Viruses   Shotokuvirae Cressdnaviricota         Turdus naumanni CRESS-DNA-virus sp.
32825078 32825078 PRJNA404067_P_NODE_23700_length_226_cov_1.709091_g23313_i0 PRJNA404067 23700 226 1.709091 3.86254566 Crogonang virus 31 3063426 Viruses Viruses 53.9 2.94e-7   NR XII43503.1 3063426 g23313 i0 62.5 0.530973451327434 40 15 53.1 0 2 121 56 95 XII43503.1 MAG: hypothetical protein [Crogonang virus 31] diamond 120 53.9 1 Viruses   Shotokuvirae Cressdnaviricota         Crogonang virus 31

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