RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA473201" 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

  • PRJNA473201 · 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
6822215 6822215 PRJNA473201_P_NODE_79286_length_244_cov_0.900585_g78544_i0 PRJNA473201 79286 244 0.900585 2.1974274 Hirudo verbana 311461 Annelida Annelida 58.4 4.73e-4   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g78544 i0 92.683 0.557377049180328 41 1 16 2 41 79 1098863 1098903 Hirudo verbana genome assembly, chromosome: 12 blastn 136 58.4 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
8097038 8097038 PRJNA473201_P_NODE_47567_length_297_cov_4.544643_g46825_i0 PRJNA473201 47567 297 4.544643 13.49758971 Hirudo verbana 311461 Annelida Annelida 54.7 0.008   NTclustered gi|2918369714|emb|OZ237790.1| 311461 g46825 i0 100 0.0976430976430976 29 0 10 0 117 145 5823238 5823266 Hirudo verbana genome assembly, chromosome: 12 blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
10648170 10648170 PRJNA473201_P_NODE_69889_length_249_cov_0.875000_g69147_i0 PRJNA473201 69889 249 0.875 2.17875 Hirudo verbana 311461 Annelida Annelida 52.8 0.023   NTclustered gi|2918369616|emb|OZ237781.1| 311461 g69147 i0 100 0.112449799196787 28 0 11 0 16 43 707531 707504 Hirudo verbana genome assembly, chromosome: 3 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
15747368 15747368 PRJNA473201_P_NODE_87553_length_219_cov_13.760274_g86811_i0 PRJNA473201 87553 219 13.760274 30.13500006 Hirudo verbana 311461 Annelida Annelida 63.9 8.95e-6   NTclustered gi|2918369718|emb|OZ237791.1| 311461 g86811 i0 93.023 0.19634703196347 43 3 20 0 128 170 6115065 6115107 Hirudo verbana genome assembly, chromosome: 13 blastn 43 63.9 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
17021291 17021291 PRJNA473201_P_NODE_47914_length_296_cov_21.538117_g47172_i0 PRJNA473201 47914 296 21.538117 63.75282632 Hirudo verbana 311461 Annelida Annelida 52.8 0.027   NTclustered gi|2918369710|emb|OZ237789.1| 311461 g47172 i0 100 0.0945945945945946 28 0 9 0 174 201 5801470 5801497 Hirudo verbana genome assembly, chromosome: 11 blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana
24670862 24670862 PRJNA473201_P_NODE_87700_length_216_cov_9.412587_g86958_i0 PRJNA473201 87700 216 9.412587 20.33118792 Hirudo verbana 311461 Annelida Annelida 56.5 0.001   NTclustered gi|2918369643|emb|OZ237784.1| 311461 g86958 i0 100 0.944444444444444 30 0 14 0 1 30 4666540 4666569 Hirudo verbana genome assembly, chromosome: 6 blastn 204 56.5 1 Eukaryota Opisthokonta Metazoa Annelida Clitellata Hirudinida Hirudinidae Hirudo Hirudo verbana

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