RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJEB76780", 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 · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJEB76780 · 16 ✖

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
138660 138660 PRJEB76780_P_NODE_10521_length_252_cov_1.307263_g10421_i0 PRJEB76780 10521 252 1.307263 3.29430276 Thaumatomonas sp. TMT002 407209 SAR_Eukaryotes SAR_Eukaryotes 222 1.65e-53   NTclustered gi|193875699|gb|EU812202.1| 407209 g10421 i0 83.333 69.1428571428571 246 35 96 6 1 243 317 75 Thaumatomonas sp. TMT002 clone tshsp70-1 70 kDa heat shock protein mRNA, partial cds blastn 17424 222 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
3547018 3547018 PRJEB76780_P_NODE_7783_length_290_cov_0.903226_g7683_i0 PRJEB76780 7783 290 0.903226 2.6193554 Bodomorpha 188949 SAR_Eukaryotes SAR_Eukaryotes 536 6.079999999999999e-148   NTclustered gi|219524870|gb|EU709233.1| 175275 g7683 i0 100 99.0068965517241 290 0 100 0 1 290 810 521 Uncultured cercozoan isolate HetPan13 18S ribosomal RNA gene, partial sequence blastn 28712 536 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
3964944 3964944 PRJEB76780_P_NODE_6844_length_308_cov_1.527660_g6744_i0 PRJEB76780 6844 308 1.52766 4.7051928 Thaumatomonas seravini 188939 SAR_Eukaryotes SAR_Eukaryotes 375 1.5e-99   NTclustered gi|160337402|gb|EF455799.1| 188939 g6744 i0 88.636 98.8506493506493 308 35 100 0 1 308 273 580 Thaumatomonas seravini beta-tubulin (btub) gene, partial cds blastn 30446 375 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas seravini
6099583 6099583 PRJEB76780_P_NODE_10905_length_251_cov_0.876404_g10805_i0 PRJEB76780 10905 251 0.876404 2.19977404 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 279 9.58e-71   NTclustered gi|27734360|gb|AY099135.1| 188952 g10805 i0 86.905 219.466135458167 252 30 99 1 1 249 346 95 Cercomonas edax isolate pub7 polyubiquitin gene, partial cds blastn 55086 279 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas edax
6516874 6516874 PRJEB76780_P_NODE_11346_length_249_cov_0.886364_g11246_i0 PRJEB76780 11346 249 0.886364 2.20704636 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 126 8.299999999999999e-32   NR MES1907878.1 1215613 g11246 i0 75.6 3.95180722891566 82 20 98.8 0 3 248 376 457 MES1907878.1 T-complex protein 1 subunit eta [Cercozoa sp. M6MM] diamond 984 126 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
20122923 20122923 PRJEB76780_P_NODE_3856_length_414_cov_6.378299_g3756_i0 PRJEB76780 3856 414 6.378299 26.40615786 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 207 2.76e-66   NR ADK26622.1 323453 g3756 i0 72.3 1.88405797101449 130 36 94.2 0 24 413 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 780 207 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
20539702 20539702 PRJEB76780_P_NODE_2977_length_476_cov_1.156328_g2877_i0 PRJEB76780 2977 476 1.156328 5.50412128 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 664 0   NTclustered gi|88792583|gb|DQ386164.1| 372086 g2877 i0 91.983 97.8655462184874 474 36 99 2 1 473 1579 2051 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 46584 664 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
21815445 21815445 PRJEB76780_P_NODE_1178_length_764_cov_3.874096_g1088_i0 PRJEB76780 1178 764 3.874096 29.59809344 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 273 6.479999999999999e-89   NR MES1912193.1 1215613 g1088 i0 55.5 7.44895287958115 238 106 93.5 0 752 39 1 238 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 5691 273 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
21815455 21815455 PRJEB76780_P_NODE_12958_length_243_cov_1.305882_g12858_i0 PRJEB76780 12958 243 1.305882 3.17329326 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 135 8.71e-35   NR MES1909201.1 1215613 g12858 i0 80 0.987654320987654 80 13 98.8 2 242 3 622 698 MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 135 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27879831 27879831 PRJEB76780_P_NODE_13525_length_235_cov_2.919753_g13425_i0 PRJEB76780 13525 235 2.919753 6.86141955 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 86.3 1.22e-18   NR MES1908571.1 1215613 g13425 i0 53.7 1.8 67 31 85.5 0 222 22 55 121 MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] diamond 423 86.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28013585 28013585 PRJEB76780_P_NODE_10365_length_253_cov_0.866667_g10265_i0 PRJEB76780 10365 253 0.866667 2.19266751 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 79.7 4.16e-15   NR MES1910326.1 1215613 g10265 i0 49.4 0.960474308300395 81 35 96 1 253 11 392 466 MES1910326.1 hypothetical protein [Cercozoa sp. M6MM] diamond 243 79.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28897368 28897368 PRJEB76780_P_NODE_4428_length_386_cov_1.993610_g4328_i0 PRJEB76780 4428 386 1.99361 7.6953346 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.8 8.31e-8   NR MES1907423.1 1215613 g4328 i0 32.7 0.83160621761658 107 65 83.2 1 324 4 126 225 MES1907423.1 hypothetical protein [Cercozoa sp. M6MM] diamond 321 60.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29332251 29332251 PRJEB76780_P_NODE_10169_length_254_cov_1.292818_g10069_i0 PRJEB76780 10169 254 1.292818 3.28375772 root 1 Root_unresolved Root_unresolved 113 2.25e-27   NR MES1911892.1 1215613 g10069 i0 58 1.91338582677165 81 34 95.7 0 2 244 339 419 MES1911892.1 hypothetical protein [Cercozoa sp. M6MM] diamond 486 114 0.991228070175439 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29339629 29339629 PRJEB76780_P_NODE_7129_length_303_cov_0.952174_g7029_i0 PRJEB76780 7129 303 0.952174 2.88508722 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.4 0.00169   NR MES1908186.1 1215613 g7029 i0 41.5 0.524752475247525 53 31 52.5 0 8 166 67 119 MES1908186.1 hypothetical protein [Cercozoa sp. M6MM] diamond 159 47.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30287430 30287430 PRJEB76780_P_NODE_7112_length_303_cov_1.182609_g7012_i0 PRJEB76780 7112 303 1.182609 3.58330527 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 71.6 5.13e-12   NR MES1912100.1 1215613 g7012 i0 37.2 0.851485148514851 86 54 85.1 0 2 259 435 520 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 258 71.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30666086 30666086 PRJEB76780_P_NODE_8393_length_280_cov_0.893720_g8293_i0 PRJEB76780 8393 280 0.89372 2.502416 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 3.88e-22   NR MES1907663.1 1215613 g8293 i0 50 2.87142857142857 90 45 96.4 0 3 272 620 709 MES1907663.1 hypothetical protein [Cercozoa sp. M6MM] diamond 804 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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