RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA432257" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA432257 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
28212577 28212577 PRJNA432257_S_NODE_99006_length_177_cov_2.435714_g98625_i0 PRJNA432257 99006 177 2.435714 4.31121378 Lamellibrachia satsuma 104711 Annelida Annelida 64.3 3.84e-10   NR KAI0236386.1 104711 g98625 i0 51.8 0.949152542372881 56 27 94.9 0 168 1 7 62 KAI0236386.1 hypothetical protein LSAT2_013042 [Lamellibrachia satsuma] diamond 168 64.3 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
28749551 28749551 PRJNA432257_S_NODE_16907_length_341_cov_2.062500_g16526_i0 PRJNA432257 16907 341 2.0625 7.033125 Lamellibrachia satsuma 104711 Annelida Annelida 67 3.5e-10   NR KAI0207824.1 104711 g16526 i0 52.7 1.48680351906158 55 26 48.4 0 296 132 1 55 KAI0207824.1 hypothetical protein LSAT2_007476 [Lamellibrachia satsuma] diamond 507 67 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
28939124 28939124 PRJNA432257_S_NODE_28908_length_283_cov_2.146341_g28527_i0 PRJNA432257 28908 283 2.146341 6.07414503 Pectinaria gouldii 260746 Annelida Annelida 115 1.8599999999999997e-30   NR AKV16243.1 260746 g28527 i0 56.5 0.975265017667845 92 40 97.5 0 4 279 61 152 AKV16243.1 putative translationally controlled tumor protein [Pectinaria gouldii] diamond 276 115 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Terebellida Pectinariidae Pectinaria Pectinaria gouldii
29050301 29050301 PRJNA432257_S_NODE_78828_length_194_cov_2.452229_g78447_i0 PRJNA432257 78828 194 2.452229 4.75732426 Metazoa 33208 Annelida Annelida 104 1.18e-27   NR ABW23150.1 6344 g78447 i0 87 6.68041237113402 54 7 83.5 0 192 31 30 83 ABW23150.1 ribosomal protein rps21 [Arenicola marina] diamond 1296 104 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta   Arenicolidae Arenicola Arenicola marina
29965956 29965956 PRJNA432257_S_NODE_102711_length_174_cov_1.708029_g102330_i0 PRJNA432257 102711 174 1.708029 2.97197046 Sabellida 6362 Annelida Annelida 89.7 1.74e-19   NR KAI0212100.1 104711 g102330 i0 66.7 4.87931034482759 57 19 98.3 0 3 173 143 199 KAI0212100.1 Heterogeneous nuclear ribonucleoprotein D-like-A [Lamellibrachia satsuma] diamond 849 89.7 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Lamellibrachia Lamellibrachia satsuma
32098924 32098924 PRJNA432257_S_NODE_77018_length_196_cov_1.867925_g76637_i0 PRJNA432257 77018 196 1.867925 3.661133 Ridgeia piscesae 27915 Annelida Annelida 68.9 1.21e-12   NR KAK2171706.1 27915 g76637 i0 71.4 2.57142857142857 42 12 64.3 0 195 70 123 164 KAK2171706.1 hypothetical protein NP493_1036g00032 [Ridgeia piscesae] diamond 504 68.9 1 Eukaryota Opisthokonta Metazoa Annelida Polychaeta Sabellida Siboglinidae Ridgeia Ridgeia piscesae
32762430 32762430 PRJNA432257_S_NODE_46700_length_237_cov_2.535000_g46319_i0 PRJNA432257 46700 237 2.535 6.00795 Sipunculus nudus 6446 Annelida Annelida 123 4.87e-34   NR ABW90360.1 6446 g46319 i0 75.9 3 79 19 100 0 237 1 8 86 ABW90360.1 putative ribosomal protein L28 [Sipunculus nudus] diamond 711 123 1 Eukaryota Opisthokonta Metazoa Annelida Sipuncula Golfingiida Sipunculidae Sipunculus Sipunculus nudus

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