RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Viruses · 10 ✖

tax_phylum 1

tax_kingdom 1

bioproject 1

  • PRJNA993416 · 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
8628872 8628872 PRJNA993416_P_NODE_16227_length_241_cov_0.916667_g16122_i0 PRJNA993416 16227 241 0.916667 2.20916747 Caudoviricetes sp. 2832643 Viruses Viruses 86.7 7.53e-19   NR XOR51512.1 2832643 g16122 i0 56 0.933609958506224 75 31 90.9 1 8 226 46 120 XOR51512.1 MAG: thymidylate kinase [Caudoviricetes sp.] diamond 225 86.7 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
26905815 26905815 PRJNA993416_P_NODE_16281_length_241_cov_0.916667_g16176_i0 PRJNA993416 16281 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 50.4 2.53e-5   NR YP_006988261.1 1211640 g16176 i0 39.5 4.87966804979253 76 43 94.6 1 12 239 33 105 YP_006988261.1 hypothetical protein CcrColossus_gp027 [Caulobacter phage CcrColossus] diamond 1176 50.4 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes   Jeanschmidtviridae Colossusvirus Colossusvirus colossus
26963005 26963005 PRJNA993416_P_NODE_5542_length_355_cov_1.911348_g5437_i0 PRJNA993416 5542 355 1.911348 6.7852854 Caudoviricetes sp. 2832643 Viruses Viruses 43.9 0.00709   NR DAI46203.1 2832643 g5437 i0 32.9 0.591549295774648 70 42 59.2 1 215 6 1 65 DAI46203.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 210 43.9 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28447866 28447866 PRJNA993416_P_NODE_606_length_995_cov_1.658351_g531_i0 PRJNA993416 606 995 1.658351 16.50059245 uncultured marine virus 186617 Viruses Viruses 130 4.75e-34   NR AKH48730.1 186617 g531 i0 61.1 0.57286432160804 95 35 28.6 1 928 644 1 93 AKH48730.1 hypothetical protein [uncultured marine virus] diamond 570 130 1 Viruses               uncultured marine virus
28573905 28573905 PRJNA993416_P_NODE_11547_length_259_cov_1.655914_g11442_i0 PRJNA993416 11547 259 1.655914 4.28881726 Caudoviricetes sp. 2832643 Viruses Viruses 140 3.17e-40   NR DAQ80072.1 2832643 g11442 i0 84.6 0.903474903474903 78 12 90.3 0 255 22 111 188 DAQ80072.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 234 140 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
29521172 29521172 PRJNA993416_P_NODE_12910_length_250_cov_0.870056_g12805_i0 PRJNA993416 12910 250 0.870056 2.17514 Caudoviricetes sp. 2832643 Viruses Viruses 77 1.41e-15   NR DAQ64683.1 2832643 g12805 i0 50 0.912 76 35 91.2 1 23 250 20 92 DAQ64683.1 MAG TPA: hypothetical protein [Caudoviricetes sp.] diamond 228 77 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
30469063 30469063 PRJNA993416_P_NODE_10013_length_274_cov_1.393035_g9908_i0 PRJNA993416 10013 274 1.393035 3.8169159 Sylvanvirus sp. 2487774 Viruses Viruses 82.4 6.1e-16   NR AYV87083.1 2487774 g9908 i0 44.3 0.963503649635037 88 49 96.4 0 265 2 499 586 AYV87083.1 MAG: putative RNA helicase SDE3 [Sylvanvirus sp.] diamond 264 82.4 1 Viruses               Sylvanvirus sp.
32112942 32112942 PRJNA993416_P_NODE_15038_length_244_cov_0.900585_g14933_i0 PRJNA993416 15038 244 0.900585 2.1974274 Pseudomonas phage KP1 2562463 Viruses Viruses 119 5.65e-29   NR YP_010597331.1 2562463 g14933 i0 72.5 2.93852459016393 80 22 98.4 0 3 242 73 152 YP_010597331.1 hypothetical protein PM391_gp33 [Pseudomonas phage KP1] diamond 717 119 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes     Kipunavirus Kipunavirus KP1
32681540 32681540 PRJNA993416_P_NODE_10600_length_268_cov_2.097436_g10495_i0 PRJNA993416 10600 268 2.097436 5.62112848 Caudoviricetes sp. 2832643 Viruses Viruses 80.1 2.93e-15   NR DAL31101.1 2832643 g10495 i0 50 0.985074626865672 88 41 96.3 3 258 1 287 373 DAL31101.1 MAG TPA_asm: DNA encapsidation protein [Caudoviricetes sp.] diamond 264 80.1 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32713258 32713258 PRJNA993416_P_NODE_10080_length_273_cov_1.540000_g9975_i0 PRJNA993416 10080 273 1.54 4.2042 Caudoviricetes sp. 2832643 Viruses Viruses 75.1 1.43e-13   NR XCI66020.1 2832643 g9975 i0 52.6 0.835164835164835 76 36 83.5 0 228 1 42 117 XCI66020.1 MAG: DnaB-like replicative helicase [Caudoviricetes sp.] diamond 228 75.1 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);;