RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA857143" 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

  • PRJNA857143 · 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
2119801 2119801 PRJNA857143_S_NODE_74542_length_347_cov_1.708029_g73449_i0 PRJNA857143 74542 347 1.708029 5.92686063 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.009   NTclustered gi|2918369566|emb|OZ237732.1| 317547 g73449 i0 100 0.331412103746398 29 0 8 0 198 226 1714756 1714728 Eunicella cavolini genome assembly, chromosome: 16 blastn 115 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
8497474 8497474 PRJNA857143_S_NODE_93707_length_320_cov_3.473684_g92614_i0 PRJNA857143 93707 320 3.473684 11.1157888 Eunicella cavolini 317547 Cnidaria other_Eukaryota 54.7 0.008   NTclustered gi|2918369564|emb|OZ237730.1| 317547 g92614 i0 100 0.090625 29 0 9 0 152 180 3667557 3667529 Eunicella cavolini genome assembly, chromosome: 14 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Eunicellidae Eunicella Eunicella cavolini
11047347 11047347 PRJNA857143_S_NODE_187029_length_245_cov_1.360465_g185936_i0 PRJNA857143 187029 245 1.360465 3.33313925 Stylophora pistillata 50429 Cnidaria other_Eukaryota 67.6 7.9e-7   NTclustered gi|1270028065|ref|XM_022952689.1| 50429 g185936 i0 89.286 4.02040816326531 56 3 22 3 69 123 570 623 PREDICTED: Stylophora pistillata wiskott-Aldrich syndrome protein homolog 1-like (LOC111345318), transcript variant X2, mRNA blastn 985 67.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
11439003 11439003 PRJNA857143_S_NODE_134489_length_279_cov_1.800971_g133396_i0 PRJNA857143 134489 279 1.800971 5.02470909 Coronatae 86058 Cnidaria other_Eukaryota 86.1 2.53e-12   NTclustered gi|15208481|gb|AY026368.1| 86043 g133396 i0 89.552 0.480286738351254 67 7 24 0 20 86 1403 1469 Atolla vanhoeffeni 28S large subunit ribosomal RNA gene, partial sequence blastn 134 86.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Coronatae Atollidae Atolla Atolla vanhoeffeni
11439056 11439056 PRJNA857143_S_NODE_31589_length_457_cov_23.768229_g30497_i0 PRJNA857143 31589 457 23.768229 108.62080653 Ellisella 328399 Cnidaria other_Eukaryota 97.1 2.02e-15   NTclustered gi|2689317297|gb|PP410744.1| 2751895 g30497 i0 95.161 13.5798687089716 62 2 22 1 325 386 3528 3588 Ellisella elongata voucher USNM:1660444 large subunit ribosomal RNA gene, partial sequence blastn 6206 97.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleralcyonacea Ellisellidae Ellisella Ellisella elongata
21244902 21244902 PRJNA857143_S_NODE_103717_length_309_cov_1.444915_g102624_i0 PRJNA857143 103717 309 1.444915 4.46478735 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.029   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g102624 i0 96.774 0.100323624595469 31 1 10 0 228 258 11317220 11317190 Anemonia sulcata genome assembly, chromosome: 6 blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
25069335 25069335 PRJNA857143_S_NODE_142500_length_272_cov_2.924623_g141407_i0 PRJNA857143 142500 272 2.924623 7.95497456 Xenia sp. Carnegie-2017 2897299 Cnidaria other_Eukaryota 73.1 1.92e-8   NTclustered gi|2202656492|ref|XM_047000882.1| 2897299 g141407 i0 86.364 3.59558823529412 66 9 24 0 154 219 373 308 PREDICTED: Xenia sp. Carnegie-2017 cysteine-rich and transmembrane domain-containing protein B-like (LOC124450251), transcript variant X5, mRNA blastn 978 73.1 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017

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