RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA575566" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA575566 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 0

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
3110966 3110966 PRJNA575566_P_NODE_22963_length_216_cov_0.993548_g22766_i0 PRJNA575566 22963 216 0.993548 2.14606368 Dictyostelium purpureum 5786 Evosea other_Eukaryota 137 5.119999999999999e-28   NTclustered gi|330843944|ref|XM_003293853.1| 5786 g22766 i0 80.214 7.98611111111111 187 33 86 4 3 187 332 148 Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_42693), partial mRNA blastn 1725 137 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum
5663679 5663679 PRJNA575566_P_NODE_13665_length_284_cov_2.286996_g13468_i0 PRJNA575566 13665 284 2.286996 6.49506864 Dictyostelium purpureum 5786 Evosea other_Eukaryota 60.2 1.57e-4   NTclustered gi|330797187|ref|XM_003286596.1| 5786 g13468 i0 97.143 0.123239436619718 35 1 12 0 209 243 923 889 Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_77529), partial mRNA blastn 35 60.2 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium purpureum
23512311 23512311 PRJNA575566_P_NODE_1639_length_806_cov_2.573154_g1466_i0 PRJNA575566 1639 806 2.573154 20.73962124 Dictyostelium citrinum 361072 Evosea other_Eukaryota 71.3 2.24e-7   NTclustered gi|294662991|ref|NC_007787.2| 361072 g1466 i0 88.525 5.17369727047146 61 3 7 4 330 387 20181 20240 Dictyostelium citrinum mitochondrion, complete genome blastn 4170 71.3 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium citrinum
23512642 23512642 PRJNA575566_P_NODE_9279_length_343_cov_1.361702_g9082_i0 PRJNA575566 9279 343 1.361702 4.67063786 Dictyostelium discoideum 44689 Evosea other_Eukaryota 63.9 1.5e-5   NTclustered gi|166240321|ref|XM_632518.2| 352472 g9082 i0 81.928 0.24198250728863 83 7 23 7 127 205 455 533 Dictyostelium discoideum AX4 acyl-CoA oxidase (DDB_G0286669) mRNA, complete cds blastn 83 63.9 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium discoideum

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