contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA222400" and tax_phylum = "Annelida"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4194263 | 4194263 | PRJNA222400_P_NODE_204_length_1038_cov_1.689585_g188_i0 | PRJNA222400 | 204 | 1038 | 1.689585 | 17.5378923 | Platynereis dumerilii | 6359 | Annelida | Annelida | 134 | 3.66e-26 | NTclustered | gi|83307670|emb|CT033644.1| | 6359 | g188 | i0 | 78.199 | 1.8121387283237 | 211 | 44 | 20 | 2 | 252 | 461 | 657 | 866 | Platynereis dumerilii EST IB0AAA16DC02EM1 | blastn | 1881 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 11845744 | 11845744 | PRJNA222400_P_NODE_1450_length_427_cov_1.687831_g1417_i0 | PRJNA222400 | 1450 | 427 | 1.687831 | 7.20703837 | Platynereis dumerilii | 6359 | Annelida | Annelida | 67.6 | 1.47e-6 | NTclustered | gi|613484554|gb|KJ405466.1| | 6359 | g1417 | i0 | 83.784 | 0.173302107728337 | 74 | 9 | 17 | 3 | 98 | 169 | 2945 | 2873 | Platynereis dumerilii isolate PlduMyo2 myosin mRNA, complete cds | blastn | 74 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 16944474 | 16944474 | PRJNA222400_P_NODE_3094_length_266_cov_1.359447_g3061_i0 | PRJNA222400 | 3094 | 266 | 1.359447 | 3.61612902 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g3061 | i0 | 94.444 | 0.240601503759398 | 36 | 1 | 13 | 1 | 3 | 37 | 520190 | 520155 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
Advanced export
JSON shape: default, array, newline-delimited
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);;