RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA352850" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA352850 · 4 ✖

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
2946588 2946588 PRJNA352850_P_NODE_50863_length_337_cov_2.006944_g48030_i0 PRJNA352850 50863 337 2.006944 6.76340128 Homocognata cf. vulgaris 2231174 SAR_Eukaryotes SAR_Eukaryotes 285 2.88e-72   NTclustered gi|1402550492|gb|MH488778.1| 2231174 g48030 i0 82.44 35.3382789317507 336 50 99 5 4 336 2848 2519 Homocognata cf. vulgaris isolate CGS2A sequence blastn 11909 285 1 Eukaryota Sar   Cercozoa       Homocognata Homocognata cf. vulgaris
18246734 18246734 PRJNA352850_P_NODE_24755_length_558_cov_3.559921_g21938_i0 PRJNA352850 24755 558 3.559921 19.86435918 Lecythium sp. 3678_261K 238773 SAR_Eukaryotes SAR_Eukaryotes 614 5.589999999999998e-171   NTclustered gi|33089893|gb|AY283756.1| 238773 g21938 i0 93.462 76.0286738351254 413 27 74 0 1 413 353 765 Lecythium sp. 3678_261K actin gene, partial cds blastn 42424 614 1 Eukaryota Sar   Cercozoa Thecofilosea Tectofilosida Chlamydophryidae Lecythium Lecythium sp. 3678_261K
20796566 20796566 PRJNA352850_P_NODE_25857_length_541_cov_3.981707_g23035_i0 PRJNA352850 25857 541 3.981707 21.54103487 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 937 0   NTclustered gi|1402550478|gb|MH488764.1| 2231161 g23035 i0 97.974 24.1090573012939 543 5 100 3 1 541 1412 874 Rosculus hawesi isolate MSUPP161R small subunit ribosomal RNA gene, partial sequence blastn 13043 937 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi
22071762 22071762 PRJNA352850_P_NODE_29378_length_496_cov_1.829978_g26551_i0 PRJNA352850 29378 496 1.829978 9.07669088 Rosculus hawesi 2231161 SAR_Eukaryotes SAR_Eukaryotes 917 0   NTclustered gi|1402550477|gb|MH488763.1| 2231161 g26551 i0 100 26.2802419354839 496 0 100 0 1 496 1926 1431 Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence blastn 13035 917 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus hawesi

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