RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1134759" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA1134759 · 15 ✖

analysis 1

  • blastn · 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
2834714 2834714 PRJNA1134759_P_NODE_13363_length_432_cov_45.715877_g13187_i0 PRJNA1134759 13363 432 45.715877 197.49258864 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 8.96e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g13187 i0 100 0.203703703703704 31 0 7 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
2834901 2834901 PRJNA1134759_P_NODE_5943_length_620_cov_10.663620_g5775_i0 PRJNA1134759 5943 620 10.66362 66.114444 Acineta flava 1003325 SAR_Eukaryotes SAR_Eukaryotes 117 2.1500000000000003e-21   NTclustered gi|328684895|gb|HM122011.1| 1003325 g5775 i0 86.792 17.1209677419355 106 13 17 1 227 332 347 243 Acineta flava isolate SNK10010701 macronuclear blastn 10615 117 1 Eukaryota Sar   Ciliophora Phyllopharyngea Endogenida Acinetidae Acineta Acineta flava
2834905 2834905 PRJNA1134759_P_NODE_6843_length_585_cov_2.470703_g6671_i0 PRJNA1134759 6843 585 2.470703 14.45361255 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 0.001   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g6671 i0 100 0.181196581196581 31 0 5 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 106 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
4111163 4111163 PRJNA1134759_P_NODE_34004_length_291_cov_1.935780_g33828_i0 PRJNA1134759 34004 291 1.93578 5.6331198 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 5.79e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g33828 i0 100 0.302405498281787 31 0 11 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
4111250 4111250 PRJNA1134759_P_NODE_57984_length_232_cov_2.333333_g57808_i0 PRJNA1134759 57984 232 2.333333 5.41333256 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.46e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g57808 i0 100 0.379310344827586 31 0 13 0 196 226 31 1 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
6662097 6662097 PRJNA1134759_P_NODE_58026_length_231_cov_7.151899_g57850_i0 PRJNA1134759 58026 231 7.151899 16.52088669 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.44e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g57850 i0 100 0.380952380952381 31 0 13 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
9212182 9212182 PRJNA1134759_P_NODE_40288_length_272_cov_3.929648_g40112_i0 PRJNA1134759 40288 272 3.929648 10.68864256 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 5.36e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g40112 i0 100 0.323529411764706 31 0 11 0 236 266 31 1 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
13785230 13785230 PRJNA1134759_P_NODE_13171_length_435_cov_3.331492_g12995_i0 PRJNA1134759 13171 435 3.331492 14.4919902 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 100 1.48e-16   NTclustered gi|2862228911|gb|PQ645545.1| 426632 g12995 i0 86.17 15.7080459770115 94 11 22 2 22 115 2277 2368 Chaetoceros diadema isolate AGSB0427 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 6833 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros diadema
14313033 14313033 PRJNA1134759_P_NODE_30212_length_305_cov_5.456897_g30036_i0 PRJNA1134759 30212 305 5.456897 16.64353585 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 6.11e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g30036 i0 100 0.288524590163934 31 0 10 0 269 299 31 1 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
15059594 15059594 PRJNA1134759_P_NODE_59712_length_197_cov_6.088710_g59536_i0 PRJNA1134759 59712 197 6.08871 11.9947587 Karyorelictea 33827 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.005   NTclustered gi|2261268989|emb|OX095830.1| 2930470 g59536 i0 100 0.436548223350254 29 0 15 0 1 29 1 29 Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) blastn 86 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Kentrophoridae Kentrophoros Kentrophoros sp. 1 BS-2022
15587121 15587121 PRJNA1134759_P_NODE_57673_length_234_cov_5.826087_g57497_i0 PRJNA1134759 57673 234 5.826087 13.63304358 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.5e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g57497 i0 100 0.376068376068376 31 0 13 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
18135966 18135966 PRJNA1134759_P_NODE_56755_length_241_cov_12.636905_g56579_i0 PRJNA1134759 56755 241 12.636905 30.45494105 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.66e-4   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g56579 i0 100 0.365145228215768 31 0 13 0 7 37 1 31 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 88 58.4 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
19409995 19409995 PRJNA1134759_P_NODE_17336_length_385_cov_1.958333_g17160_i0 PRJNA1134759 17336 385 1.958333 7.53958205 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.003   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g17160 i0 100 0.150649350649351 30 0 8 0 350 379 30 1 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 58 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
23236482 23236482 PRJNA1134759_P_NODE_4099_length_730_cov_2.003044_g3951_i0 PRJNA1134759 4099 730 2.003044 14.6222212 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 63.9 3.38e-5   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g3951 i0 97.368 0.0520547945205479 38 0 5 1 687 724 37 1 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 38 63.9 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
24510165 24510165 PRJNA1134759_P_NODE_59020_length_217_cov_19.548611_g58844_i0 PRJNA1134759 59020 217 19.548611 42.42048587 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.001   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g58844 i0 100 0.267281105990783 30 0 14 0 7 36 1 30 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 58 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022

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