RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA664479", tax_kingdom = "Metazoa" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA664479 · 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
7007778 7007778 PRJNA664479_S_NODE_12326_length_175_cov_1.619048_g12250_i0 PRJNA664479 12326 175 1.619048 2.833334 Hirudo verbana 311461 Annelida Annelida 60.2 8.81e-5   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g12250 i0 100 4.49142857142857 32 0 19 0 68 99 1760047 1760016 Hirudo verbana genome assembly, chromosome: 11 blastn 786 60.2 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
27093562 27093562 PRJNA664479_S_NODE_3962_length_260_cov_2.033175_g3886_i0 PRJNA664479 3962 260 2.033175 5.286255 Metazoa 33208 Annelida Annelida 76.6 1.23e-15   NR KAK2181635.1 27915 g3886 i0 55 1.89230769230769 80 36 92.3 0 20 259 3 82 KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] diamond 492 76.6 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
28167557 28167557 PRJNA664479_S_NODE_14065_length_168_cov_0.899160_g13989_i0 PRJNA664479 14065 168 0.89916 1.5105888 Metazoa 33208 Annelida Annelida 70.5 1.88e-12   NR KAK2140683.1 53620 g13989 i0 72.5 54.0178571428571 51 14 91.1 0 9 161 4 54 KAK2140683.1 hypothetical protein LSH36_1279g00018 [Paralvinella palmiformis] diamond 9075 71.2 0.990168539325843 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Alvinellidae Paralvinella Paralvinella palmiformis
29102663 29102663 PRJNA664479_S_NODE_11088_length_182_cov_0.796992_g11012_i0 PRJNA664479 11088 182 0.796992 1.45052544 Ridgeia piscesae 27915 Annelida Annelida 70.5 1.15e-13   NR KAK2181635.1 27915 g11012 i0 61 0.972527472527473 59 23 97.3 0 2 178 20 78 KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] diamond 177 70.5 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
30461042 30461042 PRJNA664479_S_NODE_613_length_594_cov_12.933945_g546_i0 PRJNA664479 613 594 12.933945 76.8276333 Ridgeia piscesae 27915 Annelida Annelida 118 1.99e-30   NR KAK2181635.1 27915 g546 i0 53.5 0.641414141414141 127 59 64.1 0 125 505 3 129 KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] diamond 381 118 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
30492281 30492281 PRJNA664479_S_NODE_6533_length_216_cov_0.928144_g6457_i0 PRJNA664479 6533 216 0.928144 2.00479104 Dimorphilus gyrociliatus 2664684 Annelida Annelida 62 4.22e-9   NR CAD5125663.1 2664684 g6457 i0 57.7 11.5138888888889 52 22 72.2 0 216 61 53 104 CAD5125663.1 DgyrCDS13864 [Dimorphilus gyrociliatus] diamond 2487 62 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Dinophilidae Dimorphilus Dimorphilus gyrociliatus

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