RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA773625" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA773625 · 4 ✖

analysis 1

  • diamond · 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
26936231 26936231 PRJNA773625_P_NODE_8462_length_167_cov_0.881356_g8447_i0 PRJNA773625 8462 167 0.881356 1.47186452 Magnoliopsida 3398 Plants Plants 107 7.27e-26   NR XP_015696260.2 4533 g8447 i0 92.7 3.95209580838323 55 4 98.8 0 166 2 202 256 XP_015696260.2 probable purine permease 5 [Oryza brachyantha] diamond 660 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza brachyantha
27116355 27116355 PRJNA773625_P_NODE_10602_length_163_cov_0.912281_g10587_i0 PRJNA773625 10602 163 0.912281 1.48701803 Phyllostachys edulis 38705 Plants Plants 52 6.59e-6   NR ADB85343.1 38705 g10587 i0 69.4 0.662576687116564 36 11 66.3 0 110 3 1 36 ADB85343.1 putative transposon protein [Phyllostachys edulis] diamond 108 52 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis
29043053 29043053 PRJNA773625_P_NODE_10108_length_164_cov_0.904348_g10093_i0 PRJNA773625 10108 164 0.904348 1.48313072 Oryza sativa Japonica Group 39947 Plants Plants 59.7 1.32e-8   NR AAM18766.1 39947 g10093 i0 74.2 1.6280487804878 31 8 56.7 0 3 95 299 329 AAM18766.1 putative copia-like retrotransposon Hopscotch polyprotein [Oryza sativa Japonica Group] diamond 267 59.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza sativa
29043054 29043054 PRJNA773625_P_NODE_10428_length_163_cov_0.912281_g10413_i0 PRJNA773625 10428 163 0.912281 1.48701803 Phyllostachys edulis 38705 Plants Plants 90.5 9.87e-22   NR ADB85422.1 38705 g10413 i0 81.1 1.87730061349693 53 10 97.5 0 163 5 48 100 ADB85422.1 putative retrotransposon protein [Phyllostachys edulis] diamond 306 90.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Phyllostachys Phyllostachys edulis

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