RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA596870" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

  • Viruses · 17 ✖

bioproject 1

  • PRJNA596870 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
12047233 12047233 PRJNA596870_P_NODE_10_length_8268_cov_36.627700_g3_i0 PRJNA596870 10 8268 36.6277 3028.378236 Marnaviridae sp. 2715102 Viruses Viruses 2099 0   NR ULF99949.1 2715102 g3 i0 67.7 0.554426705370102 1528 466 55.3 8 7473 2902 18 1522 ULF99949.1 MAG: hypothetical protein 1 [Marnaviridae sp.] diamond 4584 2099 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
23520937 23520937 PRJNA596870_P_NODE_35959_length_245_cov_0.895349_g35826_i0 PRJNA596870 35959 245 0.895349 2.19360505 Bathycoccus sp. RCC11 2812571 Viruses Viruses 142 2.38e-37   NR YP_004061438.1 880159 g35826 i0 79 12.8938775510204 81 17 99.2 0 2 244 285 365 YP_004061438.1 hypothetical protein BpV1_008c [Bathycoccus sp. RCC1105 virus BpV1] diamond 3159 142 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Algavirales Phycodnaviridae Prasinovirus Bathycoccus sp. RCC1105 virus BpV
26618346 26618346 PRJNA596870_P_NODE_18201_length_311_cov_1.390756_g18068_i0 PRJNA596870 18201 311 1.390756 4.32525116 Ripduovirus 2560215 Viruses Viruses 101 1.1099999999999999e-23   NR YP_009598957.1 1923889 g18068 i0 53.8 2.0064308681672 104 47 99.4 1 310 2 97 200 YP_009598957.1 hypothetical protein FDH28_gp157 [Ralstonia phage RP12] diamond 624 102 0.990196078431373 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
28279762 28279762 PRJNA596870_P_NODE_29446_length_251_cov_0.865169_g29313_i0 PRJNA596870 29446 251 0.865169 2.17157419 Providencia phage PSTNGR1 2783542 Viruses Viruses 130 5.62e-33   NR QPB11232.1 2783542 g29313 i0 75.6 0.9800796812749 82 20 98 0 249 4 32 113 QPB11232.1 DNA-directed RNA polymerase [Providencia phage PSTNGR1] diamond 246 130 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autonotataviridae Jeruvirus Jeruvirus PSTNGR1
28829968 28829968 PRJNA596870_P_NODE_39308_length_242_cov_0.911243_g39175_i0 PRJNA596870 39308 242 0.911243 2.20520806 Ripduovirus 2560215 Viruses Viruses 85.5 3.19e-17   NR YP_009598718.1 1923889 g39175 i0 50 1.97107438016529 80 39 99.2 1 241 2 475 553 YP_009598718.1 virion structural protein [Ralstonia phage RP12] diamond 477 85.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
29037983 29037983 PRJNA596870_P_NODE_29908_length_251_cov_0.865169_g29775_i0 PRJNA596870 29908 251 0.865169 2.17157419 Ralstonia phage RP12 1923889 Viruses Viruses 133 3.7499999999999998e-34   NR YP_009598967.1 1923889 g29775 i0 73.8 1.93625498007968 80 21 95.6 0 3 242 592 671 YP_009598967.1 RNA polymerase beta subunit [Ralstonia phage RP12] diamond 486 133 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
29195738 29195738 PRJNA596870_P_NODE_34889_length_246_cov_0.890173_g34756_i0 PRJNA596870 34889 246 0.890173 2.18982558 Providencia phage PSTNGR1 2783542 Viruses Viruses 158 7.26e-43   NR QPB11269.1 2783542 g34756 i0 86.4 0.98780487804878 81 11 98.8 0 2 244 590 670 QPB11269.1 DNA-directed DNA polymerase [Providencia phage PSTNGR1] diamond 243 158 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autonotataviridae Jeruvirus Jeruvirus PSTNGR1
30048024 30048024 PRJNA596870_P_NODE_14511_length_342_cov_1.144981_g14378_i0 PRJNA596870 14511 342 1.144981 3.91583502 Providencia phage PSTNGR1 2783542 Viruses Viruses 187 3.67e-53   NR QPB11243.1 2783542 g14378 i0 80.7 1 114 22 100 0 342 1 45 158 QPB11243.1 hypothetical protein [Providencia phage PSTNGR1] diamond 342 187 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Autographivirales Autonotataviridae Jeruvirus Jeruvirus PSTNGR1
30711706 30711706 PRJNA596870_P_NODE_9714_length_404_cov_2.075529_g9581_i0 PRJNA596870 9714 404 2.075529 8.38513716 Erwinia phage FBB1 2776772 Viruses Viruses 60.8 8.42e-9   NR QOI66622.1 2776772 g9581 i0 33.3 0.913366336633663 123 60 89.9 5 1 363 2 104 QOI66622.1 hypothetical protein [Erwinia phage FBB1] diamond 369 60.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes Pantevenvirales Straboviridae Roskildevirus Erwinia phage FBB1
30901379 30901379 PRJNA596870_P_NODE_21634_length_288_cov_1.739535_g21501_i0 PRJNA596870 21634 288 1.739535 5.0098608 Klosneuvirus KNV1 1977640 Viruses Viruses 53.9 7.24e-6   NR ARF12033.1 1977640 g21501 i0 30.2 1.3125 126 57 99 3 286 2 321 446 ARF12033.1 AAA family ATPase [Klosneuvirus KNV1] diamond 378 53.9 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Klosneuvirus Klosneuvirus KNV1
31312097 31312097 PRJNA596870_P_NODE_36735_length_244_cov_0.900585_g36602_i0 PRJNA596870 36735 244 0.900585 2.1974274 Ralstonia phage RP31 1923890 Viruses Viruses 71.6 2.5e-12   NR BAW19303.1 1923890 g36602 i0 45.6 0.971311475409836 79 43 97.1 0 239 3 146 224 BAW19303.1 hypothetical protein [Ralstonia phage RP31] diamond 237 71.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Chimalliviridae Ripduovirus Ripduovirus RP12
31659893 31659893 PRJNA596870_P_NODE_30177_length_250_cov_0.870056_g30044_i0 PRJNA596870 30177 250 0.870056 2.17514 Ralstonia phage FLC4-3B 3157663 Viruses Viruses 100 1.48e-22   NR BFM93871.1 3157663 g30044 i0 56.8 0.888 74 32 88.8 0 225 4 17 90 BFM93871.1 hypothetical protein [Ralstonia phage FLC4-3B] diamond 222 100 1 Viruses               Ralstonia phage FLC4-3B
31659900 31659900 PRJNA596870_P_NODE_9877_length_402_cov_1.142857_g9744_i0 PRJNA596870 9877 402 1.142857 4.59428514 Pseudomonas phage phi-2 1450169 Viruses Viruses 128 6.31e-33   NR YP_003345487.1 693582 g9744 i0 58 0.835820895522388 112 43 80.6 2 77 400 8 119 YP_003345487.1 DNA polymerase exonuclease subunit [Pseudomonas phage phi-2] diamond 336 128 1 Viruses Duplodnaviria Heunggongvirae Uroviricota Caudoviricetes   Autographiviridae Tunggulvirus Tunggulvirus f2
31849786 31849786 PRJNA596870_P_NODE_14097_length_346_cov_1.128205_g13964_i0 PRJNA596870 14097 346 1.128205 3.9035893 Pithovirus LCPAC2 2506592 Viruses Viruses 57 3.32e-7   NR QBK91324.1 2506592 g13964 i0 31.7 1.76011560693642 120 71 94.5 3 17 343 46 165 QBK91324.1 MAG: Ras family GTPase [Pithovirus LCPAC202] diamond 609 57 1 Viruses Pithoviruses             Pithovirus LCPAC202
32197936 32197936 PRJNA596870_P_NODE_29458_length_251_cov_0.865169_g29325_i0 PRJNA596870 29458 251 0.865169 2.17157419 Paper mulberry vein-banding virus 2810460 Viruses Viruses 97.4 2.42e-21   NR QRN45547.1 2810460 g29325 i0 66.3 0.956175298804781 80 25 95.6 2 245 6 503 580 QRN45547.1 P3 [Paper mulberry vein-banding virus] diamond 240 97.4 1 Viruses   Pararnavirae Artverviricota Revtraviricetes Ortervirales Caulimoviridae Badnavirus Paper mulberry vein-banding virus
32261460 32261460 PRJNA596870_P_NODE_26718_length_262_cov_2.206349_g26585_i0 PRJNA596870 26718 262 2.206349 5.78063438 Aeromonas phage vB_AsaP_MQM1 3038230 Viruses Viruses 53.1 5.24e-7   NR WFZ78521.1 3038230 g26585 i0 45 0.687022900763359 60 33 68.7 0 30 209 13 72 WFZ78521.1 hypothetical protein MQM1_038 [Aeromonas phage vB_AsaP_MQM1] diamond 180 53.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage vB_AsaP_MQM1
32609056 32609056 PRJNA596870_P_NODE_33020_length_248_cov_0.880000_g32887_i0 PRJNA596870 33020 248 0.88 2.1824 Aeromonas phage vB_AsaP_MQM1 3038230 Viruses Viruses 49.7 1.39e-4   NR WFZ78501.1 3038230 g32887 i0 38.8 0.967741935483871 80 49 96.8 0 2 241 44 123 WFZ78501.1 hypothetical protein MQM1_018 [Aeromonas phage vB_AsaP_MQM1] diamond 240 49.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage vB_AsaP_MQM1

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