RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJEB12982" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB12982 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
7673042 7673042 PRJEB12982_P_NODE_11367_length_209_cov_1.075000_g11204_i0 PRJEB12982 11367 209 1.075 2.24675 root 1 Root_unresolved Root_unresolved 108 1.2799999999999999e-28   NR KAE8577506.1 8364 g11204 i0 94.3 49.4497607655502 53 3 76.1 0 207 49 81 133 KAE8577506.1 hypothetical protein XENTR_v10004594 [Xenopus tropicalis] diamond 10335 108 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Pipidae Xenopus Xenopus tropicalis
16597831 16597831 PRJEB12982_P_NODE_2914_length_451_cov_1.141791_g2753_i0 PRJEB12982 2914 451 1.141791 5.14947741 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 197 6.77e-59   NR NP_001091345.1 8355 g2753 i0 64.2 10.9223946784922 151 50 97.8 1 446 6 14 164 NP_001091345.1 uncharacterized protein LOC100037184 [Xenopus laevis] diamond 4926 198 0.994949494949495 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Pipidae Xenopus Xenopus laevis
26621472 26621472 PRJEB12982_P_NODE_9521_length_230_cov_0.966851_g9358_i0 PRJEB12982 9521 230 0.966851 2.2237573 Bufotes viridis 30338 Chordata Chordata 43.9 0.0119   NR CAK8629749.1 30338 g9358 i0 71.4 0.365217391304348 28 8 36.5 0 184 101 335 362 CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] diamond 84 43.9 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
27159170 27159170 PRJEB12982_P_NODE_7802_length_259_cov_0.947619_g7639_i0 PRJEB12982 7802 259 0.947619 2.45433321 Bufotes viridis 30338 Chordata Chordata 43.1 0.0309   NR CAK8629749.1 30338 g7639 i0 73.1 0.602316602316602 26 7 30.1 0 200 123 335 360 CAK8629749.1 Interleukin-1 receptor type 1 [Bufotes viridis] diamond 156 43.5 0.990804597701149 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Bufonidae Bufotes Bufotes viridis
27412529 27412529 PRJEB12982_P_NODE_17463_length_166_cov_0.871795_g17300_i0 PRJEB12982 17463 166 0.871795 1.4471797 Mirounga angustirostris 9716 Chordata Chordata 63.9 4.41e-10   NR XP_064427218.1 9716 g17300 i0 55.6 4.95180722891566 45 20 81.3 0 166 32 172 216 XP_064427218.1 protein kinase C eta type isoform X2 [Mirounga angustirostris] diamond 822 64.3 0.993779160186625 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Phocidae Mirounga Mirounga angustirostris
27974284 27974284 PRJEB12982_P_NODE_17105_length_167_cov_0.864407_g16942_i0 PRJEB12982 17105 167 0.864407 1.44355969 Gymnophiona 8445 Chordata Chordata 97.8 3.0999999999999997e-24   NR XP_029470360.1 194408 g16942 i0 81.8 4.94011976047904 55 10 98.8 0 166 2 89 143 XP_029470360.1 40S ribosomal protein S27-like isoform X1 [Rhinatrema bivittatum] diamond 825 97.8 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Gymnophiona Rhinatrematidae Rhinatrema Rhinatrema bivittatum
28416469 28416469 PRJEB12982_P_NODE_19106_length_164_cov_0.886957_g18943_i0 PRJEB12982 19106 164 0.886957 1.45460948 Amphibia 8292 Chordata Chordata 56.2 2.2e-7   NR XP_069070717.1 8319 g18943 i0 59.6 6.71341463414634 47 18 84.1 1 156 19 482 528 XP_069070717.1 acyl-CoA dehydrogenase family member 11-like [Pleurodeles waltl] diamond 1101 56.6 0.992932862190813 Eukaryota Opisthokonta Metazoa Chordata Amphibia Caudata Salamandridae Pleurodeles Pleurodeles waltl
29868784 29868784 PRJEB12982_P_NODE_20331_length_162_cov_0.902655_g20168_i0 PRJEB12982 20331 162 0.902655 1.4623011 Crocodylia 1294634 Chordata Chordata 52 6.6e-6   NR XP_019392365.1 8502 g20168 i0 64.5 1.7037037037037 31 11 57.4 0 3 95 8 38 XP_019392365.1 PREDICTED: thioredoxin reductase 3 isoform X1 [Crocodylus porosus] diamond 276 52 1 Eukaryota Opisthokonta Metazoa Chordata   Crocodylia Crocodylidae Crocodylus Crocodylus porosus
30437708 30437708 PRJEB12982_P_NODE_16893_length_167_cov_0.864407_g16730_i0 PRJEB12982 16893 167 0.864407 1.44355969 Anura 8342 Chordata Chordata 63.5 6.08e-10   NR XP_040197539.1 8407 g16730 i0 62 5.53293413173653 50 18 88 1 8 154 1340 1389 XP_040197539.1 dynein heavy chain 3, axonemal-like [Rana temporaria] diamond 924 63.5 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Rana Rana temporaria
30753423 30753423 PRJEB12982_P_NODE_13454_length_191_cov_0.950704_g13291_i0 PRJEB12982 13454 191 0.950704 1.81584464 Chordata 7711 Chordata Chordata 85.9 1.48e-18   NR XP_034506505.1 9646 g13291 i0 63.9 78.5811518324607 61 22 95.8 0 183 1 136 196 XP_034506505.1 60S ribosomal protein L22-like [Ailuropoda melanoleuca] diamond 15009 86.7 0.990772779700115 Eukaryota Opisthokonta Metazoa Chordata Mammalia Carnivora Ursidae Ailuropoda Ailuropoda melanoleuca
30917887 30917887 PRJEB12982_P_NODE_6954_length_276_cov_1.577093_g6791_i0 PRJEB12982 6954 276 1.577093 4.35277668 Erpetoichthys calabaricus 27687 Chordata Chordata 120 1.63e-30   NR XP_051791274.1 27687 g6791 i0 77.1 7.21739130434783 83 18 89.1 1 29 274 115 197 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 1992 120 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
30943119 30943119 PRJEB12982_P_NODE_16414_length_169_cov_1.275000_g16251_i0 PRJEB12982 16414 169 1.275 2.15475 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 48.5 1.19e-4   NR CAG5087671.1 34765 g16251 i0 38 7.56213017751479 50 31 88.8 0 152 3 18 67 CAG5087671.1 Oidioi.mRNA.OKI2018_I69.PAR.g11601.t1.cds [Oikopleura dioica] diamond 1278 48.9 0.991820040899796 Eukaryota Opisthokonta Metazoa Chordata Appendicularia Copelata Oikopleuridae Oikopleura Oikopleura dioica
31258993 31258993 PRJEB12982_P_NODE_9635_length_228_cov_1.139665_g9472_i0 PRJEB12982 9635 228 1.139665 2.5984362 root 1 Root_unresolved Root_unresolved 107 1.18e-26   NR CAH1258701.1 7740 g9472 i0 64.4 8.64473684210526 73 26 96.1 0 220 2 168 240 CAH1258701.1 PRDX3 [Branchiostoma lanceolatum] diamond 1971 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma lanceolatum
31834488 31834488 PRJEB12982_P_NODE_21097_length_161_cov_0.910714_g20934_i0 PRJEB12982 21097 161 0.910714 1.46624954 Clavelina lepadiformis 159417 Chordata Chordata 56.2 2.1e-7   NR CAK8687992.1 159417 g20934 i0 60.8 1.90062111801242 51 20 95 0 9 161 275 325 CAK8687992.1 unnamed protein product [Clavelina lepadiformis] diamond 306 56.2 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Aplousobranchia Clavelinidae Clavelina Clavelina lepadiformis
32056098 32056098 PRJEB12982_P_NODE_18078_length_165_cov_1.603448_g17915_i0 PRJEB12982 18078 165 1.603448 2.6456892 Cyrtonyx montezumae 9017 Chordata Chordata 50.4 1.25e-5   NR XP_065594369.1 9017 g17915 i0 53.3 5.47272727272727 60 17 89.1 2 147 1 50 109 XP_065594369.1 small ribosomal subunit protein eS25 [Cyrtonyx montezumae] diamond 903 50.4 1 Eukaryota Opisthokonta Metazoa Chordata Aves Galliformes Odontophoridae Cyrtonyx Cyrtonyx montezumae
32845771 32845771 PRJEB12982_P_NODE_17940_length_166_cov_0.871795_g17777_i0 PRJEB12982 17940 166 0.871795 1.4471797 Phallusia mammillata 59560 Chordata Chordata 68.6 8.59e-12   NR CAB3250007.1 59560 g17777 i0 61.1 1.75301204819277 54 18 97.6 1 164 3 160 210 CAB3250007.1 guanine nucleotide-binding protein G(k) subunit alpha-like [Phallusia mammillata] diamond 291 68.6 1 Eukaryota Opisthokonta Metazoa Chordata Ascidiacea Phlebobranchia Ascidiidae Phallusia Phallusia mammillata

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