RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA400391" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA400391 · 4 ✖

analysis 1

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
10009147 10009147 PRJNA400391_S_NODE_5928_length_161_cov_1.825397_g5867_i0 PRJNA400391 5928 161 1.825397 2.93888917 Stenostomum 39238 Platyhelminthes Platyhelminthes 259 7.34e-65   NTclustered gi|209968693|gb|FJ384856.1| 570256 g5867 i0 96.203 71.3726708074534 158 6 98 0 1 158 80 237 Stenostomum sp. 'island' isolate K04_93 28S ribosomal RNA gene, partial sequence blastn 11491 259 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sp. 'island'
10618004 10618004 PRJNA400391_S_NODE_4489_length_189_cov_1.584416_g4428_i0 PRJNA400391 4489 189 1.584416 2.99454624 Stenostomum leucops 52061 Platyhelminthes Platyhelminthes 285 1.4699999999999998e-72   NTclustered gi|28273263|gb|AY157151.1| 52061 g4428 i0 95.531 64.2645502645503 179 7 95 1 1 179 2489 2312 Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence blastn 12146 285 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops
17658573 17658573 PRJNA400391_S_NODE_2554_length_251_cov_2.884259_g2493_i0 PRJNA400391 2554 251 2.884259 7.23949009 Stenostomum 39238 Platyhelminthes Platyhelminthes 448 2.48e-121   NTclustered gi|2177180|gb|U95947.1|SSU95947 60215 g2493 i0 98.805 99.5617529880478 251 3 100 0 1 251 388 138 Stenostomum sp. 'Aguinaldo, 1997' 18S ribosomal RNA gene, complete sequence blastn 24990 448 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum sp. 'Aguinaldo, 1997'
22090593 22090593 PRJNA400391_S_NODE_6418_length_154_cov_1.142857_g6357_i0 PRJNA400391 6418 154 1.142857 1.75999978 Stenostomum leucops 52061 Platyhelminthes Platyhelminthes 285 1.14e-72   NTclustered gi|28273263|gb|AY157151.1| 52061 g6357 i0 100 39.8701298701299 154 0 100 0 1 154 1971 2124 Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence blastn 6140 285 1 Eukaryota Opisthokonta Metazoa Platyhelminthes     Stenostomidae Stenostomum Stenostomum leucops

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