RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA669701" 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

  • PRJNA669701 · 5 ✖

analysis 1

  • blastn · 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
1912232 1912232 PRJNA669701_P_NODE_64842_length_306_cov_1.321888_g64447_i0 PRJNA669701 64842 306 1.321888 4.04497728 Hirudo verbana 311461 Annelida Annelida 54.7 0.008   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g64447 i0 96.875 0.209150326797386 32 1 10 0 44 75 7947858 7947889 Hirudo verbana genome assembly, chromosome: 13 blastn 64 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
2440001 2440001 PRJNA669701_P_NODE_86322_length_274_cov_2.482587_g85927_i0 PRJNA669701 86322 274 2.482587 6.80228838 Metazoa 33208 Annelida Annelida 209 1.41e-49   NTclustered gi|1068288397|gb|KU728766.1| 6390 g85927 i0 80.97 77.1021897810219 268 47 97 4 8 273 1082 817 Enchytraeus albidus mitochondrial ATP synthase subunit beta precursor, mRNA, partial cds; nuclear gene for mitochondrial product blastn 21126 209 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Enchytraeida Enchytraeidae Enchytraeus Enchytraeus albidus
4463759 4463759 PRJNA669701_P_NODE_45804_length_353_cov_1.100000_g45409_i0 PRJNA669701 45804 353 1.1 3.883 Ailoscolex lacteospumosus 1046305 Annelida Annelida 65.8 4.29e-6   NTclustered gi|2920003545|emb|OZ238868.1| 1046305 g45409 i0 100 1.1643059490085 35 0 10 0 34 68 22690197 22690163 Ailoscolex lacteospumosus genome assembly, chromosome: 9 blastn 411 65.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Ailoscolecidae Ailoscolex Ailoscolex lacteospumosus
4464364 4464364 PRJNA669701_P_NODE_91624_length_268_cov_1.579487_g91229_i0 PRJNA669701 91624 268 1.579487 4.23302516 Hirudo verbana 311461 Annelida Annelida 52.8 0.025   NTclustered gi|2918369693|emb|OZ237785.1| 311461 g91229 i0 100 0.417910447761194 28 0 10 0 30 57 2109487 2109514 Hirudo verbana genome assembly, chromosome: 7 blastn 112 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
4992285 4992285 PRJNA669701_P_NODE_146904_length_229_cov_2.711538_g146509_i0 PRJNA669701 146904 229 2.711538 6.20942202 Opisthokonta 33154 Annelida Annelida 111 3.32e-20   NTclustered gi|675851743|ref|XM_009013184.1| 6412 g146509 i0 81.752 37.7423580786026 137 21 59 4 39 173 299 165 Helobdella robusta hypothetical protein partial mRNA blastn 8643 111 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Rhynchobdellida Glossiphoniidae Helobdella Helobdella robusta

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