RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA529224", tax_clade = "Sar" 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

  • PRJNA529224 · 5 ✖

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
11317672 11317672 PRJNA529224_S_NODE_1949_length_150_cov_5.024793_g1942_i0 PRJNA529224 1949 150 5.024793 7.5371895 Paulinella 39716 SAR_Eukaryotes SAR_Eukaryotes 169 1.16e-37   NTclustered gi|238617606|gb|FJ973381.1| 39717 g1942 i0 94.495 6.28666666666667 109 6 73 0 1 109 2451 2559 Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence blastn 943 169 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
11976729 11976729 PRJNA529224_S_NODE_1470_length_175_cov_8.657534_g1463_i0 PRJNA529224 1470 175 8.657534 15.1506845 Cercozoa sp. ATCC 50407 981319 SAR_Eukaryotes SAR_Eukaryotes 318 1.32e-82   NTclustered gi|323652741|gb|HQ121438.1| 981319 g1463 i0 99.429 101.057142857143 175 1 100 0 1 175 1588 1414 Cercozoa sp. ATCC 50407 18S small subunit ribosomal RNA gene, partial sequence blastn 17685 318 1 Eukaryota Sar   Cercozoa         Cercozoa sp. ATCC 50407
11976741 11976741 PRJNA529224_S_NODE_1910_length_152_cov_5.081301_g1903_i0 PRJNA529224 1910 152 5.081301 7.72357752 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 191 2.52e-44   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1903 i0 89.542 44.9078947368421 153 13 100 2 1 152 3673 3823 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 6826 191 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
13251861 13251861 PRJNA529224_S_NODE_531_length_266_cov_13.012658_g524_i0 PRJNA529224 531 266 13.012658 34.61367028 uncultured marine cercozoan 329653 SAR_Eukaryotes SAR_Eukaryotes 178 3.849999999999999e-40   NTclustered gi|282952377|emb|FN598310.1| 329653 g524 i0 80 28.5864661654135 250 42 92 8 22 266 767 1013 Uncultured marine cercozoan partial 18S rRNA gene, clone BS10_B7 blastn 7604 178 1 Eukaryota Sar   Cercozoa         uncultured marine cercozoan
14526896 14526896 PRJNA529224_S_NODE_1672_length_162_cov_6.127820_g1665_i0 PRJNA529224 1672 162 6.12782 9.9270684 Gymnophrys sp. ATCC 50923 646463 SAR_Eukaryotes SAR_Eukaryotes 145 2.16e-30   NTclustered gi|238617604|gb|FJ973379.1| 646463 g1665 i0 85.926 96.0432098765432 135 19 83 0 28 162 1945 2079 Gymnophrys sp. ATCC 50923 28S ribosomal RNA gene, partial sequence blastn 15559 145 1 Eukaryota Sar   Cercozoa       Gymnophrys Gymnophrys sp. ATCC 50923

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