RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA929924" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA929924 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
3459780 3459780 PRJNA929924_P_NODE_14443_length_174_cov_1.664000_g14280_i0 PRJNA929924 14443 174 1.664 2.89536 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 102 7.300000000000001e-27   NR KAJ1422858.1 483371 g14280 i0 80.4 0.96551724137931 56 11 96.6 0 168 1 1 56 KAJ1422858.1 ribosomal protein S27 [Ochromonadaceae sp. CCMP2298] diamond 168 102 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
22586051 22586051 PRJNA929924_P_NODE_9838_length_250_cov_1.034826_g9675_i0 PRJNA929924 9838 250 1.034826 2.587065 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 124 8.23e-31   NR KAJ1421113.1 483371 g9675 i0 77.8 0.972 81 18 97.2 0 8 250 309 389 KAJ1421113.1 hypothetical protein B484DRAFT_433346 [Ochromonadaceae sp. CCMP2298] diamond 243 124 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
26930035 26930035 PRJNA929924_P_NODE_14622_length_172_cov_1.284553_g14459_i0 PRJNA929924 14622 172 1.284553 2.20943116 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 86.3 6.65e-18   NR KAJ1436072.1 483371 g14459 i0 68.4 0.994186046511628 57 18 99.4 0 1 171 704 760 KAJ1436072.1 inositol 1,4,5-trisphosphate/ryanodine receptor-domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] diamond 171 86.3 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27341168 27341168 PRJNA929924_P_NODE_16443_length_166_cov_0.888889_g16280_i0 PRJNA929924 16443 166 0.888889 1.47555574 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0175   NR KRW99552.1 266149 g16280 i0 43.5 0.831325301204819 46 26 83.1 0 138 1 210 255 KRW99552.1 hypothetical protein PPERSA_01198 [Pseudocohnilembus persalinus] diamond 138 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27436011 27436011 PRJNA929924_P_NODE_12623_length_194_cov_1.075862_g12460_i0 PRJNA929924 12623 194 1.075862 2.08717228 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 93.6 2.48e-21   NR KAJ1415384.1 483371 g12460 i0 75.8 1.91752577319588 62 14 95.9 1 187 2 194 254 KAJ1415384.1 ribosomal protein S3Ae [Ochromonadaceae sp. CCMP2298] diamond 372 93.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28382962 28382962 PRJNA929924_P_NODE_14826_length_170_cov_1.289256_g14663_i0 PRJNA929924 14826 170 1.289256 2.1917352 Chrysophaeum taylorii 2483200 SAR_Eukaryotes SAR_Eukaryotes 99.8 1.46e-25   NR KAJ8613817.1 2483200 g14663 i0 88.7 5.59411764705882 53 6 93.5 0 170 12 49 101 KAJ8613817.1 hypothetical protein CTAYLR_004895 [Chrysophaeum taylorii] diamond 951 99.8 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Chrysophaeum Chrysophaeum taylorii
28509326 28509326 PRJNA929924_P_NODE_17587_length_163_cov_0.912281_g17424_i0 PRJNA929924 17587 163 0.912281 1.48701803 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 84.7 2.03e-17   NR KAJ1414441.1 483371 g17424 i0 73.1 0.957055214723926 52 14 95.7 0 157 2 84 135 KAJ1414441.1 hypothetical protein B484DRAFT_165638 [Ochromonadaceae sp. CCMP2298] diamond 156 84.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28761770 28761770 PRJNA929924_P_NODE_16787_length_165_cov_0.896552_g16624_i0 PRJNA929924 16787 165 0.896552 1.4793108 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 55.5 4.09e-7   NR XP_001441532.1 5888 g16624 i0 56.4 0.709090909090909 39 17 70.9 0 9 125 65 103 XP_001441532.1 uncharacterized protein GSPATT00010369001 [Paramecium tetraurelia] diamond 117 55.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29298688 29298688 PRJNA929924_P_NODE_17169_length_164_cov_0.904348_g17006_i0 PRJNA929924 17169 164 0.904348 1.48313072 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 105 3.37e-28   NR KAJ1440827.1 483371 g17006 i0 85.2 0.98780487804878 54 8 98.8 0 162 1 10 63 KAJ1440827.1 tubulin-tyrosine ligase/Tubulin polyglutamylase, partial [Ochromonadaceae sp. CCMP2298] diamond 162 105 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30719950 30719950 PRJNA929924_P_NODE_15554_length_168_cov_0.873950_g15391_i0 PRJNA929924 15554 168 0.87395 1.468236 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 74.3 1.63e-14   NR KRX00852.1 266149 g15391 i0 62.5 2 56 21 100 0 1 168 101 156 KRX00852.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 336 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30783227 30783227 PRJNA929924_P_NODE_17774_length_163_cov_0.912281_g17611_i0 PRJNA929924 17774 163 0.912281 1.48701803 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.36e-14   NR KAJ1432765.1 483371 g17611 i0 63.5 0.957055214723926 52 19 95.7 0 161 6 2900 2951 KAJ1432765.1 hypothetical protein B484DRAFT_394815, partial [Ochromonadaceae sp. CCMP2298] diamond 156 76.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31130491 31130491 PRJNA929924_P_NODE_12975_length_189_cov_2.028571_g12812_i0 PRJNA929924 12975 189 2.028571 3.83399919 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00379   NR KAJ1421180.1 483371 g12812 i0 35.8 0.841269841269841 53 34 84.1 0 29 187 772 824 KAJ1421180.1 hypothetical protein B484DRAFT_433328, partial [Ochromonadaceae sp. CCMP2298] diamond 159 44.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31225441 31225441 PRJNA929924_P_NODE_11855_length_206_cov_1.305732_g11692_i0 PRJNA929924 11855 206 1.305732 2.68980792 Nannochloropsis salina CCMP1776 1027361 SAR_Eukaryotes SAR_Eukaryotes 105 9.31e-26   NR TFJ83676.1 1027361 g11692 i0 66.2 3.96116504854369 68 23 99 0 1 204 162 229 TFJ83676.1 hypothetical protein NSK_004780 [Nannochloropsis salina CCMP1776] diamond 816 105 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Microchloropsis Microchloropsis salina
31984677 31984677 PRJNA929924_P_NODE_17698_length_163_cov_0.912281_g17535_i0 PRJNA929924 17698 163 0.912281 1.48701803 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 69.7 7.79e-13   NR KAL3795184.1 382360 g17535 i0 94.1 1.26993865030675 34 2 62.6 0 5 106 169 202 KAL3795184.1 hypothetical protein ACHAWO_005356 [Cyclotella atomus] diamond 207 69.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32648483 32648483 PRJNA929924_P_NODE_15100_length_169_cov_0.866667_g14937_i0 PRJNA929924 15100 169 0.866667 1.46466723 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 86.7 4.67e-18   NR KAJ1432666.1 483371 g14937 i0 58.9 0.994082840236686 56 23 99.4 0 1 168 132 187 KAJ1432666.1 pre-RNA processing PIH1/Nop17-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 168 86.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298

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