RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA415636" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 4

tax_superkingdom 1

tax_clade 1

  • Sar · 13 ✖

bioproject 1

  • PRJNA415636 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
2358741 2358741 PRJNA415636_S_NODE_2882_length_282_cov_1.519149_g2835_i0 PRJNA415636 2882 282 1.519149 4.28400018 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 108 5.460000000000001e-26   NR CEP01219.1 37360 g2835 i0 63.9 0.882978723404255 83 29 88.3 1 282 34 236 317 CEP01219.1 hypothetical protein PBRA_001825 [Plasmodiophora brassicae] diamond 249 108 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
5522887 5522887 PRJNA415636_S_NODE_3785_length_254_cov_2.135266_g3738_i0 PRJNA415636 3785 254 2.135266 5.42357564 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 109 4.55e-28   NR CAD8167353.1 43137 g3738 i0 63.4 7.77165354330709 82 30 96.9 0 253 8 71 152 CAD8167353.1 unnamed protein product [Paramecium octaurelia] diamond 1974 110 0.990909090909091 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
9347246 9347246 PRJNA415636_S_NODE_3988_length_249_cov_2.777228_g3941_i0 PRJNA415636 3988 249 2.777228 6.91529772 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 146 3.9e-43   NR CEO98514.1 37360 g3941 i0 89 98.7951807228916 82 9 98.8 0 3 248 61 142 CEO98514.1 hypothetical protein PBRA_006628 [Plasmodiophora brassicae] diamond 24600 147 0.993197278911565 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
26726994 26726994 PRJNA415636_S_NODE_4421_length_239_cov_1.312500_g4374_i0 PRJNA415636 4421 239 1.3125 3.136875 Parmales sp. scaly parma 2962637 SAR_Eukaryotes SAR_Eukaryotes 114 1.71e-27   NR GMI60954.1 2962637 g4374 i0 68.4 1.93305439330544 76 24 95.4 0 1 228 2558 2633 GMI60954.1 hypothetical protein ScalyP_jg8377 [Parmales sp. scaly parma] diamond 462 114 1 Eukaryota Sar     Bolidophyceae Parmales     Parmales sp. scaly parma
26917376 26917376 PRJNA415636_S_NODE_4522_length_237_cov_2.147368_g4475_i0 PRJNA415636 4522 237 2.147368 5.08926216 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 62.4 3.49e-9   NR YP_009118062.1 372086 g4475 i0 90.3 0.392405063291139 31 3 39.2 0 108 200 283 313 YP_009118062.1 NADH dehydrogenase subunit 1 [Paracercomonas marina] diamond 93 62.4 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
28023197 28023197 PRJNA415636_S_NODE_3485_length_262_cov_3.041860_g3438_i0 PRJNA415636 3485 262 3.04186 7.9696732 Plasmodiophora brassicae 37360 SAR_Eukaryotes SAR_Eukaryotes 72.8 5.88e-14   NR CEO99081.1 37360 g3438 i0 63.6 0.50381679389313 44 16 50.4 0 2 133 98 141 CEO99081.1 hypothetical protein PBRA_007195 [Plasmodiophora brassicae] diamond 132 72.8 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28102747 28102747 PRJNA415636_S_NODE_3565_length_260_cov_3.356808_g3518_i0 PRJNA415636 3565 260 3.356808 8.7277008 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.3 9.59e-19   NR CEP00996.1 37360 g3518 i0 78 2.33076923076923 50 11 57.7 0 2 151 143 192 CEP00996.1 hypothetical protein PBRA_008308 [Plasmodiophora brassicae] diamond 606 86.7 0.995386389850058 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
30945394 30945394 PRJNA415636_S_NODE_5914_length_213_cov_0.921687_g5867_i0 PRJNA415636 5914 213 0.921687 1.96319331 Symbiodinium 2949 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00159   NR CAE7299703.1 2951 g5867 i0 48 3.52112676056338 50 24 69 2 171 25 340 388 CAE7299703.1 unc-104 [Symbiodinium microadriaticum] diamond 750 46.2 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
31451183 31451183 PRJNA415636_S_NODE_3996_length_249_cov_1.767327_g3949_i0 PRJNA415636 3996 249 1.767327 4.40064423 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 65.1 4.87e-10   NR XP_001026118.2 312017 g3949 i0 63.8 1.69879518072289 47 17 56.6 0 5 145 335 381 XP_001026118.2 transmembrane protein, putative, partial [Tetrahymena thermophila SB210] diamond 423 65.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31577656 31577656 PRJNA415636_S_NODE_3256_length_270_cov_1.412556_g3209_i0 PRJNA415636 3256 270 1.412556 3.8139012 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.5 9.13e-12   NR XP_008619232.1 1156394 g3209 i0 57.7 7.81111111111111 71 30 78.9 0 1 213 572 642 XP_008619232.1 hypothetical protein SDRG_14852 [Saprolegnia diclina VS20] diamond 2109 70.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
31704072 31704072 PRJNA415636_S_NODE_3737_length_255_cov_2.475962_g3690_i0 PRJNA415636 3737 255 2.475962 6.3137031 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.5 9.24e-14   NR CEP00957.1 37360 g3690 i0 73.2 7.21176470588235 41 11 48.2 0 255 133 41 81 CEP00957.1 hypothetical protein PBRA_008269 [Plasmodiophora brassicae] diamond 1839 71.2 0.990168539325843 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
32035435 32035435 PRJNA415636_S_NODE_5278_length_223_cov_1.159091_g5231_i0 PRJNA415636 5278 223 1.159091 2.58477293 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 107 6.25e-25   NR KAL4485779.1 2486642 g5231 i0 75 2.58295964125561 64 16 86.1 0 192 1 116 179 KAL4485779.1 hypothetical protein ABPG72_012319 [Tetrahymena utriculariae] diamond 576 107 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
32573563 32573563 PRJNA415636_S_NODE_5519_length_219_cov_2.046512_g5472_i0 PRJNA415636 5519 219 2.046512 4.48186128 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 47.8 4.79e-4   NR CAH0481106.1 622444 g5472 i0 34.8 1.58904109589041 66 42 89 1 213 19 46 111 CAH0481106.1 unnamed protein product [Peronospora belbahrii] diamond 348 47.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii

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