RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA515078" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA515078 · 6 ✖

analysis 1

  • blastn · 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
8139802 8139802 PRJNA515078_P_NODE_10087_length_285_cov_1.185484_g9854_i0 PRJNA515078 10087 285 1.185484 3.3786294 Ailoscolex lacteospumosus 1046305 Annelida Annelida 54.7 0.007   NTclustered gi|2920003644|emb|OZ238875.1| 1046305 g9854 i0 94.444 0.224561403508772 36 1 12 1 210 244 520155 520190 Ailoscolex lacteospumosus genome assembly, chromosome: 16 blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
8139819 8139819 PRJNA515078_P_NODE_12467_length_252_cov_1.269767_g12234_i0 PRJNA515078 12467 252 1.269767 3.19981284 Ailoscolex lacteospumosus 1046305 Annelida Annelida 58.4 4.91e-4   NTclustered gi|2920003527|emb|OZ238867.1| 1046305 g12234 i0 100 0.575396825396825 31 0 12 0 131 161 20955849 20955819 Ailoscolex lacteospumosus genome assembly, chromosome: 8 blastn 145 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
9414982 9414982 PRJNA515078_P_NODE_24108_length_177_cov_1.114286_g23875_i0 PRJNA515078 24108 177 1.114286 1.97228622 Hirudo verbana 311461 Annelida Annelida 58.4 3.21e-4   NTclustered gi|2918369693|emb|OZ237785.1| 311461 g23875 i0 100 1.44067796610169 31 0 18 0 20 50 797032 797002 Hirudo verbana genome assembly, chromosome: 7 blastn 255 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
14515793 14515793 PRJNA515078_P_NODE_26152_length_170_cov_1.172932_g25919_i0 PRJNA515078 26152 170 1.172932 1.9939844 Hirudo verbana 311461 Annelida Annelida 54.7 0.004   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g25919 i0 100 0.170588235294118 29 0 17 0 104 132 4048964 4048992 Hirudo verbana genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
16413655 16413655 PRJNA515078_P_NODE_30173_length_159_cov_1.278689_g29940_i0 PRJNA515078 30173 159 1.278689 2.03311551 Opisthokonta 33154 Annelida Annelida 52.8 0.013   NTclustered gi|675859291|ref|XM_009016958.1| 6412 g29940 i0 100 0.528301886792453 28 0 18 0 132 159 1089 1116 Helobdella robusta hypothetical protein partial mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta
22163747 22163747 PRJNA515078_P_NODE_7338_length_344_cov_1.306189_g7105_i0 PRJNA515078 7338 344 1.306189 4.49329016 Hirudo verbana 311461 Annelida Annelida 54.7 0.009   NTclustered gi|2918369620|emb|OZ237782.1| 311461 g7105 i0 100 0.927325581395349 29 0 8 0 222 250 12192786 12192814 Hirudo verbana genome assembly, chromosome: 4 blastn 319 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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