RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1115053" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 31 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1115053 · 31 ✖

analysis 1

  • diamond · 31 ✖
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
15531881 15531881 PRJNA1115053_S_NODE_71333_length_295_cov_3.809524_g69516_i0 PRJNA1115053 71333 295 3.809524 11.2380958 Sphagnum balticum 128184 Plants Plants 159 6.35e-48   NR CAM6001409.1 128184 g69516 i0 82.2 0.915254237288136 90 16 91.5 0 2 271 41 130 CAM6001409.1 unnamed protein product [Sphagnum balticum] diamond 270 159 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum balticum
20624851 20624851 PRJNA1115053_S_NODE_156477_length_215_cov_4.563953_g154660_i0 PRJNA1115053 156477 215 4.563953 9.81249895 Olea europaea subsp. europaea 158383 Plants Plants 90.5 4.58e-22   NR CAA2964041.1 158383 g154660 i0 86.2 0.809302325581395 58 8 80.9 0 4 177 11 68 CAA2964041.1 arabinogalactan peptide 20 [Olea europaea subsp. europaea] diamond 174 90.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Oleaceae Olea Olea europaea
26751128 26751128 PRJNA1115053_S_NODE_241401_length_178_cov_2.214815_g239584_i0 PRJNA1115053 241401 178 2.214815 3.9423707 Quercus robur 38942 Plants Plants 111 7.090000000000001e-27   NR XP_050257533.1 38942 g239584 i0 91.1 0.943820224719101 56 5 94.4 0 176 9 377 432 XP_050257533.1 uncharacterized protein LOC126702755 [Quercus robur] diamond 168 111 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus robur
26814953 26814953 PRJNA1115053_S_NODE_209141_length_190_cov_1.632653_g207324_i0 PRJNA1115053 209141 190 1.632653 3.1020407 Quercus rubra 3512 Plants Plants 110 5.02e-30   NR KAK4576094.1 3512 g207324 i0 100 0.805263157894737 51 0 80.5 0 1 153 15 65 KAK4576094.1 hypothetical protein RGQ29_026876 [Quercus rubra] diamond 153 110 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
26878440 26878440 PRJNA1115053_S_NODE_350641_length_151_cov_1.166667_g348824_i0 PRJNA1115053 350641 151 1.166667 1.76166717 Tanacetum cinerariifolium 118510 Plants Plants 42.4 0.0143   NR GEX87984.1 118510 g348824 i0 41.5 0.814569536423841 41 24 81.5 0 24 146 640 680 GEX87984.1 reverse transcriptase domain-containing protein [Tanacetum cinerariifolium] diamond 123 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
26941342 26941342 PRJNA1115053_S_NODE_268202_length_170_cov_1.480315_g266385_i0 PRJNA1115053 268202 170 1.480315 2.5165355 Tanacetum cinerariifolium 118510 Plants Plants 41.6 0.0353   NR GEY78393.1 118510 g266385 i0 43.2 0.652941176470588 37 20 63.5 1 126 19 245 281 GEY78393.1 hypothetical protein [Tanacetum cinerariifolium] diamond 111 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
27194310 27194310 PRJNA1115053_S_NODE_254862_length_174_cov_1.465649_g253045_i0 PRJNA1115053 254862 174 1.465649 2.55022926 Gossypium tomentosum 34277 Plants Plants 40.4 0.0329   NR TYH73074.1 34277 g253045 i0 53.8 0.448275862068966 26 12 44.8 0 27 104 20 45 TYH73074.1 hypothetical protein ES332_D05G302500v1 [Gossypium tomentosum] diamond 78 40.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium tomentosum
27320957 27320957 PRJNA1115053_S_NODE_199223_length_194_cov_1.867550_g197406_i0 PRJNA1115053 199223 194 1.86755 3.623047 Hordeum vulgare 4513 Plants Plants 79.3 2.56e-17   NR KAE8791892.1 4513 g197406 i0 77 0.943298969072165 61 12 92.8 2 1 180 48 107 KAE8791892.1 hypothetical protein D1007_33520 [Hordeum vulgare] diamond 183 79.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Hordeum Hordeum vulgare
27636832 27636832 PRJNA1115053_S_NODE_142464_length_224_cov_2.237569_g140647_i0 PRJNA1115053 142464 224 2.237569 5.01215456 Colocasia esculenta 4460 Plants Plants 89 1.6e-20   NR MQL87405.1 4460 g140647 i0 55.4 27.7366071428571 74 33 99.1 0 3 224 57 130 MQL87405.1 hypothetical protein [Colocasia esculenta] diamond 6213 89 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Alismatales Araceae Colocasia Colocasia esculenta
28290635 28290635 PRJNA1115053_S_NODE_166466_length_210_cov_1.305389_g164649_i0 PRJNA1115053 166466 210 1.305389 2.7413169 Streptophyta 35493 Plants Plants 41.6 0.0431   NR ABK21107.1 3332 g164649 i0 100 1.42857142857143 20 0 28.6 0 210 151 151 170 ABK21107.1 unknown [Picea sitchensis] diamond 300 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
28520841 28520841 PRJNA1115053_S_NODE_254907_length_174_cov_1.465649_g253090_i0 PRJNA1115053 254907 174 1.465649 2.55022926 Theobroma cacao 3641 Plants Plants 42.4 0.00999   NR WRX13638.1 3641 g253090 i0 34.3 1.20689655172414 70 31 94.8 1 9 173 34 103 WRX13638.1 hypothetical protein QQP08_006125 [Theobroma cacao] diamond 210 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Theobroma Theobroma cacao
28647172 28647172 PRJNA1115053_S_NODE_80587_length_282_cov_1.694561_g78770_i0 PRJNA1115053 80587 282 1.694561 4.77866202 Quercus rubra 3512 Plants Plants 98.2 6.179999999999999e-24   NR KAK4608262.1 3512 g78770 i0 97.6 0.446808510638298 42 1 44.7 0 280 155 93 134 KAK4608262.1 hypothetical protein RGQ29_001889 [Quercus rubra] diamond 126 98.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
28678765 28678765 PRJNA1115053_S_NODE_125707_length_236_cov_2.238342_g123890_i0 PRJNA1115053 125707 236 2.238342 5.28248712 Dichanthelium oligosanthes 888268 Plants Plants 44.7 0.00709   NR OEL35238.1 888268 g123890 i0 37 1.3728813559322 54 33 67.4 1 47 205 112 165 OEL35238.1 UDP-glucuronate:xylan alpha-glucuronosyltransferase 2 [Dichanthelium oligosanthes] diamond 324 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Dichanthelium Dichanthelium oligosanthes
28931282 28931282 PRJNA1115053_S_NODE_85348_length_276_cov_1.536481_g83531_i0 PRJNA1115053 85348 276 1.536481 4.24068756 Camellia lanceoleosa 1840588 Plants Plants 43.1 0.0427   NR KAI8008548.1 1840588 g83531 i0 31.4 0.760869565217391 70 47 76.1 1 58 267 885 953 KAI8008548.1 hypothetical protein LOK49_LG07G01868 [Camellia lanceoleosa] diamond 210 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia lanceoleosa
29593904 29593904 PRJNA1115053_S_NODE_85670_length_275_cov_3.956897_g83853_i0 PRJNA1115053 85670 275 3.956897 10.88146675 Quercus rubra 3512 Plants Plants 75.9 6.16e-16   NR KAK4605734.1 3512 g83853 i0 97.1 0.370909090909091 34 1 37.1 0 3 104 35 68 KAK4605734.1 hypothetical protein RGQ29_000149 [Quercus rubra] diamond 102 75.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
29837840 29837840 PRJNA1115053_S_NODE_203611_length_192_cov_2.315436_g201794_i0 PRJNA1115053 203611 192 2.315436 4.44563712 Sphagnum 13804 Plants Plants 67.8 2.62e-11   NR KAH8959751.1 53036 g201794 i0 60.5 2.6875 43 17 67.2 0 190 62 366 408 KAH8959751.1 hypothetical protein BDL97_06G093500 [Sphagnum fallax] diamond 516 67.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum fallax
30162555 30162555 PRJNA1115053_S_NODE_211252_length_189_cov_1.904110_g209435_i0 PRJNA1115053 211252 189 1.90411 3.5987679 Lactuca sativa 4236 Plants Plants 42 0.0336   NR XP_023736106.1 4236 g209435 i0 54.5 0.523809523809524 33 15 52.4 0 29 127 211 243 XP_023736106.1 U-box domain-containing protein 62 [Lactuca sativa] diamond 99 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
30478873 30478873 PRJNA1115053_S_NODE_172393_length_207_cov_1.170732_g170576_i0 PRJNA1115053 172393 207 1.170732 2.42341524 Brassica oleracea 3712 Plants Plants 43.5 0.00574   NR VDD33108.1 3712 g170576 i0 28.1 0.927536231884058 64 45 91.3 1 17 205 65 128 VDD33108.1 unnamed protein product [Brassica oleracea] diamond 192 43.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica oleracea
30857820 30857820 PRJNA1115053_S_NODE_317234_length_157_cov_1.263158_g315417_i0 PRJNA1115053 317234 157 1.263158 1.98315806 Arabidopsis thaliana 3702 Plants Plants 41.2 0.0166   NR NP_181449.1 3702 g315417 i0 36.6 0.78343949044586 41 26 78.3 0 128 6 23 63 NP_181449.1 uncharacterized protein AT2G39160 [Arabidopsis thaliana] diamond 123 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis thaliana
31110469 31110469 PRJNA1115053_S_NODE_102275_length_257_cov_1.345794_g100458_i0 PRJNA1115053 102275 257 1.345794 3.45869058 Salix koriyanagi 2511006 Plants Plants 43.1 0.0323   NR KAJ6723367.1 2511006 g100458 i0 44.4 1.05058365758755 45 25 52.5 0 188 54 586 630 KAJ6723367.1 CTP SYNTHASE [Salix koriyanagi] diamond 270 43.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Salix Salix koriyanagi
31141885 31141885 PRJNA1115053_S_NODE_176675_length_204_cov_6.981366_g174858_i0 PRJNA1115053 176675 204 6.981366 14.24198664 Arabidopsis suecica 45249 Plants Plants 42 0.0417   NR KAG7563338.1 45249 g174858 i0 34.8 1.01470588235294 69 31 80.9 2 35 199 435 503 KAG7563338.1 Protein kinase C-like phorbol ester/diacylglycerol-binding domain [Arabidopsis suecica] diamond 207 42 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis suecica
31395361 31395361 PRJNA1115053_S_NODE_256956_length_173_cov_2.215385_g255139_i0 PRJNA1115053 256956 173 2.215385 3.83261605 Daucus carota subsp. sativus 79200 Plants Plants 48.9 9.72e-5   NR XP_063945983.1 79200 g255139 i0 52.6 0.658959537572254 38 18 65.9 0 116 3 383 420 XP_063945983.1 uncharacterized protein LOC135151459 [Daucus carota subsp. sativus] diamond 114 48.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Apiales Apiaceae Daucus Daucus carota
31426811 31426811 PRJNA1115053_S_NODE_337996_length_153_cov_0.872727_g336179_i0 PRJNA1115053 337996 153 0.872727 1.33527231 Paspalum notatum var. saurae 547442 Plants Plants 41.2 0.0394   NR WVZ89713.1 547442 g336179 i0 56 0.490196078431373 25 11 49 0 4 78 142 166 WVZ89713.1 hypothetical protein U9M48_036079 [Paspalum notatum var. saurae] diamond 75 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Paspalum Paspalum notatum
31490317 31490317 PRJNA1115053_S_NODE_229016_length_182_cov_4.525180_g227199_i0 PRJNA1115053 229016 182 4.52518 8.2358276 Quercus rubra 3512 Plants Plants 82 6.97e-18   NR KAK4594628.1 3512 g227199 i0 84.8 0.758241758241758 46 7 75.8 0 180 43 114 159 KAK4594628.1 hypothetical protein RGQ29_018349 [Quercus rubra] diamond 138 82 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
31711524 31711524 PRJNA1115053_S_NODE_239517_length_179_cov_1.411765_g237700_i0 PRJNA1115053 239517 179 1.411765 2.52705935 Picea sitchensis 3332 Plants Plants 91.7 8.8e-20   NR ABR16708.1 3332 g237700 i0 88.1 0.988826815642458 59 7 98.9 0 2 178 314 372 ABR16708.1 unknown [Picea sitchensis] diamond 177 91.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea sitchensis
31901317 31901317 PRJNA1115053_S_NODE_55437_length_324_cov_3.565836_g53620_i0 PRJNA1115053 55437 324 3.565836 11.55330864 Closterium sp. Naga37s-1 2996811 Plants Plants 46.6 0.0043   NR CAI5522813.1 2996811 g53620 i0 39.3 0.990740740740741 107 47 91.7 5 315 19 365 461 CAI5522813.1 unnamed protein product [Closterium sp. Naga37s-1] diamond 321 46.6 1 Eukaryota   Viridiplantae Streptophyta Zygnematophyceae Desmidiales Closteriaceae Closterium Closterium sp. Naga37s-1
31932868 31932868 PRJNA1115053_S_NODE_190477_length_198_cov_1.509677_g188660_i0 PRJNA1115053 190477 198 1.509677 2.98916046 Quercus rubra 3512 Plants Plants 84 1.62e-19   NR KAK4589130.1 3512 g188660 i0 100 0.636363636363636 42 0 63.6 0 1 126 31 72 KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra] diamond 126 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra
32091165 32091165 PRJNA1115053_S_NODE_148438_length_220_cov_2.711864_g146621_i0 PRJNA1115053 148438 220 2.711864 5.9661008 Ananas comosus var. bracteatus 296719 Plants Plants 45.4 0.00294   NR CAD1818577.1 296719 g146621 i0 31.3 7.30909090909091 67 34 91.4 1 214 14 151 205 CAD1818577.1 unnamed protein product [Ananas comosus var. bracteatus] diamond 1608 45.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Bromeliaceae Ananas Ananas comosus
32249717 32249717 PRJNA1115053_S_NODE_334358_length_153_cov_1.309091_g332541_i0 PRJNA1115053 334358 153 1.309091 2.00290923 Zizania palustris 103762 Plants Plants 42.4 0.0135   NR KAG8050060.1 103762 g332541 i0 50 1.33333333333333 34 17 66.7 0 112 11 145 178 KAG8050060.1 hypothetical protein GUJ93_ZPchr0009g1888 [Zizania palustris] diamond 204 42.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zizania Zizania palustris
32335578 32335578 PRJNA1115053_S_NODE_281799_length_166_cov_1.560976_g279982_i0 PRJNA1115053 281799 166 1.560976 2.59122016 Sphagnum 13804 Plants Plants 41.6 0.0275   NR CAM6079425.1 128247 g279982 i0 57.6 3.03614457831325 33 14 59.6 0 1 99 146 178 CAM6079425.1 unnamed protein product [Sphagnum tenellum] diamond 504 41.6 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum tenellum
32849090 32849090 PRJNA1115053_S_NODE_156840_length_215_cov_2.232558_g155023_i0 PRJNA1115053 156840 215 2.232558 4.7999997 Lithocarpus litseifolius 425828 Plants Plants 105 3.27e-25   NR KAK9992956.1 425828 g155023 i0 81.3 0.893023255813953 64 12 89.3 0 19 210 1 64 KAK9992956.1 hypothetical protein SO802_022659 [Lithocarpus litseifolius] diamond 192 105 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Lithocarpus Lithocarpus litseifolius

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