RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA309466" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA309466 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
27060226 27060226 PRJNA309466_P_NODE_13162_length_180_cov_1.587786_g13105_i0 PRJNA309466 13162 180 1.587786 2.8580148 Magnoliopsida 3398 Plants Plants 57 4.13e-8   NR XP_021608764.1 3983 g13105 i0 70.6 11.3333333333333 34 10 56.7 0 176 75 135 168 XP_021608764.1 uncharacterized protein LOC110612317 [Manihot esculenta] diamond 2040 57.4 0.993031358885017 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Manihot Manihot esculenta
27611457 27611457 PRJNA309466_P_NODE_5564_length_247_cov_4.434343_g5507_i0 PRJNA309466 5564 247 4.434343 10.95282721 Smallanthus sonchifolius 185202 Plants Plants 41.2 0.0378   NR KAI3744066.1 185202 g5507 i0 43.4 0.643724696356275 53 25 58.3 1 79 222 27 79 KAI3744066.1 hypothetical protein L1987_57138 [Smallanthus sonchifolius] diamond 159 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Smallanthus Smallanthus sonchifolius
27769465 27769465 PRJNA309466_P_NODE_18384_length_161_cov_2.794643_g18327_i0 PRJNA309466 18384 161 2.794643 4.49937523 Ricinus communis 3988 Plants Plants 42 0.0228   NR EEF52918.1 3988 g18327 i0 95 0.372670807453416 20 1 37.3 0 7 66 300 319 EEF52918.1 cinnamoyl-CoA reductase, putative [Ricinus communis] diamond 60 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Euphorbiaceae Ricinus Ricinus communis
29726531 29726531 PRJNA309466_P_NODE_7770_length_218_cov_1.343195_g7713_i0 PRJNA309466 7770 218 1.343195 2.9281651 Closterium sp. Naga37s-1 2996811 Plants Plants 59.3 3.87e-8   NR CAI5493210.1 2996811 g7713 i0 49.3 3.90825688073395 71 33 93.6 1 207 4 348 418 CAI5493210.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 852 59.3 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1
30105722 30105722 PRJNA309466_P_NODE_7312_length_222_cov_3.884393_g7255_i0 PRJNA309466 7312 222 3.884393 8.62335246 Camellia sinensis 4442 Plants Plants 43.9 0.00663   NR CAL5440926.1 4442 g7255 i0 50 0.675675675675676 50 22 67.6 1 196 47 114 160 CAL5440926.1 unnamed protein product [Camellia sinensis] diamond 150 43.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
31749252 31749252 PRJNA309466_P_NODE_8957_length_207_cov_2.518987_g8900_i0 PRJNA309466 8957 207 2.518987 5.21430309 Carpinus fangiana 176857 Plants Plants 68.9 1.8e-13   NR KAE7996271.1 176857 g8900 i0 69.4 0.710144927536232 49 13 68.1 1 197 57 30 78 KAE7996271.1 hypothetical protein FH972_001005 [Carpinus fangiana] diamond 147 68.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Betulaceae Carpinus Carpinus fangiana
32065664 32065664 PRJNA309466_P_NODE_14298_length_174_cov_3.168000_g14241_i0 PRJNA309466 14298 174 3.168 5.51232 Ficus carica 3494 Plants Plants 101 9.549999999999999e-24   NR GMN27810.1 3494 g14241 i0 80.7 0.982758620689655 57 11 98.3 0 172 2 327 383 GMN27810.1 hypothetical protein TIFTF001_001808 [Ficus carica] diamond 171 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Moraceae Ficus Ficus carica

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