contig_metadata
13 rows where bioproject = "PRJNA1041773", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19295727 | 19295727 | PRJNA1041773_P_NODE_12196_length_592_cov_2.587669_g11869_i0 | PRJNA1041773 | 12196 | 592 | 2.587669 | 15.31900048 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 193 | 3.31e-44 | NTclustered | gi|2919509818|ref|XM_071651395.1| | 105358 | g11869 | i0 | 87.425 | 26.2567567567568 | 167 | 21 | 28 | 0 | 148 | 314 | 249 | 415 | PREDICTED: Diadema antillarum histone H3, embryonic (LOC139740824), mRNA | blastn | 15544 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 23122325 | 23122325 | PRJNA1041773_P_NODE_25439_length_412_cov_2.643068_g25108_i0 | PRJNA1041773 | 25439 | 412 | 2.643068 | 10.88944016 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 65.8 | 5.09e-6 | NTclustered | gi|1826629806|ref|XR_004445017.1| | 1529436 | g25108 | i0 | 93.333 | 0.478155339805825 | 45 | 2 | 11 | 1 | 3 | 47 | 602 | 645 | PREDICTED: Anneissia japonica uncharacterized LOC117106215 (LOC117106215), ncRNA | blastn | 197 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 24395852 | 24395852 | PRJNA1041773_P_NODE_100680_length_241_cov_0.916667_g100347_i0 | PRJNA1041773 | 100680 | 241 | 0.916667 | 2.20916747 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 69.4 | 2.15e-7 | NTclustered | gi|2707383269|ref|XM_054914763.2| | 7653 | g100347 | i0 | 95.349 | 0.356846473029046 | 43 | 2 | 18 | 0 | 146 | 188 | 2031 | 2073 | PREDICTED: Lytechinus pictus protein IWS1 homolog (LOC129278618), transcript variant X1, mRNA | blastn | 86 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 24396247 | 24396247 | PRJNA1041773_P_NODE_34860_length_356_cov_0.883392_g34527_i0 | PRJNA1041773 | 34860 | 356 | 0.883392 | 3.14487552 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|2707381877|ref|XM_054915728.2| | 7653 | g34527 | i0 | 100 | 0.0814606741573034 | 29 | 0 | 8 | 0 | 273 | 301 | 2739 | 2767 | PREDICTED: Lytechinus pictus uncharacterized LOC129279627 (LOC129279627), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 26813733 | 26813733 | PRJNA1041773_P_NODE_97001_length_243_cov_0.905882_g96668_i0 | PRJNA1041773 | 97001 | 243 | 0.905882 | 2.20129326 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 93.6 | 2.05e-20 | NR | KAJ8031339.1 | 206669 | g96668 | i0 | 66.2 | 2.40740740740741 | 65 | 22 | 80.2 | 0 | 243 | 49 | 111 | 175 | KAJ8031339.1 hypothetical protein HOLleu_28041 [Holothuria leucospilota] | diamond | 585 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 26940137 | 26940137 | PRJNA1041773_P_NODE_94102_length_244_cov_0.900585_g93769_i0 | PRJNA1041773 | 94102 | 244 | 0.900585 | 2.1974274 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 47.8 | 6.21e-4 | NR | PIK41515.1 | 307972 | g93769 | i0 | 65.6 | 1.37704918032787 | 32 | 11 | 39.3 | 0 | 195 | 100 | 303 | 334 | PIK41515.1 putative RNA-directed DNA polymerase from mobile element jockey-like [Apostichopus japonicus] | diamond | 336 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27414735 | 27414735 | PRJNA1041773_P_NODE_73483_length_256_cov_2.202186_g73150_i0 | PRJNA1041773 | 73483 | 256 | 2.202186 | 5.63759616 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 97.8 | 1.89e-21 | NR | KAJ8048841.1 | 206669 | g73150 | i0 | 50.6 | 3.97265625 | 85 | 42 | 99.6 | 0 | 255 | 1 | 8 | 92 | KAJ8048841.1 hypothetical protein HOLleu_01315 [Holothuria leucospilota] | diamond | 1017 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30446127 | 30446127 | PRJNA1041773_P_NODE_69613_length_263_cov_1.094737_g69280_i0 | PRJNA1041773 | 69613 | 263 | 1.094737 | 2.87915831 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 84.7 | 8.24e-17 | NR | KAJ8045879.1 | 206669 | g69280 | i0 | 74 | 1.71102661596958 | 50 | 13 | 57 | 0 | 72 | 221 | 1435 | 1484 | KAJ8045879.1 hypothetical protein HOLleu_08985 [Holothuria leucospilota] | diamond | 450 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31070037 | 31070037 | PRJNA1041773_P_NODE_72695_length_258_cov_0.945946_g72362_i0 | PRJNA1041773 | 72695 | 258 | 0.945946 | 2.44054068 | Lytechinus | 7652 | Echinodermata | other_Eukaryota | 63.5 | 2.22e-9 | NR | XP_054752873.2 | 7653 | g72362 | i0 | 39.5 | 3.96511627906977 | 86 | 51 | 98.8 | 1 | 258 | 4 | 968 | 1053 | XP_054752873.2 uncharacterized protein LOC129258664 [Lytechinus pictus] | diamond | 1023 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 31584012 | 31584012 | PRJNA1041773_P_NODE_92176_length_245_cov_0.895349_g91843_i0 | PRJNA1041773 | 92176 | 245 | 0.895349 | 2.19360505 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 61.6 | 8.38e-9 | NR | KAJ8050169.1 | 206669 | g91843 | i0 | 69.8 | 0.52653061224489806 | 43 | 12 | 52.7 | 1 | 134 | 6 | 133 | 174 | KAJ8050169.1 hypothetical protein HOLleu_03265 [Holothuria leucospilota] | diamond | 129 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32374863 | 32374863 | PRJNA1041773_P_NODE_4299_length_978_cov_1.869613_g4059_i0 | PRJNA1041773 | 4299 | 978 | 1.869613 | 18.28481514 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 173 | 6.689999999999998e-47 | NR | XP_022111247.1 | 133434 | g4059 | i0 | 54.3 | 1.26993865030675 | 138 | 61 | 41.7 | 1 | 43 | 450 | 163 | 300 | XP_022111247.1 uncharacterized protein LOC110990511 [Acanthaster planci] | diamond | 1242 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 32722058 | 32722058 | PRJNA1041773_P_NODE_86680_length_247_cov_0.885057_g86347_i0 | PRJNA1041773 | 86680 | 247 | 0.885057 | 2.18609079 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 45.8 | 0.00205 | NR | KAJ8023806.1 | 206669 | g86347 | i0 | 52.4 | 3.27935222672065 | 42 | 13 | 42.5 | 1 | 247 | 143 | 52 | 93 | KAJ8023806.1 GTPase IMAP family member 7 [Holothuria leucospilota] | diamond | 810 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32879374 | 32879374 | PRJNA1041773_P_NODE_42260_length_326_cov_2.980237_g41927_i0 | PRJNA1041773 | 42260 | 326 | 2.980237 | 9.71557262 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 0.00319 | NR | KAJ8030247.1 | 206669 | g41927 | i0 | 30.4 | 1.21472392638037 | 69 | 48 | 63.5 | 0 | 315 | 109 | 775 | 843 | KAJ8030247.1 hypothetical protein HOLleu_26606 [Holothuria leucospilota] | diamond | 396 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota |
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);;