RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 16 ✖

bioproject 1

  • PRJNA1113956 · 16 ✖

analysis 1

  • blastn · 16 ✖

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
1496677 1496677 PRJNA1113956_P_NODE_18702_length_263_cov_1.621053_g18362_i0 PRJNA1113956 18702 263 1.621053 4.26336939 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 169 2.28e-37   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g18362 i0 97 0.380228136882129 100 3 38 0 164 263 1 100 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 100 169 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
1496754 1496754 PRJNA1113956_P_NODE_42_length_4383_cov_18.165197_g30_i0 PRJNA1113956 42 4383 18.165197 796.18058451 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 2471 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g30 i0 91.699 0.688113164499201 1783 143 69 5 2 1782 7108 5329 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 3016 2471 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
5324940 5324940 PRJNA1113956_P_NODE_22865_length_241_cov_0.916667_g22525_i0 PRJNA1113956 22865 241 0.916667 2.20916747 Enterobacter phage vB_EluP_RZH 3249627 Viruses Viruses 440 3.959999999999999e-119   NTclustered gi|2795099075|gb|PQ140450.1| 3249627 g22525 i0 99.585 8 241 1 100 0 1 241 25616 25376 Enterobacter phage vB_EluP_RZH, complete genome blastn 1928 440 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Karamvirus Enterobacter phage vB_EluP_RZH
6126809 6126809 PRJNA1113956_P_NODE_22345_length_242_cov_1.366864_g22005_i0 PRJNA1113956 22345 242 1.366864 3.30781088 Christensenvirus 2732061 Viruses Viruses 448 2.3799999999999995e-121   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g22005 i0 100 6.17768595041322 242 0 100 0 1 242 626 867 Escherichia phage TR2, complete genome blastn 1495 448 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
6599992 6599992 PRJNA1113956_P_NODE_11246_length_400_cov_1.798165_g10906_i0 PRJNA1113956 11246 400 1.798165 7.19266 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 189 2.8e-43   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g10906 i0 94.309 0.3075 123 7 31 0 1 123 517 639 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 123 189 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
9952053 9952053 PRJNA1113956_P_NODE_19788_length_251_cov_0.865169_g19448_i0 PRJNA1113956 19788 251 0.865169 2.17157419 Christensenvirus 2732061 Viruses Viruses 464 2.47e-126   NTclustered gi|1842038479|ref|NC_048208.1| 2507711 g19448 i0 100 21.4860557768924 251 0 100 0 1 251 40651 40401 Enterobacteria phage vB_EcoS_IME542, complete genome blastn 5393 464 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Christensenvirus IME542
11227059 11227059 PRJNA1113956_P_NODE_10609_length_421_cov_1.347701_g10270_i0 PRJNA1113956 10609 421 1.347701 5.67382121 Tequatrovirus 10663 Viruses Viruses 778 0   NTclustered gi|2721715921|emb|OZ035787.1| 10665 g10270 i0 100 99.9714964370546 421 0 100 0 1 421 38672 38252 Tequatrovirus T4 genome assembly, chromosome: 1 blastn 42088 778 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Tequatrovirus T4
11227178 11227178 PRJNA1113956_P_NODE_18669_length_264_cov_1.083770_g18329_i0 PRJNA1113956 18669 264 1.08377 2.8611528 Christensenvirus 2732061 Viruses Viruses 477 3.359999999999999e-130   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g18329 i0 99.242 6.15909090909091 264 2 100 0 1 264 24506 24769 Escherichia phage TR2, complete genome blastn 1626 477 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
12975858 12975858 PRJNA1113956_P_NODE_4151_length_866_cov_1.938209_g3873_i0 PRJNA1113956 4151 866 1.938209 16.78488994 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 377 1.2699999999999999e-99   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g3873 i0 92.135 0.431870669745958 267 21 43 0 230 496 1442 1708 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 374 377 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
17601517 17601517 PRJNA1113956_P_NODE_16154_length_299_cov_1.022124_g15814_i0 PRJNA1113956 16154 299 1.022124 3.05615076 Tequatrovirus 10663 Viruses Viruses 553 6.25e-153   NTclustered gi|2721715921|emb|OZ035787.1| 10665 g15814 i0 100 99.9364548494983 299 0 100 0 1 299 38198 37900 Tequatrovirus T4 genome assembly, chromosome: 1 blastn 29881 553 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Tequatrovirus Tequatrovirus T4
20150179 20150179 PRJNA1113956_P_NODE_12836_length_358_cov_1.350877_g12496_i0 PRJNA1113956 12836 358 1.350877 4.83613966 Christensenvirus 2732061 Viruses Viruses 662 0   NTclustered gi|2287965697|gb|OP087522.1| 2972435 g12496 i0 100 54.8966480446927 358 0 100 0 1 358 12790 12433 Escherichia phage TR1, complete genome blastn 19653 662 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR1
20150212 20150212 PRJNA1113956_P_NODE_14776_length_321_cov_1.862903_g14436_i0 PRJNA1113956 14776 321 1.862903 5.97991863 root 1 Root_unresolved Root_unresolved 582 8.639999999999997e-162   NTclustered gi|2053021216|tpg|BK023879.1| 38018 g14436 i0 99.377 99.4018691588785 321 2 100 0 1 321 1346 1026 MAG TPA_asm: Bacteriophage sp. isolate ctXXx2, partial genome blastn 31908 582 1 Viruses               Bacteriophage sp.
21425787 21425787 PRJNA1113956_P_NODE_13117_length_352_cov_1.376344_g12777_i0 PRJNA1113956 13117 352 1.376344 4.84473088 Christensenvirus 2732061 Viruses Viruses 651 0   NTclustered gi|2312628476|gb|OP251154.1| 2978981 g12777 i0 100 6.99715909090909 352 0 100 0 1 352 4289 3938 Escherichia phage TR2, complete genome blastn 2463 651 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Drexlerviridae Christensenvirus Escherichia phage TR2
21898809 21898809 PRJNA1113956_P_NODE_13778_length_338_cov_3.192453_g13438_i0 PRJNA1113956 13778 338 3.192453 10.79049114 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 569 7.119999999999998e-158   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g13438 i0 97.041 1 338 10 100 0 1 338 390 53 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 338 569 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Danio blood picornavirus/Zebrafish picornavirus 2
23174192 23174192 PRJNA1113956_P_NODE_12679_length_362_cov_1.598616_g12339_i0 PRJNA1113956 12679 362 1.598616 5.78698992 Caudoviricetes sp. 2832643 Viruses Viruses 244 5.28e-60   NTclustered gi|2914852811|gb|OR221766.1| 2832643 g12339 i0 79.603 0.975138121546961 353 62 97 7 12 362 29237 29581 MAG: Caudoviricetes sp. isolate MSP1259 genomic sequence blastn 353 244 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
23174337 23174337 PRJNA1113956_P_NODE_7919_length_533_cov_1.676087_g7585_i0 PRJNA1113956 7919 533 1.676087 8.93354371 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 699 0   NTclustered gi|2551699335|gb|OK619588.1| 3063761 g7585 i0 95.045 0.833020637898687 444 22 83 0 47 490 2100 2543 Zebrafish picornavirus 2 isolate AU/2020 polyprotein gene, complete cds blastn 444 699 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);;