contig_metadata
21 rows where bioproject = "PRJNA421571", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 423654 | 423654 | PRJNA421571_P_NODE_64141_length_324_cov_1.167331_g61592_i0 | PRJNA421571 | 64141 | 324 | 1.167331 | 3.78215244 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 121 | 8.229999999999999e-23 | NTclustered | gi|1834267010|ref|XM_033772568.1| | 7604 | g61592 | i0 | 88.119 | 3.0679012345679 | 101 | 12 | 31 | 0 | 86 | 186 | 402 | 502 | PREDICTED: Asterias rubens dynein light chain LC6, flagellar outer arm (LOC117290977), mRNA | blastn | 994 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 4250480 | 4250480 | PRJNA421571_P_NODE_56584_length_354_cov_1.580071_g54035_i0 | PRJNA421571 | 56584 | 354 | 1.580071 | 5.59345134 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 67 | 3.99e-10 | NR | XP_030851423.1 | 7668 | g54035 | i0 | 34.9 | 3.08474576271186 | 109 | 67 | 89 | 1 | 319 | 5 | 401 | 509 | XP_030851423.1 glucosidase 2 subunit beta [Strongylocentrotus purpuratus] | diamond | 1092 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 5527602 | 5527602 | PRJNA421571_P_NODE_74845_length_289_cov_2.893519_g72296_i0 | PRJNA421571 | 74845 | 289 | 2.893519 | 8.36226991 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 58.4 | 5.75e-4 | NTclustered | gi|2919467476|ref|XM_071643602.1| | 105358 | g72296 | i0 | 97.143 | 0.411764705882353 | 35 | 0 | 12 | 1 | 132 | 165 | 3809 | 3843 | PREDICTED: Diadema antillarum prostaglandin reductase 2-like (LOC139732756), mRNA | blastn | 119 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 8075176 | 8075176 | PRJNA421571_P_NODE_102767_length_243_cov_2.352941_g100218_i0 | PRJNA421571 | 102767 | 243 | 2.352941 | 5.71764663 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 124 | 1.51e-33 | NR | XP_033640423.1 | 7604 | g100218 | i0 | 75 | 13.8271604938272 | 80 | 20 | 98.8 | 0 | 2 | 241 | 23 | 102 | XP_033640423.1 60S ribosomal protein L19-like [Asterias rubens] | diamond | 3360 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 18274735 | 18274735 | PRJNA421571_P_NODE_44535_length_427_cov_2.231638_g41987_i0 | PRJNA421571 | 44535 | 427 | 2.231638 | 9.52909426 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.011 | NTclustered | gi|2707361744|ref|XM_054910354.2| | 7653 | g41987 | i0 | 100 | 0.0679156908665105 | 29 | 0 | 7 | 0 | 304 | 332 | 506 | 478 | PREDICTED: Lytechinus pictus histone-lysine N-methyltransferase NSD2-like (LOC129273332), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19549237 | 19549237 | PRJNA421571_P_NODE_53916_length_368_cov_1.277966_g51367_i0 | PRJNA421571 | 53916 | 368 | 1.277966 | 4.70291488 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 112 | 9.38e-27 | NR | XP_038072890.1 | 46514 | g51367 | i0 | 49.6 | 2.0054347826087 | 123 | 53 | 99.5 | 2 | 368 | 3 | 91 | 205 | XP_038072890.1 calcium/calmodulin-dependent protein kinase type IV-like [Patiria miniata] | diamond | 738 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 23374492 | 23374492 | PRJNA421571_P_NODE_21499_length_758_cov_3.480292_g19145_i0 | PRJNA421571 | 21499 | 758 | 3.480292 | 26.38061336 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 129 | 2.41e-30 | NR | XP_063953926.1 | 7653 | g19145 | i0 | 38.7 | 2.12137203166227 | 181 | 104 | 71.6 | 1 | 1 | 543 | 420 | 593 | XP_063953926.1 uncharacterized protein LOC135153732 [Lytechinus pictus] | diamond | 1608 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 24649541 | 24649541 | PRJNA421571_P_NODE_49120_length_396_cov_1.191950_g46572_i0 | PRJNA421571 | 49120 | 396 | 1.19195 | 4.720122 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 164 | 2.62e-45 | NR | XP_063966105.1 | 7653 | g46572 | i0 | 63.9 | 4.03787878787879 | 133 | 43 | 98.5 | 3 | 2 | 391 | 97 | 227 | XP_063966105.1 large ribosomal subunit protein uL18-like [Lytechinus pictus] | diamond | 1599 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 26839317 | 26839317 | PRJNA421571_P_NODE_99461_length_246_cov_0.890173_g96912_i0 | PRJNA421571 | 99461 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 112 | 1.0400000000000002e-27 | NR | XP_071502009.1 | 105358 | g96912 | i0 | 74.7 | 7.30487804878049 | 75 | 19 | 91.5 | 0 | 226 | 2 | 27 | 101 | XP_071502009.1 malate dehydrogenase, mitochondrial-like [Diadema antillarum] | diamond | 1797 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30233603 | 30233603 | PRJNA421571_P_NODE_50012_length_390_cov_1.164038_g47464_i0 | PRJNA421571 | 50012 | 390 | 1.164038 | 4.5397482 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 63.5 | 1.09e-8 | NR | XP_038053600.1 | 46514 | g47464 | i0 | 37.8 | 0.692307692307692 | 90 | 48 | 67.7 | 2 | 18 | 281 | 4876 | 4959 | XP_038053600.1 MAM and LDL-receptor class A domain-containing protein 1-like [Patiria miniata] | diamond | 270 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30644208 | 30644208 | PRJNA421571_P_NODE_56073_length_357_cov_1.024648_g53524_i0 | PRJNA421571 | 56073 | 357 | 1.024648 | 3.65799336 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 44.7 | 0.028 | NR | KAJ8032438.1 | 206669 | g53524 | i0 | 32.8 | 1.09243697478992 | 67 | 43 | 56.3 | 1 | 356 | 156 | 776 | 840 | KAJ8032438.1 RNA-directed DNA polymerase from mobile element jockey [Holothuria leucospilota] | diamond | 390 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30707506 | 30707506 | PRJNA421571_P_NODE_50534_length_387_cov_0.914013_g47986_i0 | PRJNA421571 | 50534 | 387 | 0.914013 | 3.53723031 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 72.8 | 5.77e-12 | NR | XP_071506436.1 | 105358 | g47986 | i0 | 47.4 | 1.82945736434109 | 78 | 41 | 60.5 | 0 | 287 | 54 | 473 | 550 | XP_071506436.1 disks large homolog 1-like [Diadema antillarum] | diamond | 708 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30707538 | 30707538 | PRJNA421571_P_NODE_92754_length_251_cov_0.865169_g90205_i0 | PRJNA421571 | 92754 | 251 | 0.865169 | 2.17157419 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 48.1 | 5.29e-4 | NR | XP_038077192.1 | 46514 | g90205 | i0 | 62.5 | 0.382470119521912 | 32 | 12 | 38.2 | 0 | 250 | 155 | 1169 | 1200 | XP_038077192.1 fibropellin-1-like [Patiria miniata] | diamond | 96 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30977033 | 30977033 | PRJNA421571_P_NODE_93354_length_250_cov_0.870056_g90805_i0 | PRJNA421571 | 93354 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 88.6 | 2.83e-18 | NR | XP_041457071.1 | 7654 | g90805 | i0 | 48.8 | 8.7 | 82 | 41 | 98.4 | 1 | 3 | 248 | 319 | 399 | XP_041457071.1 putative phospholipase B-like 2 [Lytechinus variegatus] | diamond | 2175 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 31118059 | 31118059 | PRJNA421571_P_NODE_86275_length_262_cov_2.222222_g83726_i0 | PRJNA421571 | 86275 | 262 | 2.222222 | 5.82222164 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 58.2 | 6.02e-8 | NR | KAJ8046785.1 | 206669 | g83726 | i0 | 49.1 | 1.85496183206107 | 57 | 29 | 65.3 | 0 | 255 | 85 | 131 | 187 | KAJ8046785.1 EKC/KEOPS complex subunit Tprkb [Holothuria leucospilota] | diamond | 486 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31640783 | 31640783 | PRJNA421571_P_NODE_93516_length_250_cov_0.870056_g90967_i0 | PRJNA421571 | 93516 | 250 | 0.870056 | 2.17514 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 66.6 | 1.52e-10 | NR | XP_041469074.1 | 7654 | g90967 | i0 | 60.8 | 3.252 | 51 | 20 | 61.2 | 0 | 2 | 154 | 322 | 372 | XP_041469074.1 carboxypeptidase A1-like isoform X2 [Lytechinus variegatus] | diamond | 813 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32147078 | 32147078 | PRJNA421571_P_NODE_87638_length_259_cov_3.645161_g85089_i0 | PRJNA421571 | 87638 | 259 | 3.645161 | 9.44096699 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 3.96e-26 | NR | XP_038063470.1 | 46514 | g85089 | i0 | 65.9 | 16.2046332046332 | 82 | 28 | 95 | 0 | 2 | 247 | 48 | 129 | XP_038063470.1 60S ribosomal protein L7a-like [Patiria miniata] | diamond | 4197 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32273795 | 32273795 | PRJNA421571_P_NODE_57938_length_348_cov_1.400000_g55389_i0 | PRJNA421571 | 57938 | 348 | 1.4 | 4.872 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 132 | 2.7e-35 | NR | XP_071499074.1 | 105358 | g55389 | i0 | 56 | 11.0086206896552 | 116 | 50 | 99.1 | 1 | 2 | 346 | 109 | 224 | XP_071499074.1 persulfide dioxygenase ETHE1, mitochondrial-like [Diadema antillarum] | diamond | 3831 | 133 | 0.992481203007519 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32542037 | 32542037 | PRJNA421571_P_NODE_83119_length_269_cov_2.719388_g80570_i0 | PRJNA421571 | 83119 | 269 | 2.719388 | 7.31515372 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 133 | 2.1e-37 | NR | XP_030830056.1 | 7668 | g80570 | i0 | 91.4 | 1.77323420074349 | 70 | 6 | 78.1 | 0 | 58 | 267 | 1 | 70 | XP_030830056.1 ADP-ribosylation factor-like [Strongylocentrotus purpuratus] | diamond | 477 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32825338 | 32825338 | PRJNA421571_P_NODE_97980_length_247_cov_0.885057_g95431_i0 | PRJNA421571 | 97980 | 247 | 0.885057 | 2.18609079 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 65.5 | 3.94e-10 | NR | XP_071503728.1 | 105358 | g95431 | i0 | 41.8 | 18.8866396761134 | 79 | 43 | 96 | 1 | 240 | 4 | 730 | 805 | XP_071503728.1 protein transport protein Sec24C-like [Diadema antillarum] | diamond | 4665 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32888091 | 32888091 | PRJNA421571_P_NODE_77320_length_283_cov_1.976190_g74771_i0 | PRJNA421571 | 77320 | 283 | 1.97619 | 5.5926177 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.2 | 7.99e-7 | NR | XP_038063470.1 | 46514 | g74771 | i0 | 42.9 | 0.667844522968198 | 63 | 35 | 65.7 | 1 | 277 | 92 | 198 | 260 | XP_038063470.1 60S ribosomal protein L7a-like [Patiria miniata] | diamond | 189 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;