RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA771359" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA771359 · 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
15235251 15235251 PRJNA771359_S_NODE_392_length_479_cov_19.742081_g314_i0 PRJNA771359 392 479 19.742081 94.56456799 Eukaryota 2759 Plants Plants 863 0   NTclustered gi|1201359271|gb|MF040793.1| 3078 g314 i0 99.165 100.985386221294 479 4 100 0 1 479 530 52 Auxenochlorella pyrenoidosa isolate HITH6 18S ribosomal RNA gene, partial sequence blastn 48372 869 0.993095512082854 Eukaryota core chlorophytes Viridiplantae Chlorophyta Trebouxiophyceae Chlorellales Chlorellaceae Auxenochlorella Auxenochlorella pyrenoidosa
16049634 16049634 PRJNA771359_S_NODE_2633_length_206_cov_2.556213_g2550_i0 PRJNA771359 2633 206 2.556213 5.26579878 Pyramimonas sp. HV-2008 498058 Plants Plants 191 3.66e-44   NTclustered gi|166236044|gb|EU375499.1| 498058 g2550 i0 93.798 61.2135922330097 129 5 63 3 48 176 445 320 Pyramimonas sp. HV-2008 28S ribosomal RNA gene, partial sequence blastn 12610 191 1 Eukaryota   Viridiplantae Chlorophyta Pyramimonadophyceae Pyramimonadales Pyramimonadaceae Pyramimonas Pyramimonas sp. HV-2008
17325361 17325361 PRJNA771359_S_NODE_234_length_592_cov_25.041441_g161_i0 PRJNA771359 234 592 25.041441 148.24533072 Aegagropila linnaei 162062 Plants Plants 654 0   NTclustered gi|1279575452|gb|MF683076.1| 162062 g161 i0 88.951 202.491554054054 534 54 90 4 61 592 2875 2345 Aegagropila linnaei 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast blastn 119875 654 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Cladophorales Pithophoraceae Aegagropila Aegagropila linnaei
21149649 21149649 PRJNA771359_S_NODE_4597_length_158_cov_9.090909_g4514_i0 PRJNA771359 4597 158 9.090909 14.36363622 Pandorina colemaniae 47786 Plants Plants 82.4 1.67e-11   NTclustered gi|1808706812|gb|MH511720.1| 47786 g4514 i0 90.323 14.5316455696203 62 6 39 0 97 158 25235 25174 Pandorina colemaniae ATP synthase CF1 epsilon subunit (atpE), 30S ribosomal protein S7 (rps7), ribosomal protein S14 (rps14), M protein of photosystem II (psbM), Z protein of photosystem II (psbZ), cytochrome c biogenesis protein (ccsA), photosystem I P700 apoprotein A1 (psaA), photosystem II CP47 chlorophyll apoprotein (psbB), protochlorophyllide reductase subunit N (chlN), ribosomal protein L2 (rpl2), ribosomal protein S19 (rps19), ribosomal protein L16 (rpl16), ribosomal protein L14 (rpl14), ribosomal protein L5 (rpl5), ribosomal protein S8 (rps8), and ribosomal protein S4 (rps4) genes, complete cds; plastid blastn 2296 82.4 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Volvocaceae Pandorina Pandorina colemaniae

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