RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1120203" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1120203 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
9203140 9203140 PRJNA1120203_P_NODE_67968_length_272_cov_35.773869_g66952_i0 PRJNA1120203 67968 272 35.773869 97.30492368 Liriope tetraphylla 37524 Cnidaria other_Eukaryota 407 4.619999999999999e-109   NTclustered gi|952952540|gb|KT809327.1| 37524 g66952 i0 94.981 95.2316176470588 259 13 95 0 13 271 2581 2839 Liriope tetraphylla mitochondrion, partial genome blastn 25903 407 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Limnomedusae Geryoniidae Liriope Liriope tetraphylla
9956006 9956006 PRJNA1120203_P_NODE_60088_length_290_cov_1.294931_g59072_i0 PRJNA1120203 60088 290 1.294931 3.7552999 Cyanea 27803 Cnidaria other_Eukaryota 490 4.799999999999999e-134   NTclustered gi|2020261272|gb|MW832751.1| 135523 g59072 i0 98.556 94.0172413793103 277 4 96 0 1 277 223 499 Cyanea nozakii isolate 16S rRNA Hap31 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 27265 490 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Semaeostomeae Cyaneidae Cyanea Cyanea nozakii
15055213 15055213 PRJNA1120203_P_NODE_106352_length_237_cov_10.219512_g105336_i0 PRJNA1120203 106352 237 10.219512 24.22024344 Scleractinia 6125 Cnidaria other_Eukaryota 399 6.589999999999999e-107   NTclustered gi|2889125804|gb|PQ875201.1| 51068 g105336 i0 98.667 94.6708860759494 225 3 95 0 1 225 1406 1630 Sandalolitha robusta isolate 3209F mitochondrion, complete genome blastn 22437 399 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Fungiidae Sandalolitha Sandalolitha robusta
19401177 19401177 PRJNA1120203_P_NODE_73956_length_259_cov_2.827957_g72940_i0 PRJNA1120203 73956 259 2.827957 7.32440863 Hydractinia carica 2752231 Cnidaria other_Eukaryota 172 1.7399999999999999e-38   NTclustered gi|150368568|emb|AM411418.1| 2752231 g72940 i0 79.518 19.1737451737452 249 46 95 5 14 259 468 222 Hydractinia minuta 16S rRNA gene, haplotype Hydractinia minuta mitochondrial partial 16S rRNA variant New Zealand blastn 4966 172 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia carica
20153971 20153971 PRJNA1120203_P_NODE_106516_length_234_cov_4.515528_g105500_i0 PRJNA1120203 106516 234 4.515528 10.56633552 Merulinidae 46736 Cnidaria other_Eukaryota 394 3.02e-105   NTclustered gi|2571076060|gb|OR492066.1| 498486 g105500 i0 98.649 94.8076923076923 222 3 95 0 1 222 207 428 Favites pentagona isolate M24 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 22185 394 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Favites Favites pentagona

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