RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA390533" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 15 ✖

bioproject 1

  • PRJNA390533 · 15 ✖

analysis 1

  • diamond · 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
11888751 11888751 PRJNA390533_P_NODE_8370_length_679_cov_4.070312_g7580_i0 PRJNA390533 8370 679 4.070312 27.63741848 Psychrobacter phage D'Alembert 2891959 Viruses Viruses 150 4.72e-40   NR CAH1193240.1 2891959 g7580 i0 49.3 3.27835051546392 150 73 66.3 1 655 206 1 147 CAH1193240.1 XkdK-like protein [Psychrobacter phage D'Alembert] diamond 2226 150 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Psychrobacter phage D'Alembert
14438804 14438804 PRJNA390533_P_NODE_752_length_1677_cov_7.327839_g614_i0 PRJNA390533 752 1677 7.327839 122.88786003 Panax cryptic virus 4 2809267 Viruses Viruses 784 1.01e-281   NR QRG29207.1 2809267 g614 i0 79.2 0.876565295169946 490 102 87.7 0 14 1483 1 490 QRG29207.1 putative CP [Panax cryptic virus 4] diamond 1470 784 1 Viruses   Orthornavirae Pisuviricota Duplopiviricetes Durnavirales Partitiviridae   Panax cryptic virus 4
27739021 27739021 PRJNA390533_P_NODE_36344_length_199_cov_2.543750_g35317_i0 PRJNA390533 36344 199 2.54375 5.0620625 Microbacterium phage Count 2182352 Viruses Viruses 47.8 3.34e-4   NR AWN03372.1 2182352 g35317 i0 51.3 0.587939698492462 39 19 58.8 0 197 81 148 186 AWN03372.1 hypothetical protein PBI_COUNT_49 [Microbacterium phage Count] diamond 117 47.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Microbacterium phage Count
29727525 29727525 PRJNA390533_P_NODE_12510_length_544_cov_5.182178_g11568_i0 PRJNA390533 12510 544 5.182178 28.19104832 Caudoviricetes sp. 2832643 Viruses Viruses 136 2.5e-37   NR AXF51898.1 2832643 g11568 i0 56.7 0.661764705882353 120 51 66.2 1 173 532 4 122 AXF51898.1 MAG: NADH dehydrogenase subunit C [Caudoviricetes sp.] diamond 360 136 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30865072 30865072 PRJNA390533_P_NODE_2194_length_1186_cov_9.176112_g1855_i0 PRJNA390533 2194 1186 9.176112 108.82868832 Acinetobacter phage MD-2 2865959 Viruses Viruses 236 7.55e-72   NR CAH1066774.1 2899278 g1855 i0 62.4 0.430016863406408 170 64 43 0 1174 665 93 262 CAH1066774.1 Uncharacterised protein [Acinetobacter phage MD-2021a] diamond 510 236 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Acinetobacter phage MD-2021a
31023151 31023151 PRJNA390533_P_NODE_26675_length_296_cov_11.249027_g25648_i0 PRJNA390533 26675 296 11.249027 33.29711992 Erysiphe necator associated virus 2 2741903 Viruses Viruses 95.5 1.82e-20   NR QKI79984.1 2741903 g25648 i0 71.2 0.668918918918919 66 19 66.9 0 276 79 465 530 QKI79984.1 RNA-dependent RNA polymerase [Erysiphe necator associated virus 2] diamond 198 95.5 1 Viruses               Erysiphe necator associated virus 2
31514483 31514483 PRJNA390533_P_NODE_13676_length_512_cov_22.642706_g12701_i0 PRJNA390533 13676 512 22.642706 115.93065472 Viruses 10239 Viruses Viruses 182 9.06e-51   NR UQS93311.1 2933656 g12701 i0 53.4 1.88671875 161 73 93.8 2 490 11 435 594 UQS93311.1 MAG: polymerase PB1 [Bactrocera correcta Orthomyxo-like virus] diamond 966 182 1 Viruses   Orthornavirae Negarnaviricota Insthoviricetes Articulavirales Orthomyxoviridae   Bactrocera correcta Orthomyxo-like virus
31623841 31623841 PRJNA390533_P_NODE_19396_length_395_cov_2.064607_g18374_i0 PRJNA390533 19396 395 2.064607 8.15519765 Macrobrachium rosenbergii picorna-like virus 4 3132542 Viruses Viruses 135 5.4e-34   NR WWZ85593.1 3132542 g18374 i0 78.8 0.607594936708861 80 17 60.8 0 395 156 1768 1847 WWZ85593.1 RNA-dependent RNA polymerase [Macrobrachium rosenbergii picorna-like virus 4] diamond 240 135 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Macrobrachium rosenbergii picorna-like virus 4
31718799 31718799 PRJNA390533_P_NODE_25537_length_315_cov_1.478261_g24510_i0 PRJNA390533 25537 315 1.478261 4.65652215 Caudoviricetes sp. 2832643 Viruses Viruses 63.2 9.58e-11   NR XOS41782.1 2832643 g24510 i0 45.6 0.542857142857143 57 31 54.3 0 16 186 1 57 XOS41782.1 MAG: hypothetical protein MSP0993_51 [Caudoviricetes sp.] diamond 171 63.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32146965 32146965 PRJNA390533_P_NODE_40118_length_180_cov_1.638298_g39091_i0 PRJNA390533 40118 180 1.638298 2.9489364 root 1 Root_unresolved Root_unresolved 73.2 7.49e-14   NR YP_009603591.1 1175654 g39091 i0 58.9 2.85 56 21 93.3 1 169 2 155 208 YP_009603591.1 QueE-like radical SAM domain [Pseudomonas phage PaMx25] diamond 513 73.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Nipunavirus Nipunavirus PaMx25
32193412 32193412 PRJNA390533_P_NODE_28858_length_266_cov_1.136564_g27831_i0 PRJNA390533 28858 266 1.136564 3.02326024 Caudoviricetes sp. 2832643 Viruses Viruses 151 3.3599999999999992e-43   NR XOQ93795.1 2832643 g27831 i0 83 0.992481203007519 88 15 99.2 0 3 266 22 109 XOQ93795.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 264 151 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32414965 32414965 PRJNA390533_P_NODE_31299_length_238_cov_3.542714_g30272_i0 PRJNA390533 31299 238 3.542714 8.43165932 Caudoviricetes sp. 2832643 Viruses Viruses 47 8.91e-5   NR DAR72918.1 2832643 g30272 i0 57.8 0.567226890756303 45 18 55.5 1 84 215 14 58 DAR72918.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 135 47 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32414975 32414975 PRJNA390533_P_NODE_46219_length_160_cov_1.000000_g45192_i0 PRJNA390533 46219 160 1 1.6 Pseudanabaena phage Pan4 2981587 Viruses Viruses 95.5 8.14e-22   NR UXO94023.1 2981587 g45192 i0 81.5 3.0375 54 9 99.4 1 160 2 153 206 UXO94023.1 DNA methylase [Pseudanabaena phage Pan4] diamond 486 95.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Pseudanabaena phage Pan4
32510031 32510031 PRJNA390533_P_NODE_1959_length_1236_cov_7.183793_g1653_i0 PRJNA390533 1959 1236 7.183793 88.79168148 Caudoviricetes sp. 2832643 Viruses Viruses 130 7.23e-33   NR XOR18952.1 2832643 g1653 i0 64.5 0.533980582524272 110 36 26.2 2 568 245 1 109 XOR18952.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 660 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32541651 32541651 PRJNA390533_P_NODE_12199_length_554_cov_1.933981_g11261_i0 PRJNA390533 12199 554 1.933981 10.71425474 Caudoviricetes sp. 2832643 Viruses Viruses 94 1.34e-18   NR XOQ91086.1 2832643 g11261 i0 41.4 0.693140794223827 128 73 68.8 2 21 401 445 571 XOQ91086.1 MAG: pre-neck appendage [Caudoviricetes sp.] diamond 384 94 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.

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