contig_metadata
9 rows where bioproject = "PRJNA577580", tax_clade = "Sar" and tax_phylum = "Perkinsozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19690435 | 19690435 | PRJNA577580_P_NODE_13236_length_255_cov_1.609890_g13158_i0 | PRJNA577580 | 13236 | 255 | 1.60989 | 4.1052195 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 83.2 | 1.48e-16 | NR | KAF4701897.1 | 32597 | g13158 | i0 | 44.4 | 7.65882352941177 | 81 | 45 | 95.3 | 0 | 1 | 243 | 94 | 174 | KAF4701897.1 hypothetical protein FOZ63_032165, partial [Perkinsus olseni] | diamond | 1953 | 83.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 26699616 | 26699616 | PRJNA577580_P_NODE_15861_length_244_cov_0.912281_g15783_i0 | PRJNA577580 | 15861 | 244 | 0.912281 | 2.22596564 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.6499999999999995e-31 | NR | KAF4688135.1 | 32597 | g15783 | i0 | 74.1 | 13.9426229508197 | 81 | 19 | 99.6 | 1 | 243 | 1 | 683 | 761 | KAF4688135.1 hypothetical protein FOZ60_003142 [Perkinsus olseni] | diamond | 3402 | 126 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27269246 | 27269246 | PRJNA577580_P_NODE_11863_length_268_cov_2.117949_g11785_i0 | PRJNA577580 | 11863 | 268 | 2.117949 | 5.67610332 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 5.74e-36 | NR | KAF4677206.1 | 330153 | g11785 | i0 | 78.4 | 5.79850746268657 | 74 | 16 | 82.8 | 0 | 1 | 222 | 511 | 584 | KAF4677206.1 hypothetical protein FOL47_002769 [Perkinsus chesapeaki] | diamond | 1554 | 139 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 27648481 | 27648481 | PRJNA577580_P_NODE_10364_length_285_cov_1.471698_g10286_i0 | PRJNA577580 | 10364 | 285 | 1.471698 | 4.1943393 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 8.73e-15 | NR | KAF4656681.1 | 32597 | g10286 | i0 | 53.8 | 1.36842105263158 | 65 | 29 | 68.4 | 1 | 283 | 89 | 56 | 119 | KAF4656681.1 signal recognition particle 19kDa [Perkinsus olseni] | diamond | 390 | 75.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 28532571 | 28532571 | PRJNA577580_P_NODE_7187_length_336_cov_1.098859_g7109_i0 | PRJNA577580 | 7187 | 336 | 1.098859 | 3.69216624 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.82e-26 | NR | XP_002765768.1 | 423536 | g7109 | i0 | 50 | 1.03571428571429 | 116 | 48 | 98.2 | 2 | 334 | 5 | 104 | 215 | XP_002765768.1 tetratricopeptide repeat protein, putative [Perkinsus marinus ATCC 50983] | diamond | 348 | 107 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 30774905 | 30774905 | PRJNA577580_P_NODE_16314_length_242_cov_1.514793_g16236_i0 | PRJNA577580 | 16314 | 242 | 1.514793 | 3.66579906 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.64e-6 | NR | KAF4704498.1 | 32597 | g16236 | i0 | 40 | 9.59504132231405 | 65 | 39 | 80.6 | 0 | 241 | 47 | 306 | 370 | KAF4704498.1 hypothetical protein FOZ62_024017, partial [Perkinsus olseni] | diamond | 2322 | 55.1 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30851404 | 30851404 | PRJNA577580_P_NODE_6134_length_363_cov_1.075862_g6056_i0 | PRJNA577580 | 6134 | 363 | 1.075862 | 3.90537906 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0041 | NR | KAF4745642.1 | 32597 | g6056 | i0 | 66.7 | 0.942148760330578 | 24 | 8 | 19.8 | 0 | 354 | 283 | 2 | 25 | KAF4745642.1 hypothetical protein FOZ63_021187, partial [Perkinsus olseni] | diamond | 342 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30946384 | 30946384 | PRJNA577580_P_NODE_6814_length_344_cov_2.321033_g6736_i0 | PRJNA577580 | 6814 | 344 | 2.321033 | 7.98435352 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 93.2 | 2.39e-19 | NR | KAF4708651.1 | 32597 | g6736 | i0 | 41 | 4.05523255813953 | 117 | 56 | 90.7 | 4 | 32 | 343 | 148 | 264 | KAF4708651.1 Sorl1p, variant 2 [Perkinsus olseni] | diamond | 1395 | 93.6 | 0.995726495726496 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32797534 | 32797534 | PRJNA577580_P_NODE_12420_length_263_cov_1.563158_g12342_i0 | PRJNA577580 | 12420 | 263 | 1.563158 | 4.11110554 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 2.12e-4 | NR | KAF4683455.1 | 32597 | g12342 | i0 | 35.1 | 6.23954372623574 | 74 | 48 | 84.4 | 0 | 259 | 38 | 216 | 289 | KAF4683455.1 extended synaptotagmin-like protein, partial [Perkinsus olseni] | diamond | 1641 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni |
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);;