RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 9 ✖

tax_clade 1

bioproject 1

  • PRJEB12237 · 9 ✖

analysis 1

  • blastn · 9 ✖

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
1294910 1294910 PRJEB12237_P_NODE_4122_length_317_cov_9.262411_g3926_i0 PRJEB12237 4122 317 9.262411 29.36184287 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 459 1.5000000000000002e-124   NTclustered gi|197723521|gb|EF681900.2| 458884 g3926 i0 99.602 100.085173501577 251 1 79 0 1 251 251 1 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 31727 459 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
2570596 2570596 PRJEB12237_P_NODE_5543_length_253_cov_4.866972_g5347_i0 PRJEB12237 5543 253 4.866972 12.31343916 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 462 8.95e-126   NTclustered gi|197723521|gb|EF681900.2| 458884 g5347 i0 99.605 100.901185770751 253 1 100 0 1 253 970 718 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 25528 462 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
5123052 5123052 PRJEB12237_P_NODE_2285_length_468_cov_4.561201_g2090_i0 PRJEB12237 2285 468 4.561201 21.34642068 Bodomorpha sp. HFCC 92 458884 SAR_Eukaryotes SAR_Eukaryotes 813 0   NTclustered gi|197723521|gb|EF681900.2| 458884 g2090 i0 98.073 22.792735042735 467 9 99 0 2 468 713 247 Bodomorpha sp. HFCC 92 28S ribosomal RNA gene, partial sequence blastn 10667 813 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
12464741 12464741 PRJEB12237_P_NODE_6730_length_220_cov_1.864865_g6534_i0 PRJEB12237 6730 220 1.864865 4.102703 Cercozoa 136419 SAR_Eukaryotes SAR_Eukaryotes 274 3.82e-69   NTclustered gi|238617606|gb|FJ973381.1| 39717 g6534 i0 89.545 100.168181818182 220 17 100 3 1 220 2877 2664 Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence blastn 22037 274 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
15322853 15322853 PRJEB12237_P_NODE_2833_length_412_cov_5.925729_g2637_i0 PRJEB12237 2833 412 5.925729 24.41400348 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 285 3.59e-72   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g2637 i0 81.283 36.1601941747573 374 51 90 11 41 412 4021 3665 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 14898 285 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
20421359 20421359 PRJEB12237_P_NODE_6777_length_219_cov_2.472826_g6581_i0 PRJEB12237 6777 219 2.472826 5.41548894 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 252 1.78e-62   NTclustered gi|238617602|gb|FJ973377.1| 188950 g6581 i0 87.444 52.4703196347032 223 22 100 6 1 219 2689 2909 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 11491 252 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
22662555 22662555 PRJEB12237_P_NODE_6238_length_232_cov_3.934010_g6042_i0 PRJEB12237 6238 232 3.93401 9.1269032 Bodomorpha 188949 SAR_Eukaryotes SAR_Eukaryotes 429 8.2e-116   NTclustered gi|225216798|gb|FJ176713.1| 458884 g6042 i0 100 100.512931034483 232 0 100 0 1 232 132 363 Bodomorpha sp. HFCC92 18S ribosomal RNA gene, partial sequence blastn 23319 429 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha sp. HFCC 92
22972629 22972629 PRJEB12237_P_NODE_10379_length_164_cov_2.620155_g10183_i0 PRJEB12237 10379 164 2.620155 4.2970542 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 231 1.6399999999999998e-56   NTclustered gi|238617605|gb|FJ973380.1| 45107 g10183 i0 92.121 101.390243902439 165 11 100 2 1 164 1023 1186 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 16628 231 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
24246455 24246455 PRJEB12237_P_NODE_10080_length_168_cov_1.037594_g9884_i0 PRJEB12237 10080 168 1.037594 1.74315792 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 189 1.0299999999999998e-43   NTclustered gi|300521445|gb|GQ377709.1| 323453 g9884 i0 87.059 95.3273809523809 170 18 100 4 1 168 502 669 Heteromita sp. PRA-74 14-3-3 protein-like mRNA, partial sequence blastn 16015 189 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74

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