RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1197996" and tax_phylum = "Chlorophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorophyta · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1197996 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
1598761 1598761 PRJNA1197996_S_NODE_2482_length_520_cov_14.579418_g2431_i0 PRJNA1197996 2482 520 14.579418 75.8129736 Micromonas commoda 296587 Plants Plants 309 2.7400000000000005e-79   NTclustered gi|255088120|ref|XM_002505937.1| 296587 g2431 i0 82.768 66.4365384615385 354 54 68 6 163 514 1465 1117 Micromonas commoda adenosylhomocysteinase partial mRNA blastn 34547 309 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
7977634 7977634 PRJNA1197996_S_NODE_4507_length_428_cov_3.678873_g4453_i0 PRJNA1197996 4507 428 3.678873 15.74557644 Micromonas commoda 296587 Plants Plants 148 5.119999999999999e-31   NTclustered gi|255072432|ref|XM_002499845.1| 296587 g4453 i0 79.902 13.7429906542056 204 39 47 2 226 428 1183 981 Micromonas commoda predicted protein partial mRNA blastn 5882 148 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
8696565 8696565 PRJNA1197996_S_NODE_1367_length_638_cov_5.950442_g1321_i0 PRJNA1197996 1367 638 5.950442 37.96381996 root 1 Root_unresolved Root_unresolved 134 2.2e-26   NTclustered gi|255077919|ref|XM_002502494.1| 296587 g1321 i0 86.667 3.0282131661442 120 16 19 0 513 632 2193 2074 Micromonas commoda H+-translocating pyrophosphatase family partial mRNA blastn 1932 134 1 Eukaryota   Viridiplantae Chlorophyta Mamiellophyceae Mamiellales Mamiellaceae Micromonas Micromonas commoda
10528048 10528048 PRJNA1197996_S_NODE_4389_length_432_cov_2.743733_g4335_i0 PRJNA1197996 4389 432 2.743733 11.85292656 Chlamydomonas reinhardtii 3055 Plants Plants 126 2.4199999999999998e-24   NTclustered gi|2082241335|ref|XM_001695651.2| 3055 g4335 i0 86.726 0.456018518518519 113 15 26 0 320 432 1890 1778 Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g146527v5), mRNA blastn 197 126 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Chlorophyceae Chlamydomonadales Chlamydomonadaceae Chlamydomonas Chlamydomonas reinhardtii
14352901 14352901 PRJNA1197996_S_NODE_15612_length_290_cov_1.433180_g15558_i0 PRJNA1197996 15612 290 1.43318 4.156222 Rhexinema sarcinoideum 43261 Plants Plants 466 8.09e-127   NTclustered gi|1052423652|gb|KX306821.1| 43261 g15558 i0 95.833 104.7 288 12 99 0 1 288 4365 4078 Rhexinema sarcinoideum chloroplast, complete genome blastn 30363 466 1 Eukaryota core chlorophytes Viridiplantae Chlorophyta Ulvophyceae Ulotrichales Helicodictyaceae Rhexinema Rhexinema sarcinoideum

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