RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA559720" and tax_kingdom = "Orthornavirae"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Orthornavirae · 11 ✖

bioproject 1

  • PRJNA559720 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
543493 543493 PRJNA559720_P_NODE_1_length_6062_cov_6.049257_g0_i0 PRJNA559720 1 6062 6.049257 366.70595934 Potexvirus marmorplantagonis 3433852 Viruses Viruses 11040 0   NTclustered gi|872708292|emb|LN794199.1| 28354 g0 i0 99.587 46.8073243154075 6053 25 99 0 10 6062 6065 13 Plantago asiatica mosaic virus, complete genome, isolate Concador blastn 283746 11040 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Tymovirales Alphaflexiviridae Potexvirus Potexvirus marmorplantagonis
1819267 1819267 PRJNA559720_P_NODE_6362_length_406_cov_1.279279_g6223_i0 PRJNA559720 6362 406 1.279279 5.19387274 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 265 4.6e-66   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g6223 i0 98.667 0.369458128078818 150 1 37 1 1 150 957 1105 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 150 265 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1819275 1819275 PRJNA559720_P_NODE_6882_length_389_cov_0.971519_g6743_i0 PRJNA559720 6882 389 0.971519 3.77920891 Picornaviridae sp. 1530251 Viruses Viruses 536 8.419999999999997e-148   NTclustered gi|2245485800|gb|ON162018.1| 1530251 g6743 i0 91.517 1.86889460154242 389 33 100 0 1 389 1058 670 MAG: Picornaviridae sp. isolate 161-k141_128852 RNA dependent RNA polymerase gene, partial cds blastn 727 536 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
3094410 3094410 PRJNA559720_P_NODE_103_length_1803_cov_2.732948_g87_i0 PRJNA559720 103 1803 2.732948 49.27505244 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1044 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g87 i0 96.1 0.793677204658902 641 23 79 2 3 642 5968 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1431 1044 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5647467 5647467 PRJNA559720_P_NODE_9125_length_327_cov_0.909449_g8986_i0 PRJNA559720 9125 327 0.909449 2.97389823 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 518 2.5199999999999998e-142   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g8986 i0 96.203 0.9663608562691132 316 12 97 0 12 327 2548 2233 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 316 518 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
6921505 6921505 PRJNA559720_P_NODE_1326_length_836_cov_1.437746_g1241_i0 PRJNA559720 1326 836 1.437746 12.01955656 Picornaviridae sp. 1530251 Viruses Viruses 1284 0   NTclustered gi|2245485797|gb|ON162017.1| 1530251 g1241 i0 94.378 1 836 47 100 0 1 836 1358 2193 MAG: Picornaviridae sp. isolate 161-k141_121922 RNA dependent RNA polymerase and capsid protein genes, partial cds blastn 836 1284 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
9472229 9472229 PRJNA559720_P_NODE_9988_length_308_cov_1.710638_g9849_i0 PRJNA559720 9988 308 1.710638 5.26876504 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 259 1.5800000000000002e-64   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g9849 i0 97.987 0.483766233766234 149 3 48 0 160 308 639 491 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 149 259 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
18395400 18395400 PRJNA559720_P_NODE_14355_length_248_cov_0.880000_g14216_i0 PRJNA559720 14355 248 0.88 2.1824 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 368 1.96e-97   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g14216 i0 98.104 0.850806451612903 211 4 85 0 1 211 1652 1442 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 211 368 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
18395507 18395507 PRJNA559720_P_NODE_8375_length_345_cov_1.507353_g8236_i0 PRJNA559720 8375 345 1.507353 5.20036785 Picornaviridae sp. 1530251 Viruses Viruses 394 4.71e-105   NTclustered gi|2245485797|gb|ON162017.1| 1530251 g8236 i0 87.464 1.5768115942029 343 42 99 1 2 344 1107 766 MAG: Picornaviridae sp. isolate 161-k141_121922 RNA dependent RNA polymerase and capsid protein genes, partial cds blastn 544 394 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
20945749 20945749 PRJNA559720_P_NODE_3497_length_554_cov_1.372141_g3369_i0 PRJNA559720 3497 554 1.372141 7.60166114 Picornaviridae sp. 1530251 Viruses Viruses 625 2.5599999999999995e-174   NTclustered gi|2245485800|gb|ON162018.1| 1530251 g3369 i0 89.537 0.897111913357401 497 46 89 5 1 494 496 3 MAG: Picornaviridae sp. isolate 161-k141_128852 RNA dependent RNA polymerase gene, partial cds blastn 497 625 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
23495994 23495994 PRJNA559720_P_NODE_779_length_1010_cov_5.160085_g719_i0 PRJNA559720 779 1010 5.160085 52.1168585 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 1666 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g719 i0 96.429 0.998019801980198 1008 36 99 0 1 1008 5981 6988 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 1008 1666 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2

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