RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1008624" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 21 ✖

bioproject 1

  • PRJNA1008624 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
26591028 26591028 PRJNA1008624_P_NODE_33041_length_165_cov_0.896552_g32853_i0 PRJNA1008624 33041 165 0.896552 1.4793108 African cichlid piscichuvirus 3065075 Viruses Viruses 83.6 5.19e-17   NR WLN26256.1 3065075 g32853 i0 66 0.963636363636364 53 18 96.4 0 163 5 774 826 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 159 83.6 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
27128868 27128868 PRJNA1008624_P_NODE_12942_length_233_cov_1.489130_g12754_i0 PRJNA1008624 12942 233 1.48913 3.4696729 brine shrimp arlivirus 9 2900384 Viruses Viruses 80.1 3.26e-17   NR UNI74142.1 2900384 g12754 i0 89.7 0.502145922746781 39 4 50.2 0 118 2 1 39 UNI74142.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 117 80.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
27287354 27287354 PRJNA1008624_P_NODE_25383_length_174_cov_1.192000_g25195_i0 PRJNA1008624 25383 174 1.192 2.07408 brine shrimp arlivirus 9 2900384 Viruses Viruses 85.1 1.64e-17   NR UNI74141.1 2900384 g25195 i0 70.2 0.982758620689655 57 17 98.3 0 2 172 109 165 UNI74141.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 171 85.1 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
27406542 27406542 PRJNA1008624_P_NODE_7363_length_309_cov_1.938462_g7175_i0 PRJNA1008624 7363 309 1.938462 5.98984758 Lispiviridae 2501987 Viruses Viruses 179 2.22e-52   NR UNI74075.1 2900377 g7175 i0 87.1 1.97087378640777 101 13 98.1 0 2 304 296 396 UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2] diamond 609 180 0.994444444444444 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsasecalis
27414009 27414009 PRJNA1008624_P_NODE_18083_length_200_cov_2.410596_g17895_i0 PRJNA1008624 18083 200 2.410596 4.821192 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 92.4 6.76e-20   NR XCM67741.1 3003959 g17895 i0 73 1.92 63 17 94.5 0 5 193 1934 1996 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 384 92.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27540140 27540140 PRJNA1008624_P_NODE_44_length_3555_cov_11.155448_g28_i0 PRJNA1008624 44 3555 11.155448 396.5761764 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 345 1.49e-97   NR XCO56027.1 3233859 g28 i0 27.3 1.68945147679325 950 637 79.4 16 3137 315 86 990 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 6006 345 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
27666538 27666538 PRJNA1008624_P_NODE_2724_length_523_cov_2.438819_g2544_i0 PRJNA1008624 2724 523 2.438819 12.75502337 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 58.5 2.19e-6   NR XCM67741.1 3003959 g2544 i0 27 0.69980879541109 122 84 68.8 2 59 418 1060 1178 XCM67741.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 366 58.5 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28171506 28171506 PRJNA1008624_P_NODE_12526_length_236_cov_2.443850_g12338_i0 PRJNA1008624 12526 236 2.44385 5.767486 brine shrimp arlivirus 9 2900384 Viruses Viruses 155 1.1e-41   NR UNI74144.1 2900384 g12338 i0 97.4 0.978813559322034 77 2 97.9 0 3 233 1220 1296 UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] diamond 231 155 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
28266045 28266045 PRJNA1008624_P_NODE_3866_length_436_cov_2.258398_g3680_i0 PRJNA1008624 3866 436 2.258398 9.84661528 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 138 1.02e-34   NR UNY41988.1 3003959 g3680 i0 44.8 0.98394495412844 143 79 98.4 0 431 3 1173 1315 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 429 138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28550650 28550650 PRJNA1008624_P_NODE_8607_length_285_cov_1.343220_g8419_i0 PRJNA1008624 8607 285 1.34322 3.828177 Wufeng shrew permutotetravirus 16 3084857 Viruses Viruses 83.6 1.56e-16   NR WPV63132.1 3084857 g8419 i0 46.8 0.989473684210526 94 49 98.9 1 283 2 214 306 WPV63132.1 MAG: coat protein [Wufeng shrew permutotetravirus 16] diamond 282 83.6 1 Viruses   Orthornavirae       Permutotetraviridae   Wufeng shrew permutotetravirus 16
29529331 29529331 PRJNA1008624_P_NODE_9330_length_274_cov_1.462222_g9142_i0 PRJNA1008624 9330 274 1.462222 4.00648828 Salarius guttatus piscichuvirus 2951531 Viruses Viruses 54.3 4.67e-6   NR YP_010840939.1 2951531 g9142 i0 40.7 0.941605839416058 86 47 89.8 2 272 27 28 113 YP_010840939.1 L protein [Hardyhead chuvirus] diamond 258 54.3 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus Salarius guttatus piscichuvirus
29560621 29560621 PRJNA1008624_P_NODE_23930_length_178_cov_2.689922_g23742_i0 PRJNA1008624 23930 178 2.689922 4.78806116 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 60.8 6.47e-9   NR XCM68142.1 3003959 g23742 i0 53.4 0.97752808988764 58 27 97.8 0 174 1 139 196 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 174 60.8 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
29686810 29686810 PRJNA1008624_P_NODE_7850_length_298_cov_1.642570_g7662_i0 PRJNA1008624 7850 298 1.64257 4.8948586 brine shrimp arlivirus 9 2900384 Viruses Viruses 164 1.26e-46   NR UNI74140.1 2900384 g7662 i0 83.3 1.93288590604027 96 16 96.6 0 292 5 1 96 UNI74140.1 MAG: hypothetical protein [brine shrimp arlivirus 9] diamond 576 164 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
29749963 29749963 PRJNA1008624_P_NODE_4671_length_393_cov_1.648256_g4484_i0 PRJNA1008624 4671 393 1.648256 6.47764608 brine shrimp arlivirus 2 2900377 Viruses Viruses 150 4.4e-40   NR UNI74076.1 2900377 g4484 i0 59.4 1.05343511450382 138 49 100 1 393 1 182 319 UNI74076.1 MAG: hypothetical protein [brine shrimp arlivirus 2] diamond 414 150 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsasecalis
30097585 30097585 PRJNA1008624_P_NODE_24892_length_175_cov_1.698413_g24704_i0 PRJNA1008624 24892 175 1.698413 2.97222275 brine shrimp arlivirus 2 2900377 Viruses Viruses 112 7.5599999999999995e-28   NR UNI74075.1 2900377 g24704 i0 87.7 0.977142857142857 57 7 97.7 0 2 172 104 160 UNI74075.1 MAG: hypothetical protein [brine shrimp arlivirus 2] diamond 171 112 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Artemvirus Artemvirus bsasecalis
30855951 30855951 PRJNA1008624_P_NODE_25714_length_173_cov_1.209677_g25526_i0 PRJNA1008624 25714 173 1.209677 2.09274121 brine shrimp arlivirus 9 2900384 Viruses Viruses 120 6.1899999999999995e-30   NR UNI74144.1 2900384 g25526 i0 96.5 0.988439306358382 57 2 98.8 0 3 173 252 308 UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] diamond 171 120 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
31077305 31077305 PRJNA1008624_P_NODE_11135_length_250_cov_1.711443_g10947_i0 PRJNA1008624 11135 250 1.711443 4.2786075 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 127 6.749999999999999e-32   NR XCM68142.1 3003959 g10947 i0 71.3 1.92 80 23 96 0 248 9 237 316 XCM68142.1 MAG: nonstructural polyprotein, partial [Picornavirales sp.] diamond 480 127 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31203077 31203077 PRJNA1008624_P_NODE_6035_length_342_cov_2.436860_g5847_i0 PRJNA1008624 6035 342 2.43686 8.3340612 brine shrimp arlivirus 9 2900384 Viruses Viruses 216 1.31e-62   NR UNI74144.1 2900384 g5847 i0 91.1 0.982456140350877 112 10 98.2 0 340 5 1050 1161 UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] diamond 336 216 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
31266856 31266856 PRJNA1008624_P_NODE_9675_length_269_cov_1.527273_g9487_i0 PRJNA1008624 9675 269 1.527273 4.10836437 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 62 8.78e-9   NR UNY41988.1 3003959 g9487 i0 44.9 1.97397769516729 89 40 93.7 4 257 6 85 169 UNY41988.1 MAG: polyprotein [Picornavirales sp.] diamond 531 62 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32152570 32152570 PRJNA1008624_P_NODE_17378_length_204_cov_1.870968_g17190_i0 PRJNA1008624 17378 204 1.870968 3.81677472 African cichlid piscichuvirus 3065075 Viruses Viruses 63.2 1.4e-9   NR WLN26256.1 3065075 g17190 i0 51.8 0.823529411764706 56 27 82.4 0 200 33 179 234 WLN26256.1 MAG: L protein, partial [African cichlid piscichuvirus] diamond 168 63.2 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Jingchuvirales Chuviridae Piscichuvirus African cichlid piscichuvirus
32878670 32878670 PRJNA1008624_P_NODE_10240_length_261_cov_1.339623_g10052_i0 PRJNA1008624 10240 261 1.339623 3.49641603 brine shrimp arlivirus 9 2900384 Viruses Viruses 162 5.78e-44   NR UNI74144.1 2900384 g10052 i0 90.6 0.977011494252874 85 8 97.7 0 3 257 1741 1825 UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] diamond 255 162 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9

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