RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA526367" and tax_clade = "Haptista"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Haptista · 3 ✖

bioproject 1

  • PRJNA526367 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
4322840 4322840 PRJNA526367_P_NODE_34824_length_200_cov_12.324503_g34614_i0 PRJNA526367 34824 200 12.324503 24.649006 Emiliania huxleyi 2903 Haptophyta other_Eukaryota 244 2.67e-60   NTclustered gi|551569863|ref|XM_005770835.1| 280463 g34614 i0 91.304 6.53 184 8 88 2 18 193 736 919 Emiliania huxleyi CCMP1516 hypothetical protein mRNA blastn 1306 244 1 Eukaryota Haptista   Haptophyta   Isochrysidales Noelaerhabdaceae Emiliania Emiliania huxleyi
17073186 17073186 PRJNA526367_P_NODE_3334_length_367_cov_3.433962_g3128_i0 PRJNA526367 3334 367 3.433962 12.60264054 Haptophyta environmental samples 171259 Haptophyta other_Eukaryota 265 4.1099999999999995e-66   NTclustered gi|311909458|gb|HQ446272.1| 171259 g3128 i0 100 64.5885558583106 143 0 64 0 1 143 1620 1478 Uncultured haptophyte clone BrayaSo_water_18S 18S ribosomal RNA gene, partial sequence blastn 23704 265 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples
25340260 25340260 PRJNA526367_P_NODE_4880_length_332_cov_3.985866_g4671_i0 PRJNA526367 4880 332 3.985866 13.23307512 Emiliania 2902 Haptophyta other_Eukaryota 235 2.8899999999999996e-57   NTclustered gi|1706993689|gb|MN194619.1| 171259 g4671 i0 99.237 70.7259036144578 131 0 74 1 196 325 291 161 Haptophyta environmental samples clone cvl2 small subunit ribosomal RNA gene, partial sequence blastn 23481 235 1 Eukaryota Haptista   Haptophyta         Haptophyta environmental samples

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