RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA688736 · 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
1177799 1177799 PRJNA688736_P_NODE_44581_length_248_cov_0.891429_g44296_i0 PRJNA688736 44581 248 0.891429 2.21074392 Saprolegnia diclina VS2 112098 SAR_Eukaryotes SAR_Eukaryotes 142 5.01e-37   NR XP_008610586.1 1156394 g44296 i0 80.5 3.96774193548387 82 16 99.2 0 247 2 19 100 XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] diamond 984 142 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
8830817 8830817 PRJNA688736_P_NODE_49467_length_243_cov_0.917647_g49182_i0 PRJNA688736 49467 243 0.917647 2.22988221 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 126 1.0599999999999998e-31   NR XP_004029989.1 5932 g49182 i0 71.3 1.97530864197531 80 23 98.8 0 2 241 375 454 XP_004029989.1 hypothetical protein IMG5_169500 [Ichthyophthirius multifiliis] diamond 480 127 0.992125984251969 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
9596722 9596722 PRJNA688736_P_NODE_47928_length_245_cov_0.906977_g47643_i0 PRJNA688736 47928 245 0.906977 2.22209365 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 115 9.79e-28   NR QBH22568.1 282688 g47643 i0 72.8 0.991836734693878 81 22 99.2 0 245 3 767 847 QBH22568.1 V-type proton ATPase subunit a [Philasterides dicentrarchi] diamond 243 115 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
15970430 15970430 PRJNA688736_P_NODE_31453_length_286_cov_1.098592_g31168_i0 PRJNA688736 31453 286 1.098592 3.14197312 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 170 8.67e-52   NR CBJ26992.1 2880 g31168 i0 82.2 3.77622377622378 90 16 94.4 0 3 272 98 187 CBJ26992.1 conserved unknown protein [Ectocarpus siliculosus] diamond 1080 170 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
17245973 17245973 PRJNA688736_P_NODE_44554_length_248_cov_0.891429_g44269_i0 PRJNA688736 44554 248 0.891429 2.21074392 root 1 Root_unresolved Root_unresolved 157 2.84e-47   NR KAJ1404383.1 483371 g44269 i0 93.9 1.98387096774194 82 5 99.2 0 248 3 20 101 KAJ1404383.1 hypothetical protein B484DRAFT_457346 [Ochromonadaceae sp. CCMP2298] diamond 492 157 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
26904103 26904103 PRJNA688736_P_NODE_40421_length_253_cov_0.866667_g40136_i0 PRJNA688736 40421 253 0.866667 2.19266751 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 129 1.36e-33   NR CEO99495.1 37360 g40136 i0 71.1 9.84189723320158 83 24 98.4 0 3 251 274 356 CEO99495.1 hypothetical protein PBRA_007228 [Plasmodiophora brassicae] diamond 2490 130 0.992307692307692 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Plasmodiophora Plasmodiophora brassicae
28408751 28408751 PRJNA688736_P_NODE_45666_length_247_cov_0.896552_g45381_i0 PRJNA688736 45666 247 0.896552 2.21448344 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 105 2.1e-24   NR OEU21942.1 635003 g45381 i0 58.8 0.97165991902834 80 33 97.2 0 242 3 162 241 OEU21942.1 hypothetical protein FRACYDRAFT_232090 [Fragilariopsis cylindrus CCMP1102] diamond 240 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28693057 28693057 PRJNA688736_P_NODE_31887_length_284_cov_1.398104_g31602_i0 PRJNA688736 31887 284 1.398104 3.97061536 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 114 2.05e-29   NR CAE7473169.1 2951 g31602 i0 63.6 0.929577464788732 88 32 93 0 283 20 117 204 CAE7473169.1 RPS8 [Symbiodinium microadriaticum] diamond 264 114 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
29335926 29335926 PRJNA688736_P_NODE_43809_length_249_cov_0.886364_g43524_i0 PRJNA688736 43809 249 0.886364 2.20704636 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 62.4 4.74e-9   NR XP_001444384.1 5888 g43524 i0 40.5 4.74698795180723 79 42 95.2 1 248 12 101 174 XP_001444384.1 uncharacterized protein GSPATT00012511001 [Paramecium tetraurelia] diamond 1182 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29356024 29356024 PRJNA688736_P_NODE_21509_length_338_cov_2.105660_g21224_i0 PRJNA688736 21509 338 2.10566 7.1171308 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 131 8.529999999999999e-37   NR KAG5177524.1 303371 g21224 i0 62.1 1.82840236686391 103 39 91.4 0 29 337 3 105 KAG5177524.1 ribosomal protein L14-domain-containing protein [Tribonema minus] diamond 618 131 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
29967518 29967518 PRJNA688736_P_NODE_47031_length_246_cov_0.901734_g46746_i0 PRJNA688736 47031 246 0.901734 2.21826564 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 118 1.9499999999999999e-31   NR XP_012653439.1 312017 g46746 i0 69.1 2.96341463414634 81 25 98.8 0 245 3 23 103 XP_012653439.1 60S ribosomal protein L17 [Tetrahymena thermophila SB210] diamond 729 119 0.991596638655462 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30082107 30082107 PRJNA688736_P_NODE_48652_length_244_cov_0.912281_g48367_i0 PRJNA688736 48652 244 0.912281 2.22596564 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 92.8 5.38e-22   NR KAJ1411071.1 483371 g48367 i0 70.8 3.14754098360656 65 19 79.9 0 198 4 5 69 KAJ1411071.1 50S ribosomal protein L30e-like protein [Ochromonadaceae sp. CCMP2298] diamond 768 92.8 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30208365 30208365 PRJNA688736_P_NODE_19852_length_350_cov_0.927798_g19567_i0 PRJNA688736 19852 350 0.927798 3.247293 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00893   NR CAJ1392690.1 2562239 g19567 i0 60 0.3 35 12 30 1 199 95 47 79 CAJ1392690.1 unnamed protein product [Effrenium voratum] diamond 105 43.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
30967082 30967082 PRJNA688736_P_NODE_45854_length_247_cov_0.896552_g45569_i0 PRJNA688736 45854 247 0.896552 2.21448344 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 105 2.51e-24   NR OMJ78935.1 5963 g45569 i0 59.3 0.983805668016194 81 32 98.4 1 245 3 333 412 OMJ78935.1 hypothetical protein SteCoe_21156 [Stentor coeruleus] diamond 243 105 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31662365 31662365 PRJNA688736_P_NODE_50877_length_242_cov_0.923077_g50592_i0 PRJNA688736 50877 242 0.923077 2.23384634 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 129 4.02e-36   NR KAJ1414110.1 483371 g50592 i0 72.5 0.991735537190083 80 21 99.2 1 240 1 56 134 KAJ1414110.1 thioredoxin-like protein [Ochromonadaceae sp. CCMP2298] diamond 240 129 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31883856 31883856 PRJNA688736_P_NODE_45757_length_247_cov_0.896552_g45472_i0 PRJNA688736 45757 247 0.896552 2.21448344 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 82.4 4.26e-16   NR XP_001426365.1 5888 g45472 i0 44.9 0.947368421052632 78 43 94.7 0 2 235 151 228 XP_001426365.1 uncharacterized protein GSPATT00029597001 [Paramecium tetraurelia] diamond 234 82.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32200400 32200400 PRJNA688736_P_NODE_9958_length_473_cov_3.570000_g9674_i0 PRJNA688736 9958 473 3.57 16.8861 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.27e-5   NR CAG9310987.1 1481888 g9674 i0 35.1 0.596194503171247 94 56 59 2 401 123 231 320 CAG9310987.1 unnamed protein product [Blepharisma stoltei] diamond 282 54.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32232260 32232260 PRJNA688736_P_NODE_48618_length_244_cov_0.912281_g48333_i0 PRJNA688736 48618 244 0.912281 2.22596564 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 52.4 1.44e-5   NR KRX06315.1 266149 g48333 i0 37.9 1.45081967213115 58 36 71.3 0 241 68 265 322 KRX06315.1 Protein kinase-like domain [Pseudocohnilembus persalinus] diamond 354 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32831888 32831888 PRJNA688736_P_NODE_48100_length_245_cov_0.906977_g47815_i0 PRJNA688736 48100 245 0.906977 2.22209365 Parmales sp. scaly parma 2962637 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0155   NR GMI53004.1 2962637 g47815 i0 52.5 0.746938775510204 61 27 74.7 1 3 185 2147 2205 GMI53004.1 hypothetical protein ScalyP_jg2609, partial [Parmales sp. scaly parma] diamond 183 43.9 1 Eukaryota Sar     Bolidophyceae Parmales     Parmales sp. scaly parma

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