RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA509429" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA509429 · 11 ✖

analysis 1

  • diamond · 11 ✖
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
26887532 26887532 PRJNA509429_P_NODE_27841_length_238_cov_1.162562_g27013_i0 PRJNA509429 27841 238 1.162562 2.76689756 Selaginella moellendorffii 88036 Plants Plants 42 0.0422   NR XP_024541998.1 88036 g27013 i0 43.5 0.579831932773109 46 22 52.9 2 112 237 75 120 XP_024541998.1 uncharacterized protein LOC112350290 isoform X1 [Selaginella moellendorffii] diamond 138 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Lycopodiopsida Selaginellales Selaginellaceae Selaginella Selaginella moellendorffii
27677699 27677699 PRJNA509429_P_NODE_48604_length_157_cov_1.311475_g47776_i0 PRJNA509429 48604 157 1.311475 2.05901575 Aristolochia fimbriata 158543 Plants Plants 42 0.0212   NR KAG9438554.1 158543 g47776 i0 53.7 1.56687898089172 41 18 78.3 1 3 125 318 357 KAG9438554.1 hypothetical protein H6P81_021505 [Aristolochia fimbriata] diamond 246 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Piperales Aristolochiaceae Aristolochia Aristolochia fimbriata
28530034 28530034 PRJNA509429_P_NODE_45447_length_165_cov_1.138462_g44619_i0 PRJNA509429 45447 165 1.138462 1.8784623 Arabidopsis suecica 45249 Plants Plants 59.7 1.39e-8   NR KAG7528190.1 45249 g44619 i0 64.3 2.21818181818182 42 13 72.7 1 120 1 1649 1690 KAG7528190.1 GAG-pre-integrase domain, partial [Arabidopsis suecica] diamond 366 59.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis suecica
28972011 28972011 PRJNA509429_P_NODE_49168_length_156_cov_0.909091_g48340_i0 PRJNA509429 49168 156 0.909091 1.41818196 Cryptomeria japonica 3369 Plants Plants 42.4 0.0144   NR GLJ49133.1 3369 g48340 i0 38.5 1 52 27 90.4 2 16 156 12 63 GLJ49133.1 hypothetical protein SUGI_1036500 [Cryptomeria japonica] diamond 156 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
29003970 29003970 PRJNA509429_P_NODE_45188_length_165_cov_3.076923_g44360_i0 PRJNA509429 45188 165 3.076923 5.07692295 Capsicum chinense 80379 Plants Plants 45.1 0.00193   NR PHU28461.1 80379 g44360 i0 46.2 0.945454545454545 52 27 92.7 1 3 155 17 68 PHU28461.1 hypothetical protein BC332_00554 [Capsicum chinense] diamond 156 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Capsicum Capsicum chinense
29824255 29824255 PRJNA509429_P_NODE_47891_length_159_cov_0.935484_g47063_i0 PRJNA509429 47891 159 0.935484 1.48741956 Arachis hypogaea 3818 Plants Plants 62.8 2.46e-10   NR ABH09321.1 3818 g47063 i0 54.7 1 53 24 100 0 159 1 74 126 ABH09321.1 leucine rich protein [Arachis hypogaea] diamond 159 62.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Arachis Arachis hypogaea
30740599 30740599 PRJNA509429_P_NODE_20574_length_295_cov_6.396154_g19746_i0 PRJNA509429 20574 295 6.396154 18.8686543 Vigna unguiculata 3917 Plants Plants 47.4 6.65e-4   NR QCD80736.1 3917 g19746 i0 35.9 0.793220338983051 78 47 76.3 2 17 241 67 144 QCD80736.1 hypothetical protein DEO72_LG2g1058 [Vigna unguiculata] diamond 234 47.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Vigna Vigna unguiculata
31657223 31657223 PRJNA509429_P_NODE_42317_length_174_cov_1.122302_g41489_i0 PRJNA509429 42317 174 1.122302 1.95280548 Cichorium endivia 114280 Plants Plants 42 0.0268   NR KAI3486772.1 114280 g41489 i0 50.9 0.913793103448276 53 19 87.9 3 2 154 159 206 KAI3486772.1 hypothetical protein L1887_49631 [Cichorium endivia] diamond 159 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Cichorium Cichorium endivia
32005452 32005452 PRJNA509429_P_NODE_33358_length_207_cov_2.732558_g32530_i0 PRJNA509429 33358 207 2.732558 5.65639506 Arctium lappa 4217 Plants Plants 47 7.31e-4   NR KAI3664033.1 4217 g32530 i0 51.1 0.652173913043478 45 22 65.2 0 203 69 152 196 KAI3664033.1 hypothetical protein L6452_45150 [Arctium lappa] diamond 135 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Arctium Arctium lappa
32511971 32511971 PRJNA509429_P_NODE_21599_length_285_cov_4.704000_g20771_i0 PRJNA509429 21599 285 4.704 13.4064 Pistacia integerrima 434235 Plants Plants 80.1 4.65e-15   NR KAJ0007286.1 434235 g20771 i0 68.4 0.6 57 18 60 0 222 52 131 187 KAJ0007286.1 hypothetical protein Pint_28935 [Pistacia integerrima] diamond 171 80.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Anacardiaceae Pistacia Pistacia integerrima
32904997 32904997 PRJNA509429_P_NODE_6840_length_557_cov_22.145594_g6084_i0 PRJNA509429 6840 557 22.145594 123.35095858 root 1 Root_unresolved Root_unresolved 110 1.69e-24   NR GFA39473.1 118510 g6084 i0 68.1 1.01256732495512 94 30 50.6 0 275 556 334 427 GFA39473.1 aminoglycoside resistance protein, chloroplastic [Tanacetum cinerariifolium] diamond 564 111 0.990990990990991 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium

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