RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA1204310", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1204310 · 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
9256637 9256637 PRJNA1204310_P_NODE_14508_length_466_cov_1.155216_g14211_i0 PRJNA1204310 14508 466 1.155216 5.38330656 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 244 2.56e-77   NR MES1910618.1 1215613 g14211 i0 76 0.991416309012876 154 37 99.1 0 3 464 69 222 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 462 244 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
11807311 11807311 PRJNA1204310_P_NODE_15630_length_450_cov_3.055703_g15333_i0 PRJNA1204310 15630 450 3.055703 13.7506635 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 754 0   NTclustered gi|33089893|gb|AY283756.1| 238773 g15333 i0 96.889 99.2955555555556 450 14 100 0 1 450 246 695 Lecythium sp. 3678_261K actin gene, partial cds blastn 44683 754 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
13798304 13798304 PRJNA1204310_P_NODE_16611_length_438_cov_4.879452_g16314_i0 PRJNA1204310 16611 438 4.879452 21.37199976 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 181 5.709999999999999e-54   NR MES1907458.1 1215613 g16314 i0 72.4 0.86986301369863 127 35 87 0 56 436 4 130 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 381 181 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
18181413 18181413 PRJNA1204310_P_NODE_7615_length_628_cov_0.981982_g7329_i0 PRJNA1204310 7615 628 0.981982 6.16684696 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 218 9.8e-65   NR MES1910324.1 1215613 g7329 i0 49.3 1.0843949044586 227 95 98.9 4 5 625 83 309 MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] diamond 681 218 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19454707 19454707 PRJNA1204310_P_NODE_11136_length_526_cov_1.732892_g10841_i0 PRJNA1204310 11136 526 1.732892 9.11501192 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 244 4.81e-78   NR MES1911029.1 1215613 g10841 i0 65.4 1.02091254752852 179 58 99.8 1 526 2 47 225 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 537 244 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
23280830 23280830 PRJNA1204310_P_NODE_15719_length_449_cov_2.250000_g15422_i0 PRJNA1204310 15719 449 2.25 10.1025 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 181 1.51e-53   NR MES1911029.1 1215613 g15422 i0 61.4 2.03118040089087 153 53 99.6 3 1 447 101 251 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 912 181 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27799307 27799307 PRJNA1204310_P_NODE_22304_length_386_cov_1.246006_g22007_i0 PRJNA1204310 22304 386 1.246006 4.80958316 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94 5.71e-20   NR MES1908577.1 1215613 g22007 i0 42.1 1.74093264248705 107 62 83.2 0 65 385 29 135 MES1908577.1 hypothetical protein [Cercozoa sp. M6MM] diamond 672 94 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28399046 28399046 PRJNA1204310_P_NODE_33186_length_324_cov_1.243028_g32889_i0 PRJNA1204310 33186 324 1.243028 4.02741072 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 79 3.22e-15   NR AAT09082.1 227086 g32889 i0 40 0.87962962962963 95 57 88 0 308 24 107 201 AAT09082.1 glutathione-s-transferase [Bigelowiella natans] diamond 285 79 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28525543 28525543 PRJNA1204310_P_NODE_63147_length_227_cov_2.025974_g62850_i0 PRJNA1204310 63147 227 2.025974 4.59896098 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47 8.97e-4   NR MES1907347.1 1215613 g62850 i0 46.8 1.24229074889868 47 20 62.1 1 167 27 224 265 MES1907347.1 hypothetical protein [Cercozoa sp. M6MM] diamond 282 47 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30325916 30325916 PRJNA1204310_P_NODE_47072_length_267_cov_2.020619_g46775_i0 PRJNA1204310 47072 267 2.020619 5.39505273 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 116 7.3699999999999985e-28   NR MES1913984.1 1215613 g46775 i0 60.9 0.97752808988764 87 34 97.8 0 261 1 421 507 MES1913984.1 hypothetical protein [Cercozoa sp. M6MM] diamond 261 116 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31716115 31716115 PRJNA1204310_P_NODE_42297_length_285_cov_1.466981_g42000_i0 PRJNA1204310 42297 285 1.466981 4.18089585 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 111 3.98e-29   NR ADK26622.1 323453 g42000 i0 89.1 0.578947368421053 55 6 57.9 0 3 167 76 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 165 111 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
32032506 32032506 PRJNA1204310_P_NODE_26598_length_358_cov_1.094737_g26301_i0 PRJNA1204310 26598 358 1.094737 3.91915846 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 56.6 4.71e-7   NR MES1911919.1 1215613 g26301 i0 63.2 0.318435754189944 38 14 31.8 0 278 165 1 38 MES1911919.1 hypothetical protein [Cercozoa sp. M6MM] diamond 114 56.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32349142 32349142 PRJNA1204310_P_NODE_45099_length_275_cov_1.262376_g44802_i0 PRJNA1204310 45099 275 1.262376 3.471534 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 106 4.1e-25   NR MES1911580.1 1215613 g44802 i0 62.3 0.84 77 27 81.8 1 3 227 135 211 MES1911580.1 hypothetical protein [Cercozoa sp. M6MM] diamond 231 106 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32380611 32380611 PRJNA1204310_P_NODE_29579_length_342_cov_1.115242_g29282_i0 PRJNA1204310 29579 342 1.115242 3.81412764 Thaumatomonas sp. TMT 45100 SAR_Eukaryotes SAR_Eukaryotes 103 5.15e-23   NR ACF24495.1 407209 g29282 i0 42.9 1.96491228070175 112 62 98.2 1 341 6 98 207 ACF24495.1 eukaryotic translation elongation factor 2, partial [Thaumatomonas sp. TMT002] diamond 672 103 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
32790520 32790520 PRJNA1204310_P_NODE_24640_length_370_cov_1.313131_g24343_i0 PRJNA1204310 24640 370 1.313131 4.8585847 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 92.4 4.1200000000000005e-21   NR AAT09102.1 227086 g24343 i0 40.5 2.48918918918919 111 62 89.2 2 40 369 22 129 AAT09102.1 cysteine proteinase, partial [Bigelowiella natans] diamond 921 92.4 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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