RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB73599", tax_kingdom = "Orthornavirae" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 15 ✖

tax_kingdom 1

  • Orthornavirae · 15 ✖

bioproject 1

  • PRJEB73599 · 15 ✖

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
135213 135213 PRJEB73599_P_NODE_8021_length_191_cov_2.623457_g7734_i0 PRJEB73599 8021 191 2.623457 5.01080287 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 351 1.45e-92   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g7734 i0 100 0.994764397905759 190 0 99 0 1 190 876 1065 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 190 351 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
1409753 1409753 PRJEB73599_P_NODE_2_length_8228_cov_6.194170_g1_i0 PRJEB73599 2 8228 6.19417 509.6563076 Crogonang virus 58 3063050 Viruses Viruses 3365 0   NTclustered gi|2836327550|gb|PQ161599.1| 3063050 g1 i0 81.318 1.34309674282936 4202 736 51 44 2278 6455 144 4320 MAG: Crogonang virus 58 isolate CS25 RNA-dependent RNA polymerase gene, complete cds; and capsid protein gene, partial cds blastn 11051 3365 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
2685252 2685252 PRJEB73599_P_NODE_3_length_8164_cov_6.212415_g1_i1 PRJEB73599 3 8164 6.212415 507.1815606 Crogonang virus 58 3063050 Viruses Viruses 3365 0   NTclustered gi|2836327550|gb|PQ161599.1| 3063050 g1 i1 81.318 1.35362567368937 4202 736 51 44 2278 6455 144 4320 MAG: Crogonang virus 58 isolate CS25 RNA-dependent RNA polymerase gene, complete cds; and capsid protein gene, partial cds blastn 11051 3365 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 58
2685275 2685275 PRJEB73599_P_NODE_6643_length_230_cov_1.741294_g6356_i0 PRJEB73599 6643 230 1.741294 4.0049762 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 420 4.89e-113   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g6356 i0 99.565 2 230 1 100 0 1 230 1189 1418 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 460 420 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
5237743 5237743 PRJEB73599_P_NODE_5_length_6284_cov_7.841886_g2_i0 PRJEB73599 5 6284 7.841886 492.78411624 Qianjiang marna-like virus 54 3347701 Viruses Viruses 944 4.08e-291   NR XHA88140.1 3347701 g2 i0 48.1 0.506524506683641 1061 518 49.6 14 5880 2767 686 1736 XHA88140.1 MAG: polyprotein [Qianjiang marna-like virus 54] diamond 3183 944 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 54
17986786 17986786 PRJEB73599_P_NODE_7175_length_214_cov_1.767568_g6888_i0 PRJEB73599 7175 214 1.767568 3.78259552 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 387 4.55e-103   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g6888 i0 100 1.96728971962617 209 0 98 0 4 212 1182 974 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 421 387 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
20536118 20536118 PRJEB73599_P_NODE_9617_length_160_cov_1.679389_g9330_i0 PRJEB73599 9617 160 1.679389 2.6870224 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 296 5.55e-76   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g9330 i0 100 2 160 0 100 0 1 160 187 28 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 320 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
21811960 21811960 PRJEB73599_P_NODE_5458_length_272_cov_2.074074_g5171_i0 PRJEB73599 5458 272 2.074074 5.64148128 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 497 2.67e-136   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g5171 i0 99.632 2 272 1 100 0 1 272 920 649 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 544 497 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
27792375 27792375 PRJEB73599_P_NODE_124_length_1914_cov_3.293369_g88_i0 PRJEB73599 124 1914 3.293369 63.03508266 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 537 1.1899999999999995e-169   NR XHA88175.1 3003959 g88 i0 44.2 0.996865203761755 636 347 98.9 7 1893 1 878 1510 XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71] diamond 1908 537 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Fish-associated picorna-like virus 3
27950231 27950231 PRJEB73599_P_NODE_9125_length_169_cov_1.785714_g8838_i0 PRJEB73599 9125 169 1.785714 3.01785666 Marnaviridae sp. 2715102 Viruses Viruses 101 3.389999999999999e-23   NR ULF99991.1 2715102 g8838 i0 82.1 0.994082840236686 56 10 99.4 0 2 169 2905 2960 ULF99991.1 MAG: hypothetical protein [Marnaviridae sp.] diamond 168 101 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
28455521 28455521 PRJEB73599_P_NODE_8786_length_175_cov_1.842466_g8499_i0 PRJEB73599 8786 175 1.842466 3.2243155 Crogonang virus 69 3063080 Viruses Viruses 106 6.45e-25   NR WPR18350.1 3063080 g8499 i0 86.2 1.98857142857143 58 8 99.4 0 174 1 601 658 WPR18350.1 MAG: capsid protein [Crogonang virus 69] diamond 348 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 69
29433823 29433823 PRJEB73599_P_NODE_70_length_2346_cov_3.078981_g47_i0 PRJEB73599 70 2346 3.078981 72.23289426 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 295 1.1e-80   NR XHA88175.1 3003959 g47 i0 43.9 0.818414322250639 319 179 40.8 0 1389 2345 202 520 XHA88175.1 MAG: polyprotein [Qianjiang marna-like virus 71] diamond 1920 295 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Fish-associated picorna-like virus 3
30658827 30658827 PRJEB73599_P_NODE_7113_length_216_cov_1.636364_g6826_i0 PRJEB73599 7113 216 1.636364 3.53454624 Viruses 10239 Viruses Viruses 135 4.05e-35   NR URG14941.1 1530251 g6826 i0 80.3 4.93055555555556 71 14 98.6 0 3 215 211 281 URG14941.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 1065 136 0.992647058823529 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
32088838 32088838 PRJEB73599_P_NODE_2378_length_477_cov_2.689732_g2113_i0 PRJEB73599 2378 477 2.689732 12.83002164 Qianjiang marna-like virus 141 3347565 Viruses Viruses 63.9 1.95e-8   NR XHA88296.1 3347565 g2113 i0 30.5 1.19496855345912 190 98 98.1 7 469 2 531 720 XHA88296.1 MAG: polyprotein, partial [Qianjiang marna-like virus 141] diamond 570 63.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 141
32120658 32120658 PRJEB73599_P_NODE_798_length_847_cov_2.193154_g642_i0 PRJEB73599 798 847 2.193154 18.57601438 Herophile durna-like virus 2912704 Viruses Viruses 149 6.459999999999999e-37   NR DAZ87252.1 2912704 g642 i0 40.4 0.701298701298701 198 112 68.7 4 1 582 373 568 DAZ87252.1 TPA_asm: RNA-dependent polymerase, partial [Herophile durna-like virus] diamond 594 149 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales     Herophile durna-like virus

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