RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 9 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB48872 · 9 ✖

analysis 1

  • diamond · 9 ✖
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
21392834 21392834 PRJEB48872_P_NODE_593317_length_170_cov_1.251908_g577505_i0 PRJEB48872 593317 170 1.251908 2.1282436 root 1 Root_unresolved Root_unresolved 107 2.68e-27   NR CAA2991187.1 158383 g577505 i0 100 1.97647058823529 56 0 98.8 0 1 168 84 139 CAA2991187.1 Hypothetical predicted protein, partial [Olea europaea subsp. europaea] diamond 336 107 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
27222958 27222958 PRJEB48872_P_NODE_201043_length_387_cov_2.870690_g185236_i0 PRJEB48872 201043 387 2.87069 11.1095703 Cicer arietinum 3827 Plants Plants 45.4 0.019   NR XP_004513007.1 3827 g185236 i0 37.7 0.534883720930233 69 37 51.9 2 100 300 264 328 XP_004513007.1 cyclin-dependent kinase F-1 [Cicer arietinum] diamond 207 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Cicer Cicer arietinum
27570603 27570603 PRJEB48872_P_NODE_508664_length_191_cov_1.743421_g492852_i0 PRJEB48872 508664 191 1.743421 3.32993411 Olea europaea subsp. europaea 158383 Plants Plants 119 5.5e-33   NR CAA2962774.1 158383 g492852 i0 100 0.879581151832461 56 0 88 0 170 3 1 56 CAA2962774.1 general secretion pathway [Olea europaea subsp. europaea] diamond 168 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
28960133 28960133 PRJEB48872_P_NODE_510568_length_191_cov_0.796053_g494756_i0 PRJEB48872 510568 191 0.796053 1.52046123 Tanacetum cinerariifolium 118510 Plants Plants 41.2 0.035   NR GEZ02509.1 118510 g494756 i0 39.6 0.753926701570681 48 25 69.1 1 132 1 83 130 GEZ02509.1 hypothetical protein [Tanacetum cinerariifolium] diamond 144 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
29332093 29332093 PRJEB48872_P_NODE_628349_length_162_cov_2.544715_g612537_i0 PRJEB48872 628349 162 2.544715 4.1224383 root 1 Root_unresolved Root_unresolved 115 8.2e-30   NR CAA2962657.1 158383 g612537 i0 100 1.96296296296296 53 0 98.1 0 161 3 208 260 CAA2962657.1 crotonase, partial [Olea europaea subsp. europaea] diamond 318 115 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
30159639 30159639 PRJEB48872_P_NODE_430652_length_217_cov_3.044944_g414840_i0 PRJEB48872 430652 217 3.044944 6.60752848 Trifolium medium 97028 Plants Plants 42.7 0.0277   NR MCH79499.1 97028 g414840 i0 36 0.691244239631336 50 31 69.1 1 202 53 181 229 MCH79499.1 replication protein A 70 kDa dna-binding subunit [Trifolium medium] diamond 150 42.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Trifolium Trifolium medium
30350020 30350020 PRJEB48872_P_NODE_281192_length_302_cov_1.323194_g265380_i0 PRJEB48872 281192 302 1.323194 3.99604588 Olea europaea subsp. europaea 158383 Plants Plants 184 1.89e-51   NR CAA2977210.1 158383 g265380 i0 100 0.993377483443709 100 0 99.3 0 302 3 204 303 CAA2977210.1 efflux RND transporter periplasmic adaptor subunit, partial [Olea europaea subsp. europaea] diamond 300 184 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
31354040 31354040 PRJEB48872_P_NODE_683576_length_152_cov_1.938053_g667764_i0 PRJEB48872 683576 152 1.938053 2.94584056 Triticum 4564 Plants Plants 50.8 1.48e-5   NR XP_044452714.1 4565 g667764 i0 48.3 2.30921052631579 58 21 96.7 1 151 5 85 142 XP_044452714.1 uncharacterized protein LOC123184700 isoform X1 [Triticum aestivum] diamond 351 50.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
31613705 31613705 PRJEB48872_P_NODE_515096_length_189_cov_2.053333_g499284_i0 PRJEB48872 515096 189 2.053333 3.88079937 Olea europaea subsp. europaea 158383 Plants Plants 125 1.7599999999999998e-32   NR CAA2991188.1 158383 g499284 i0 100 0.984126984126984 62 0 98.4 0 188 3 214 275 CAA2991188.1 thymidylate kinase, partial [Olea europaea subsp. europaea] diamond 186 125 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea

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