RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA235310" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA235310 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
16944657 16944657 PRJNA235310_P_NODE_3734_length_195_cov_1.424658_g3708_i0 PRJNA235310 3734 195 1.424658 2.7780831 Metazoa 33208 Annelida Annelida 107 5.05e-28   NR ABW90345.1 6446 g3708 i0 73.8 16.2615384615385 61 16 93.8 0 193 11 34 94 ABW90345.1 putative ribosomal protein L8, partial [Sipunculus nudus] diamond 3171 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Annelida Sipuncula Golfingiida Sipunculidae Sipunculus Sipunculus nudus
16944691 16944691 PRJNA235310_P_NODE_6074_length_163_cov_1.368421_g6048_i0 PRJNA235310 6074 163 1.368421 2.23052623 Paralvinella palmiformis 53620 Annelida Annelida 79.3 1.6e-15   NR KAK2156575.1 53620 g6048 i0 69.8 11.558282208589 53 16 97.5 0 162 4 824 876 KAK2156575.1 hypothetical protein LSH36_209g00006 [Paralvinella palmiformis] diamond 1884 79.3 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
30927279 30927279 PRJNA235310_P_NODE_934_length_411_cov_3.842541_g908_i0 PRJNA235310 934 411 3.842541 15.79284351 Eurythoe complanata 167815 Annelida Annelida 77.4 2.37e-15   NR ABW23238.1 167815 g908 i0 54.3 4.13868613138686 70 32 51.1 0 73 282 1 70 ABW23238.1 ribosomal protein rplp2 [Eurythoe complanata] diamond 1701 77.4 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Eunicida Amphinomidae Eurythoe Eurythoe complanata
32697544 32697544 PRJNA235310_P_NODE_2480_length_245_cov_1.408163_g2454_i0 PRJNA235310 2480 245 1.408163 3.44999935 Arenicola marina 6344 Annelida Annelida 132 3.9800000000000004e-36   NR ABW23138.1 6344 g2454 i0 70.4 5.95102040816327 81 24 99.2 0 245 3 146 226 ABW23138.1 ribosomal protein rps4, partial [Arenicola marina] diamond 1458 132 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina
32760627 32760627 PRJNA235310_P_NODE_4980_length_169_cov_0.866667_g4954_i0 PRJNA235310 4980 169 0.866667 1.46466723 Owenia fusiformis 6347 Annelida Annelida 58.2 5.8e-9   NR CAH1772573.1 6347 g4954 i0 78.1 1.06508875739645 32 7 56.8 0 96 1 2 33 CAH1772573.1 unnamed protein product [Owenia fusiformis] diamond 180 58.2 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Oweniidae Owenia Owenia fusiformis

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