RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA793147" and tax_phylum = "Annelida"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Annelida · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA793147 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
3767770 3767770 PRJNA793147_P_NODE_62923_length_221_cov_2.802632_g62657_i0 PRJNA793147 62923 221 2.802632 6.19381672 Megascolecidae 6400 Annelida Annelida 399 6.069999999999998e-107   NTclustered gi|341833289|gb|HQ728980.1| 1046282 g62657 i0 99.103 133.502262443439 223 0 100 1 1 221 2296 2074 Driloleirus sp. 917 28S large subunit ribosomal RNA gene, partial sequence blastn 29504 399 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Driloleirus Driloleirus sp. 917
7594032 7594032 PRJNA793147_P_NODE_37766_length_273_cov_3.524510_g37500_i0 PRJNA793147 37766 273 3.52451 9.6219123 Megascolecidae 6400 Annelida Annelida 477 3.489999999999999e-130   NTclustered gi|1446066788|dbj|LC259253.1| 1982487 g37500 i0 99.617 86.7728937728938 261 1 96 0 1 261 261 1 Pithemera sp. Samar gene for 28S rRNA, partial sequence blastn 23689 477 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Pithemera Pithemera sp. Samar
16518670 16518670 PRJNA793147_P_NODE_15773_length_426_cov_2.285714_g15507_i0 PRJNA793147 15773 426 2.285714 9.73714164 Megascolecidae 6400 Annelida Annelida 760 0   NTclustered gi|1934632930|gb|MW272759.1| 320981 g15507 i0 98.826 94.3755868544601 426 5 100 0 1 426 778 353 Metaphire glareosa voucher Mam-11 large subunit ribosomal RNA gene, partial sequence blastn 40204 765 0.993464052287582 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Metaphire Metaphire glareosa
19904700 19904700 PRJNA793147_P_NODE_44356_length_253_cov_1.527174_g44090_i0 PRJNA793147 44356 253 1.527174 3.86375022 Hirudo verbana 311461 Annelida Annelida 56.5 0.002   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g44090 i0 94.444 2.26877470355731 36 2 14 0 44 79 12719898 12719933 Hirudo verbana genome assembly, chromosome: 6 blastn 574 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
21618061 21618061 PRJNA793147_P_NODE_39577_length_267_cov_4.045455_g39311_i0 PRJNA793147 39577 267 4.045455 10.80136485 Megascolecidae 6400 Annelida Annelida 494 3.38e-135   NTclustered gi|575427369|gb|KF205939.1| 320986 g39311 i0 100 100 267 0 100 0 1 267 30 296 Duplodicodrilus schmardae isolate SR63T 18S ribosomal RNA gene, partial sequence blastn 26700 494 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Megascolecidae Duplodicodrilus Duplodicodrilus schmardae
23731092 23731092 PRJNA793147_P_NODE_58819_length_228_cov_3.905660_g58553_i0 PRJNA793147 58819 228 3.90566 8.9049048 Eisenia fetida 6396 Annelida Annelida 309 1.0900000000000002e-79   NTclustered gi|11494215|gb|AF212166.1|AF212166 6396 g58553 i0 91.266 42.0087719298246 229 17 100 2 1 228 3616 3390 Eisenia fetida 28S ribosomal RNA gene, partial sequence blastn 9578 309 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Crassiclitellata Lumbricidae Eisenia Eisenia fetida

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