RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA1175041 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
7418932 7418932 PRJNA1175041_P_NODE_104386_length_242_cov_0.899408_g101518_i0 PRJNA1175041 104386 242 0.899408 2.17656736 Magnoliopsida 3398 Plants Plants 126 1.05e-32   NR KAK1439614.1 13708 g101518 i0 76.3 9.91735537190083 80 19 99.2 0 3 242 244 323 KAK1439614.1 hypothetical protein QVD17_05434 [Tagetes erecta] diamond 2400 127 0.992125984251969 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tagetes Tagetes erecta
7969724 7969724 PRJNA1175041_P_NODE_102587_length_244_cov_0.888889_g99719_i0 PRJNA1175041 102587 244 0.888889 2.16888916 Liquidambar formosana 63359 Plants Plants 79.7 5.06e-16   NR KAK9289475.1 63359 g99719 i0 62.5 0.983606557377049 80 21 98.4 3 243 4 68 138 KAK9289475.1 hypothetical protein L1049_007630 [Liquidambar formosana] diamond 240 79.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Saxifragales Altingiaceae Liquidambar Liquidambar formosana
13071233 13071233 PRJNA1175041_P_NODE_99391_length_247_cov_0.867816_g96523_i0 PRJNA1175041 99391 247 0.867816 2.14350552 Bauhinia variegata 167791 Plants Plants 132 2.57e-34   NR KAI4333178.1 167791 g96523 i0 71.6 2.95141700404858 81 23 98.4 0 4 246 242 322 KAI4333178.1 hypothetical protein L6164_018016 [Bauhinia variegata] diamond 729 132 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Bauhinia Bauhinia variegata
15620395 15620395 PRJNA1175041_P_NODE_98793_length_247_cov_0.873563_g95925_i0 PRJNA1175041 98793 247 0.873563 2.15770061 Ericales 41945 Plants Plants 139 1.21e-38   NR XP_028093611.1 4442 g95925 i0 87.8 12.9473684210526 82 10 99.6 0 247 2 176 257 XP_028093611.1 vesicle-associated protein 4-2-like [Camellia sinensis] diamond 3198 139 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis
21994094 21994094 PRJNA1175041_P_NODE_87998_length_271_cov_1.424242_g85130_i0 PRJNA1175041 87998 271 1.424242 3.8596958200000002 Magnoliopsida 3398 Plants Plants 102 5.72e-26   NR XP_012858566.1 4155 g85130 i0 86 14.8339483394834 57 8 63.1 0 172 2 1 57 XP_012858566.1 PREDICTED: copper transport protein CCH-like [Erythranthe guttata] diamond 4020 103 0.990291262135922 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Phrymaceae Erythranthe Erythranthe guttata
28209028 28209028 PRJNA1175041_P_NODE_58966_length_381_cov_0.896104_g56098_i0 PRJNA1175041 58966 381 0.896104 3.41415624 Vitis vinifera 29760 Plants Plants 55.5 7.43e-7   NR CBI20901.3 29760 g56098 i0 59.6 0.818897637795276 52 20 40.9 1 368 213 3 53 CBI20901.3 unnamed protein product, partial [Vitis vinifera] diamond 312 55.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
28259726 28259726 PRJNA1175041_P_NODE_85746_length_277_cov_1.627451_g82878_i0 PRJNA1175041 85746 277 1.627451 4.50803927 Magnoliopsida 3398 Plants Plants 136 1.5e-37   NR XP_030508234.1 3483 g82878 i0 72.8 1.9927797833935 92 25 99.6 0 276 1 142 233 XP_030508234.1 uncharacterized protein LOC115722982 [Cannabis sativa] diamond 552 136 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Cannabaceae Cannabis Cannabis sativa
28386185 28386185 PRJNA1175041_P_NODE_99046_length_247_cov_0.873563_g96178_i0 PRJNA1175041 99046 247 0.873563 2.15770061 Magnoliopsida 3398 Plants Plants 101 9.57e-26   NR XP_009804089.1 4096 g96178 i0 71.7 3.34008097165992 60 17 72.9 0 180 1 1 60 XP_009804089.1 uncharacterized protein [Nicotiana sylvestris] diamond 825 101 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Nicotiana Nicotiana sylvestris
28682985 28682985 PRJNA1175041_P_NODE_107207_length_240_cov_0.898204_g104339_i0 PRJNA1175041 107207 240 0.898204 2.1556896 Zea mays 4577 Plants Plants 116 1.72e-30   NR NP_001168103.1 4577 g104339 i0 76.1 9.95 67 16 83.8 0 240 40 116 182 NP_001168103.1 uncharacterized protein LOC100381841 [Zea mays] diamond 2388 116 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Zea Zea mays
28859702 28859702 PRJNA1175041_P_NODE_50848_length_434_cov_0.847645_g47981_i0 PRJNA1175041 50848 434 0.847645 3.6787793 Magnoliopsida 3398 Plants Plants 119 8.480000000000001e-29   NR CAL9014535.1 151428 g47981 i0 47.4 6.33870967741935 133 62 87.1 3 390 13 3 134 CAL9014535.1 unnamed protein product [Prunus brigantina] diamond 2751 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rosaceae Prunus Prunus brigantina
31734703 31734703 PRJNA1175041_P_NODE_106877_length_240_cov_0.910180_g104009_i0 PRJNA1175041 106877 240 0.91018 2.184432 Magnoliopsida 3398 Plants Plants 126 1.51e-31   NR RVX07820.1 29760 g104009 i0 80.2 13.1375 81 15 100 1 240 1 303 383 RVX07820.1 TBC1 domain family member 5 [Vitis vinifera] diamond 3153 126 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis vinifera
32367848 32367848 PRJNA1175041_P_NODE_67739_length_337_cov_2.761364_g64871_i0 PRJNA1175041 67739 337 2.761364 9.30579668 Magnoliopsida 3398 Plants Plants 45.8 0.00138   NR KAJ9672252.1 103349 g64871 i0 56.3 1.28189910979228 48 21 42.7 0 12 155 1 48 KAJ9672252.1 hypothetical protein PVL29_025747 [Vitis rotundifolia] diamond 432 46.2 0.991341991341991 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Vitales Vitaceae Vitis Vitis rotundifolia
32443693 32443693 PRJNA1175041_P_NODE_80459_length_292_cov_2.178082_g77591_i0 PRJNA1175041 80459 292 2.178082 6.35999944 Paulownia fortunei 586722 Plants Plants 86.3 1.71e-17   NR KAI3468241.1 586722 g77591 i0 50 1.72602739726027 84 41 86.3 1 39 290 135 217 KAI3468241.1 hypothetical protein Pfo_024904 [Paulownia fortunei] diamond 504 86.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Paulowniaceae Paulownia Paulownia fortunei

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