RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA675042 · 8 ✖

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
9575577 9575577 PRJNA675042_P_NODE_42448_length_339_cov_0.842105_g41998_i0 PRJNA675042 42448 339 0.842105 2.85473595 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.002   NTclustered gi|75756243|gb|DQ158856.1| 227086 g41998 i0 100 0.265486725663717 30 0 9 0 65 94 104160 104131 Bigelowiella natans nucleomorph chromosome 1, complete sequence blastn 90 56.5 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
14675320 14675320 PRJNA675042_P_NODE_14632_length_447_cov_10.256684_g14182_i0 PRJNA675042 14632 447 10.256684 45.84737748 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 704 0   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g14182 i0 100 9.78747203579418 381 0 98 0 8 388 402 22 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 4375 704 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
18499205 18499205 PRJNA675042_P_NODE_36915_length_351_cov_3.266187_g36465_i0 PRJNA675042 36915 351 3.266187 11.46431637 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 551 2.6799999999999993e-152   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g36465 i0 97.531 39.7350427350427 324 4 100 4 29 351 1663 1983 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 13947 551 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
19772953 19772953 PRJNA675042_P_NODE_132156_length_248_cov_0.880000_g131706_i0 PRJNA675042 132156 248 0.88 2.1824 Partenskyella glossopodia 552666 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.022   NTclustered gi|1011058031|ref|NC_029742.1| 552666 g131706 i0 100 0.112903225806452 28 0 11 0 32 59 72224 72251 Partenskyella glossopodia plastid DNA, complete sequence, strain: RCC365 blastn 28 52.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Partenskyella Partenskyella glossopodia
21049315 21049315 PRJNA675042_P_NODE_27777_length_380_cov_1.299674_g27327_i0 PRJNA675042 27777 380 1.299674 4.9387612 Lotharella vacuolata 74820 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.036   NTclustered gi|893149157|dbj|AB996600.1| 74820 g27327 i0 100 0.0736842105263158 28 0 7 0 15 42 16122 16095 Lotharella vacuolata nucleomorph DNA, chromosome: 2, complete sequence, strain: CCMP240 blastn 28 52.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella vacuolata
21050194 21050194 PRJNA675042_P_NODE_9757_length_505_cov_5.875000_g9310_i0 PRJNA675042 9757 505 5.875 29.66875 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 861 0   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g9310 i0 98.182 9.70891089108911 495 5 98 2 12 504 1103 611 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 4903 861 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
23599476 23599476 PRJNA675042_P_NODE_20459_length_410_cov_3.507418_g20009_i0 PRJNA675042 20459 410 3.507418 14.3804138 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 333 1.26e-86   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g20009 i0 83.646 32.2170731707317 373 42 100 14 1 366 2552 2192 Rosculus vulgaris isolate CCA sequence blastn 13209 333 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
30504536 30504536 PRJNA675042_P_NODE_35933_length_354_cov_1.096085_g35483_i0 PRJNA675042 35933 354 1.096085 3.8801409 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.76e-6   NR MES1907809.1 1215613 g35483 i0 62.8 2.27966101694915 43 16 36.4 0 185 313 106 148 MES1907809.1 ABC transporter E member 2 [Cercozoa sp. M6MM] diamond 807 56.6 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);;