RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA900028", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 14 ✖

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA900028 · 14 ✖

analysis 1

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
874787 874787 PRJNA900028_P_NODE_150801_length_165_cov_0.879310_g150052_i0 PRJNA900028 150801 165 0.87931 1.4508615 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 75 2.94e-9   NTclustered gi|88792583|gb|DQ386164.1| 372086 g150052 i0 84.615 20.9090909090909 78 9 47 3 25 102 1751 1825 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 3450 75 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
2149582 2149582 PRJNA900028_P_NODE_10522_length_343_cov_2.319728_g9774_i0 PRJNA900028 10522 343 2.319728 7.95666704 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 612 1.19e-170   NTclustered gi|197723521|gb|EF681900.2| 458884 g9774 i0 98.834 27.2361516034985 343 4 100 0 1 343 258 600 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 9342 612 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
5978984 5978984 PRJNA900028_P_NODE_56545_length_200_cov_3.284768_g55796_i0 PRJNA900028 56545 200 3.284768 6.569536 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 370 4.22e-98   NTclustered gi|197723521|gb|EF681900.2| 458884 g55796 i0 100 101.055 200 0 100 0 1 200 927 728 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 20211 370 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
7252991 7252991 PRJNA900028_P_NODE_163986_length_163_cov_1.789474_g163237_i0 PRJNA900028 163986 163 1.789474 2.91684262 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 302 1.22e-77   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g163237 i0 100 7.6319018404908 163 0 100 0 1 163 41 203 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1244 302 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
9803138 9803138 PRJNA900028_P_NODE_21048_length_267_cov_1.688073_g20299_i0 PRJNA900028 21048 267 1.688073 4.50715491 Micrometopion nutans 985835 SAR_Eukaryotes SAR_Eukaryotes 161 3.89e-35   NTclustered gi|323652744|gb|HQ121441.1| 985835 g20299 i0 85.621 45.7340823970037 153 22 57 0 107 259 410 258 Micrometopion nutans strain CCAP 1904/1 18S small subunit ribosomal RNA gene, partial sequence blastn 12211 161 1 Eukaryota Sar   Cercozoa Imbricatea   Metromonadea Micrometopion Micrometopion nutans
10173347 10173347 PRJNA900028_P_NODE_14788_length_301_cov_1.813492_g14039_i0 PRJNA900028 14788 301 1.813492 5.45861092 Guttulinopsis 1144921 SAR_Eukaryotes SAR_Eukaryotes 538 1.76e-148   NTclustered gi|1402550487|gb|MH488773.1| 2231167 g14039 i0 99.003 27.7873754152824 301 1 100 1 1 301 1097 799 Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence blastn 8364 538 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis sp.
17452709 17452709 PRJNA900028_P_NODE_12434_length_322_cov_2.234432_g11686_i0 PRJNA900028 12434 322 2.234432 7.19487104 Rosculus incognitus 2231162 SAR_Eukaryotes SAR_Eukaryotes 595 1.1099999999999995e-165   NTclustered gi|1402550483|gb|MH488769.1| 2231162 g11686 i0 100 14.7391304347826 322 0 100 0 1 322 590 269 Rosculus incognitus isolate ATCC 50577 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 4746 595 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus incognitus
17453693 17453693 PRJNA900028_P_NODE_3594_length_568_cov_2.208092_g2875_i0 PRJNA900028 3594 568 2.208092 12.54196256 Rosculus incognitus 2231162 SAR_Eukaryotes SAR_Eukaryotes 1016 0   NTclustered gi|1402550483|gb|MH488769.1| 2231162 g2875 i0 98.944 26.1161971830986 568 6 100 0 1 568 1403 836 Rosculus incognitus isolate ATCC 50577 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 14834 1016 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus incognitus
17453731 17453731 PRJNA900028_P_NODE_39594_length_221_cov_2.569767_g38845_i0 PRJNA900028 39594 221 2.569767 5.67918507 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 209 1.1e-49   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g38845 i0 89.286 6.98190045248869 168 17 76 1 1 168 2570 2736 Rosculus vulgaris isolate CCA sequence blastn 1543 209 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
18726235 18726235 PRJNA900028_P_NODE_154235_length_164_cov_0.956522_g153486_i0 PRJNA900028 154235 164 0.956522 1.56869608 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 287 3.45e-73   NTclustered gi|238617602|gb|FJ973377.1| 188950 g153486 i0 98.171 8.57317073170732 164 3 100 0 1 164 2908 2745 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 1406 287 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
18726943 18726943 PRJNA900028_P_NODE_3895_length_545_cov_2.552419_g3170_i0 PRJNA900028 3895 545 2.552419 13.91068355 Guttulinopsis rogosa 2231170 SAR_Eukaryotes SAR_Eukaryotes 874 0   NTclustered gi|1402550485|gb|MH488771.1| 2231170 g3170 i0 96.756 40.7247706422018 524 13 96 3 21 542 1456 1977 Guttulinopsis rogosa isolate ATCC 50030 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 22195 874 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis rogosa
21276348 21276348 PRJNA900028_P_NODE_11717_length_330_cov_1.249110_g10969_i0 PRJNA900028 11717 330 1.24911 4.122063 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 387 7.5e-103   NTclustered gi|238617605|gb|FJ973380.1| 45107 g10969 i0 87.915 97.4606060606061 331 36 100 2 1 330 1272 1599 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 32162 387 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
21276368 21276368 PRJNA900028_P_NODE_118237_length_167_cov_1.516949_g117488_i0 PRJNA900028 118237 167 1.516949 2.53330483 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 298 1.63e-76   NTclustered gi|238617602|gb|FJ973377.1| 188950 g117488 i0 98.81 44.1676646706587 168 1 100 1 1 167 1672 1505 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 7376 298 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24196872 24196872 PRJNA900028_P_NODE_4619_length_499_cov_1.186667_g3886_i0 PRJNA900028 4619 499 1.186667 5.92146833 Guttulinopsis 1144921 SAR_Eukaryotes SAR_Eukaryotes 883 0   NTclustered gi|1402550487|gb|MH488773.1| 2231167 g3886 i0 98.6 15.1362725450902 500 5 100 2 1 499 146 644 Guttulinopsis sp. isolate STA small subunit ribosomal RNA gene, partial sequence blastn 7553 889 0.993250843644544 Eukaryota Sar   Cercozoa     Guttulinopsidae Guttulinopsis Guttulinopsis sp.

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