RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA1067370" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1067370 · 7 ✖

analysis 1

  • blastn · 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
1455481 1455481 PRJNA1067370_P_NODE_30462_length_353_cov_1.803571_g29914_i0 PRJNA1067370 30462 353 1.803571 6.36660563 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 67.6 1.19e-6   NTclustered gi|2037951426|ref|XM_041620741.1| 7654 g29914 i0 89.091 0.623229461756374 55 5 15 1 252 305 2564 2510 PREDICTED: Lytechinus variegatus nascent polypeptide-associated complex subunit alpha, muscle-specific form-like (LOC121424886), transcript variant X2, mRNA blastn 220 67.6 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
4007363 4007363 PRJNA1067370_P_NODE_47824_length_301_cov_12.692982_g47276_i0 PRJNA1067370 47824 301 12.692982 38.20587582 Anneissia japonica 1529436 Echinodermata other_Eukaryota 52.8 0.028   NTclustered gi|1826637416|ref|XM_033250801.1| 1529436 g47276 i0 100 0.0930232558139535 28 0 9 0 150 177 3220 3193 PREDICTED: Anneissia japonica homeobox protein unc-4 homolog (LOC117108691), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
6559032 6559032 PRJNA1067370_P_NODE_8166_length_630_cov_1.278276_g7639_i0 PRJNA1067370 8166 630 1.278276 8.0531388 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 115 7.860000000000001e-21   NTclustered gi|2037951426|ref|XM_041620741.1| 7654 g7639 i0 77.957 1.64285714285714 186 39 29 2 27 211 2685 2501 PREDICTED: Lytechinus variegatus nascent polypeptide-associated complex subunit alpha, muscle-specific form-like (LOC121424886), transcript variant X2, mRNA blastn 1035 115 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
7833592 7833592 PRJNA1067370_P_NODE_69907_length_265_cov_1.083333_g69358_i0 PRJNA1067370 69907 265 1.083333 2.87083245 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 63.9 1.12e-5   NTclustered gi|1752343278|ref|XM_030977850.1| 7668 g69358 i0 95 2.26037735849057 40 2 15 0 79 118 1733 1772 PREDICTED: Strongylocentrotus purpuratus nucleolar protein dao-5-like (LOC115918424), transcript variant X2, mRNA blastn 599 63.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
9108215 9108215 PRJNA1067370_P_NODE_116888_length_232_cov_2.257862_g116339_i0 PRJNA1067370 116888 232 2.257862 5.23823984 Acanthaster planci 133434 Echinodermata other_Eukaryota 60.2 1.24e-4   NTclustered gi|1229187992|ref|XM_022252116.1| 133434 g116339 i0 100 0.689655172413793 32 0 14 0 123 154 2850 2819 PREDICTED: Acanthaster planci zinc finger protein PLAG1-like (LOC110988519), transcript variant X5, mRNA blastn 160 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
10384241 10384241 PRJNA1067370_P_NODE_57689_length_283_cov_1.757143_g57140_i0 PRJNA1067370 57689 283 1.757143 4.97271469 Asterias rubens 7604 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1834293604|ref|XM_033787930.1| 7604 g57140 i0 100 0.402826855123675 29 0 10 0 177 205 4295 4267 PREDICTED: Asterias rubens methylcytosine dioxygenase TET2-like (LOC117303674), transcript variant X1, mRNA blastn 114 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
24406707 24406707 PRJNA1067370_P_NODE_29480_length_358_cov_1.347368_g28932_i0 PRJNA1067370 29480 358 1.347368 4.82357744 Patiria miniata 46514 Echinodermata other_Eukaryota 287 8.54e-73   NTclustered gi|46909232|gb|AY580175.1| 46514 g28932 i0 82.143 94.072625698324 336 58 94 2 1 335 839 1173 Asterina miniata ATP synthase beta subunit mRNA, partial cds blastn 33678 287 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata

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