RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 18 ✖

bioproject 1

  • PRJEB39643 · 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
2607417 2607417 PRJEB39643_P_NODE_141303_length_244_cov_1.801170_g141110_i0 PRJEB39643 141303 244 1.80117 4.3948548 Caudoviricetes sp. 2832643 Viruses Viruses 87 1.17e-18   NR DAS07109.1 2832643 g141110 i0 66.7 0.774590163934426 63 21 77.5 0 189 1 1 63 DAS07109.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 189 87 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
3884353 3884353 PRJEB39643_P_NODE_61044_length_280_cov_1.487923_g60851_i0 PRJEB39643 61044 280 1.487923 4.1661844 root 1 Root_unresolved Root_unresolved 188 7.710000000000001e-58   NR DAJ93717.1 38018 g60851 i0 98.9 1.99285714285714 93 1 99.6 0 280 2 172 264 DAJ93717.1 MAG TPA: putative transcriptional regulator, partial [Bacteriophage sp.] diamond 558 188 1 Viruses               Bacteriophage sp.
26780285 26780285 PRJEB39643_P_NODE_122101_length_251_cov_1.730337_g121908_i0 PRJEB39643 122101 251 1.730337 4.34314587 Siphoviridae sp. ctLeG9 2827848 Viruses Viruses 127 4.919999999999999e-32   NR DAF42493.1 2827848 g121908 i0 97.2 0.848605577689243 71 2 84.9 0 37 249 344 414 DAF42493.1 MAG TPA: tail fiber protein [Siphoviridae sp. ctLeG9] diamond 213 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctLeG9
26906832 26906832 PRJEB39643_P_NODE_142682_length_244_cov_0.900585_g142489_i0 PRJEB39643 142682 244 0.900585 2.1974274 Botrytis cinerea ssDNA virus 1 2735960 Viruses Viruses 65.1 4.29e-10   NR WSP06248.1 2735960 g142489 i0 48.3 0.737704918032787 60 30 72.5 1 190 14 103 162 WSP06248.1 coat protein [Botrytis cinerea ssDNA virus 1] diamond 180 65.1 1 Viruses   Shotokuvirae Cressdnaviricota Repensiviricetes Geplafuvirales Genomoviridae   Botrytis cinerea ssDNA virus 1
27001508 27001508 PRJEB39643_P_NODE_138762_length_245_cov_1.790698_g138569_i0 PRJEB39643 138762 245 1.790698 4.3872101 Caudoviricetes sp. 2832643 Viruses Viruses 55.8 1.03e-7   NR DAY24990.1 2832643 g138569 i0 54.9 1.16326530612245 51 23 62.4 0 14 166 53 103 DAY24990.1 MAG TPA: Endodeoxyribonuclease RusA [Caudoviricetes sp.] diamond 285 55.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27665412 27665412 PRJEB39643_P_NODE_131944_length_247_cov_2.655172_g131751_i0 PRJEB39643 131944 247 2.655172 6.55827484 uncultured Caudovirales phage 2100421 Viruses Viruses 58.5 7.21e-8   NR CAB4185846.1 2100421 g131751 i0 35.4 0.959514170040486 79 44 96 2 4 240 95 166 CAB4185846.1 Glycosyltransferase, DXD sugar-binding motif [uncultured Caudovirales phage] diamond 237 58.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Peduoviridae Maltschvirus Maltschvirus maltsch
28170417 28170417 PRJEB39643_P_NODE_117466_length_253_cov_1.711111_g117273_i0 PRJEB39643 117466 253 1.711111 4.32911083 Caudoviricetes sp. 2832643 Viruses Viruses 58.5 1.64e-8   NR DAP08129.1 2832643 g117273 i0 55 0.711462450592885 60 26 70 1 253 77 36 95 DAP08129.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 180 58.5 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28359705 28359705 PRJEB39643_P_NODE_151906_length_237_cov_8.695122_g151713_i0 PRJEB39643 151906 237 8.695122 20.60743914 Caudoviricetes sp. 2832643 Viruses Viruses 41.2 0.0112   NR DAJ33774.1 2832643 g151713 i0 57.6 0.417721518987342 33 13 41.8 1 144 46 2 33 DAJ33774.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 99 41.2 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28517788 28517788 PRJEB39643_P_NODE_113827_length_255_cov_1.692308_g113634_i0 PRJEB39643 113827 255 1.692308 4.3153854 Hyperionvirus sp. 2487770 Viruses Viruses 69.7 1.36e-11   NR AYV84623.1 2487770 g113634 i0 53.6 0.658823529411765 56 26 65.9 0 241 74 153 208 AYV84623.1 MAG: putative helicase/exonuclease [Hyperionvirus sp.] diamond 168 69.7 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae   Hyperionvirus sp.
28738851 28738851 PRJEB39643_P_NODE_96347_length_263_cov_1.621053_g96154_i0 PRJEB39643 96347 263 1.621053 4.26336939 Caudoviricetes sp. 2832643 Viruses Viruses 98.6 1.09e-21   NR DAV36679.1 2832643 g96154 i0 54 0.992395437262357 87 40 99.2 0 263 3 70 156 DAV36679.1 MAG TPA: clamp loader [Caudoviricetes sp.] diamond 261 98.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28801748 28801748 PRJEB39643_P_NODE_72408_length_274_cov_1.532338_g72215_i0 PRJEB39643 72408 274 1.532338 4.19860612 Tupanvirus deep ocean 2126984 Viruses Viruses 68.6 3.25e-11   NR YP_010781083.1 2126984 g72215 i0 41.6 1.94890510948905 89 49 95.3 2 265 5 193 280 YP_010781083.1 hypothetical protein QJ856_gp0282 [Tupanvirus deep ocean] diamond 534 68.6 1 Viruses   Bamfordvirae Nucleocytoviricota Megaviricetes Imitervirales Mimiviridae Tupanvirus Tupanvirus altamarinense
29653998 29653998 PRJEB39643_P_NODE_129970_length_248_cov_1.760000_g129777_i0 PRJEB39643 129970 248 1.76 4.3648 Caudoviricetes sp. 2832643 Viruses Viruses 145 4.69e-41   NR DAT47767.1 2832643 g129777 i0 87.8 0.991935483870968 82 10 99.2 0 2 247 33 114 DAT47767.1 MAG TPA: cAMP-binding protein, partial [Caudoviricetes sp.] diamond 246 145 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30127938 30127938 PRJEB39643_P_NODE_80052_length_271_cov_1.555556_g79859_i0 PRJEB39643 80052 271 1.555556 4.21555676 Caudoviricetes sp. 2832643 Viruses Viruses 173 1.02e-51   NR DAV25954.1 2832643 g79859 i0 93.3 0.996309963099631 90 6 99.6 0 270 1 59 148 DAV25954.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 270 173 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30570298 30570298 PRJEB39643_P_NODE_96813_length_263_cov_1.621053_g96620_i0 PRJEB39643 96813 263 1.621053 4.26336939 Caudoviricetes sp. 2832643 Viruses Viruses 59.3 4.63e-9   NR DAS72892.1 2832643 g96620 i0 65.9 0.501901140684411 44 12 50.2 1 69 200 47 87 DAS72892.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 132 59.3 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30595352 30595352 PRJEB39643_P_NODE_60353_length_281_cov_1.480769_g60160_i0 PRJEB39643 60353 281 1.480769 4.16096089 Viruses 10239 Viruses Viruses 60.8 7.45e-10   NR DAD69782.1 2827584 g60160 i0 59.3 1.81494661921708 59 21 59.8 2 51 218 22 80 DAD69782.1 MAG TPA: hypothetical protein, partial [Siphoviridae sp. ctfYP22] diamond 510 60.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Siphoviridae sp. ctfYP22
31044796 31044796 PRJEB39643_P_NODE_157535_length_226_cov_2.013072_g157341_i0 PRJEB39643 157535 226 2.013072 4.54954272 Caudoviricetes sp. 2832643 Viruses Viruses 132 5.63e-35   NR DAY12257.1 2832643 g157341 i0 79.2 5.11061946902655 77 13 98.2 1 224 3 44 120 DAY12257.1 MAG TPA: Lysin [Caudoviricetes sp.] diamond 1155 132 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31076169 31076169 PRJEB39643_P_NODE_155475_length_227_cov_2.532468_g155282_i0 PRJEB39643 155475 227 2.532468 5.74870236 Caudoviricetes sp. 2832643 Viruses Viruses 69.7 9.6e-12   NR DAV25941.1 2832643 g155282 i0 56 0.991189427312775 75 32 99.1 1 225 1 897 970 DAV25941.1 MAG TPA: DNA packaging protein [Caudoviricetes sp.] diamond 225 69.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
31834881 31834881 PRJEB39643_P_NODE_81097_length_270_cov_1.563452_g80904_i0 PRJEB39643 81097 270 1.563452 4.2213204 Herelleviridae sp. 2831613 Viruses Viruses 123 8.3e-33   NR DAG98655.1 2831613 g80904 i0 73.3 0.955555555555556 86 23 95.6 0 5 262 101 186 DAG98655.1 MAG TPA: hypothetical protein [Herelleviridae sp.] diamond 258 123 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Herelleviridae   Herelleviridae 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);;