RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA385073", tax_clade = "Opisthokonta" 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

tax_clade 1

  • Opisthokonta · 6 ✖

bioproject 1

  • PRJNA385073 · 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
2956179 2956179 PRJNA385073_P_NODE_14083_length_360_cov_1.073171_g13922_i0 PRJNA385073 14083 360 1.073171 3.8634156 Hirudo verbana 311461 Annelida Annelida 56.5 0.003   NTclustered gi|2918369613|emb|OZ237779.1| 311461 g13922 i0 88 0.138888888888889 50 3 14 3 147 195 11779400 11779447 Hirudo verbana genome assembly, chromosome: 1 blastn 50 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
4232599 4232599 PRJNA385073_P_NODE_13784_length_362_cov_1.903114_g13623_i0 PRJNA385073 13784 362 1.903114 6.88927268 Ninoe nigripes 318790 Annelida Annelida 560 4.61e-155   NTclustered gi|61652091|gb|AY838862.1| 318790 g13623 i0 94.536 24.7430939226519 366 15 100 4 1 362 818 454 Ninoe nigripes 28S ribosomal RNA gene, partial sequence blastn 8957 560 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Eunicida Lumbrineridae Ninoe Ninoe nigripes
5509765 5509765 PRJNA385073_P_NODE_39685_length_254_cov_2.502762_g39523_i0 PRJNA385073 39685 254 2.502762 6.35701548 Ailoscolex lacteospumosus 1046305 Annelida Annelida 52.8 0.023   NTclustered gi|2920003418|emb|OZ238863.1| 1046305 g39523 i0 100 0.110236220472441 28 0 11 0 98 125 13068524 13068551 Ailoscolex lacteospumosus genome assembly, chromosome: 4 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
11884461 11884461 PRJNA385073_P_NODE_27470_length_286_cov_1.774648_g27308_i0 PRJNA385073 27470 286 1.774648 5.07549328 Lumbriculus variegatus 61662 Annelida Annelida 272 1.86e-68   NTclustered gi|131573173|gb|EF443157.1| 61662 g27308 i0 84.229 97.3496503496503 279 44 98 0 8 286 369 91 Lumbriculus variegatus alpha tubulin mRNA, partial cds blastn 27842 272 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Lumbriculida Lumbriculidae Lumbriculus Lumbriculus variegatus
16983820 16983820 PRJNA385073_P_NODE_58034_length_241_cov_1.755952_g57872_i0 PRJNA385073 58034 241 1.755952 4.23184432 Prionospio sp. 3 MH-2023 3059271 Annelida Annelida 185 2.0499999999999998e-42   NTclustered gi|2532676581|gb|OR243570.1| 3059271 g57872 i0 80.816 15.0912863070539 245 39 99 6 1 240 3388 3629 Prionospio sp. 3 MH-2023 isolate MH29 large subunit ribosomal RNA gene, partial sequence blastn 3637 185 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Spionida Spionidae Prionospio Prionospio sp. 3 MH-2023
27359844 27359844 PRJNA385073_P_NODE_44543_length_249_cov_1.511364_g44381_i0 PRJNA385073 44543 249 1.511364 3.76329636 Lamellibrachia satsuma 104711 Annelida Annelida 111 3.1300000000000003e-26   NR KAI0231760.1 104711 g44381 i0 70.3 2.80722891566265 74 22 89.2 0 223 2 32 105 KAI0231760.1 General transcription and DNA repair factor IIH helicase subunit XPB [Lamellibrachia satsuma] diamond 699 111 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma

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