RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond" and bioproject = "PRJNA348537"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 3

tax_clade 1

bioproject 1

  • PRJNA348537 · 24 ✖

analysis 1

  • diamond · 24 ✖
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
27611966 27611966 PRJNA348537_S_NODE_2384_length_196_cov_4.335404_g2338_i0 PRJNA348537 2384 196 4.335404 8.49739184 Caudoviricetes sp. 2832643 Viruses Viruses 98.6 4.38e-22   NR DAM41230.1 2832643 g2338 i0 79 0.948979591836735 62 13 94.9 0 187 2 78 139 DAM41230.1 MAG TPA: DNA polymerase B, partial [Caudoviricetes sp.] diamond 186 98.6 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
27832814 27832814 PRJNA348537_S_NODE_2244_length_201_cov_1.777108_g2198_i0 PRJNA348537 2244 201 1.777108 3.57198708 Qianjiang marna-like virus 92 3347743 Viruses Viruses 48.9 1.5e-4   NR XHA88211.1 3347743 g2198 i0 37.5 0.835820895522388 56 35 83.6 0 28 195 2287 2342 XHA88211.1 MAG: polyprotein [Qianjiang marna-like virus 92] diamond 168 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Qianjiang marna-like virus 92
28116929 28116929 PRJNA348537_S_NODE_505_length_384_cov_3.816619_g459_i0 PRJNA348537 505 384 3.816619 14.65581696 Caudoviricetes sp. 2832643 Viruses Viruses 127 9.29e-34   NR DAM41232.1 2832643 g459 i0 55.2 0.9765625 125 56 97.7 0 378 4 62 186 DAM41232.1 MAG TPA: head to tail adaptor [Caudoviricetes sp.] diamond 375 127 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
28274799 28274799 PRJNA348537_S_NODE_3226_length_173_cov_3.275362_g3180_i0 PRJNA348537 3226 173 3.275362 5.66637626 Picornaviridae sp. 1530251 Viruses Viruses 48.9 9.7e-5   NR URG14992.1 1530251 g3180 i0 47.4 0.988439306358382 57 29 97.1 1 172 5 86 142 URG14992.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 171 48.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28306489 28306489 PRJNA348537_S_NODE_2126_length_205_cov_1.141176_g2080_i0 PRJNA348537 2126 205 1.141176 2.3394108 Changjiang picorna-like virus 2 1922791 Viruses Viruses 73.6 3.18e-13   NR YP_009336608.1 1922791 g2080 i0 50.8 0.951219512195122 65 32 95.1 0 10 204 944 1008 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 195 73.6 1 Viruses               Changjiang picorna-like virus 2
28432842 28432842 PRJNA348537_S_NODE_1666_length_227_cov_3.213542_g1620_i0 PRJNA348537 1666 227 3.213542 7.29474034 Vibrio mimicus 674 Bacteria Bacteria 42.7 0.0294   NR WP_070383176.1 674 g1620 i0 35.4 0.859030837004405 65 35 81.9 2 8 193 7 67 WP_070383176.1 OmpA family protein [Vibrio mimicus] diamond 195 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio mimicus
28874769 28874769 PRJNA348537_S_NODE_848_length_308_cov_2.677656_g802_i0 PRJNA348537 848 308 2.677656 8.24718048 Picornaviridae sp. 1530251 Viruses Viruses 43.9 0.0316   NR URG14784.1 1530251 g802 i0 30.1 0.905844155844156 93 64 89.6 1 20 295 737 829 URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 279 43.9 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae sp.
28938058 28938058 PRJNA348537_S_NODE_4528_length_152_cov_2.410256_g4482_i0 PRJNA348537 4528 152 2.410256 3.66358912 Hyla sarda 327740 Chordata Chordata 60.1 6.41e-9   NR XP_056389893.1 327740 g4482 i0 71.1 4.77631578947368 38 10 73 1 39 149 164 201 XP_056389893.1 ORM1-like protein 1 isoform X1 [Hyla sarda] diamond 726 60.1 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Hylidae Hyla Hyla sarda
29159158 29159158 PRJNA348537_S_NODE_4589_length_151_cov_8.060345_g4543_i0 PRJNA348537 4589 151 8.060345 12.17112095 Byssothecium circinans 147558 Fungi Fungi 45.4 1.16e-4   NR KAF1948084.1 147558 g4543 i0 59.5 1.49006622516556 37 15 73.5 0 117 7 9 45 KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans] diamond 225 45.4 1 Eukaryota Opisthokonta Fungi Ascomycota Dothideomycetes Pleosporales Massarinaceae Byssothecium Byssothecium circinans
29253460 29253460 PRJNA348537_S_NODE_569_length_364_cov_5.231003_g523_i0 PRJNA348537 569 364 5.231003 19.04085092 Erpetoichthys calabaricus 27687 Chordata Chordata 139 2.9199999999999996e-37   NR XP_051791274.1 27687 g523 i0 78.3 5.30769230769231 92 19 75 1 20 292 115 206 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 1932 139 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
30011726 30011726 PRJNA348537_S_NODE_1031_length_284_cov_196.706827_g985_i0 PRJNA348537 1031 284 196.706827 558.64738868 Porphyrobacter sp. GA68 2883480 Bacteria Bacteria 92.4 1.7e-19   NR WP_228244238.1 2883480 g985 i0 98 0.517605633802817 49 1 51.8 0 283 137 9 57 WP_228244238.1 alpha/beta fold hydrolase [Porphyrobacter sp. GA68] diamond 147 92.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Porphyrobacter Porphyrobacter sp. GA68
30359615 30359615 PRJNA348537_S_NODE_592_length_357_cov_13.633540_g546_i0 PRJNA348537 592 357 13.63354 48.6717378 Salmonella enterica 28901 Bacteria Bacteria 41.6 0.0493   NR WP_231233012.1 28901 g546 i0 35.4 0.831932773109244 99 24 79 6 310 29 17 80 WP_231233012.1 hypothetical protein, partial [Salmonella enterica] diamond 297 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Salmonella Salmonella enterica
30485550 30485550 PRJNA348537_S_NODE_3093_length_176_cov_2.709220_g3047_i0 PRJNA348537 3093 176 2.70922 4.7682272 Marnaviridae sp. 2715102 Viruses Viruses 86.7 5.12e-18   NR ULG00022.1 2715102 g3047 i0 74.1 3.95454545454545 58 15 98.9 0 175 2 1394 1451 ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.] diamond 696 86.7 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
30881772 30881772 PRJNA348537_S_NODE_1414_length_245_cov_1.228571_g1368_i0 PRJNA348537 1414 245 1.228571 3.00999895 Bacillota 1239 Bacteria Bacteria 44.7 0.00293   NR EEI82387.1 525255 g1368 i0 52.3 2.15510204081633 44 19 53.9 1 39 170 88 129 EEI82387.1 hypothetical protein HMPREF0077_1527 [Anaerococcus tetradius ATCC 35098] diamond 528 44.7 1 Bacteria   Bacillati Bacillota Tissierellia Tissierellales Peptoniphilaceae Anaerococcus Anaerococcus tetradius
31117146 31117146 PRJNA348537_S_NODE_3815_length_162_cov_1.708661_g3769_i0 PRJNA348537 3815 162 1.708661 2.76803082 Marnaviridae sp. 2715102 Viruses Viruses 64.3 2.98e-10   NR ULG00022.1 2715102 g3769 i0 50.9 1.01851851851852 55 25 98.1 1 2 160 448 502 ULG00022.1 MAG: putative polyprotein [Marnaviridae sp.] diamond 165 64.3 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31180268 31180268 PRJNA348537_S_NODE_1455_length_241_cov_8.485437_g1409_i0 PRJNA348537 1455 241 8.485437 20.44990317 Ilumatobacter sp. 1967498 Bacteria Bacteria 43.5 0.0183   NR NKB41104.1 1967498 g1409 i0 43.5 0.572614107883817 46 26 57.3 0 38 175 26 71 NKB41104.1 hypothetical protein [Ilumatobacter sp.] diamond 138 43.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
31844683 31844683 PRJNA348537_S_NODE_2337_length_198_cov_1.368098_g2291_i0 PRJNA348537 2337 198 1.368098 2.70883404 Marnaviridae sp. 2715102 Viruses Viruses 42.4 0.0283   NR ULG00016.1 2715102 g2291 i0 37.7 0.924242424242424 61 33 84.8 1 29 196 152 212 ULG00016.1 MAG: hypothetical protein 2 [Marnaviridae sp.] diamond 183 42.4 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Marnaviridae   Marnaviridae sp.
31844684 31844684 PRJNA348537_S_NODE_617_length_350_cov_152.374603_g571_i0 PRJNA348537 617 350 152.374603 533.3111105 Porphyrobacter sp. GA68 2883480 Bacteria Bacteria 95.5 3.07e-20   NR WP_228244238.1 2883480 g571 i0 98 0.437142857142857 51 1 43.7 0 2 154 9 59 WP_228244238.1 alpha/beta fold hydrolase [Porphyrobacter sp. GA68] diamond 153 95.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Porphyrobacter Porphyrobacter sp. GA68
31971309 31971309 PRJNA348537_S_NODE_2478_length_193_cov_1.772152_g2432_i0 PRJNA348537 2478 193 1.772152 3.42025336 Changjiang picorna-like virus 2 1922791 Viruses Viruses 92.4 6.21e-20   NR YP_009336608.1 1922791 g2432 i0 67.7 1.01036269430052 65 18 97.9 2 2 190 49 112 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 195 92.4 1 Viruses               Changjiang picorna-like virus 2
32161391 32161391 PRJNA348537_S_NODE_1238_length_261_cov_5.977876_g1192_i0 PRJNA348537 1238 261 5.977876 15.60225636 Caudoviricetes sp. 2832643 Viruses Viruses 156 3.63e-44   NR DAM41229.1 2832643 g1192 i0 83.9 1 87 14 100 0 1 261 63 149 DAM41229.1 MAG TPA: DNA encapsidation protein, partial [Caudoviricetes sp.] diamond 261 156 1 Viruses   Heunggongvirae Uroviricota Caudoviricetes       Caudoviricetes sp.
32256489 32256489 PRJNA348537_S_NODE_1598_length_231_cov_282.714286_g1552_i0 PRJNA348537 1598 231 282.714286 653.07000066 Ixodes persulcatus 34615 Arthropoda Arthropoda 40 0.0496   NR CAL6244649.1 34615 g1552 i0 57.9 0.493506493506494 38 14 49.4 1 117 230 4 39 CAL6244649.1 unnamed protein product [Ixodes persulcatus] diamond 114 40 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Ixodida Ixodidae Ixodes Ixodes persulcatus
32526789 32526789 PRJNA348537_S_NODE_1459_length_241_cov_2.708738_g1413_i0 PRJNA348537 1459 241 2.708738 6.52805858 Viruses 10239 Viruses Viruses 118 1.08e-28   NR YP_009336608.1 1922791 g1413 i0 71.4 2.87551867219917 77 22 95.9 0 231 1 197 273 YP_009336608.1 hypothetical protein [Changjiang picorna-like virus 2] diamond 693 118 1 Viruses               Changjiang picorna-like virus 2
32572734 32572734 PRJNA348537_S_NODE_4379_length_154_cov_2.285714_g4333_i0 PRJNA348537 4379 154 2.285714 3.51999956 Pimephales minnow adintovirus 2609864 Viruses Viruses 60.1 4.57e-9   NR DAC81394.1 2609864 g4333 i0 68.4 0.74025974025974 38 12 74 0 114 1 7 44 DAC81394.1 TPA_asm: FtsK [Pimephales minnow adintovirus] diamond 114 60.1 1 Viruses   Bamfordvirae Preplasmiviricota Polintoviricetes Orthopolintovirales Adintoviridae   Pimephales minnow adintovirus
32761388 32761388 PRJNA348537_S_NODE_1720_length_224_cov_2.153439_g1674_i0 PRJNA348537 1720 224 2.153439 4.82370336 Picornaviridae sp. 1530251 Viruses Viruses 134 2.37e-34   NR URG14784.1 1530251 g1674 i0 82.2 0.977678571428571 73 13 97.8 0 219 1 3 75 URG14784.1 MAG: RNA dependent RNA polymerase, partial [Picornaviridae sp.] diamond 219 134 1 Viruses   Orthornavirae Pisuviricota Pisoniviricetes Picornavirales Picornaviridae   Picornaviridae 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);;