RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA526367" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA526367 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
26602323 26602323 PRJNA526367_P_NODE_33601_length_220_cov_2.982456_g33391_i0 PRJNA526367 33601 220 2.982456 6.5614032 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 54.3 3.73e-7   NR KAJ1400061.1 483371 g33391 i0 50 0.681818181818182 50 25 68.2 0 158 9 37 86 KAJ1400061.1 hypothetical protein B484DRAFT_406118 [Ochromonadaceae sp. CCMP2298] diamond 150 54.3 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
26665596 26665596 PRJNA526367_P_NODE_44541_length_175_cov_5.079365_g44331_i0 PRJNA526367 44541 175 5.079365 8.88888875 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 67.4 3.05e-11   NR KAJ1440511.1 483371 g44331 i0 51.8 0.96 56 27 96 0 8 175 2241 2296 KAJ1440511.1 hypothetical protein B484DRAFT_415525 [Ochromonadaceae sp. CCMP2298] diamond 168 67.4 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27772582 27772582 PRJNA526367_P_NODE_54844_length_163_cov_4.666667_g54634_i0 PRJNA526367 54844 163 4.666667 7.60666721 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 82.8 9.54e-17   NR KAJ1438371.1 483371 g54634 i0 78 0.920245398773006 50 11 92 0 10 159 442 491 KAJ1438371.1 autophagy protein Apg9-domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] diamond 150 82.8 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28845685 28845685 PRJNA526367_P_NODE_49448_length_168_cov_2.571429_g49238_i0 PRJNA526367 49448 168 2.571429 4.32000072 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 49.7 4.79e-5   NR CAK0848447.1 89957 g49238 i0 45.3 5.58928571428571 53 28 94.6 1 160 2 2150 2201 CAK0848447.1 unnamed protein product, partial [Polarella glacialis] diamond 939 49.7 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
29382697 29382697 PRJNA526367_P_NODE_61729_length_156_cov_2.831776_g61519_i0 PRJNA526367 61729 156 2.831776 4.41757056 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 84.7 9.2e-18   NR KAJ1408124.1 483371 g61519 i0 74.5 0.980769230769231 51 13 98.1 0 154 2 162 212 KAJ1408124.1 regulator of chromosome condensation 1/beta-lactamase-inhibitor protein II, partial [Ochromonadaceae sp. CCMP2298] diamond 153 84.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29919553 29919553 PRJNA526367_P_NODE_37091_length_188_cov_3.589928_g36881_i0 PRJNA526367 37091 188 3.589928 6.74906464 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 63.5 8.15e-10   NR KAJ1441783.1 483371 g36881 i0 57.6 0.941489361702128 59 20 92.6 2 9 182 123 177 KAJ1441783.1 hypothetical protein B484DRAFT_390500 [Ochromonadaceae sp. CCMP2298] diamond 177 63.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30014295 30014295 PRJNA526367_P_NODE_46671_length_172_cov_2.252033_g46461_i0 PRJNA526367 46671 172 2.252033 3.87349676 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 53.5 7.5e-7   NR CAK9094323.1 1381693 g46461 i0 51 1.7093023255814 49 24 85.5 0 163 17 84 132 CAK9094323.1 Uncharacterized protein SCF082_LOCUS44339, partial [Durusdinium trenchii] diamond 294 53.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
31246451 31246451 PRJNA526367_P_NODE_49595_length_167_cov_10.779661_g49385_i0 PRJNA526367 49595 167 10.779661 18.002033870000002 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.28e-9   NR KAI2488951.1 210448 g49385 i0 60.9 1.77844311377246 46 18 82.6 0 2 139 13 58 KAI2488951.1 carbohydrate kinase-like protein [Fragilaria crotonensis] diamond 297 60.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31594609 31594609 PRJNA526367_P_NODE_30536_length_323_cov_2.850365_g30327_i0 PRJNA526367 30536 323 2.850365 9.20667895 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0391   NR EJK50985.1 159749 g30327 i0 54.8 0.287925696594427 31 14 28.8 0 316 224 1215 1245 EJK50985.1 hypothetical protein THAOC_29894, partial [Thalassiosira oceanica] diamond 93 43.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
32163985 32163985 PRJNA526367_P_NODE_40378_length_182_cov_4.902256_g40168_i0 PRJNA526367 40378 182 4.902256 8.92210592 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 66.2 2.32e-11   NR KAJ1426706.1 483371 g40168 i0 50.7 1.2032967032967 73 21 95.6 1 176 3 95 167 KAJ1426706.1 hypothetical protein B484DRAFT_81788 [Ochromonadaceae sp. CCMP2298] diamond 219 66.2 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32480418 32480418 PRJNA526367_P_NODE_36199_length_190_cov_1.446809_g35989_i0 PRJNA526367 36199 190 1.446809 2.7489371 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 94 1.7e-20   NR KAJ1409004.1 483371 g35989 i0 73.3 0.947368421052632 60 16 94.7 0 8 187 1058 1117 KAJ1409004.1 hypothetical protein B484DRAFT_403358 [Ochromonadaceae sp. CCMP2298] diamond 180 94 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32543723 32543723 PRJNA526367_P_NODE_56239_length_162_cov_3.265487_g56029_i0 PRJNA526367 56239 162 3.265487 5.29008894 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 60.5 6.76e-9   NR CAE8721897.1 89957 g56029 i0 53.8 3.85185185185185 52 22 92.6 1 158 9 117 168 CAE8721897.1 unnamed protein product [Polarella glacialis] diamond 624 60.5 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis

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