contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA909412" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3441455 | 3441455 | PRJNA909412_P_NODE_1403_length_465_cov_11.967136_g1264_i0 | PRJNA909412 | 1403 | 465 | 11.967136 | 55.6471824 | Keratella quadrata | 204742 | Rotifera | other_Eukaryota | 448 | 4.929999999999999e-121 | NTclustered | gi|83285188|gb|DQ297735.1| | 204742 | g1264 | i0 | 84.532 | 70.5698924731183 | 459 | 64 | 98 | 7 | 11 | 465 | 770 | 315 | Keratella quadrata 28S ribosomal RNA gene, partial sequence | blastn | 32815 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Keratella | Keratella quadrata | |
| 4719234 | 4719234 | PRJNA909412_P_NODE_6304_length_209_cov_1.470588_g6163_i0 | PRJNA909412 | 6304 | 209 | 1.470588 | 3.07352892 | Brachionus manjavacas | 667381 | Rotifera | other_Eukaryota | 75 | 3.91e-9 | NTclustered | gi|2006240371|gb|MW559986.1| | 667381 | g6163 | i0 | 88.889 | 5.26315789473684 | 63 | 3 | 29 | 3 | 116 | 175 | 6201 | 6262 | Brachionus manjavacas isolate AU chromosome I mitochondrion, complete sequence | blastn | 1100 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus manjavacas | |
| 8543554 | 8543554 | PRJNA909412_P_NODE_11527_length_168_cov_2.596899_g11386_i0 | PRJNA909412 | 11527 | 168 | 2.596899 | 4.36279032 | Cephalodella forficula | 360656 | Rotifera | other_Eukaryota | 305 | 9.81e-79 | NTclustered | gi|83285081|gb|DQ297693.1| | 360656 | g11386 | i0 | 99.405 | 99.9761904761905 | 168 | 1 | 100 | 0 | 1 | 168 | 797 | 630 | Cephalodella forficula 18S ribosomal RNA gene, partial sequence | blastn | 16796 | 305 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Notommatidae | Cephalodella | Cephalodella forficula | |
| 9818550 | 9818550 | PRJNA909412_P_NODE_16948_length_151_cov_1.964286_g16807_i0 | PRJNA909412 | 16948 | 151 | 1.964286 | 2.96607186 | Euchlanis alata | 338269 | Rotifera | other_Eukaryota | 213 | 5.34e-51 | NTclustered | gi|83655555|gb|DQ079942.1| | 338269 | g16807 | i0 | 92.053 | 42.2715231788079 | 151 | 12 | 100 | 0 | 1 | 151 | 3 | 153 | Euchlanis alata 28S ribosomal RNA gene, partial sequence | blastn | 6383 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Euchlanis | Euchlanis alata | |
| 20375524 | 20375524 | PRJNA909412_P_NODE_6256_length_209_cov_3.394118_g6115_i0 | PRJNA909412 | 6256 | 209 | 3.394118 | 7.09370662 | Ploima | 84394 | Rotifera | other_Eukaryota | 237 | 4.71e-58 | NTclustered | gi|308156994|gb|GQ890459.1| | 360688 | g6115 | i0 | 87.44 | 88.4114832535885 | 207 | 24 | 99 | 2 | 1 | 207 | 432 | 636 | Platyias quadricornis isolate DNA197 large subunit ribosomal RNA gene, partial sequence | blastn | 18478 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Platyias | Platyias quadricornis | |
| 23842949 | 23842949 | PRJNA909412_P_NODE_6059_length_213_cov_1.201149_g5918_i0 | PRJNA909412 | 6059 | 213 | 1.201149 | 2.55844737 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 174 | 3.83e-39 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g5918 | i0 | 82.353 | 29.4600938967136 | 204 | 32 | 96 | 3 | 10 | 213 | 11192 | 11391 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 6275 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens |
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);;