RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1009807" and tax_clade = "core chlorophytes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • core chlorophytes · 4 ✖

bioproject 1

  • PRJNA1009807 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
2276523 2276523 PRJNA1009807_S_NODE_1222_length_274_cov_12.791489_g1194_i0 PRJNA1009807 1222 274 12.791489 35.04867986 Eukaryota 2759 Plants Plants 211 3.92e-50   NTclustered gi|371782091|emb|HE610123.1| 3107 g1194 i0 92.157 55.8394160583942 153 7 56 4 1 153 4979 5126 Hydrodictyon reticulatum 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain M2243 blastn 15300 211 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Sphaeropleales Hydrodictyaceae Hydrodictyon Hydrodictyon reticulatum
9929418 9929418 PRJNA1009807_S_NODE_688_length_353_cov_24.519108_g660_i0 PRJNA1009807 688 353 24.519108 86.55245124 Eukaryota 2759 Plants Plants 643 4.329999999999998e-180   NTclustered gi|1714003650|gb|MN243923.1| 3079 g660 i0 99.715 99.3031161473088 351 1 99 0 3 353 887 537 Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence blastn 35054 645 0.996899224806202 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Chlorella Chlorella sp.
18006551 18006551 PRJNA1009807_S_NODE_2615_length_196_cov_1.815287_g2587_i0 PRJNA1009807 2615 196 1.815287 3.55796252 Caulerpa sertularioides 76315 Plants Plants 76.8 1.01e-9   NTclustered gi|1799633313|gb|MK792750.1| 148953 g2587 i0 87.692 2.13265306122449 65 8 33 0 32 96 9400 9336 Caulerpa sertularioides f. longipes chloroplast, complete genome blastn 418 76.8 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Bryopsidales Caulerpaceae Caulerpa Caulerpa sertularioides
22678234 22678234 PRJNA1009807_S_NODE_4158_length_162_cov_3.634146_g4130_i0 PRJNA1009807 4158 162 3.634146 5.88731652 Pedinomonas 3158 Plants Plants 134 4.6800000000000005e-27   NTclustered gi|371782136|emb|HE610168.1| 160064 g4130 i0 91.753 91.1111111111111 97 7 59 1 65 160 2528 2624 Pedinomonas tuberculata plastid 16S rRNA gene (partial), 23S rRNA gene (partial), tRNA-Ile gene, tRNA-Ala gene and ITS1, strain SAG 42.84 blastn 14760 134 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Pedinophyceae Pedinomonadales Pedinomonadaceae Pedinomonas Pedinomonas tuberculata

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