RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1197996 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
10527537 10527537 PRJNA1197996_S_NODE_1089_length_693_cov_5.490323_g1046_i0 PRJNA1197996 1089 693 5.490323 38.04793839 Berkeleya fennica 1577906 SAR_Eukaryotes SAR_Eukaryotes 86.1 6.82e-12   NTclustered gi|746001744|ref|NC_026126.1| 1577906 g1046 i0 86.842 3.16017316017316 76 10 11 0 557 632 34837 34762 Berkeleya fennica mitochondrion, complete genome blastn 2190 86.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Berkeleyaceae Berkeleya Berkeleya fennica
10528022 10528022 PRJNA1197996_S_NODE_3389_length_469_cov_7.752525_g3335_i0 PRJNA1197996 3389 469 7.752525 36.35934225 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 265 5.38e-66   NTclustered gi|657012511|gb|KF302595.1| 2850 g3335 i0 88.889 4.27078891257996 216 22 46 2 255 469 298 84 Phaeodactylum tricornutum clone C854 ubiquitin-ribosomal protein fusion S27a mRNA, partial cds blastn 2003 265 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
16900949 16900949 PRJNA1197996_S_NODE_1254_length_659_cov_4.068259_g1209_i0 PRJNA1197996 1254 659 4.068259 26.80982681 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 604 4.019999999999999e-168   NTclustered gi|657012562|gb|KF302618.1| 2850 g1209 i0 88.956 51.2352048558422 498 44 75 7 166 656 21 514 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 33764 604 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
22000593 22000593 PRJNA1197996_S_NODE_1378_length_636_cov_10.371226_g1332_i0 PRJNA1197996 1378 636 10.371226 65.96099736 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 403 1.5099999999999994e-107   NTclustered gi|657012465|gb|KF302574.1| 2850 g1332 i0 87.791 36.187106918239 344 42 54 0 122 465 344 1 Phaeodactylum tricornutum clone C567 ribosomal protein mRNA, partial cds blastn 23015 403 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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