RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA993416" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA993416 · 19 ✖

analysis 1

  • diamond · 19 ✖

tax_kingdom 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
16278747 16278747 PRJNA993416_P_NODE_3593_length_446_cov_2.372654_g3488_i0 PRJNA993416 3593 446 2.372654 10.58203684 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 165 4.16e-44   NR CAE7860305.1 2951 g3488 i0 57.9 1.02242152466368 152 53 99.6 5 3 446 751 895 CAE7860305.1 gdhA [Symbiodinium microadriaticum] diamond 456 165 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
25202031 25202031 PRJNA993416_P_NODE_3080_length_487_cov_1.509662_g2975_i0 PRJNA993416 3080 487 1.509662 7.35205394 root 1 Root_unresolved Root_unresolved 169 4.49e-45   NR CAE7860220.1 2951 g2975 i0 50.3 18.9733059548255 161 79 98.6 1 3 482 306 466 CAE7860220.1 unnamed protein product [Symbiodinium microadriaticum] diamond 9240 170 0.994117647058824 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27215911 27215911 PRJNA993416_P_NODE_5742_length_348_cov_1.163636_g5637_i0 PRJNA993416 5742 348 1.163636 4.04945328 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 115 2.9800000000000003e-27   NR CAE7860283.1 2951 g5637 i0 49.6 2.06034482758621 123 53 98.3 3 7 348 203 325 CAE7860283.1 18 [Symbiodinium microadriaticum] diamond 717 115 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27500614 27500614 PRJNA993416_P_NODE_6783_length_319_cov_1.662602_g6678_i0 PRJNA993416 6783 319 1.662602 5.30370038 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 70.1 2.41e-11   NR CAE7860226.1 2951 g6678 i0 56.6 0.498432601880878 53 23 49.8 0 160 318 35 87 CAE7860226.1 dnaE [Symbiodinium microadriaticum] diamond 159 70.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27847639 27847639 PRJNA993416_P_NODE_14064_length_246_cov_3.115607_g13959_i0 PRJNA993416 14064 246 3.115607 7.66439322 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 137 1.4599999999999998e-35   NR CAE7860283.1 2951 g13959 i0 68.8 0.975609756097561 80 25 97.6 0 245 6 1004 1083 CAE7860283.1 18 [Symbiodinium microadriaticum] diamond 240 137 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28295597 28295597 PRJNA993416_P_NODE_5546_length_355_cov_1.613475_g5441_i0 PRJNA993416 5546 355 1.613475 5.72783625 root 1 Root_unresolved Root_unresolved 85.9 1.02e-16   NR CAE7860218.1 2951 g5441 i0 40.7 1.74929577464789 113 57 94.6 3 14 349 66 169 CAE7860218.1 dnaJ [Symbiodinium microadriaticum] diamond 621 85.9 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28510848 28510848 PRJNA993416_P_NODE_847_length_870_cov_1.836888_g764_i0 PRJNA993416 847 870 1.836888 15.9809256 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 222 2.44e-64   NR CAE7860308.1 2951 g764 i0 48.4 2.38620689655172 221 103 74.8 2 2 652 130 343 CAE7860308.1 dda [Symbiodinium microadriaticum] diamond 2076 222 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28889665 28889665 PRJNA993416_P_NODE_8268_length_289_cov_1.162037_g8163_i0 PRJNA993416 8268 289 1.162037 3.35828693 Symbiodinium sp. KB8 230985 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00152   NR CAE7942065.1 230985 g8163 i0 44.9 0.84083044982699 49 27 50.9 0 242 96 33 81 CAE7942065.1 unnamed protein product, partial [Symbiodinium sp. KB8] diamond 243 45.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. KB8
29363428 29363428 PRJNA993416_P_NODE_16309_length_241_cov_0.916667_g16204_i0 PRJNA993416 16309 241 0.916667 2.20916747 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 52 2.04e-5   NR CAG9310885.1 1481888 g16204 i0 47 3.41078838174274 66 29 82.2 2 35 232 581 640 CAG9310885.1 unnamed protein product [Blepharisma stoltei] diamond 822 52 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29426284 29426284 PRJNA993416_P_NODE_1309_length_733_cov_2.803030_g1213_i0 PRJNA993416 1309 733 2.80303 20.5462099 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 167 8.699999999999998e-44   NR CAE7860201.1 2951 g1213 i0 42.5 2.41473396998636 193 99 74.5 2 549 4 402 593 CAE7860201.1 unnamed protein product [Symbiodinium microadriaticum] diamond 1770 167 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30348867 30348867 PRJNA993416_P_NODE_16572_length_230_cov_2.433121_g16467_i0 PRJNA993416 16572 230 2.433121 5.5961783 root 1 Root_unresolved Root_unresolved 87.4 5.95e-18   NR CAE7860319.1 2951 g16467 i0 57.9 2.02173913043478 76 29 96.5 2 228 7 1153 1227 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 465 87.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30595065 30595065 PRJNA993416_P_NODE_15873_length_242_cov_0.911243_g15768_i0 PRJNA993416 15873 242 0.911243 2.20520806 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00573   NR SPQ94142.1 37360 g15768 i0 48.8 0.892561983471074 41 21 50.8 0 1 123 764 804 SPQ94142.1 unnamed protein product [Plasmodiophora brassicae] diamond 216 45.1 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30626634 30626634 PRJNA993416_P_NODE_11673_length_258_cov_1.421622_g11568_i0 PRJNA993416 11673 258 1.421622 3.66778476 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.97e-6   NR CAE7860203.1 2951 g11568 i0 40.6 0.802325581395349 69 41 80.2 0 217 11 145 213 CAE7860203.1 unnamed protein product [Symbiodinium microadriaticum] diamond 207 55.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30974475 30974475 PRJNA993416_P_NODE_4534_length_394_cov_0.959502_g4429_i0 PRJNA993416 4534 394 0.959502 3.78043788 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 89 1.48e-17   NR CAE7860319.1 2951 g4429 i0 43.6 1.06598984771574 140 70 99.7 3 1 393 1841 1980 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 420 89 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
31385440 31385440 PRJNA993416_P_NODE_11216_length_263_cov_0.900000_g11111_i0 PRJNA993416 11216 263 0.9 2.367 Eimeria brunetti 51314 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0366   NR CDJ46073.1 51314 g11111 i0 38.5 0.593155893536122 52 31 59.3 1 158 3 5885 5935 CDJ46073.1 HECT-domain (ubiquitin-transferase) containing protein, putative [Eimeria brunetti] diamond 156 43.1 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria brunetti
31606710 31606710 PRJNA993416_P_NODE_13116_length_249_cov_0.875000_g13011_i0 PRJNA993416 13116 249 0.875 2.17875 Cafeteria roenbergensis 33653 SAR_Eukaryotes SAR_Eukaryotes 65.5 4.01e-10   NR KAA0173957.1 33653 g13011 i0 51.4 2.74698795180723 74 35 89.2 1 227 6 1816 1888 KAA0173957.1 hypothetical protein FNF27_04518 [Cafeteria roenbergensis] diamond 684 65.5 1 Eukaryota Sar     Bigyra Bicosoecida Cafeteriaceae Cafeteria Cafeteria roenbergensis
31891352 31891352 PRJNA993416_P_NODE_1577_length_678_cov_1.940496_g1479_i0 PRJNA993416 1577 678 1.940496 13.15656288 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 201 4.100000000000001e-59   NR CAE7860281.1 2951 g1479 i0 52.5 1.61946902654867 183 84 80.5 2 611 66 187 367 CAE7860281.1 unnamed protein product [Symbiodinium microadriaticum] diamond 1098 201 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32334642 32334642 PRJNA993416_P_NODE_11339_length_261_cov_1.856383_g11234_i0 PRJNA993416 11339 261 1.856383 4.84515963 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 80.1 3.48e-15   NR CAE7860228.1 2951 g11234 i0 44.2 0.988505747126437 86 46 97.7 2 261 7 1072 1156 CAE7860228.1 prkA [Symbiodinium microadriaticum] diamond 258 80.1 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32397770 32397770 PRJNA993416_P_NODE_16579_length_230_cov_2.082803_g16474_i0 PRJNA993416 16579 230 2.082803 4.7904469 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 89 1.68e-18   NR CAE7860275.1 2951 g16474 i0 61.9 0.821739130434783 63 24 82.2 0 37 225 2 64 CAE7860275.1 rpt-4 [Symbiodinium microadriaticum] diamond 189 89 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum

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