RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA289590" 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 · 17 ✖

bioproject 1

  • PRJNA289590 · 17 ✖

analysis 1

  • diamond · 17 ✖
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
11851450 11851450 PRJNA289590_P_NODE_50_length_8312_cov_35.741619_g45_i0 PRJNA289590 50 8312 35.741619 2970.84337128 Tanacetum cinerariifolium 118510 Plants Plants 1348 0   NR GEU28046.1 118510 g45 i0 50.1 0.597690086621752 1656 491 52.6 10 6214 1841 1 1510 GEU28046.1 hypothetical protein [Tanacetum cinerariifolium] diamond 4968 1348 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
24598832 24598832 PRJNA289590_P_NODE_340_length_3133_cov_37.440337_g289_i0 PRJNA289590 340 3133 37.440337 1173.00575821 Tanacetum cinerariifolium 118510 Plants Plants 1249 0   NR GEU28371.1 118510 g289 i0 77.3 0.785189913820619 820 160 78.2 3 3092 642 7915 8711 GEU28371.1 adenylosuccinate synthetase 2, chloroplastic [Tanacetum cinerariifolium] diamond 2460 1249 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
24598898 24598898 PRJNA289590_P_NODE_60_length_7880_cov_47.160005_g55_i0 PRJNA289590 60 7880 47.160005 3716.208394 Tanacetum cinerariifolium 118510 Plants Plants 1794 0   NR GEU28657.1 118510 g55 i0 64 0.630837563451777 1657 320 63 12 6864 1900 1363 2745 GEU28657.1 hypothetical protein [Tanacetum cinerariifolium] diamond 4971 1794 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
26775490 26775490 PRJNA289590_P_NODE_29921_length_164_cov_0.904348_g29697_i0 PRJNA289590 29921 164 0.904348 1.48313072 Salicaceae 3688 Plants Plants 85.5 5.67e-18   NR KAJ6977063.1 444605 g29697 i0 71.7 15.4939024390244 53 15 97 0 163 5 223 275 KAJ6977063.1 hypothetical protein NC653_029067 [Populus alba x Populus x berolinensis] diamond 2541 86.3 0.990730011587486 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malpighiales Salicaceae Populus Populus alba x Populus x berolinensis
26902145 26902145 PRJNA289590_P_NODE_30261_length_163_cov_0.912281_g30037_i0 PRJNA289590 30261 163 0.912281 1.48701803 Eukaryota 2759 Plants Plants 92.8 2.8e-20   NR KAK1644219.1 4521 g30037 i0 84.3 53.6134969325153 51 8 93.9 0 158 6 117 167 KAK1644219.1 hypothetical protein QYE76_062024 [Lolium multiflorum] diamond 8739 93.6 0.991452991452991 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Lolium Lolium multiflorum
27295433 27295433 PRJNA289590_P_NODE_26103_length_169_cov_0.866667_g25879_i0 PRJNA289590 26103 169 0.866667 1.46466723 Lactuca virosa 75947 Plants Plants 87.4 1.14e-18   NR CAH1446825.1 75947 g25879 i0 91.1 3.19526627218935 45 4 79.9 0 169 35 278 322 CAH1446825.1 unnamed protein product [Lactuca virosa] diamond 540 87.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca virosa
27516542 27516542 PRJNA289590_P_NODE_22063_length_188_cov_1.345324_g21839_i0 PRJNA289590 22063 188 1.345324 2.52920912 Taxus chinensis 29808 Plants Plants 49.3 8.56e-5   NR KAH9299581.1 29808 g21839 i0 45 0.957446808510638 60 33 95.7 0 8 187 18 77 KAH9299581.1 hypothetical protein KI387_031263, partial [Taxus chinensis] diamond 180 49.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Taxaceae Taxus Taxus chinensis
28084787 28084787 PRJNA289590_P_NODE_20165_length_198_cov_1.731544_g19941_i0 PRJNA289590 20165 198 1.731544 3.42845712 Oryza meyeriana var. granulata 110450 Plants Plants 41.2 0.0405   NR KAF0907231.1 110450 g19941 i0 42.6 0.712121212121212 47 27 71.2 0 150 10 84 130 KAF0907231.1 hypothetical protein E2562_015738 [Oryza meyeriana var. granulata] diamond 141 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Oryza Oryza meyeriana
28084801 28084801 PRJNA289590_P_NODE_28285_length_166_cov_0.888889_g28061_i0 PRJNA289590 28285 166 0.888889 1.47555574 Lactuca sativa 4236 Plants Plants 94.7 6.4400000000000006e-21   NR KAJ0205032.1 4236 g28061 i0 89.1 7.95180722891566 55 6 99.4 0 166 2 215 269 KAJ0205032.1 hypothetical protein LSAT_V11C500233370 [Lactuca sativa] diamond 1320 94.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca sativa
28702533 28702533 PRJNA289590_P_NODE_10027_length_292_cov_2.625514_g9803_i0 PRJNA289590 10027 292 2.625514 7.66650088 root 1 Root_unresolved Root_unresolved 95.1 2.81e-20   NR GEU28496.1 118510 g9803 i0 62.3 15.9965753424658 77 29 79.1 0 62 292 422 498 GEU28496.1 hypothetical protein [Tanacetum cinerariifolium] diamond 4671 95.9 0.991657977059437 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
28937472 28937472 PRJNA289590_P_NODE_31408_length_162_cov_0.920354_g31184_i0 PRJNA289590 31408 162 0.920354 1.49097348 Lactuca saligna 75948 Plants Plants 62.4 3.54e-10   NR CAI9276967.1 75948 g31184 i0 71.1 0.703703703703704 38 11 70.4 0 159 46 139 176 CAI9276967.1 unnamed protein product [Lactuca saligna] diamond 114 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca saligna
29397044 29397044 PRJNA289590_P_NODE_9929_length_294_cov_1.412245_g9705_i0 PRJNA289590 9929 294 1.412245 4.1520003 root 1 Root_unresolved Root_unresolved 176 1.28e-48   NR GEU28335.1 118510 g9705 i0 89.7 6.92857142857143 97 10 99 0 3 293 1506 1602 GEU28335.1 acetylglutamate kinase [Tanacetum cinerariifolium] diamond 2037 177 0.994350282485876 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
29853107 29853107 PRJNA289590_P_NODE_26731_length_168_cov_0.873950_g26507_i0 PRJNA289590 26731 168 0.87395 1.468236 Lactuca virosa 75947 Plants Plants 100 4.419999999999999e-23   NR CAH1440299.1 75947 g26507 i0 90.9 1.96428571428571 55 5 98.2 0 2 166 178 232 CAH1440299.1 unnamed protein product [Lactuca virosa] diamond 330 100 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Lactuca Lactuca virosa
30516487 30516487 PRJNA289590_P_NODE_26933_length_168_cov_0.873950_g26709_i0 PRJNA289590 26933 168 0.87395 1.468236 Cinchona calisaya 153742 Plants Plants 62.4 7.56e-11   NR KAL3536430.1 153742 g26709 i0 70 0.714285714285714 40 12 71.4 0 167 48 64 103 KAL3536430.1 hypothetical protein ACH5RR_004891 [Cinchona calisaya] diamond 120 62.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Gentianales Rubiaceae Cinchona Cinchona calisaya
30755367 30755367 PRJNA289590_P_NODE_27734_length_167_cov_0.881356_g27510_i0 PRJNA289590 27734 167 0.881356 1.47186452 Sphagnum 13804 Plants Plants 53.1 2.76e-6   NR CAK9861730.1 128206 g27510 i0 51.9 4.56287425149701 52 24 93.4 1 11 166 9 59 CAK9861730.1 unnamed protein product, partial [Sphagnum jensenii] diamond 762 53.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
30800744 30800744 PRJNA289590_P_NODE_26814_length_168_cov_0.873950_g26590_i0 PRJNA289590 26814 168 0.87395 1.468236 Sphagnum jensenii 128206 Plants Plants 84 6.9e-19   NR CAK9251138.1 128206 g26590 i0 80 0.892857142857143 50 10 89.3 0 2 151 70 119 CAK9251138.1 unnamed protein product [Sphagnum jensenii] diamond 150 84 1 Eukaryota Embryophyta Viridiplantae Streptophyta Sphagnopsida Sphagnales Sphagnaceae Sphagnum Sphagnum jensenii
32413823 32413823 PRJNA289590_P_NODE_11279_length_273_cov_2.705357_g11055_i0 PRJNA289590 11279 273 2.705357 7.38562461 Brassica napus 3708 Plants Plants 44.7 0.00734   NR WZZ08975.1 3708 g11055 i0 48.8 0.472527472527473 43 21 46.2 1 39 164 127 169 WZZ08975.1 hypothetical protein YC2023_094896 [Brassica napus] diamond 129 44.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus

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