contig_metadata
13 rows where analysis = "blastn" and tax_phylum = "Chaetognatha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1779768 | 1779768 | PRJNA533114_P_NODE_108982_length_245_cov_1.139535_g108730_i0 | PRJNA533114 | 108982 | 245 | 1.139535 | 2.79186075 | Flaccisagitta enflata | 366393 | Chaetognatha | other_Eukaryota | 63.9 | 1.02e-5 | NTclustered | gi|151935668|gb|EF490819.1| | 366393 | g108730 | i0 | 95 | 0.163265306122449 | 40 | 2 | 16 | 0 | 28 | 67 | 514 | 553 | Flaccisagitta enflata posterior Hox B mRNA, partial cds | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Flaccisagitta | Flaccisagitta enflata | |
| 2002022 | 2002022 | PRJNA749559_P_NODE_4282_length_208_cov_0.870748_g4212_i0 | PRJNA749559 | 4282 | 208 | 0.870748 | 1.81115584 | Parasagitta elegans | 1562708 | Chaetognatha | other_Eukaryota | 230 | 7.839999999999999e-56 | NTclustered | gi|14280069|gb|AF342799.1| | 1562708 | g4212 | i0 | 96.429 | 7.98076923076923 | 140 | 4 | 67 | 1 | 70 | 208 | 324 | 185 | Sagitta elegans internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1660 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Parasagitta | Parasagitta elegans | |
| 2542547 | 2542547 | PRJNA975724_S_NODE_93682_length_228_cov_6.516129_g93501_i0 | PRJNA975724 | 93682 | 228 | 6.516129 | 14.85677412 | Metazoa | 33208 | Chaetognatha | other_Eukaryota | 117 | 7.110000000000001e-22 | NTclustered | gi|234203937|gb|FJ932763.1| | 52888 | g93501 | i0 | 98.485 | 29.7324561403509 | 66 | 1 | 29 | 0 | 1 | 66 | 323 | 388 | Spadella cephaloptera isolate UP-418 28S ribosomal RNA gene, partial sequence | blastn | 6779 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Phragmophora | Spadellidae | Spadella | Spadella cephaloptera | |
| 3195784 | 3195784 | PRJNA674308_P_NODE_52343_length_162_cov_0.920354_g52108_i0 | PRJNA674308 | 52343 | 162 | 0.920354 | 1.49097348 | Spadella cephaloptera | 52888 | Chaetognatha | other_Eukaryota | 58.4 | 2.9e-4 | NTclustered | gi|157690749|tpe|BN001064.1| | 52888 | g52108 | i0 | 87.755 | 0.302469135802469 | 49 | 6 | 30 | 0 | 109 | 157 | 485 | 437 | TPA_inf: Spadella cephaloptera mRNA for putative 40S ribosomal protein S15 isoform 2 (rps15.2 gene) | blastn | 49 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Phragmophora | Spadellidae | Spadella | Spadella cephaloptera | |
| 11126242 | 11126242 | PRJNA942138_P_NODE_31569_length_254_cov_1.701657_g31418_i0 | PRJNA942138 | 31569 | 254 | 1.701657 | 4.32220878 | Spadella cephaloptera | 52888 | Chaetognatha | other_Eukaryota | 172 | 1.6999999999999996e-38 | NTclustered | gi|157690683|tpe|BN001031.1| | 52888 | g31418 | i0 | 79.918 | 6.13779527559055 | 244 | 41 | 94 | 6 | 5 | 244 | 233 | 472 | TPA_inf: Spadella cephaloptera mRNA for putative 60S ribosomal protein L23 (rpl23 gene) | blastn | 1559 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Phragmophora | Spadellidae | Spadella | Spadella cephaloptera | |
| 18372671 | 18372671 | PRJNA554794_P_NODE_20515_length_193_cov_0.812500_g16586_i0 | PRJNA554794 | 20515 | 193 | 0.8125 | 1.568125 | Spadella cephaloptera | 52888 | Chaetognatha | other_Eukaryota | 95.3 | 2.73e-15 | NTclustered | gi|157690773|tpe|BN001076.1| | 52888 | g16586 | i0 | 86.364 | 46.3782383419689 | 88 | 10 | 45 | 2 | 106 | 192 | 239 | 153 | TPA_exp: Spadella cephaloptera mRNA for putative 40S ribosomal protein S25 isoform 1 (rps25.1 gene) | blastn | 8951 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Phragmophora | Spadellidae | Spadella | Spadella cephaloptera | |
| 18746540 | 18746540 | PRJNA914897_P_NODE_36095_length_253_cov_1.283333_g35671_i0 | PRJNA914897 | 36095 | 253 | 1.283333 | 3.24683249 | Flaccisagitta enflata | 366393 | Chaetognatha | other_Eukaryota | 63.9 | 1.06e-5 | NTclustered | gi|151935668|gb|EF490819.1| | 366393 | g35671 | i0 | 95 | 0.158102766798419 | 40 | 2 | 16 | 0 | 134 | 173 | 514 | 553 | Flaccisagitta enflata posterior Hox B mRNA, partial cds | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Flaccisagitta | Flaccisagitta enflata | |
| 19045707 | 19045707 | PRJNA724011_P_NODE_52515_length_356_cov_1.088339_g51492_i0 | PRJNA724011 | 52515 | 356 | 1.088339 | 3.87448684 | Opisthokonta | 33154 | Chaetognatha | other_Eukaryota | 220 | 8.73e-53 | NTclustered | gi|158524735|gb|EU074272.1| | 366441 | g51492 | i0 | 82.353 | 48.2808988764045 | 255 | 43 | 71 | 2 | 1 | 254 | 716 | 969 | Sagitta setosa mitochondrial ATP synthase beta subunit mRNA, partial cds; nuclear gene for mitochondrial product | blastn | 17188 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Parasagitta | Parasagitta setosa | |
| 20378536 | 20378536 | PRJNA924320_S_NODE_5336_length_410_cov_6.659280_g5194_i0 | PRJNA924320 | 5336 | 410 | 6.65928 | 27.303048 | Sagitta | 10230 | Chaetognatha | other_Eukaryota | 76.8 | 2.34e-9 | NTclustered | gi|85062612|gb|DQ351890.1| | 52901 | g5194 | i0 | 90 | 12.5048780487805 | 60 | 4 | 14 | 2 | 352 | 410 | 1427 | 1369 | Sagitta bipunctata 18S small subunit ribosomal RNA gene, partial sequence | blastn | 5127 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Sagitta | Sagitta bipunctata | |
| 21231651 | 21231651 | PRJNA839281_S_NODE_15917_length_204_cov_1.103226_g15648_i0 | PRJNA839281 | 15917 | 204 | 1.103226 | 2.25058104 | Flaccisagitta enflata | 366393 | Chaetognatha | other_Eukaryota | 63.9 | 8.22e-6 | NTclustered | gi|151935668|gb|EF490819.1| | 366393 | g15648 | i0 | 95 | 0.196078431372549 | 40 | 2 | 20 | 0 | 104 | 143 | 514 | 553 | Flaccisagitta enflata posterior Hox B mRNA, partial cds | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Flaccisagitta | Flaccisagitta enflata | |
| 24548279 | 24548279 | PRJNA1195374_P_NODE_69520_length_254_cov_1.359116_g69176_i0 | PRJNA1195374 | 69520 | 254 | 1.359116 | 3.45215464 | Flaccisagitta enflata | 366393 | Chaetognatha | other_Eukaryota | 63.9 | 1.07e-5 | NTclustered | gi|151935668|gb|EF490819.1| | 366393 | g69176 | i0 | 95 | 0.15748031496063 | 40 | 2 | 16 | 0 | 33 | 72 | 553 | 514 | Flaccisagitta enflata posterior Hox B mRNA, partial cds | blastn | 40 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Flaccisagitta | Flaccisagitta enflata | |
| 24729214 | 24729214 | PRJNA529924_P_NODE_2060_length_348_cov_2.448276_g1886_i0 | PRJNA529924 | 2060 | 348 | 2.448276 | 8.52000048 | Spadella cephaloptera | 52888 | Chaetognatha | other_Eukaryota | 178 | 5.2099999999999986e-40 | NTclustered | gi|157690683|tpe|BN001031.1| | 52888 | g1886 | i0 | 80.328 | 4.42528735632184 | 244 | 40 | 69 | 6 | 8 | 247 | 233 | 472 | TPA_inf: Spadella cephaloptera mRNA for putative 60S ribosomal protein L23 (rpl23 gene) | blastn | 1540 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Phragmophora | Spadellidae | Spadella | Spadella cephaloptera | |
| 24760273 | 24760273 | PRJNA556992_P_NODE_866100_length_242_cov_3.562130_g863910_i0 | PRJNA556992 | 866100 | 242 | 3.56213 | 8.6203546 | Parasagitta setosa | 366441 | Chaetognatha | other_Eukaryota | 215 | 2.63e-51 | NTclustered | gi|158524735|gb|EU074272.1| | 366441 | g863910 | i0 | 82.716 | 55.7148760330578 | 243 | 40 | 100 | 2 | 1 | 242 | 724 | 965 | Sagitta setosa mitochondrial ATP synthase beta subunit mRNA, partial cds; nuclear gene for mitochondrial product | blastn | 13483 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Chaetognatha | Sagittoidea | Aphragmophora | Sagittidae | Parasagitta | Parasagitta setosa |
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);;