RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJEB55122" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 14 ✖

bioproject 1

  • PRJEB55122 · 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
23073507 23073507 PRJEB55122_P_NODE_679_length_1761_cov_4.870911_g583_i0 PRJEB55122 679 1761 4.870911 85.77674271 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 364 2.6099999999999994e-110   NR XCM67838.1 3003959 g583 i0 36.6 0.926746166950596 544 318 91.7 7 1761 148 499 1021 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 1632 364 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26716623 26716623 PRJEB55122_P_NODE_5681_length_611_cov_2.076512_g5304_i0 PRJEB55122 5681 611 2.076512 12.68748832 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 171 2.23e-45   NR XCM67838.1 3003959 g5304 i0 46.6 1.01145662847791 206 92 98.2 4 611 12 322 515 XCM67838.1 MAG: structural polyprotein [Picornavirales sp.] diamond 618 171 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26843864 26843864 PRJEB55122_P_NODE_20821_length_242_cov_1.077720_g20424_i0 PRJEB55122 20821 242 1.07772 2.6080824 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 88.2 3.76e-18   NR XCM67837.1 3003959 g20424 i0 50 0.966942148760331 78 39 96.7 0 236 3 1076 1153 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 234 88.2 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
26843866 26843866 PRJEB55122_P_NODE_27061_length_204_cov_2.012903_g26664_i0 PRJEB55122 27061 204 2.012903 4.10632212 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 55.8 5.28e-7   NR XCO56027.1 3233859 g26664 i0 43.3 1.97058823529412 67 36 98.5 1 3 203 471 535 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 402 55.8 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
26907039 26907039 PRJEB55122_P_NODE_14202_length_315_cov_2.255639_g13805_i0 PRJEB55122 14202 315 2.255639 7.10526285 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 110 1.07e-25   NR XCM67837.1 3003959 g13805 i0 51.5 1.92380952380952 101 49 96.2 0 11 313 1340 1440 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 606 110 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
27096729 27096729 PRJEB55122_P_NODE_11122_length_376_cov_0.914373_g10725_i0 PRJEB55122 11122 376 0.914373 3.43804248 brine shrimp arlivirus 9 2900384 Viruses Viruses 246 9.28e-73   NR UNI74144.1 2900384 g10725 i0 89.6 0.997340425531915 125 13 99.7 0 2 376 92 216 UNI74144.1 MAG: RNA-dependent RNA polymerase [brine shrimp arlivirus 9] diamond 375 246 1 Viruses   Orthornavirae Negarnaviricota Monjiviricetes Mononegavirales Lispiviridae Arlivirus brine shrimp arlivirus 9
27570658 27570658 PRJEB55122_P_NODE_9084_length_436_cov_1.596899_g8690_i0 PRJEB55122 9084 436 1.596899 6.96247964 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 90.1 8.81e-18   NR XCM68108.1 3003959 g8690 i0 40.3 0.818807339449541 119 65 80.5 2 3 353 60 174 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 357 90.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28359880 28359880 PRJEB55122_P_NODE_34086_length_177_cov_1.218750_g33689_i0 PRJEB55122 34086 177 1.21875 2.1571875 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 86.3 7.29e-18   NR XCM67837.1 3003959 g33689 i0 64.4 1 59 21 100 0 177 1 566 624 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 177 86.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
28738955 28738955 PRJEB55122_P_NODE_16547_length_282_cov_1.223176_g16150_i0 PRJEB55122 16547 282 1.223176 3.44935632 Fusarium culmorum yue-like virus 1 3233859 Viruses Viruses 48.9 4.19e-4   NR XCO56027.1 3233859 g16150 i0 35.6 0.925531914893617 87 56 92.6 0 1 261 595 681 XCO56027.1 MAG: putative RNA-dependent RNA polymerase [Fusarium culmorum yue-like virus 1] diamond 261 48.9 1 Viruses   Orthornavirae Negarnaviricota Yunchangviricetes Goujianvirales Yueviridae   Fusarium culmorum yue-like virus 1
29433253 29433253 PRJEB55122_P_NODE_35110_length_173_cov_2.096774_g34713_i0 PRJEB55122 35110 173 2.096774 3.62741902 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 69.7 4.48e-12   NR XCM67837.1 3003959 g34713 i0 60.4 1.83815028901734 53 21 91.9 0 172 14 1708 1760 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 318 69.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31234049 31234049 PRJEB55122_P_NODE_8655_length_451_cov_1.373134_g8261_i0 PRJEB55122 8655 451 1.373134 6.19283434 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 250 8.53e-74   NR XCM67837.1 3003959 g8261 i0 72 0.997782705099778 150 42 99.8 0 451 2 1433 1582 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 450 250 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31898468 31898468 PRJEB55122_P_NODE_26317_length_208_cov_1.308176_g25920_i0 PRJEB55122 26317 208 1.308176 2.72100608 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 74.3 1.76e-13   NR XCM68108.1 3003959 g25920 i0 60.3 0.980769230769231 68 23 93.8 3 14 208 678 744 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 204 74.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
31930026 31930026 PRJEB55122_P_NODE_9237_length_431_cov_1.463351_g8843_i0 PRJEB55122 9237 431 1.463351 6.3070428100000004 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 104 8.919999999999999e-23   NR XCM68108.1 3003959 g8843 i0 46.3 0.751740139211137 108 57 75.2 1 31 354 881 987 XCM68108.1 MAG: structural polyprotein [Picornavirales sp.] diamond 324 104 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
32563178 32563178 PRJEB55122_P_NODE_32119_length_184_cov_1.155556_g31722_i0 PRJEB55122 32119 184 1.155556 2.12622304 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 84.3 3.78e-17   NR XCM67837.1 3003959 g31722 i0 60.7 0.994565217391304 61 24 99.5 0 2 184 1582 1642 XCM67837.1 MAG: nonstructural polyprotein [Picornavirales sp.] diamond 183 84.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3

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