RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA638724" and tax_kingdom = "Metazoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA638724 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
27017708 27017708 PRJNA638724_P_NODE_1542_length_470_cov_2.518892_g1456_i0 PRJNA638724 1542 470 2.518892 11.8387924 Erpetoichthys calabaricus 27687 Chordata Chordata 145 4.57e-39   NR XP_051791274.1 27687 g1456 i0 60.3 6.3 141 28 89.4 2 51 470 115 228 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 2961 145 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
28451638 28451638 PRJNA638724_P_NODE_6706_length_250_cov_0.870056_g6620_i0 PRJNA638724 6706 250 0.870056 2.17514 Entomobryomorpha 730330 Arthropoda Arthropoda 47 0.00125   NR ODN02543.1 48709 g6620 i0 57.1 1.584 42 18 50.4 0 3 128 26 67 ODN02543.1 Organic cation transporter protein [Orchesella cincta] diamond 396 47 1 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
29872380 29872380 PRJNA638724_P_NODE_631_length_684_cov_8.909984_g550_i0 PRJNA638724 631 684 8.909984 60.94429056 root 1 Root_unresolved Root_unresolved 53.1 4.35e-4   NR GBN61280.1 182803 g550 i0 50.9 2.14035087719298 53 26 23.2 0 543 385 1136 1188 GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] diamond 1464 53.1 1 Eukaryota Opisthokonta Metazoa Arthropoda Arachnida Araneae Araneidae Araneus Araneus ventricosus
31029096 31029096 PRJNA638724_P_NODE_2515_length_381_cov_1.717532_g2429_i0 PRJNA638724 2515 381 1.717532 6.54379692 Balaenoptera physalus 9770 Chordata Chordata 43.5 0.0243   NR KAB0401909.1 9770 g2429 i0 53.2 0.37007874015748 47 18 35.4 2 224 90 13 57 KAB0401909.1 hypothetical protein E2I00_017869, partial [Balaenoptera physalus] diamond 141 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Artiodactyla Balaenopteridae Balaenoptera Balaenoptera physalus
31452504 31452504 PRJNA638724_P_NODE_7076_length_246_cov_0.890173_g6990_i0 PRJNA638724 7076 246 0.890173 2.18982558 Orchesella 48705 Arthropoda Arthropoda 57.8 1.92e-7   NR ODM97000.1 48709 g6990 i0 63.9 0.878048780487805 36 13 43.9 0 230 123 140 175 ODM97000.1 RNA polymerase II-associated protein 1 [Orchesella cincta] diamond 216 58.2 0.993127147766323 Eukaryota Opisthokonta Metazoa Arthropoda Collembola Entomobryomorpha Orchesellidae Orchesella Orchesella cincta
32610221 32610221 PRJNA638724_P_NODE_1160_length_530_cov_3.258206_g1075_i0 PRJNA638724 1160 530 3.258206 17.2684918 Macrosiphum euphorbiae 13131 Arthropoda Arthropoda 63.5 3.88e-8   NR CAI6362451.1 13131 g1075 i0 29.2 1.63018867924528 144 96 80.9 5 12 440 568 706 CAI6362451.1 unnamed protein product [Macrosiphum euphorbiae] diamond 864 63.5 1 Eukaryota Opisthokonta Metazoa Arthropoda Insecta Hemiptera Aphididae Macrosiphum Macrosiphum euphorbiae

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