RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA782551" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 18 ✖

bioproject 1

  • PRJNA782551 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
12243222 12243222 PRJNA782551_P_NODE_16090_length_251_cov_0.865169_g15968_i0 PRJNA782551 16090 251 0.865169 2.17157419 Piper DNA virus 1 1279080 Viruses Viruses 134 2.63e-34   NR AGC25937.1 1279080 g15968 i0 75.9 0.99203187250996006 83 20 99.2 0 2 250 913 995 AGC25937.1 hypothetical protein, partial [Piper DNA virus 1] diamond 249 134 1 Viruses               Piper DNA virus 1
21166277 21166277 PRJNA782551_P_NODE_20537_length_246_cov_0.890173_g20415_i0 PRJNA782551 20537 246 0.890173 2.18982558 Rhodococcus phage ReqiPine5 691963 Viruses Viruses 95.1 1.48e-20   NR YP_009016227.1 691963 g20415 i0 55.6 1.92682926829268 81 36 98.8 0 4 246 647 727 YP_009016227.1 DNA polymerase/primase [Rhodococcus phage ReqiPine5] diamond 474 95.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Reqipinevirus Reqipinevirus reqipine5
26832132 26832132 PRJNA782551_P_NODE_21061_length_245_cov_0.895349_g20939_i0 PRJNA782551 21061 245 0.895349 2.19360505 Malassezia globosa associated totivirus 1 3048756 Viruses Viruses 165 9.29e-46   NR CAI9858974.1 3048756 g20939 i0 97.5 0.991836734693878 81 2 99.2 0 243 1 483 563 CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1] diamond 243 165 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Orthototiviridae Totivirus Malassezia globosa associated totivirus 1
27053681 27053681 PRJNA782551_P_NODE_21982_length_244_cov_0.900585_g21860_i0 PRJNA782551 21982 244 0.900585 2.1974274 Caudoviricetes sp. 2832643 Viruses Viruses 112 3.26e-30   NR DAL51218.1 2832643 g21860 i0 62 0.971311475409836 79 30 97.1 0 4 240 4 82 DAL51218.1 MAG TPA_asm: Protein of unknown function (DUF2542) [Caudoviricetes sp.] diamond 237 112 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27147989 27147989 PRJNA782551_P_NODE_15582_length_251_cov_1.724719_g15460_i0 PRJNA782551 15582 251 1.724719 4.32904469 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 54.7 4.98e-7   NR QDP55722.1 2591644 g15460 i0 79.4 0.406374501992032 34 7 40.6 0 250 149 79 112 QDP55722.1 MAG: putative terminase small subunit [Prokaryotic dsDNA virus sp.] diamond 102 54.7 1 Viruses               Prokaryotic dsDNA virus sp.
27243223 27243223 PRJNA782551_P_NODE_14383_length_260_cov_1.647059_g14261_i0 PRJNA782551 14383 260 1.647059 4.2823534 Malassezia restricta virus MrV4 76775 Viruses Viruses 152 1.85e-40   NR QJA42332.1 2727863 g14261 i0 86 1.98461538461538 86 12 99.2 0 2 259 841 926 QJA42332.1 polyprotein [Malassezia restricta virus MrV40L] diamond 516 152 1 Viruses   Orthornavirae Duplornaviricota Chrymotiviricetes Ghabrivirales Totiviridae   Malassezia restricta virus MrV40L
27306589 27306589 PRJNA782551_P_NODE_17903_length_249_cov_0.875000_g17781_i0 PRJNA782551 17903 249 0.875 2.17875 Caudoviricetes sp. 2832643 Viruses Viruses 75.9 8.31e-16   NR XOS49302.1 2832643 g17781 i0 70.9 0.662650602409639 55 16 66.3 0 85 249 18 72 XOS49302.1 MAG: hypothetical protein MSP0389_82 [Caudoviricetes sp.] diamond 165 75.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27780302 27780302 PRJNA782551_P_NODE_15684_length_251_cov_0.865169_g15562_i0 PRJNA782551 15684 251 0.865169 2.17157419 Danio blood picornavirus/Zebrafish picornavirus 2 3063761 Viruses Viruses 65.1 5.68e-10   NR AVM87439.1 3063761 g15562 i0 54.9 0.609561752988048 51 23 61 0 99 251 928 978 AVM87439.1 polyprotein [Wuhan sharpbelly picornavirus 1] diamond 153 65.1 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales     Danio blood picornavirus/Zebrafish picornavirus 2
27906193 27906193 PRJNA782551_P_NODE_23525_length_242_cov_0.911243_g23403_i0 PRJNA782551 23525 242 0.911243 2.20520806 Prokaryotic dsDNA virus sp. 2591644 Viruses Viruses 74.7 2.3e-14   NR QDP51681.1 2591644 g23403 i0 67.4 1.31404958677686 46 15 57 0 235 98 5 50 QDP51681.1 MAG: hypothetical protein Tp1100MES1331091_49 [Prokaryotic dsDNA virus sp.] diamond 318 74.7 1 Viruses               Prokaryotic dsDNA virus sp.
28001369 28001369 PRJNA782551_P_NODE_20045_length_246_cov_0.890173_g19923_i0 PRJNA782551 20045 246 0.890173 2.18982558 Caudoviricetes sp. 2832643 Viruses Viruses 53.1 2.37e-6   NR XOS47123.1 2832643 g19923 i0 79.3 0.353658536585366 29 6 35.4 0 159 245 1 29 XOS47123.1 MAG: hypothetical protein MSP0423_113 [Caudoviricetes sp.] diamond 87 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28316982 28316982 PRJNA782551_P_NODE_21166_length_245_cov_0.895349_g21044_i0 PRJNA782551 21166 245 0.895349 2.19360505 Caudoviricetes sp. 2832643 Viruses Viruses 91.7 7.42e-20   NR XOS28078.1 2832643 g21044 i0 55 0.979591836734694 80 36 98 0 5 244 179 258 XOS28078.1 MAG: ssDNA binding, DNA repair, recombination and pre-synthesis [Caudoviricetes sp.] diamond 240 91.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28821790 28821790 PRJNA782551_P_NODE_17808_length_249_cov_0.875000_g17686_i0 PRJNA782551 17808 249 0.875 2.17875 Caudoviricetes sp. 2832643 Viruses Viruses 114 3.0099999999999997e-31   NR XOR09841.1 2832643 g17686 i0 79.1 0.807228915662651 67 14 80.7 0 203 3 1 67 XOR09841.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 201 114 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30780283 30780283 PRJNA782551_P_NODE_15114_length_255_cov_1.241758_g14992_i0 PRJNA782551 15114 255 1.241758 3.1664829 Caudoviricetes sp. 2832643 Viruses Viruses 108 3.3500000000000006e-27   NR XOR09842.1 2832643 g14992 i0 73.1 0.788235294117647 67 18 78.8 0 254 54 138 204 XOR09842.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 201 108 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30780284 30780284 PRJNA782551_P_NODE_19034_length_247_cov_1.626437_g18912_i0 PRJNA782551 19034 247 1.626437 4.01729939 Myoviridae sp. ctkfK18 2825165 Viruses Viruses 167 2.45e-49   NR DAG06020.1 2825165 g18912 i0 87.8 0.995951417004049 82 10 99.6 0 246 1 52 133 DAG06020.1 MAG TPA: hypothetical protein [Myoviridae sp. ctkfK18] diamond 246 167 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Myoviridae sp. ctkfK18
31485222 31485222 PRJNA782551_P_NODE_24216_length_241_cov_2.732143_g24094_i0 PRJNA782551 24216 241 2.732143 6.58446463 Mesyanzhinovviridae 2946162 Viruses Viruses 134 1.57e-34   NR YP_010738725.1 2939131 g24094 i0 75 3.98340248962656 80 20 99.6 0 1 240 561 640 YP_010738725.1 putative primase/polymerase [Xanthomonas phage Mallos] diamond 960 134 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Mesyanzhinovviridae Mallosvirus Mallosvirus mallos
31507532 31507532 PRJNA782551_P_NODE_14656_length_258_cov_1.664865_g14534_i0 PRJNA782551 14656 258 1.664865 4.2953517 Aspergillus flavus vivivirus 1 2871722 Viruses Viruses 85.5 3.98e-17   NR BED98315.1 2871722 g14534 i0 43.5 0.988372093023256 85 48 98.8 0 3 257 518 602 BED98315.1 MAG: hypothetical protein [Aspergillus flavus vivivirus 1] diamond 255 85.5 1 Viruses               Aspergillus flavus vivivirus 1
31602376 31602376 PRJNA782551_P_NODE_15996_length_251_cov_0.865169_g15874_i0 PRJNA782551 15996 251 0.865169 2.17157419 Caudoviricetes sp. 2832643 Viruses Viruses 96.3 2.31e-22   NR DAZ68549.1 2832643 g15874 i0 61.4 0.99203187250996006 83 30 99.2 1 2 250 19 99 DAZ68549.1 MAG TPA: Exonuclease [Caudoviricetes sp.] diamond 249 96.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31697124 31697124 PRJNA782551_P_NODE_9037_length_313_cov_0.962500_g8915_i0 PRJNA782551 9037 313 0.9625 3.012625 Gemycircularvirus sp. 1983771 Viruses Viruses 172 5.77e-51   NR YP_010798589.1 1983771 g8915 i0 74.5 1.95527156549521 102 26 97.8 0 310 5 122 223 YP_010798589.1 capsid protein [Gemycircularvirus sp.] diamond 612 172 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae Gemycircularvirus Gemycircularvirus 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);;