RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1035005" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA1035005 · 5 ✖

analysis 1

  • blastn · 5 ✖

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
2719039 2719039 PRJNA1035005_P_NODE_10183_length_362_cov_1.605536_g9778_i0 PRJNA1035005 10183 362 1.605536 5.81204032 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 652 0   NTclustered gi|817491030|gb|KP273902.1| 175275 g9778 i0 99.171 99.5082872928177 362 3 100 0 1 362 17 378 Uncultured cercozoan clone EHUR-35 18S ribosomal RNA gene, partial sequence blastn 36022 652 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
3995315 3995315 PRJNA1035005_P_NODE_33004_length_278_cov_2.658537_g32598_i0 PRJNA1035005 33004 278 2.658537 7.39073286 Paulinella chromatophora 39717 SAR_Eukaryotes SAR_Eukaryotes 126 1.49e-24   NTclustered gi|238617606|gb|FJ973381.1| 39717 g32598 i0 86.441 29.3201438848921 118 13 42 2 102 218 1937 1822 Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence blastn 8151 126 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
6546759 6546759 PRJNA1035005_P_NODE_20186_length_299_cov_3.867257_g19780_i0 PRJNA1035005 20186 299 3.867257 11.56309843 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 303 6.95e-78   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g19780 i0 85.382 51.5819397993311 301 34 99 10 1 296 3713 4008 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 15423 303 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
19294747 19294747 PRJNA1035005_P_NODE_5576_length_450_cov_1.843501_g5176_i0 PRJNA1035005 5576 450 1.843501 8.2957545 Protaspis grandis 361427 SAR_Eukaryotes SAR_Eukaryotes 638 2.63e-178   NTclustered gi|290760486|gb|GQ144689.1| 361427 g5176 i0 92.222 100.748888888889 450 35 100 0 1 450 2106 1657 Protaspis grandis large subunit ribosomal RNA gene, partial sequence blastn 45337 638 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Protaspis Protaspis grandis
24394824 24394824 PRJNA1035005_P_NODE_29920_length_282_cov_3.196172_g29514_i0 PRJNA1035005 29920 282 3.196172 9.01320504 Amorphochlora amoebiformis 1561963 SAR_Eukaryotes SAR_Eukaryotes 300 8.41e-77   NTclustered gi|33346934|gb|AY251797.1| 1561963 g29514 i0 88.889 81.1950354609929 243 27 86 0 40 282 227 469 Lotharella amoeboformis ubiquitin/actin fusion protein 2 gene, partial cds blastn 22897 300 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Amorphochlora Amorphochlora amoebiformis

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