RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJDB3785" and tax_phylum = "Chaetognatha"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chaetognatha · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB3785 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
19134503 19134503 PRJDB3785_S_NODE_7576_length_273_cov_1.133929_g7423_i0 PRJDB3785 7576 273 1.133929 3.09562617 Spadella cephaloptera 52888 Chaetognatha other_Eukaryota 130 1.16e-36   NR CAL69099.1 52888 g7423 i0 95.7 2.27472527472527 69 3 75.8 0 1 207 83 151 CAL69099.1 TPA: putative 40S ribosomal protein S13 [Spadella cephaloptera] diamond 621 130 1 Eukaryota Opisthokonta Metazoa Chaetognatha Sagittoidea Phragmophora Spadellidae Spadella Spadella cephaloptera
27626993 27626993 PRJDB3785_S_NODE_12084_length_220_cov_1.432749_g11931_i0 PRJDB3785 12084 220 1.432749 3.1520478 Metazoa 33208 Chaetognatha other_Eukaryota 103 3e-26   NR CAL69071.1 52888 g11931 i0 62 7.74545454545455 71 27 96.8 0 218 6 66 136 CAL69071.1 TPA: putative 60S ribosomal protein L27 isoform 2 [Spadella cephaloptera] diamond 1704 103 1 Eukaryota Opisthokonta Metazoa Chaetognatha Sagittoidea Phragmophora Spadellidae Spadella Spadella cephaloptera
30727485 30727485 PRJDB3785_S_NODE_2614_length_482_cov_3.115473_g2463_i0 PRJDB3785 2614 482 3.115473 15.01657986 Spadella cephaloptera 52888 Chaetognatha other_Eukaryota 119 2.2000000000000002e-30   NR CAL69059.1 52888 g2463 i0 71.8 1.92946058091286 78 22 48.5 0 479 246 107 184 CAL69059.1 TPA: putative 60S ribosomal protein L9 [Spadella cephaloptera] diamond 930 119 1 Eukaryota Opisthokonta Metazoa Chaetognatha Sagittoidea Phragmophora Spadellidae Spadella Spadella cephaloptera
32144592 32144592 PRJDB3785_S_NODE_1358_length_686_cov_3.593407_g1238_i0 PRJDB3785 1358 686 3.593407 24.65077202 Metazoa 33208 Chaetognatha other_Eukaryota 183 1.9199999999999996e-55   NR CAL69071.1 52888 g1238 i0 62.4 4.68804664723032 133 50 58.2 0 55 453 4 136 CAL69071.1 TPA: putative 60S ribosomal protein L27 isoform 2 [Spadella cephaloptera] diamond 3216 184 0.994565217391304 Eukaryota Opisthokonta Metazoa Chaetognatha Sagittoidea Phragmophora Spadellidae Spadella Spadella cephaloptera

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