RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA1011833 · 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
27129057 27129057 PRJNA1011833_S_NODE_7742_length_406_cov_3.644628_g7326_i0 PRJNA1011833 7742 406 3.644628 14.79718968 Triparma verrucosa 1606542 SAR_Eukaryotes SAR_Eukaryotes 73.6 3.64e-12   NR GMH90071.1 1606542 g7326 i0 41.5 1.95073891625616 82 48 60.6 0 10 255 410 491 GMH90071.1 hypothetical protein TrVE_jg3437 [Triparma verrucosa] diamond 792 73.6 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma verrucosa
27761567 27761567 PRJNA1011833_S_NODE_50704_length_162_cov_2.201681_g50284_i0 PRJNA1011833 50704 162 2.2016810000000002 3.56672322 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.54e-11   NR XP_067817784.1 4779 g50284 i0 63 2.96296296296296 54 19 98.1 1 159 1 256 309 XP_067817784.1 hypothetical protein CCR75_003227 [Bremia lactucae] diamond 480 67.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
29024613 29024613 PRJNA1011833_S_NODE_728_length_967_cov_7.514069_g543_i0 PRJNA1011833 728 967 7.514069 72.66104723 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 213 5.3e-64   NR CAD8068969.1 5886 g543 i0 54 1.88004136504654 202 87 62.7 2 2 607 76 271 CAD8068969.1 unnamed protein product [Paramecium primaurelia] diamond 1818 213 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29087523 29087523 PRJNA1011833_S_NODE_20188_length_268_cov_3.631111_g19768_i0 PRJNA1011833 20188 268 3.631111 9.73137748 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 67 2.82e-11   NR XP_001014252.1 312017 g19768 i0 35.2 4.80223880597015 88 57 98.5 0 266 3 96 183 XP_001014252.1 UMP-CMP kinase [Tetrahymena thermophila SB210] diamond 1287 67 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29465872 29465872 PRJNA1011833_S_NODE_30770_length_212_cov_1.704142_g30350_i0 PRJNA1011833 30770 212 1.704142 3.6127810400000002 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 62.4 2.9e-9   NR CAD8182867.1 43137 g30350 i0 49.1 0.778301886792453 55 28 77.8 0 29 193 556 610 CAD8182867.1 unnamed protein product [Paramecium octaurelia] diamond 165 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30121701 30121701 PRJNA1011833_S_NODE_15652_length_305_cov_4.270992_g15232_i0 PRJNA1011833 15652 305 4.270992 13.0265256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 72.4 2.32e-12   NR XP_001423282.1 5888 g15232 i0 39.6 1.79016393442623 91 55 89.5 0 8 280 266 356 XP_001423282.1 uncharacterized protein GSPATT00000319001 [Paramecium tetraurelia] diamond 546 72.8 0.994505494505495 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
30248463 30248463 PRJNA1011833_S_NODE_3032_length_547_cov_6.744048_g2647_i0 PRJNA1011833 3032 547 6.744048 36.88994256 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 184 3.94e-53   NR GLE08162.1 114742 g2647 i0 67.4 8.47897623400366 172 55 93.8 1 542 30 205 376 GLE08162.1 hypothetical protein PINS_up019168 [Pythium insidiosum] diamond 4638 184 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
30508647 30508647 PRJNA1011833_S_NODE_38273_length_188_cov_2.103448_g37853_i0 PRJNA1011833 38273 188 2.103448 3.95448224 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 60.8 7.19e-9   NR CAI2369316.1 5936 g37853 i0 52.5 2.6968085106383 59 28 94.1 0 3 179 397 455 CAI2369316.1 unnamed protein product [Moneuplotes crassus] diamond 507 60.8 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31014130 31014130 PRJNA1011833_S_NODE_6295_length_434_cov_12.388747_g5882_i0 PRJNA1011833 6295 434 12.388747 53.76716198 Hondaea fermentalgiana 2315210 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0076   NR GBG31126.1 2315210 g5882 i0 31 0.691244239631336 100 62 65.7 3 46 330 18 115 GBG31126.1 Cystatin-A2 [Hondaea fermentalgiana] diamond 300 45.4 1 Eukaryota Sar     Bigyra Thraustochytrida Thraustochytriidae Hondaea Hondaea fermentalgiana
31614893 31614893 PRJNA1011833_S_NODE_28696_length_221_cov_1.078652_g28276_i0 PRJNA1011833 28696 221 1.078652 2.38382092 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 52.8 2.64e-6   NR GFH46202.1 426638 g28276 i0 39.7 1.95475113122172 73 41 95 2 212 3 48 120 GFH46202.1 hypothetical protein CTEN210_02676 [Chaetoceros tenuissimus] diamond 432 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31709811 31709811 PRJNA1011833_S_NODE_17277_length_291_cov_1.947581_g16857_i0 PRJNA1011833 17277 291 1.947581 5.66746071 Tetraparma gracilis 2962635 SAR_Eukaryotes SAR_Eukaryotes 89.7 8.08e-20   NR GMI20464.1 2962635 g16857 i0 46.5 0.88659793814433 86 45 88.7 1 290 33 88 172 GMI20464.1 hypothetical protein TeGR_g14236 [Tetraparma gracilis] diamond 258 89.7 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Tetraparma Tetraparma gracilis
32493274 32493274 PRJNA1011833_S_NODE_22139_length_255_cov_1.641509_g21719_i0 PRJNA1011833 22139 255 1.641509 4.18584795 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.1e-9   NR VEU39726.1 183589 g21719 i0 42.7 9.61176470588235 75 43 88.2 0 23 247 639 713 VEU39726.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 2451 62.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata

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