RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA488043", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 12 ✖

tax_clade 1

  • Sar · 12 ✖

bioproject 1

  • PRJNA488043 · 12 ✖

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
450101 450101 PRJNA488043_S_NODE_1021_length_188_cov_12.113208_g1010_i0 PRJNA488043 1021 188 12.113208 22.77283104 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 346 6.6e-91   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g1010 i0 100 5.30851063829787 187 0 99 0 2 188 520 334 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 998 346 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
1724468 1724468 PRJNA488043_P_NODE_10762_length_315_cov_29.335664_g8521_i0 PRJNA488043 10762 315 29.335664 92.4073416 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 243 1.6300000000000004e-59   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g8521 i0 82.686 28.650793650793705 283 39 88 10 38 315 4039 3762 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 9025 243 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
1724757 1724757 PRJNA488043_S_NODE_422_length_284_cov_7.768627_g411_i0 PRJNA488043 422 284 7.768627 22.06290068 Rosculus piscicus 2231164 SAR_Eukaryotes SAR_Eukaryotes 464 2.8399999999999998e-126   NTclustered gi|1402550472|gb|MH488758.1| 2231164 g411 i0 97.778 42.4507042253521 270 4 95 2 14 282 1180 912 Rosculus piscicus isolate GS5C small subunit ribosomal RNA gene, partial sequence blastn 12056 464 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus piscicus
9377662 9377662 PRJNA488043_P_NODE_16368_length_209_cov_4.655556_g14126_i0 PRJNA488043 16368 209 4.655556 9.73011204 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 185 1.7299999999999994e-42   NTclustered gi|238617605|gb|FJ973380.1| 45107 g14126 i0 82.791 31.3157894736842 215 29 100 5 1 209 1881 1669 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 6545 185 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
9377745 9377745 PRJNA488043_P_NODE_22128_length_153_cov_2.491935_g19886_i0 PRJNA488043 22128 153 2.491935 3.81266055 Cercomonas sp. 1979794 SAR_Eukaryotes SAR_Eukaryotes 84.2 4.44e-12   NTclustered gi|2651357801|gb|PP174314.1| 1979794 g19886 i0 80.909 6.26143790849673 110 17 72 4 1 110 3938 4043 Cercomonas sp. isolate P5 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 958 84.2 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp.
13203664 13203664 PRJNA488043_S_NODE_1411_length_163_cov_3.977612_g1400_i0 PRJNA488043 1411 163 3.977612 6.48350756 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 289 9.51e-74   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g1400 i0 99.371 6.12883435582822 159 1 98 0 5 163 885 727 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 999 289 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
15752713 15752713 PRJNA488043_S_NODE_533_length_256_cov_5.669604_g522_i0 PRJNA488043 533 256 5.669604 14.51418624 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 473 4.189999999999999e-129   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g522 i0 100 12.5390625 256 0 100 0 1 256 498 753 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 3210 473 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
18301382 18301382 PRJNA488043_P_NODE_11455_length_296_cov_7.498127_g9214_i0 PRJNA488043 11455 296 7.498127 22.19445592 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 497 2.9399999999999994e-136   NTclustered gi|238617605|gb|FJ973380.1| 45107 g9214 i0 96.97 93.8716216216216 297 8 100 1 1 296 1575 1279 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 27786 497 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
19575818 19575818 PRJNA488043_S_NODE_336_length_309_cov_10.546429_g325_i0 PRJNA488043 336 309 10.546429 32.58846561 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 571 1.7899999999999995e-158   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g325 i0 100 3.00970873786408 309 0 100 0 1 309 351 43 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 930 571 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
20224456 20224456 PRJNA488043_P_NODE_9936_length_342_cov_1.993610_g7697_i0 PRJNA488043 9936 342 1.99361 6.8181462 Sandona 1239209 SAR_Eukaryotes SAR_Eukaryotes 577 4.31e-160   NTclustered gi|2163362299|dbj|LC663795.1| 563755 g7697 i0 96.866 90.719298245614 351 0 99 1 3 342 944 594 Sandona mutans Flagella An1019C gene for 18S rRNA, partial sequence blastn 31026 577 1 Eukaryota Sar   Cercozoa   Glissomonadida Sandonidae Sandona Sandona mutans
23402325 23402325 PRJNA488043_S_NODE_139_length_419_cov_7.820513_g128_i0 PRJNA488043 139 419 7.820513 32.76794947 Rosculus sp. VDelafont-2023a 3079709 SAR_Eukaryotes SAR_Eukaryotes 584 3.219999999999999e-162   NTclustered gi|2589370978|gb|OR644361.1| 3079709 g128 i0 91.885 6.47732696897375 419 33 99 1 2 419 56 474 Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence blastn 2714 584 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp. VDelafont-2023a
24676031 24676031 PRJNA488043_S_NODE_440_length_278_cov_6.172691_g429_i0 PRJNA488043 440 278 6.172691 17.16008098 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 307 4.95e-79   NTclustered gi|238617605|gb|FJ973380.1| 45107 g429 i0 93.301 67.8956834532374 209 12 75 2 71 278 1679 1472 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 18875 307 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa

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