RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA1067370 · 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
4007086 4007086 PRJNA1067370_P_NODE_12624_length_516_cov_1.173815_g12077_i0 PRJNA1067370 12624 516 1.173815 6.0568854 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 433 1.54e-116   NTclustered gi|300676716|gb|GQ377714.1| 323453 g12077 i0 85.577 57.7151162790698 416 56 81 3 16 431 43 454 Heteromita sp. PRA-74 rps22a (rps22a) mRNA, complete cds blastn 29781 433 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
4007273 4007273 PRJNA1067370_P_NODE_34704_length_336_cov_2.920152_g34156_i0 PRJNA1067370 34704 336 2.920152 9.81171072 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 424 5.83e-114   NTclustered gi|238617602|gb|FJ973377.1| 188950 g34156 i0 91.935 70.7708333333333 310 14 90 10 34 336 2735 3040 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 23779 424 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
5283559 5283559 PRJNA1067370_P_NODE_24225_length_387_cov_3.184713_g23677_i0 PRJNA1067370 24225 387 3.184713 12.32483931 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 453 8.67e-123   NTclustered gi|238617666|gb|FJ973412.1| 188950 g23677 i0 99.203 36.9560723514212 251 2 65 0 1 251 251 1 Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds blastn 14302 453 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
5283683 5283683 PRJNA1067370_P_NODE_42285_length_312_cov_2.949791_g41737_i0 PRJNA1067370 42285 312 2.949791 9.20334792 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 337 7.189999999999998e-88   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g41737 i0 86.538 45.9583333333333 312 35 99 6 1 310 3703 4009 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 14339 337 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
6558747 6558747 PRJNA1067370_P_NODE_37726_length_326_cov_1.624506_g37178_i0 PRJNA1067370 37726 326 1.624506 5.29588956 uncultured freshwater cercozoan 356913 SAR_Eukaryotes SAR_Eukaryotes 603 6.749999999999998e-168   NTclustered gi|82470150|gb|DQ243993.1| 356913 g37178 i0 100 98.4325153374233 326 0 100 0 1 326 379 54 Uncultured freshwater cercozoan clone PCH11AU2004 18S ribosomal RNA gene, partial sequence blastn 32089 603 1 Eukaryota Sar   Cercozoa         uncultured freshwater cercozoan
9108266 9108266 PRJNA1067370_P_NODE_17068_length_450_cov_4.992042_g16520_i0 PRJNA1067370 17068 450 4.992042 22.464189 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 466 1.31e-126   NTclustered gi|238617630|gb|FJ973394.1| 188950 g16520 i0 85.398 100.317777777778 452 62 100 4 1 450 788 339 Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds blastn 45143 466 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
10384176 10384176 PRJNA1067370_P_NODE_46749_length_304_cov_7.086580_g46201_i0 PRJNA1067370 46749 304 7.08658 21.5432032 Cercomonas agilis 310805 SAR_Eukaryotes SAR_Eukaryotes 316 9.099999999999999e-82   NTclustered gi|58414956|gb|AY748813.1| 310805 g46201 i0 86.667 151.736842105263 285 38 94 0 20 304 285 1 Cercomonas agilis polyubiquitin (UBQ) gene, partial cds blastn 46128 316 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas agilis
11659391 11659391 PRJNA1067370_P_NODE_3050_length_979_cov_3.246137_g2641_i0 PRJNA1067370 3050 979 3.246137 31.77968123 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 1456 0   NTclustered gi|302026154|gb|GQ377660.1| 188950 g2641 i0 99.624 88.8855975485189 797 3 81 0 1 797 97 893 Bodomorpha minima beta-tubulin (Btub) gene, partial cds blastn 87019 1456 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
12934426 12934426 PRJNA1067370_P_NODE_1871_length_1199_cov_2.601243_g1559_i0 PRJNA1067370 1871 1199 2.601243 31.18890357 Paulinella chromatophora 39717 SAR_Eukaryotes SAR_Eukaryotes 634 9.549999999999999e-177   NTclustered gi|302563026|dbj|AB546336.1| 39717 g1559 i0 77.514 30.9874895746455 1094 219 90 21 1 1082 193 1271 Paulinella chromatophora EF-1a mRNA for elongation factor 1alpha, partial cds blastn 37154 634 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
16315803 16315803 PRJNA1067370_S_NODE_6373_length_241_cov_1.613095_g6347_i0 PRJNA1067370 6373 241 1.613095 3.88755895 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.8 1.29e-9   NTclustered gi|1915674182|emb|LR867801.1| 1395131 g6347 i0 97.727 178.701244813278 44 1 18 0 113 156 257 214 uncultured Cercomonas partial 18S rRNA gene blastn 43067 76.8 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae   uncultured Cercomonas
16757876 16757876 PRJNA1067370_P_NODE_5694_length_741_cov_3.766467_g5196_i0 PRJNA1067370 5694 741 3.766467 27.90952047 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 819 0   NTclustered gi|33089893|gb|AY283756.1| 238773 g5196 i0 92.083 85.1484480431849 581 46 78 0 161 741 768 188 Lecythium sp. 3678_261K actin gene, partial cds blastn 63095 819 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
19306759 19306759 PRJNA1067370_P_NODE_8556_length_617_cov_2.672794_g8027_i0 PRJNA1067370 8556 617 2.672794 16.49113898 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 422 4.05e-113   NTclustered gi|238617636|gb|FJ973397.1| 45107 g8027 i0 84.259 76.6288492706645 432 68 70 0 186 617 1077 646 Heteromita globosa strain ATCC 50780 actin (act) gene, partial cds blastn 47280 422 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
21857461 21857461 PRJNA1067370_P_NODE_13078_length_508_cov_1.239080_g12531_i0 PRJNA1067370 13078 508 1.23908 6.2945264 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 588 3.059999999999999e-163   NTclustered gi|33089893|gb|AY283756.1| 238773 g12531 i0 90.868 88.4074803149606 438 40 86 0 71 508 768 331 Lecythium sp. 3678_261K actin gene, partial cds blastn 44911 588 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
23133310 23133310 PRJNA1067370_P_NODE_63919_length_274_cov_1.149254_g63370_i0 PRJNA1067370 63919 274 1.149254 3.14895596 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 507 4.47e-139   NTclustered gi|238617602|gb|FJ973377.1| 188950 g63370 i0 100 1 274 0 100 0 1 274 527 800 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 274 507 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
24406839 24406839 PRJNA1067370_P_NODE_51020_length_294_cov_1.669683_g50471_i0 PRJNA1067370 51020 294 1.669683 4.90886802 Cercomonas sp. ATCC 50316 45110 SAR_Eukaryotes SAR_Eukaryotes 110 1.6e-19   NTclustered gi|27734378|gb|AY099144.1| 45110 g50471 i0 90.361 7.13605442176871 83 8 28 0 210 292 207 125 Cercomonas ATCC50316 isolate pub6 polyubiquitin gene, partial cds blastn 2098 110 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. ATCC 50316

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