contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA352610" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1668421 | 1668421 | PRJNA352610_P_NODE_20042_length_281_cov_0.927885_g19981_i0 | PRJNA352610 | 20042 | 281 | 0.927885 | 2.60735685 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 442 | 1.3199999999999993e-119 | NTclustered | gi|1752339154|ref|XM_030992761.1| | 7668 | g19981 | i0 | 95.018 | 2 | 281 | 14 | 100 | 0 | 1 | 281 | 2120 | 2400 | PREDICTED: Strongylocentrotus purpuratus unhealthy ribosome biogenesis protein 2 homolog (LOC586681), mRNA | blastn | 562 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 1668556 | 1668556 | PRJNA352610_P_NODE_26002_length_250_cov_0.870056_g25941_i0 | PRJNA352610 | 26002 | 250 | 0.870056 | 2.17514 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 396 | 9.079999999999996e-106 | NTclustered | gi|1752389646|ref|XM_030997495.1| | 7668 | g25941 | i0 | 95.2 | 9.94 | 250 | 12 | 100 | 0 | 1 | 250 | 284 | 533 | PREDICTED: Strongylocentrotus purpuratus axonemal dynein light chain domain-containing protein 1 (LOC578169), transcript variant X2, mRNA | blastn | 2485 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 2944684 | 2944684 | PRJNA352610_P_NODE_3723_length_537_cov_3.931034_g3662_i0 | PRJNA352610 | 3723 | 537 | 3.931034 | 21.10965258 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 259 | 2.9e-64 | NTclustered | gi|2919420483|ref|XM_071635166.1| | 105358 | g3662 | i0 | 77.828 | 47.7858472998138 | 442 | 82 | 81 | 12 | 89 | 522 | 505 | 72 | PREDICTED: Diadema antillarum large ribosomal subunit protein uL15-like (LOC139723966), mRNA | blastn | 25661 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 2944778 | 2944778 | PRJNA352610_P_NODE_7143_length_419_cov_1.670520_g7082_i0 | PRJNA352610 | 7143 | 419 | 1.67052 | 6.9994788 | Mesocentrotus nudus | 7666 | Echinodermata | other_Eukaryota | 774 | 0 | NTclustered | gi|73746391|gb|DQ102372.1| | 7666 | g7082 | i0 | 100 | 7.01193317422434 | 419 | 0 | 100 | 0 | 1 | 419 | 2691 | 2273 | Strongylocentrotus nudus major yolk protein (myp) mRNA, complete cds | blastn | 2938 | 774 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Mesocentrotus | Mesocentrotus nudus | |
| 6771310 | 6771310 | PRJNA352610_P_NODE_16626_length_303_cov_1.756522_g16565_i0 | PRJNA352610 | 16626 | 303 | 1.756522 | 5.32226166 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 460 | 3.959999999999999e-125 | NTclustered | gi|1752369968|ref|XM_030989100.1| | 7668 | g16565 | i0 | 94.059 | 6.0957095709571 | 303 | 18 | 100 | 0 | 1 | 303 | 742 | 440 | PREDICTED: Strongylocentrotus purpuratus soma ferritin (LOC100892337), mRNA | blastn | 1847 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 6771625 | 6771625 | PRJNA352610_P_NODE_346_length_1238_cov_5.236052_g329_i0 | PRJNA352610 | 346 | 1238 | 5.236052 | 64.82232376 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 678 | 0 | NTclustered | gi|1229161445|ref|XM_022237958.1| | 133434 | g329 | i0 | 77.269 | 91.4919224555735 | 1201 | 243 | 96 | 24 | 7 | 1192 | 90 | 1275 | PREDICTED: Acanthaster planci 60S ribosomal protein L3-like (LOC110980899), mRNA | blastn | 113267 | 678 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 9321906 | 9321906 | PRJNA352610_P_NODE_26248_length_249_cov_1.375000_g26187_i0 | PRJNA352610 | 26248 | 249 | 1.375 | 3.42375 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 171 | 5.96e-38 | NTclustered | gi|1826657970|ref|XM_033260857.1| | 1529436 | g26187 | i0 | 80 | 5.38152610441767 | 235 | 43 | 94 | 4 | 14 | 246 | 255 | 487 | PREDICTED: Anneissia japonica ras-related protein Rab-8A-like (LOC117116759), transcript variant X2, mRNA | blastn | 1340 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 11872584 | 11872584 | PRJNA352610_P_NODE_30430_length_243_cov_0.905882_g30369_i0 | PRJNA352610 | 30430 | 243 | 0.905882 | 2.20129326 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 279 | 9.23e-71 | NTclustered | gi|1752401453|ref|XM_011670607.2| | 7668 | g30369 | i0 | 92.118 | 4.17695473251029 | 203 | 9 | 81 | 3 | 47 | 243 | 1825 | 1624 | PREDICTED: Strongylocentrotus purpuratus heterogeneous nuclear ribonucleoprotein A3 homolog 2 (LOC575125), transcript variant X1, mRNA | blastn | 1015 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 14422359 | 14422359 | PRJNA352610_P_NODE_12252_length_341_cov_1.425373_g12191_i0 | PRJNA352610 | 12252 | 341 | 1.425373 | 4.86052193 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 597 | 3.299999999999999e-166 | NTclustered | gi|1752359177|ref|XM_030984524.1| | 7668 | g12191 | i0 | 98.24 | 98.8885630498534 | 341 | 6 | 100 | 0 | 1 | 341 | 197 | 537 | PREDICTED: Strongylocentrotus purpuratus 40S ribosomal protein S2 (LOC100889509), mRNA | blastn | 33721 | 597 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 15696213 | 15696213 | PRJNA352610_P_NODE_10673_length_360_cov_1.087108_g10612_i0 | PRJNA352610 | 10673 | 360 | 1.087108 | 3.9135888 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 206 | 2.4699999999999994e-48 | NTclustered | gi|2919379619|ref|XM_071627707.1| | 105358 | g10612 | i0 | 85.427 | 10.4555555555556 | 199 | 27 | 55 | 2 | 146 | 343 | 255 | 452 | PREDICTED: Diadema antillarum small ribosomal subunit protein uS10 (LOC139716148), mRNA | blastn | 3764 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 15696790 | 15696790 | PRJNA352610_P_NODE_8673_length_389_cov_1.215190_g8612_i0 | PRJNA352610 | 8673 | 389 | 1.21519 | 4.7270891 | Mesocentrotus nudus | 7666 | Echinodermata | other_Eukaryota | 652 | 0 | NTclustered | gi|73746391|gb|DQ102372.1| | 7666 | g8612 | i0 | 100 | 13.2493573264781 | 353 | 0 | 100 | 0 | 1 | 353 | 3624 | 3272 | Strongylocentrotus nudus major yolk protein (myp) mRNA, complete cds | blastn | 5154 | 652 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Mesocentrotus | Mesocentrotus nudus | |
| 16971308 | 16971308 | PRJNA352610_P_NODE_28514_length_246_cov_0.890173_g28453_i0 | PRJNA352610 | 28514 | 246 | 0.890173 | 2.18982558 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 78.7 | 3.67e-10 | NTclustered | gi|1752374489|ref|XM_030991050.1| | 7668 | g28453 | i0 | 84.524 | 0.341463414634146 | 84 | 8 | 32 | 4 | 154 | 232 | 738 | 655 | PREDICTED: Strongylocentrotus purpuratus transcription elongation factor SPT4-A (LOC592015), mRNA | blastn | 84 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 18245290 | 18245290 | PRJNA352610_P_NODE_16375_length_305_cov_1.987069_g16314_i0 | PRJNA352610 | 16375 | 305 | 1.987069 | 6.06056045 | Mesocentrotus nudus | 7666 | Echinodermata | other_Eukaryota | 564 | 2.95e-156 | NTclustered | gi|73746391|gb|DQ102372.1| | 7666 | g16314 | i0 | 100 | 9.98032786885246 | 305 | 0 | 100 | 0 | 1 | 305 | 1183 | 879 | Strongylocentrotus nudus major yolk protein (myp) mRNA, complete cds | blastn | 3044 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Mesocentrotus | Mesocentrotus nudus | |
| 18245540 | 18245540 | PRJNA352610_P_NODE_27135_length_248_cov_0.880000_g27074_i0 | PRJNA352610 | 27135 | 248 | 0.88 | 2.1824 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 244 | 3.45e-60 | NTclustered | gi|1752361445|ref|XM_003730251.3| | 7668 | g27074 | i0 | 85.425 | 0.995967741935484 | 247 | 23 | 99 | 7 | 2 | 248 | 1592 | 1825 | PREDICTED: Strongylocentrotus purpuratus E3 ubiquitin-protein ligase RMND5A (LOC588281), mRNA | blastn | 247 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 22070055 | 22070055 | PRJNA352610_P_NODE_11478_length_350_cov_1.083032_g11417_i0 | PRJNA352610 | 11478 | 350 | 1.083032 | 3.790612 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 213 | 1.43e-50 | NTclustered | gi|2919450780|ref|XM_071640769.1| | 105358 | g11417 | i0 | 81.004 | 0.797142857142857 | 279 | 43 | 78 | 7 | 68 | 341 | 1514 | 1241 | PREDICTED: Diadema antillarum dynein regulatory complex subunit 2-like (LOC139729846), mRNA | blastn | 279 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 22070545 | 22070545 | PRJNA352610_P_NODE_5578_length_459_cov_2.339378_g5517_i0 | PRJNA352610 | 5578 | 459 | 2.339378 | 10.73774502 | Mesocentrotus nudus | 7666 | Echinodermata | other_Eukaryota | 824 | 0 | NTclustered | gi|2043475731|dbj|LC175467.2| | 7666 | g5517 | i0 | 99.129 | 4.28104575163399 | 459 | 3 | 100 | 1 | 1 | 459 | 4610 | 4153 | Mesocentrotus nudus MYP mRNA for major yolk protein, complete cds | blastn | 1965 | 824 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Mesocentrotus | Mesocentrotus nudus | |
| 23345796 | 23345796 | PRJNA352610_P_NODE_26999_length_248_cov_1.148571_g26938_i0 | PRJNA352610 | 26999 | 248 | 1.148571 | 2.84845608 | Mesocentrotus nudus | 7666 | Echinodermata | other_Eukaryota | 459 | 1.13e-124 | NTclustered | gi|73746391|gb|DQ102372.1| | 7666 | g26938 | i0 | 100 | 7 | 248 | 0 | 100 | 0 | 1 | 248 | 3923 | 3676 | Strongylocentrotus nudus major yolk protein (myp) mRNA, complete cds | blastn | 1736 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Mesocentrotus | Mesocentrotus nudus | |
| 24620095 | 24620095 | PRJNA352610_P_NODE_28820_length_246_cov_0.890173_g28759_i0 | PRJNA352610 | 28820 | 246 | 0.890173 | 2.18982558 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 267 | 7.289999999999999e-67 | NTclustered | gi|1752348015|ref|XM_011674318.2| | 7668 | g28759 | i0 | 86.508 | 1.02439024390244 | 252 | 22 | 100 | 7 | 1 | 246 | 1120 | 1365 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC105442328 (LOC105442328), mRNA | blastn | 252 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 24620107 | 24620107 | PRJNA352610_P_NODE_29300_length_245_cov_0.895349_g29239_i0 | PRJNA352610 | 29300 | 245 | 0.895349 | 2.19360505 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 394 | 3.189999999999999e-105 | NTclustered | gi|1752365633|ref|XM_795391.5| | 7668 | g29239 | i0 | 95.885 | 2.96326530612245 | 243 | 10 | 99 | 0 | 3 | 245 | 481 | 239 | PREDICTED: Strongylocentrotus purpuratus nucleolin (LOC587978), mRNA | blastn | 726 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;