RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA982106" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 6 ✖

bioproject 1

  • PRJNA982106 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27816261 27816261 PRJNA982106_P_NODE_30244_length_243_cov_0.905882_g30004_i0 PRJNA982106 30244 243 0.905882 2.20129326 Euphorbia peplus 38846 Plants Plants 42.7 0.0301   NR WCJ41357.1 38846 g30004 i0 29.6 0.666666666666667 54 37 66.7 1 33 194 164 216 WCJ41357.1 hypothetical protein M5689_022233 [Euphorbia peplus] diamond 162 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Euphorbia Euphorbia peplus
28194737 28194737 PRJNA982106_P_NODE_17826_length_266_cov_1.595855_g17586_i0 PRJNA982106 17826 266 1.595855 4.2449743 Heracleum sosnowskyi 360622 Plants Plants 49.7 1.81e-4   NR KAK1360846.1 360622 g17586 i0 53.6 0.631578947368421 56 26 63.2 0 87 254 681 736 KAK1360846.1 hypothetical protein POM88_045320 [Heracleum sosnowskyi] diamond 168 49.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
28352727 28352727 PRJNA982106_P_NODE_18846_length_260_cov_1.331551_g18606_i0 PRJNA982106 18846 260 1.331551 3.4620326 Colocasia esculenta 4460 Plants Plants 52.8 1.34e-5   NR MQL83775.1 4460 g18606 i0 59 1.31538461538462 39 16 45 0 119 3 12 50 MQL83775.1 hypothetical protein [Colocasia esculenta] diamond 342 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
29900109 29900109 PRJNA982106_P_NODE_17991_length_265_cov_2.083333_g17751_i0 PRJNA982106 17991 265 2.083333 5.52083245 Heracleum sosnowskyi 360622 Plants Plants 144 2.43e-41   NR KAK1397029.1 360622 g17751 i0 81.8 9.9622641509434 88 16 99.6 0 265 2 23 110 KAK1397029.1 hypothetical protein POM88_006892 [Heracleum sosnowskyi] diamond 2640 144 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Heracleum Heracleum sosnowskyi
31353533 31353533 PRJNA982106_P_NODE_17376_length_269_cov_1.311224_g17136_i0 PRJNA982106 17376 269 1.311224 3.52719256 Diospyros lotus 55363 Plants Plants 126 2.83e-33   NR XP_052206984.1 55363 g17136 i0 76.7 18.2565055762082 90 20 99.3 1 267 1 166 255 XP_052206984.1 uncharacterized protein LOC127811292 [Diospyros lotus] diamond 4911 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ebenaceae Diospyros Diospyros lotus
31922821 31922821 PRJNA982106_P_NODE_28917_length_244_cov_0.900585_g28677_i0 PRJNA982106 28917 244 0.900585 2.1974274 Rhododendron williamsianum 262921 Plants Plants 43.5 0.0137   NR KAE9451084.1 262921 g28677 i0 45 0.491803278688525 40 16 41.8 1 13 114 62 101 KAE9451084.1 hypothetical protein C3L33_16995, partial [Rhododendron williamsianum] diamond 120 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Ericaceae Rhododendron Rhododendron williamsianum

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