RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA345071" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA345071 · 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
4220526 4220526 PRJNA345071_P_NODE_10904_length_241_cov_3.190476_g10864_i0 PRJNA345071 10904 241 3.190476 7.68904716 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 296 9.08e-76   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g10864 i0 88.797 1 241 27 100 0 1 241 13835 14075 Stenostomum sthenum mitochondrion, complete genome blastn 241 296 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
5496946 5496946 PRJNA345071_P_NODE_3125_length_340_cov_2.217228_g3085_i0 PRJNA345071 3125 340 2.217228 7.5385752 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 335 2.849999999999999e-87   NTclustered gi|926460135|gb|KR132212.1| 282301 g3085 i0 84.503 99.0441176470588 342 49 100 4 1 340 1528 1189 Macrostomum lignano clone HSP90 heat shock protein 90 (hsp90) mRNA, complete cds blastn 33675 335 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
6770915 6770915 PRJNA345071_P_NODE_226_length_950_cov_62.417332_g198_i0 PRJNA345071 226 950 62.417332 592.964654 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 1478 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g198 i0 94.931 22.8431578947368 947 43 99 5 1 944 8040 8984 Stenostomum sthenum mitochondrion, complete genome blastn 21701 1478 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
6770974 6770974 PRJNA345071_P_NODE_446_length_726_cov_4.419602_g408_i0 PRJNA345071 446 726 4.419602 32.08631052 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 791 0   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g408 i0 86.427 83.3250688705234 722 98 99 0 3 724 1205 484 Stenostomum sthenum mitochondrion, complete genome blastn 60494 791 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
11871897 11871897 PRJNA345071_P_NODE_11350_length_221_cov_4.047297_g11310_i0 PRJNA345071 11350 221 4.047297 8.94452637 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 381 2.2e-101   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g11310 i0 97.738 2 221 5 100 0 1 221 2220 2440 Stenostomum sthenum mitochondrion, complete genome blastn 442 381 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
20794718 20794718 PRJNA345071_P_NODE_3077_length_342_cov_1.929368_g3037_i0 PRJNA345071 3077 342 1.929368 6.59843856 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 377 4.7e-100   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g3037 i0 86.55 6.05847953216374 342 46 100 0 1 342 5055 5396 Stenostomum sthenum mitochondrion, complete genome blastn 2072 377 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum
23345184 23345184 PRJNA345071_P_NODE_1359_length_470_cov_3.088161_g1319_i0 PRJNA345071 1359 470 3.088161 14.5143567 Stenostomum sthenum 1611831 Platyhelminthes Platyhelminthes 470 1.06e-127   NTclustered gi|1215837197|ref|NC_035256.1| 1611831 g1319 i0 84.926 15.8787234042553 471 63 99 7 1 467 11255 10789 Stenostomum sthenum mitochondrion, complete genome blastn 7463 470 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sthenum

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