contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA1237347" and tax_phylum = "Orthonectida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26996466 | 26996466 | PRJNA1237347_P_NODE_220882_length_406_cov_1.522523_g214310_i0 | PRJNA1237347 | 220882 | 406 | 1.522523 | 6.18144338 | root | 1 | Root_unresolved | Root_unresolved | 76.6 | 3.25e-13 | NR | OAF69429.1 | 1819745 | g214310 | i0 | 51.3 | 3.13300492610837 | 76 | 37 | 56.2 | 0 | 365 | 138 | 388 | 463 | OAF69429.1 hypothetical protein A3Q56_02829 [Intoshia linei] | diamond | 1272 | 77 | 0.994805194805195 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 28146811 | 28146811 | PRJNA1237347_P_NODE_110585_length_639_cov_1.318021_g104113_i0 | PRJNA1237347 | 110585 | 639 | 1.318021 | 8.42215419 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 53.9 | 2.01e-4 | NR | OAF70026.1 | 1819745 | g104113 | i0 | 35.9 | 1.75586854460094 | 78 | 46 | 36.6 | 1 | 1 | 234 | 899 | 972 | OAF70026.1 hypothetical protein A3Q56_02216, partial [Intoshia linei] | diamond | 1122 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 28683940 | 28683940 | PRJNA1237347_P_NODE_379267_length_288_cov_2.227907_g372694_i0 | PRJNA1237347 | 379267 | 288 | 2.227907 | 6.41637216 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 66.2 | 2.8e-10 | NR | OAF71136.1 | 1819745 | g372694 | i0 | 43 | 1.65625 | 86 | 46 | 87.5 | 2 | 261 | 10 | 182 | 266 | OAF71136.1 hypothetical protein A3Q56_01093 [Intoshia linei] | diamond | 477 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 29126315 | 29126315 | PRJNA1237347_P_NODE_73389_length_831_cov_1.757256_g67484_i0 | PRJNA1237347 | 73389 | 831 | 1.757256 | 14.60279736 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 87.4 | 2.45e-15 | NR | OAF69296.1 | 1819745 | g67484 | i0 | 32.3 | 0.725631768953069 | 201 | 118 | 69.3 | 5 | 14 | 589 | 172 | 363 | OAF69296.1 hypothetical protein A3Q56_02971 [Intoshia linei] | diamond | 603 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 29820111 | 29820111 | PRJNA1237347_P_NODE_322571_length_319_cov_1.565041_g315998_i0 | PRJNA1237347 | 322571 | 319 | 1.565041 | 4.99248079 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 45.8 | 0.00723 | NR | OAF67154.1 | 1819745 | g315998 | i0 | 46 | 0.592476489028213 | 63 | 27 | 55.5 | 2 | 317 | 141 | 609 | 668 | OAF67154.1 hypothetical protein A3Q56_05126 [Intoshia linei] | diamond | 189 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 30294412 | 30294412 | PRJNA1237347_P_NODE_165512_length_491_cov_2.437799_g158948_i0 | PRJNA1237347 | 165512 | 491 | 2.437799 | 11.96959309 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 62 | 1.04e-7 | NR | OAF70112.1 | 1819745 | g158948 | i0 | 30.2 | 0.769857433808554 | 126 | 84 | 76.4 | 3 | 105 | 479 | 1811 | 1933 | OAF70112.1 DnaJ subfamily C member 13 [Intoshia linei] | diamond | 378 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 30483949 | 30483949 | PRJNA1237347_P_NODE_371933_length_292_cov_1.054795_g365360_i0 | PRJNA1237347 | 371933 | 292 | 1.054795 | 3.0800014 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 55.8 | 1.68e-6 | NR | OAF67331.1 | 1819745 | g365360 | i0 | 31 | 1.02739726027397 | 100 | 61 | 94.5 | 2 | 5 | 280 | 608 | 707 | OAF67331.1 Epithelial cell-transforming sequence 2 oncogene [Intoshia linei] | diamond | 300 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 30957808 | 30957808 | PRJNA1237347_P_NODE_242994_length_381_cov_2.237013_g236421_i0 | PRJNA1237347 | 242994 | 381 | 2.237013 | 8.52301953 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 92 | 1.08e-18 | NR | OAF70026.1 | 1819745 | g236421 | i0 | 50.6 | 7.03937007874016 | 89 | 40 | 70.1 | 2 | 112 | 378 | 1474 | 1558 | OAF70026.1 hypothetical protein A3Q56_02216, partial [Intoshia linei] | diamond | 2682 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei | |||
| 31621610 | 31621610 | PRJNA1237347_P_NODE_320676_length_320_cov_1.902834_g314103_i0 | PRJNA1237347 | 320676 | 320 | 1.902834 | 6.0890688 | Intoshia linei | 1819745 | Orthonectida | other_Eukaryota | 57 | 8.63e-7 | NR | OAF69446.1 | 1819745 | g314103 | i0 | 32.5 | 1.415625 | 83 | 56 | 77.8 | 0 | 265 | 17 | 188 | 270 | OAF69446.1 RCC1-like G exchanging factor-like protein [Intoshia linei] | diamond | 453 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Orthonectida | Rhopaluridae | Intoshia | Intoshia linei |
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);;