RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax_phylum = "Pisuviricota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pisuviricota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA509429 · 21 ✖

analysis 1

  • blastn · 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
485197 485197 PRJNA509429_P_NODE_33181_length_208_cov_2.057803_g32353_i0 PRJNA509429 33181 208 2.057803 4.28023024 Crogonang virus 24 3062947 Viruses Viruses 276 9.93e-70   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g32353 i0 90.777 0.990384615384615 206 19 99 0 1 206 891 1096 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 206 276 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
1760409 1760409 PRJNA509429_P_NODE_20242_length_299_cov_1.602273_g19414_i0 PRJNA509429 20242 299 1.602273 4.79079627 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 503 6.389999999999998e-138   NTclustered gi|2754691743|gb|PP872648.1| 3003959 g19414 i0 97 2.95986622073579 300 8 100 1 1 299 5763 6062 MAG: Picornavirales sp. isolate TC-PLV-92 MR233-17E/390 genomic sequence blastn 885 503 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
1760425 1760425 PRJNA509429_P_NODE_24362_length_262_cov_2.691630_g23534_i0 PRJNA509429 24362 262 2.69163 7.0520706 Crogonang virus 24 3062947 Viruses Viruses 429 9.449999999999999e-116   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g23534 i0 96.183 1.99236641221374 262 10 100 0 1 262 3466 3205 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 522 429 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
4312093 4312093 PRJNA509429_P_NODE_18644_length_316_cov_1.861210_g17816_i0 PRJNA509429 18644 316 1.86121 5.8814236 Marnaviridae sp. 2715102 Viruses Viruses 327 4.39e-85   NTclustered gi|2196309010|gb|MZ679223.1| 2715102 g17816 i0 85.397 0.996835443037975 315 46 99 0 2 316 1800 2114 MAG: Marnaviridae sp. isolate 358R-k141_438927 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 315 327 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
4312194 4312194 PRJNA509429_P_NODE_46264_length_163_cov_0.929688_g45436_i0 PRJNA509429 46264 163 0.929688 1.51539144 Marnaviridae sp. 2715102 Viruses Viruses 126 7.89e-25   NTclustered gi|2196309058|gb|MZ679256.1| 2715102 g45436 i0 96.104 0.94478527607362 77 3 47 0 1 77 9125 9049 MAG: Marnaviridae sp. isolate R120-k141_839266 hypothetical protein gene, complete cds blastn 154 126 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
6863032 6863032 PRJNA509429_P_NODE_39986_length_181_cov_1.589041_g39158_i0 PRJNA509429 39986 181 1.589041 2.87616421 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 335 1.36e-87   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g39158 i0 100 4.70165745856354 181 0 100 0 1 181 564 384 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 851 335 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
6863096 6863096 PRJNA509429_P_NODE_6_length_7212_cov_16.080117_g1_i0 PRJNA509429 6 7212 16.080117 1159.69803804 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2505 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g1 i0 92.036 0.666389351081531 1783 137 67 5 5 1784 7109 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 4806 2505 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
8138366 8138366 PRJNA509429_P_NODE_45787_length_164_cov_1.240310_g44959_i0 PRJNA509429 45787 164 1.24031 2.0341084 Marnaviridae sp. 2715102 Viruses Viruses 148 1.6999999999999996e-31   NTclustered gi|2196308959|gb|MZ679198.1| 2715102 g44959 i0 83.234 1.01829268292683 167 22 100 5 1 164 2065 1902 MAG: Marnaviridae sp. isolate 359R-k141_309644 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 167 148 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
8138382 8138382 PRJNA509429_P_NODE_49407_length_155_cov_1.666667_g48579_i0 PRJNA509429 49407 155 1.666667 2.58333385 Crogonang virus 24 3062947 Viruses Viruses 281 1.49e-71   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g48579 i0 99.355 2.96129032258065 155 1 100 0 1 155 6426 6272 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 459 281 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
9413344 9413344 PRJNA509429_P_NODE_26248_length_248_cov_1.981221_g25420_i0 PRJNA509429 26248 248 1.981221 4.91342808 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 453 5.2600000000000005e-123   NTclustered gi|1338075549|gb|MG647770.1| 2080259 g25420 i0 99.597 2 248 1 100 0 1 248 1105 1352 Blacklegged tick picorna-like virus 2 isolate RTS-11.1 hypothetical protein gene, partial cds blastn 496 453 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
9413384 9413384 PRJNA509429_P_NODE_36948_length_192_cov_1.707006_g36120_i0 PRJNA509429 36948 192 1.707006 3.27745152 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 305 1.15e-78   NTclustered gi|2754691743|gb|PP872648.1| 3003959 g36120 i0 95.312 2 192 9 100 0 1 192 629 438 MAG: Picornavirales sp. isolate TC-PLV-92 MR233-17E/390 genomic sequence blastn 384 305 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
9413440 9413440 PRJNA509429_P_NODE_47648_length_159_cov_1.935484_g46820_i0 PRJNA509429 47648 159 1.935484 3.07741956 Megareus marna-like virus 1 2980093 Viruses Viruses 283 4.29e-72   NTclustered gi|2306601800|gb|OP191694.1| 2980093 g46820 i0 98.742 1 159 2 100 0 1 159 42 200 MAG: Megareus marna-like virus 1 isolate Nanocul1, partial genome blastn 159 283 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Megareus marna-like virus 1
10688971 10688971 PRJNA509429_P_NODE_27569_length_239_cov_2.906863_g26741_i0 PRJNA509429 27569 239 2.906863 6.94740257 Crogonang virus 24 3062947 Viruses Viruses 420 5.11e-113   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g26741 i0 98.326 3 239 4 100 0 1 239 5100 5338 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 717 420 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
10689039 10689039 PRJNA509429_P_NODE_41949_length_175_cov_1.142857_g41121_i0 PRJNA509429 41949 175 1.142857 1.99999975 Marnaviridae sp. 2715102 Viruses Viruses 121 3.98e-23   NTclustered gi|2196309058|gb|MZ679256.1| 2715102 g41121 i0 82.482 0.782857142857143 137 24 78 0 15 151 1952 2088 MAG: Marnaviridae sp. isolate R120-k141_839266 hypothetical protein gene, complete cds blastn 137 121 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
11964047 11964047 PRJNA509429_P_NODE_50630_length_152_cov_2.735043_g49802_i0 PRJNA509429 50630 152 2.735043 4.15726536 Marnaviridae sp. 2715102 Viruses Viruses 198 1.51e-46   NTclustered gi|2196308959|gb|MZ679198.1| 2715102 g49802 i0 90.132 1 152 15 100 0 1 152 795 644 MAG: Marnaviridae sp. isolate 359R-k141_309644 hypothetical protein 1 and hypothetical protein 2 genes, complete cds blastn 152 198 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
13239163 13239163 PRJNA509429_P_NODE_37531_length_190_cov_1.374194_g36703_i0 PRJNA509429 37531 190 1.374194 2.6109686 Crogonang virus 24 3062947 Viruses Viruses 329 6.730000000000001e-86   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g36703 i0 97.895 2.36842105263158 190 4 100 0 1 190 2983 3172 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 450 329 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
15787955 15787955 PRJNA509429_P_NODE_34753_length_201_cov_1.650602_g33925_i0 PRJNA509429 34753 201 1.650602 3.31771002 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 355 1.19e-93   NTclustered gi|2214231626|gb|OM622299.1| 3003959 g33925 i0 98.507 1.54228855721393 201 3 100 0 1 201 5821 5621 MAG: Picornavirales sp. isolate HPLV-44 genomic sequence blastn 310 355 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Fish-associated picorna-like virus 3
17062602 17062602 PRJNA509429_P_NODE_51074_length_151_cov_3.275862_g50246_i0 PRJNA509429 51074 151 3.275862 4.94655162 Crogonang virus 100 3063241 Viruses Viruses 106 9.33e-19   NTclustered gi|2626079875|gb|OR270506.1| 3063241 g50246 i0 82.906 0.774834437086093 117 20 77 0 4 120 515 399 MAG: Crogonang virus 100 isolate CGH03 genomic sequence blastn 117 106 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 100
19611242 19611242 PRJNA509429_P_NODE_29056_length_230_cov_2.656410_g28228_i0 PRJNA509429 29056 230 2.65641 6.109743 Crogonang virus 24 3062947 Viruses Viruses 370 4.99e-98   NTclustered gi|2626079214|gb|OR270257.1| 3062947 g28228 i0 95.652 1 230 10 100 0 1 230 1968 2197 MAG: Crogonang virus 24 isolate CGH03 genomic sequence blastn 230 370 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Crogonang virus 24
22161976 22161976 PRJNA509429_P_NODE_24238_length_263_cov_2.692982_g23410_i0 PRJNA509429 24238 263 2.692982 7.08254266 Blacklegged tick picorna-like virus 2 2080259 Viruses Viruses 481 2.58e-131   NTclustered gi|1338075553|gb|MG647772.1| 2080259 g23410 i0 99.62 10.6539923954373 263 1 100 0 1 263 277 15 Blacklegged tick picorna-like virus 2 isolate RTS-11.3 hypothetical protein gene, partial cds blastn 2802 481 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Blacklegged tick picorna-like virus 2
22161998 22161998 PRJNA509429_P_NODE_32178_length_213_cov_1.483146_g31350_i0 PRJNA509429 32178 213 1.483146 3.15910098 Fish-associated picorna-like virus 3 3003959 Viruses Viruses 366 5.89e-97   NTclustered gi|2214231626|gb|OM622299.1| 3003959 g31350 i0 97.653 1 213 5 100 0 1 213 6541 6329 MAG: Picornavirales sp. isolate HPLV-44 genomic sequence blastn 213 366 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);;