RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA688352" and tax_phylum = "Chordata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chordata · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA688352 · 7 ✖

analysis 1

  • diamond · 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
19028446 19028446 PRJNA688352_P_NODE_3495_length_333_cov_2.207692_g3392_i0 PRJNA688352 3495 333 2.207692 7.35161436 root 1 Root_unresolved Root_unresolved 216 7.34e-64   NR XP_030109804.2 10090 g3392 i0 95.5 12.981981981982 111 5 100 0 333 1 69 179 XP_030109804.2 uncharacterized protein Gm52666 [Mus musculus] diamond 4323 218 0.990825688073395 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
27018968 27018968 PRJNA688352_P_NODE_2302_length_396_cov_2.275542_g2199_i0 PRJNA688352 2302 396 2.275542 9.01114632 Staurois parvus 386267 Chordata Chordata 57.4 1.47e-7   NR CAI9533415.1 386267 g2199 i0 40 3.14393939393939 110 47 68.9 4 294 22 1 110 CAI9533415.1 unnamed protein product [Staurois parvus] diamond 1245 57.4 1 Eukaryota Opisthokonta Metazoa Chordata Amphibia Anura Ranidae Staurois Staurois parvus
27567643 27567643 PRJNA688352_P_NODE_12084_length_241_cov_0.916667_g11981_i0 PRJNA688352 12084 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 43.5 0.0201   NR CAH1268004.1 7740 g11981 i0 33.8 2.09128630705394 74 47 89.6 1 217 2 431 504 CAH1268004.1 FAM160A1 [Branchiostoma lanceolatum] diamond 504 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Leptocardii Amphioxiformes Branchiostomatidae Branchiostoma Branchiostoma lanceolatum
30461822 30461822 PRJNA688352_P_NODE_2013_length_418_cov_2.744928_g1910_i0 PRJNA688352 2013 418 2.744928 11.47379904 Erpetoichthys calabaricus 27687 Chordata Chordata 89 5.83e-18   NR XP_051791274.1 27687 g1910 i0 52.9 3.66028708133971 102 20 72.5 2 305 3 156 230 XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] diamond 1530 89 1 Eukaryota Opisthokonta Metazoa Chordata Cladistia Polypteriformes Polypteridae Erpetoichthys Erpetoichthys calabaricus
32401874 32401874 PRJNA688352_P_NODE_2379_length_391_cov_1.823899_g2276_i0 PRJNA688352 2379 391 1.823899 7.13144509 root 1 Root_unresolved Root_unresolved 259 3.06e-83   NR XP_036010302.1 10090 g2276 i0 97.7 16.9565217391304 130 3 99.7 0 391 2 65 194 XP_036010302.1 uncharacterized protein Gm53410 [Mus musculus] diamond 6630 259 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus
32516981 32516981 PRJNA688352_P_NODE_9559_length_246_cov_0.890173_g9456_i0 PRJNA688352 9559 246 0.890173 2.18982558 Chrysochloris asiatica 185453 Chordata Chordata 43.5 0.0202   NR XP_006860356.1 185453 g9456 i0 33.3 0.878048780487805 72 43 87.8 2 21 236 303 369 XP_006860356.1 PREDICTED: inactive hydroxysteroid dehydrogenase-like protein 1 [Chrysochloris asiatica] diamond 216 43.5 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia   Chrysochloridae Chrysochloris Chrysochloris asiatica
32654145 32654145 PRJNA688352_P_NODE_5460_length_280_cov_2.821256_g5357_i0 PRJNA688352 5460 280 2.821256 7.8995168 root 1 Root_unresolved Root_unresolved 203 1.33e-60   NR XP_030110853.2 10090 g5357 i0 100 16.9392857142857 93 0 99.6 0 280 2 166 258 XP_030110853.2 uncharacterized protein Gm42427, partial [Mus musculus] diamond 4743 203 1 Eukaryota Opisthokonta Metazoa Chordata Mammalia Rodentia Muridae Mus Mus musculus

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