RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA600413" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 18 ✖

bioproject 1

  • PRJNA600413 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
26699881 26699881 PRJNA600413_P_NODE_18061_length_337_cov_2.329861_g17360_i0 PRJNA600413 18061 337 2.329861 7.85163157 Apis picorna-like virus 4 2873553 Viruses Viruses 106 6.17e-24   NR UCR92487.1 2873553 g17360 i0 75.9 0.997032640949555 112 24 99.7 3 337 2 763 871 UCR92487.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 336 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
26921744 26921744 PRJNA600413_P_NODE_17382_length_344_cov_2.810169_g16681_i0 PRJNA600413 17382 344 2.810169 9.66698136 Apis picorna-like virus 4 2873553 Viruses Viruses 181 3.42e-50   NR UCR92487.1 2873553 g16681 i0 72.8 1.98837209302326 114 31 99.4 0 342 1 2738 2851 UCR92487.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 684 181 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
26984928 26984928 PRJNA600413_P_NODE_43882_length_220_cov_1.175439_g43181_i0 PRJNA600413 43882 220 1.175439 2.5859658 Mitovirus sp. 2587224 Viruses Viruses 77.4 1.7e-14   NR WWU04548.1 2587224 g43181 i0 50 1.00909090909091 74 36 99.5 1 220 2 137 210 WWU04548.1 MAG: RNA-dependent RNA polymerase [Mitovirus sp.] diamond 222 77.4 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Mitovirus sp.
27332963 27332963 PRJNA600413_P_NODE_33583_length_246_cov_2.213198_g32882_i0 PRJNA600413 33583 246 2.213198 5.44446708 Apis picorna-like virus 4 2873553 Viruses Viruses 154 2.44e-41   NR UCR92499.1 2873553 g32882 i0 90.2 2 82 8 100 0 246 1 2815 2896 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 492 154 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
27490816 27490816 PRJNA600413_P_NODE_36583_length_237_cov_1.218085_g35882_i0 PRJNA600413 36583 237 1.218085 2.88686145 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 71.6 2.3e-12   NR AVM87439.1 3063761 g35882 i0 45.6 1 79 38 97.5 2 232 2 1465 1540 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 237 71.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
27648723 27648723 PRJNA600413_P_NODE_30724_length_256_cov_2.169082_g30023_i0 PRJNA600413 30724 256 2.169082 5.55284992 Apis picorna-like virus 4 2873553 Viruses Viruses 160 2.51e-43   NR UCR92487.1 2873553 g30023 i0 90.5 1.96875 84 8 98.4 0 254 3 1686 1769 UCR92487.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 504 160 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
28090538 28090538 PRJNA600413_P_NODE_25205_length_283_cov_1.525641_g24504_i0 PRJNA600413 25205 283 1.525641 4.31756403 Locarnavirus sp. 2809529 Viruses Viruses 179 5.07e-50   NR ULG00073.1 2809529 g24504 i0 91.5 0.996466431095406 94 8 99.6 0 282 1 1071 1164 ULG00073.1 MAG: hypothetical protein 1 [Locarnavirus sp.] diamond 282 179 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae Locarnavirus Locarnavirus sp.
28722197 28722197 PRJNA600413_P_NODE_26287_length_277_cov_0.890351_g25586_i0 PRJNA600413 26287 277 0.890351 2.46627227 Hebeloma mesophaeum partitivirus 2 3026164 Viruses Viruses 50.4 1.05e-4   NR WCQ76438.1 3026164 g25586 i0 35.6 0.63898916967509 59 38 63.9 0 182 6 94 152 WCQ76438.1 capsid [Hebeloma mesophaeum partitivirus 2] diamond 177 50.4 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Hebeloma mesophaeum partitivirus 2
29101068 29101068 PRJNA600413_P_NODE_60988_length_193_cov_1.895833_g60287_i0 PRJNA600413 60988 193 1.895833 3.65895769 Passion fruit mitovirus 1 3342389 Viruses Viruses 79.7 1.72e-15   NR XGD01531.1 3342389 g60287 i0 64.5 0.963730569948187 62 22 96.4 0 3 188 49 110 XGD01531.1 RNA-dependent RNA polymerase [Passion fruit mitovirus 1] diamond 186 79.7 1 Viruses   Orthornavirae Lenarviricota Howeltoviricetes Cryppavirales Mitoviridae Mitovirus Passion fruit mitovirus 1
29114372 29114372 PRJNA600413_P_NODE_58808_length_196_cov_1.387755_g58107_i0 PRJNA600413 58808 196 1.387755 2.7199998 Chuvivirus 2842604 Viruses Viruses 83.2 1.07e-16   NR UVF58769.1 2842604 g58107 i0 60.9 2.93877551020408 64 25 98 0 194 3 288 351 UVF58769.1 MAG: S protein [Salarius guttatus piscichuvirus] diamond 576 83.6 0.995215311004785 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Chuvivirus
29574372 29574372 PRJNA600413_P_NODE_45170_length_217_cov_1.821429_g44469_i0 PRJNA600413 45170 217 1.821429 3.95250093 Apis picorna-like virus 4 2873553 Viruses Viruses 134 2.24e-34   NR UCR92499.1 2873553 g44469 i0 91.7 1.99078341013825 72 6 99.5 0 1 216 1004 1075 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 432 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
29922106 29922106 PRJNA600413_P_NODE_74051_length_183_cov_3.328358_g73350_i0 PRJNA600413 74051 183 3.328358 6.09089514 Apis picorna-like virus 4 2873553 Viruses Viruses 93.6 2.14e-20   NR UCR92499.1 2873553 g73350 i0 72.1 1 61 17 100 0 183 1 205 265 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 183 93.6 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
30016852 30016852 PRJNA600413_P_NODE_40831_length_226_cov_1.757062_g40130_i0 PRJNA600413 40831 226 1.757062 3.97096012 Apis picorna-like virus 4 2873553 Viruses Viruses 135 7.369999999999998e-35   NR UCR92499.1 2873553 g40130 i0 86.7 1.99115044247788 75 10 99.6 0 2 226 2119 2193 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 450 135 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
30427916 30427916 PRJNA600413_P_NODE_54673_length_202_cov_1.000000_g53972_i0 PRJNA600413 54673 202 1 2.02 Chuvivirus 2842604 Viruses Viruses 50.4 3.98e-5   NR WET19891.1 2842604 g53972 i0 52.5 0.594059405940594 40 19 59.4 0 200 81 458 497 WET19891.1 MAG: nucleoprotein [Sea turtle neural virus 1] diamond 120 50.4 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Chuvivirus Chuvivirus
30711793 30711793 PRJNA600413_P_NODE_78634_length_180_cov_4.526718_g77933_i0 PRJNA600413 78634 180 4.526718 8.1480924 Apis picorna-like virus 4 2873553 Viruses Viruses 104 2.35e-24   NR UCR92499.1 2873553 g77933 i0 86 1.9 57 8 95 0 178 8 2587 2643 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 342 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
31375635 31375635 PRJNA600413_P_NODE_15236_length_371_cov_2.891304_g14535_i0 PRJNA600413 15236 371 2.891304 10.72673784 Apis picorna-like virus 4 2873553 Viruses Viruses 249 5.289999999999999e-74   NR UCR92499.1 2873553 g14535 i0 97.5 1.94070080862534 120 3 97 0 360 1 2462 2581 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 720 249 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
31375644 31375644 PRJNA600413_P_NODE_36756_length_236_cov_2.288770_g36055_i0 PRJNA600413 36756 236 2.28877 5.4014972 Apis picorna-like virus 4 2873553 Viruses Viruses 171 3.259999999999999e-47   NR UCR92499.1 2873553 g36055 i0 98.7 1.98305084745763 78 1 99.2 0 2 235 1322 1399 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 468 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4
31375657 31375657 PRJNA600413_P_NODE_98136_length_169_cov_1.683333_g97435_i0 PRJNA600413 98136 169 1.683333 2.84483277 Apis picorna-like virus 4 2873553 Viruses Viruses 96.7 1.36e-21   NR UCR92499.1 2873553 g97435 i0 80 1.95266272189349 55 11 97.6 0 167 3 1968 2022 UCR92499.1 MAG: polyprotein [Apis picorna-like virus 4] diamond 330 96.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Apis picorna-like virus 4

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