contig_metadata
7 rows where bioproject = "PRJNA690592" and tax_phylum = "Acanthocephala"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 670951 | 670951 | PRJNA690592_S_NODE_138461_length_287_cov_1.018692_g137447_i0 | PRJNA690592 | 138461 | 287 | 1.018692 | 2.92364604 | Pomphorhynchus laevis | 141832 | Acanthocephala | other_Eukaryota | 142 | 8.15e-39 | NR | KAI0983838.1 | 141832 | g137447 | i0 | 95.5 | 54.595818815331 | 67 | 3 | 70 | 0 | 287 | 87 | 276 | 342 | KAI0983838.1 hypothetical protein GJ496_006758 [Pomphorhynchus laevis] | diamond | 15669 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 27809265 | 27809265 | PRJNA690592_S_NODE_55484_length_420_cov_1.757925_g54470_i0 | PRJNA690592 | 55484 | 420 | 1.757925 | 7.383285 | Pomphorhynchus laevis | 141832 | Acanthocephala | other_Eukaryota | 52 | 1.29e-4 | NR | KAI0980059.1 | 141832 | g54470 | i0 | 39.6 | 0.821428571428571 | 53 | 32 | 37.9 | 0 | 182 | 24 | 162 | 214 | KAI0980059.1 hypothetical protein GJ496_000308 [Pomphorhynchus laevis] | diamond | 345 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 28199049 | 28199049 | PRJNA690592_S_NODE_10886_length_875_cov_4.108479_g10109_i0 | PRJNA690592 | 10886 | 875 | 4.108479 | 35.94919125 | Metazoa | 33208 | Acanthocephala | other_Eukaryota | 347 | 2.779999999999999e-116 | NR | KAI0986141.1 | 141832 | g10109 | i0 | 60.4 | 1.944 | 285 | 108 | 96.3 | 2 | 843 | 1 | 11 | 294 | KAI0986141.1 hypothetical protein GJ496_010974 [Pomphorhynchus laevis] | diamond | 1701 | 347 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 29272613 | 29272613 | PRJNA690592_S_NODE_82209_length_355_cov_1.361702_g81195_i0 | PRJNA690592 | 82209 | 355 | 1.361702 | 4.8340421 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.77e-13 | NR | KAI0988365.1 | 141832 | g81195 | i0 | 34.1 | 11.6788732394366 | 138 | 66 | 95.5 | 3 | 1 | 339 | 27 | 164 | KAI0988365.1 hypothetical protein GJ496_011601 [Pomphorhynchus laevis] | diamond | 4146 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 30777626 | 30777626 | PRJNA690592_S_NODE_186654_length_251_cov_0.865169_g185640_i0 | PRJNA690592 | 186654 | 251 | 0.865169 | 2.17157419 | Pomphorhynchus laevis | 141832 | Acanthocephala | other_Eukaryota | 132 | 3.3099999999999996e-37 | NR | CAO94728.1 | 141832 | g185640 | i0 | 78.3 | 99.1792828685259 | 83 | 18 | 99.2 | 0 | 1 | 249 | 34 | 116 | CAO94728.1 putative ribosomal protein L11, partial [Pomphorhynchus laevis] | diamond | 24894 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 31156343 | 31156343 | PRJNA690592_S_NODE_132955_length_291_cov_9.197248_g131941_i0 | PRJNA690592 | 132955 | 291 | 9.197248 | 26.76399168 | Pomphorhynchus laevis | 141832 | Acanthocephala | other_Eukaryota | 67.4 | 1.63e-12 | NR | KAI0987293.1 | 141832 | g131941 | i0 | 59.6 | 1.58762886597938 | 52 | 21 | 53.6 | 0 | 6 | 161 | 15 | 66 | KAI0987293.1 hypothetical protein GJ496_006952 [Pomphorhynchus laevis] | diamond | 462 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis | |
| 31757555 | 31757555 | PRJNA690592_S_NODE_120377_length_304_cov_1.255411_g119363_i0 | PRJNA690592 | 120377 | 304 | 1.255411 | 3.81644944 | Pomphorhynchus laevis | 141832 | Acanthocephala | other_Eukaryota | 43.5 | 0.0391 | NR | KAI0990279.1 | 141832 | g119363 | i0 | 43.5 | 0.453947368421053 | 46 | 26 | 45.4 | 0 | 303 | 166 | 54 | 99 | KAI0990279.1 hypothetical protein GJ496_004346 [Pomphorhynchus laevis] | diamond | 138 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Acanthocephala | Palaeacanthocephala | Echinorhynchida | Pomphorhynchidae | Pomphorhynchus | Pomphorhynchus laevis |
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);;