RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax_superkingdom = "Viruses"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 9 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA352850 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
22747682 22747682 PRJNA352850_P_NODE_10978_length_1010_cov_8.680541_g8614_i0 PRJNA352850 10978 1010 8.680541 87.6734641 Aeromonas phage phiA 2885153 Viruses Viruses 369 4.03e-123   NR UIS74291.1 2885153 g8614 i0 83.3 0.944554455445545 318 50 94.5 2 954 1 1 315 UIS74291.1 hypothetical protein pA_gene0076 [Aeromonas phage phiA008] diamond 954 369 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
28559321 28559321 PRJNA352850_P_NODE_80507_length_249_cov_0.965000_g77674_i0 PRJNA352850 80507 249 0.965 2.40285 Aeromonas phage phiA 2885153 Viruses Viruses 79.7 3.75e-17   NR UIS74270.1 2885153 g77674 i0 71.1 0.542168674698795 45 13 54.2 0 207 73 3 47 UIS74270.1 hypothetical protein pA_gene0055 [Aeromonas phage phiA008] diamond 135 79.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
28717081 28717081 PRJNA352850_P_NODE_35827_length_432_cov_1.355091_g32996_i0 PRJNA352850 35827 432 1.355091 5.85399312 Aeromonas phage phiA 2885153 Viruses Viruses 77.8 2.97e-15   NR UIS74280.1 2885153 g32996 i0 60 0.381944444444444 55 22 38.2 0 65 229 1 55 UIS74280.1 hypothetical protein pA_gene0065 [Aeromonas phage phiA008] diamond 165 77.8 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
29411547 29411547 PRJNA352850_P_NODE_79249_length_251_cov_1.009901_g76416_i0 PRJNA352850 79249 251 1.009901 2.53485151 Ralstonia phage FLC1-1B 3157661 Viruses Viruses 65.9 2.71e-10   NR BFM93580.1 3157661 g76416 i0 58 1.8406374501992 50 21 59.8 0 250 101 145 194 BFM93580.1 putative nuclease SbcCD D subunit [Ralstonia phage FLC1-1B] diamond 462 65.9 1 Viruses               Ralstonia phage FLC1-1B
29870839 29870839 PRJNA352850_P_NODE_65051_length_283_cov_1.619658_g62218_i0 PRJNA352850 65051 283 1.619658 4.58363214 Tupanvirus 2094720 Viruses Viruses 86.3 3.03e-17   NR CAH6420158.1 340016 g62218 i0 48.9 1.97173144876325 94 40 96.5 3 1 273 539 627 CAH6420158.1 Major core protein 4b [uncultured virus] diamond 558 86.3 1 Viruses               uncultured virus
30011792 30011792 PRJNA352850_P_NODE_71591_length_265_cov_1.824074_g68758_i0 PRJNA352850 71591 265 1.824074 4.8337961 Aeromonas phage phiA 2885153 Viruses Viruses 105 1.6500000000000002e-26   NR UIS74284.1 2885153 g68758 i0 77.5 0.80377358490566 71 16 80.4 0 2 214 51 121 UIS74284.1 hypothetical protein pA_gene0069 [Aeromonas phage phiA008] diamond 213 105 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Aeromonas phage phiA008
30137636 30137636 PRJNA352850_P_NODE_53792_length_324_cov_1.890909_g50959_i0 PRJNA352850 53792 324 1.890909 6.12654516 Caudoviricetes sp. 2832643 Viruses Viruses 77.4 5.69e-16   NR XOS04752.1 2832643 g50959 i0 61.3 0.574074074074074 62 21 54.6 1 135 311 5 66 XOS04752.1 MAG: hypothetical protein MSP1126_6 [Caudoviricetes sp.] diamond 186 77.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30833090 30833090 PRJNA352850_P_NODE_15374_length_788_cov_8.215156_g12747_i0 PRJNA352850 15374 788 8.215156 64.73542928 aphis 2 virus 3041036 Viruses Viruses 92 6.54e-17   NR DBA44221.1 3041036 g12747 i0 29.3 0.818527918781726 215 144 81.9 4 663 19 798 1004 DBA44221.1 TPA_asm: replicase protein [aphis 2 virus] diamond 645 92 1 Viruses               aphis 2 virus
31211801 31211801 PRJNA352850_P_NODE_31975_length_467_cov_2.349282_g29145_i0 PRJNA352850 31975 467 2.349282 10.97114694 Caudoviricetes sp. 2832643 Viruses Viruses 222 1.1e-68   NR XOS04751.1 2832643 g29145 i0 69 0.995717344753747 155 48 99.6 0 3 467 29 183 XOS04751.1 MAG: Int [Caudoviricetes sp.] diamond 465 222 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);;