RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1072736" 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 · 10 ✖

bioproject 1

  • PRJNA1072736 · 10 ✖

analysis 1

  • blastn · 10 ✖
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
2737517 2737517 PRJNA1072736_S_NODE_2563_length_222_cov_41.312849_g2558_i0 PRJNA1072736 2563 222 41.312849 91.71452478 Triticum aestivum 4565 Plants Plants 60.2 1.18e-4   NTclustered gi|1963662117|emb|LR861820.1| 4565 g2558 i0 100 0.527027027027027 32 0 14 0 191 222 37 6 Triticum aestivum mRNA for NB-LRR protein (Pm1 gene), cultivar Axminster, allele Pm1a blastn 117 60.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Poales Poaceae Triticum Triticum aestivum
6564930 6564930 PRJNA1072736_S_NODE_4826_length_178_cov_1.229630_g4821_i0 PRJNA1072736 4826 178 1.22963 2.1887414 Brassica rapa 3711 Plants Plants 56.5 0.001   NTclustered gi|1516519470|emb|LR031572.1| 3711 g4821 i0 100 5.8314606741573 30 0 17 0 127 156 8136623 8136652 Brassica rapa genome, scaffold: A03 blastn 1038 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica rapa
7393545 7393545 PRJNA1072736_S_NODE_5566_length_169_cov_1.404762_g5561_i0 PRJNA1072736 5566 169 1.404762 2.37404778 Brassica 3705 Plants Plants 56.5 0.001   NTclustered gi|2258309977|ref|XM_048760574.1| 3708 g5561 i0 100 1.24260355029586 30 0 18 0 9 38 1195 1166 PREDICTED: Brassica napus NDR1/HIN1-like protein 6 (LOC106392178), transcript variant X5, mRNA blastn 210 56.5 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Brassica Brassica napus
7393546 7393546 PRJNA1072736_S_NODE_6666_length_158_cov_1.452174_g6661_i0 PRJNA1072736 6666 158 1.452174 2.29443492 Fabaceae 3803 Plants Plants 292 7.07e-75   NTclustered gi|156028074|gb|EF550007.1| 3847 g6661 i0 100 100 158 0 100 0 1 158 2251 2408 Glycine max cultivar Essex trnK gene, partial sequence; and maturase K (matK) gene, complete cds; chloroplast blastn 15800 292 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Glycine Glycine max
12940705 12940705 PRJNA1072736_S_NODE_2091_length_240_cov_1.192893_g2086_i0 PRJNA1072736 2091 240 1.192893 2.8629432 Picea abies 3329 Plants Plants 54.7 0.006   NTclustered gi|2835530364|dbj|LC777194.1| 3329 g2086 i0 100 0.2375 29 0 12 0 212 240 57 29 Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds blastn 57 54.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
14215644 14215644 PRJNA1072736_S_NODE_732_length_336_cov_19.006826_g727_i0 PRJNA1072736 732 336 19.006826 63.86293536 Ziziphus jujuba 326968 Plants Plants 52.8 0.032   NTclustered gi|2739574740|gb|CP157414.1| 326968 g727 i0 100 0.0833333333333333 28 0 8 0 257 284 17663010 17662983 Ziziphus jujuba isolate TW-2024b chromosome 12 blastn 28 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Rosales Rhamnaceae Ziziphus Ziziphus jujuba
16318301 16318301 PRJNA1072736_S_NODE_2893_length_213_cov_2.558824_g2888_i0 PRJNA1072736 2893 213 2.558824 5.45029512 root 1 Root_unresolved Root_unresolved 52.8 0.019   NTclustered gi|2835530364|dbj|LC777194.1| 3329 g2888 i0 100 0.262910798122066 28 0 13 0 1 28 29 56 Picea abies Pa-Kumamoto-2022 PaMurA mRNA for UDP-N-acetylglucosamine1-carboxyvinyltransferase, complete cds blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
21863823 21863823 PRJNA1072736_S_NODE_4758_length_178_cov_6.511111_g4753_i0 PRJNA1072736 4758 178 6.511111 11.58977758 Picea abies 3329 Plants Plants 52.8 0.015   NTclustered gi|2835530398|dbj|LC777204.1| 3329 g4753 i0 100 0.314606741573034 28 0 16 0 4 31 29 56 Picea abies Pa-Kumamoto-2022 PaPbp mRNA for penicillin-binding protein, complete cds blastn 56 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies
23139284 23139284 PRJNA1072736_S_NODE_3399_length_201_cov_2.284810_g3394_i0 PRJNA1072736 3399 201 2.28481 4.5924681 Elaeis guineensis 51953 Plants Plants 78.7 2.88e-10   NTclustered gi|1658128262|ref|XM_010938349.3| 51953 g3394 i0 100 0.82089552238806 42 0 21 0 160 201 891 850 PREDICTED: Elaeis guineensis protein YeeZ (LOC105056228), transcript variant X1, mRNA blastn 165 78.7 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Arecales Arecaceae Elaeis Elaeis guineensis
23968185 23968185 PRJNA1072736_S_NODE_3699_length_195_cov_1.671053_g3694_i0 PRJNA1072736 3699 195 1.671053 3.25855335 root 1 Root_unresolved Root_unresolved 52.8 0.017   NTclustered gi|2835530370|dbj|LC777197.1| 3329 g3694 i0 100 0.717948717948718 28 0 14 0 168 195 56 29 Picea abies Pa-Kumamoto-2022 PaMurD mRNA for UDP-MurNAc-L-alanyl-D-glutamate synthetase, complete cds blastn 140 52.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Pinales Pinaceae Picea Picea abies

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