RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA758770" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Viruses · 10 ✖

bioproject 1

  • PRJNA758770 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
27053178 27053178 PRJNA758770_S_NODE_28562_length_247_cov_0.896552_g28436_i0 PRJNA758770 28562 247 0.896552 2.21448344 Caudoviricetes sp. 2832643 Viruses Viruses 52 2.06e-5   NR DAO73127.1 2832643 g28436 i0 46 0.765182186234818 63 27 72.9 2 242 63 150 208 DAO73127.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 189 52 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27306112 27306112 PRJNA758770_S_NODE_9923_length_353_cov_1.671429_g9797_i0 PRJNA758770 9923 353 1.671429 5.90014437 Currant latent virus 1476584 Viruses Viruses 232 1.6599999999999999e-68   NR WMN13751.1 1476584 g9797 i0 88 0.994334277620397 117 14 99.4 0 3 353 730 846 WMN13751.1 polyprotein [Currant latent virus] diamond 351 232 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
28663786 28663786 PRJNA758770_S_NODE_18427_length_281_cov_0.966346_g18301_i0 PRJNA758770 18427 281 0.966346 2.71543226 Currant latent virus 1476584 Viruses Viruses 164 1.14e-44   NR WMN13751.1 1476584 g18301 i0 84.9 0.99288256227758 93 14 99.3 0 280 2 612 704 WMN13751.1 polyprotein [Currant latent virus] diamond 279 164 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
28663794 28663794 PRJNA758770_S_NODE_32087_length_243_cov_0.900000_g31961_i0 PRJNA758770 32087 243 0.9 2.187 Currant latent virus 1476584 Viruses Viruses 138 7.58e-36   NR WMN13750.1 1476584 g31961 i0 83.3 0.962962962962963 78 13 96.3 0 9 242 402 479 WMN13750.1 polyprotein [Currant latent virus] diamond 234 138 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
28695477 28695477 PRJNA758770_S_NODE_4607_length_487_cov_2.195652_g4482_i0 PRJNA758770 4607 487 2.195652 10.69282524 Currant latent virus 1476584 Viruses Viruses 278 5.960000000000001e-85   NR WMN13751.1 1476584 g4482 i0 88.6 1.02258726899384 166 15 99.8 1 486 1 344 509 WMN13751.1 polyprotein [Currant latent virus] diamond 498 278 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis
28726873 28726873 PRJNA758770_S_NODE_27387_length_248_cov_0.891429_g27261_i0 PRJNA758770 27387 248 0.891429 2.21074392 Thermus phage MN1 3018631 Viruses Viruses 107 3.2499999999999998e-28   NR BDX35512.1 3018631 g27261 i0 78.3 0.834677419354839 69 15 83.5 0 2 208 28 96 BDX35512.1 hypothetical protein MN1_450 [Thermus phage MN1] diamond 207 107 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Thermus phage MN1
29137592 29137592 PRJNA758770_S_NODE_26389_length_249_cov_1.465909_g26263_i0 PRJNA758770 26389 249 1.465909 3.65011341 Tomato fruit blotch virus 2762435 Viruses Viruses 57.4 2.78e-7   NR QZN83593.1 2762435 g26263 i0 36.6 0.987951807228916 82 50 97.6 2 244 2 153 233 QZN83593.1 putative helicase-RdRP protein [Tomato fruit blotch virus] diamond 246 57.4 1 Viruses   Orthornavirae Kitrinoviricota Alsuviricetes Martellivirales Kitaviridae Blunervirus Blunervirus solani
31822954 31822954 PRJNA758770_S_NODE_30957_length_244_cov_0.912281_g30831_i0 PRJNA758770 30957 244 0.912281 2.22596564 Caudoviricetes sp. 2832643 Viruses Viruses 103 3.77e-25   NR DAL65659.1 2832643 g30831 i0 60 1.93032786885246 75 28 89.8 2 16 234 136 210 DAL65659.1 MAG TPA_asm: DNA helix destabilizing protein [Caudoviricetes sp.] diamond 471 103 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32298094 32298094 PRJNA758770_S_NODE_32899_length_242_cov_0.893491_g32773_i0 PRJNA758770 32899 242 0.893491 2.16224822 Caudoviricetes sp. 2832643 Viruses Viruses 66.6 1.14e-11   NR XOR68879.1 2832643 g32773 i0 60 1.51239669421488 45 18 55.8 0 135 1 1 45 XOR68879.1 MAG: hypothetical protein [Caudoviricetes sp.] diamond 366 66.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32582575 32582575 PRJNA758770_S_NODE_5699_length_444_cov_1.690027_g5573_i0 PRJNA758770 5699 444 1.690027 7.50371988 Currant latent virus 1476584 Viruses Viruses 296 1.0200000000000001e-91   NR WMN13751.1 1476584 g5573 i0 95.9 0.986486486486487 146 6 98.6 0 440 3 829 974 WMN13751.1 polyprotein [Currant latent virus] diamond 438 296 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Secoviridae Cheravirus Cheravirus ribis

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