RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA611476 · 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
590040 590040 PRJNA611476_P_NODE_8401_length_669_cov_1.674497_g7626_i0 PRJNA611476 8401 669 1.674497 11.20238493 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 54.7 0.019   NTclustered gi|1191051559|ref|XM_021047964.1| 2652724 g7626 i0 100 0.0433482810164425 29 0 4 0 261 289 3846 3818 PREDICTED: Exaiptasia diaphana monocarboxylate transporter 10 (LOC110242031), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
5693846 5693846 PRJNA611476_P_NODE_98365_length_246_cov_0.890173_g97574_i0 PRJNA611476 98365 246 0.890173 2.18982558 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 198 2.7e-46   NTclustered gi|2782871477|ref|XM_067061169.1| 252671 g97574 i0 81.59 7.84146341463415 239 44 97 0 7 245 482 244 PREDICTED: Clytia hemisphaerica ras-related C3 botulinum toxin substrate 1 (LOC136804570), mRNA blastn 1929 198 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
13343228 13343228 PRJNA611476_P_NODE_17151_length_477_cov_1.490099_g16361_i0 PRJNA611476 17151 477 1.490099 7.10777223 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 416 1.43e-111   NTclustered gi|2782899435|ref|XM_067068137.1| 252671 g16361 i0 82.536 484.675052410901 481 76 100 6 1 477 598 122 PREDICTED: Clytia hemisphaerica polyubiquitin-B (LOC136811514), mRNA blastn 231190 416 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
15891836 15891836 PRJNA611476_P_NODE_105513_length_244_cov_0.900585_g104722_i0 PRJNA611476 105513 244 0.900585 2.1974274 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 156 1.63e-33   NTclustered gi|2729075187|ref|XM_065199843.1| 499914 g104722 i0 84.615 13.0696721311475 156 24 64 0 1 156 773 618 PREDICTED: Rhopilema esculentum large ribosomal subunit protein uL2-like (LOC135684318), mRNA blastn 3189 156 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
16450510 16450510 PRJNA611476_P_NODE_2093_length_1361_cov_14.609472_g1576_i0 PRJNA611476 2093 1361 14.609472 198.83491392 root 1 Root_unresolved Root_unresolved 54.7 0.039   NTclustered gi|2917940696|emb|OZ237557.1| 6108 g1576 i0 100 0.527553269654666 29 0 2 0 771 799 7107589 7107561 Anemonia sulcata genome assembly, chromosome: 3 blastn 718 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
17725536 17725536 PRJNA611476_P_NODE_115154_length_241_cov_1.375000_g114363_i0 PRJNA611476 115154 241 1.375 3.31375 Metazoa 33208 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2917940735|emb|OZ237565.1| 6108 g114363 i0 100 0.580912863070539 28 0 12 0 1 28 11267017 11266990 Anemonia sulcata genome assembly, chromosome: 11 blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
22266626 22266626 PRJNA611476_P_NODE_41198_length_333_cov_1.184615_g40407_i0 PRJNA611476 41198 333 1.184615 3.94476795 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 60.2 1.88e-4   NTclustered gi|2782937488|ref|XM_067075281.1| 252671 g40407 i0 100 3.84384384384384 32 0 10 0 28 59 1041 1072 PREDICTED: Clytia hemisphaerica transcription initiation factor IIA subunit 1-like (LOC136819110), mRNA blastn 1280 60.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica

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