RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA494251" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA494251 · 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
2382457 2382457 PRJNA494251_P_NODE_3602_length_655_cov_2.685567_g3319_i0 PRJNA494251 3602 655 2.685567 17.59046385 Porifera 6040 Porifera other_Eukaryota 479 2.519999999999999e-130   NTclustered gi|2732902391|ref|XM_065339131.1| 27933 g3319 i0 81.188 91.5206106870229 606 104 92 8 46 646 1186 586 PREDICTED: Sycon ciliatum actin-3-like (LOC135826522), mRNA blastn 59946 479 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
8128444 8128444 PRJNA494251_P_NODE_37907_length_250_cov_1.378531_g37593_i0 PRJNA494251 37907 250 1.378531 3.4463275 Sycon ciliatum 27933 Porifera other_Eukaryota 63.9 1.05e-5   NTclustered gi|2732920009|ref|XM_065326823.1| 27933 g37593 i0 100 1.696 34 0 14 0 210 243 882 849 PREDICTED: Sycon ciliatum synergin gamma-like (LOC135813813), mRNA blastn 424 63.9 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
11310112 11310112 PRJNA494251_P_NODE_8789_length_447_cov_2.254011_g8485_i0 PRJNA494251 8789 447 2.254011 10.07542917 Metazoa 33208 Porifera other_Eukaryota 52.8 0.043   NTclustered gi|2732903729|ref|XM_065339866.1| 27933 g8485 i0 100 0.125279642058166 28 0 6 0 78 105 1993 2020 PREDICTED: Sycon ciliatum mucin-2-like (LOC135827356), mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
15134928 15134928 PRJNA494251_P_NODE_26532_length_284_cov_2.919431_g26218_i0 PRJNA494251 26532 284 2.919431 8.29118404 Opisthokonta 33154 Porifera other_Eukaryota 163 1.16e-35   NTclustered gi|457866990|emb|HF570289.1| 27933 g26218 i0 77.574 5.80281690140845 272 59 95 2 14 284 458 188 Sycon ciliatum mRNA for 40S ribosomal protein S14 (rps14 gene) blastn 1648 163 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
17052674 17052674 PRJNA494251_P_NODE_30914_length_268_cov_22.733333_g30600_i0 PRJNA494251 30914 268 22.733333 60.92533244 Dysidea avara 196820 Porifera other_Eukaryota 263 1.04e-65   NTclustered gi|2749550226|ref|XM_066042492.1| 196820 g30600 i0 86.722 84.2873134328358 241 26 89 6 1 238 325 88 PREDICTED: Dysidea avara actin, cytoplasmic (LOC136250303), mRNA blastn 22589 263 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
23428007 23428007 PRJNA494251_P_NODE_6699_length_502_cov_2.568765_g6397_i0 PRJNA494251 6699 502 2.568765 12.8952003 Oscarella lobularis 121494 Porifera other_Eukaryota 56.5 0.004   NTclustered gi|2746772773|ref|XM_065970894.1| 121494 g6397 i0 97.059 0.0677290836653386 34 0 7 1 405 438 2912 2944 PREDICTED: Oscarella lobularis dynein beta chain, ciliary-like (LOC136184061), mRNA blastn 34 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis

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