RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_phylum = "Rhodophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Rhodophyta · 4 ✖

bioproject 1

  • PRJNA533114 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 0

tax_clade 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
11984349 11984349 PRJNA533114_P_NODE_81270_length_269_cov_1.571429_g81018_i0 PRJNA533114 81270 269 1.571429 4.22714401 Antithamnionella miharai 536589 Rhodophyta other_Eukaryota 106 1.86e-18   NTclustered gi|2666692773|ref|NC_085547.1| 536589 g81018 i0 75.814 3.76951672862454 215 49 80 3 40 253 22602 22814 Antithamnionella miharai strain MABIK-LAS-00000332 mitochondrion, complete genome blastn 1014 106 1 Eukaryota     Rhodophyta Florideophyceae Ceramiales Ceramiaceae Antithamnionella Antithamnionella miharai
14534503 14534503 PRJNA533114_P_NODE_93092_length_251_cov_1.556180_g92840_i0 PRJNA533114 93092 251 1.55618 3.9060118 Pyropia haitanensis 1262161 Rhodophyta other_Eukaryota 193 1.28e-44   NTclustered gi|404551308|gb|JX293832.1| 1262161 g92840 i0 80.723 53.5378486055777 249 46 99 2 1 248 62 309 Porphyra haitanensis cyclophilin (cyp) mRNA, complete cds blastn 13438 193 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia haitanensis
19631600 19631600 PRJNA533114_P_NODE_80216_length_271_cov_1.252525_g79964_i0 PRJNA533114 80216 271 1.252525 3.39434275 Dermonema virens 1077399 Rhodophyta other_Eukaryota 161 3.96e-35   NTclustered gi|1088582298|ref|NC_031655.1| 1077399 g79964 i0 79.654 8.24723247232472 231 41 84 3 44 271 148222 147995 Dermonema virens chloroplast, complete genome, isolate J.0258 blastn 2235 161 1 Eukaryota     Rhodophyta Florideophyceae Nemaliales Liagoraceae Dermonema Dermonema virens
24730694 24730694 PRJNA533114_P_NODE_20100_length_504_cov_3.264501_g19851_i0 PRJNA533114 20100 504 3.264501 16.45308504 Pyropia haitanensis 1262161 Rhodophyta other_Eukaryota 165 6.07e-36   NTclustered gi|404551308|gb|JX293832.1| 1262161 g19851 i0 76.061 10.2857142857143 330 71 65 8 61 386 384 59 Porphyra haitanensis cyclophilin (cyp) mRNA, complete cds blastn 5184 165 1 Eukaryota     Rhodophyta Bangiophyceae Bangiales Bangiaceae Pyropia Pyropia haitanensis

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