contig_metadata
18 rows where bioproject = "PRJNA352610", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4220993 | 4220993 | PRJNA352610_P_NODE_18524_length_290_cov_1.050691_g18463_i0 | PRJNA352610 | 18524 | 290 | 1.050691 | 3.0470039 | Dinophyceae | 2864 | SAR_Eukaryotes | SAR_Eukaryotes | 152 | 1.3899999999999996e-42 | NR | KAF4662583.1 | 330153 | g18463 | i0 | 72.9 | 7.9448275862069 | 96 | 26 | 99.3 | 0 | 3 | 290 | 117 | 212 | KAF4662583.1 hypothetical protein FOL47_006179 [Perkinsus chesapeaki] | diamond | 2304 | 152 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 8047316 | 8047316 | PRJNA352610_P_NODE_5607_length_459_cov_1.095855_g5546_i0 | PRJNA352610 | 5607 | 459 | 1.095855 | 5.02997445 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 1.13e-73 | NR | KAF4700315.1 | 32597 | g5546 | i0 | 73 | 21.843137254902 | 152 | 41 | 99.3 | 0 | 2 | 457 | 14 | 165 | KAF4700315.1 Arf GTPase arf1 [Perkinsus olseni] | diamond | 10026 | 228 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 13147411 | 13147411 | PRJNA352610_P_NODE_19591_length_283_cov_1.466667_g19530_i0 | PRJNA352610 | 19591 | 283 | 1.466667 | 4.15066761 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 94 | 3.43e-20 | NR | KAF4657297.1 | 32597 | g19530 | i0 | 67.5 | 0.848056537102474 | 80 | 26 | 84.8 | 0 | 4 | 243 | 315 | 394 | KAF4657297.1 U4 u6 small nuclear ribonucleoprotein [Perkinsus olseni] | diamond | 240 | 94 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 13147790 | 13147790 | PRJNA352610_P_NODE_9471_length_376_cov_2.702970_g9410_i0 | PRJNA352610 | 9471 | 376 | 2.70297 | 10.1631672 | Perkinsus marinus | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 2.0499999999999998e-34 | NTclustered | gi|294881230|ref|XM_002769261.1| | 423536 | g9410 | i0 | 78.244 | 16.2021276595745 | 262 | 48 | 68 | 7 | 9 | 265 | 306 | 49 | Perkinsus marinus ATCC 50983 60S ribosomal protein L27a, putative, mRNA | blastn | 6092 | 159 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 26965367 | 26965367 | PRJNA352610_P_NODE_27422_length_248_cov_0.880000_g27361_i0 | PRJNA352610 | 27422 | 248 | 0.88 | 2.1824 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 1.27e-6 | NR | KAF4722627.1 | 32597 | g27361 | i0 | 40.3 | 4.68145161290323 | 77 | 46 | 93.1 | 0 | 248 | 18 | 49 | 125 | KAF4722627.1 hypothetical protein FOZ63_029349, partial [Perkinsus olseni] | diamond | 1161 | 53.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 27232807 | 27232807 | PRJNA352610_P_NODE_23023_length_262_cov_1.481481_g22962_i0 | PRJNA352610 | 23023 | 262 | 1.481481 | 3.88148022 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 77.8 | 2.11e-14 | NR | KAF4675656.1 | 330153 | g22962 | i0 | 50.7 | 0.767175572519084 | 67 | 33 | 76.7 | 0 | 255 | 55 | 127 | 193 | KAF4675656.1 hypothetical protein FOL47_007428 [Perkinsus chesapeaki] | diamond | 201 | 77.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 28085408 | 28085408 | PRJNA352610_P_NODE_5765_length_454_cov_1.461942_g5704_i0 | PRJNA352610 | 5765 | 454 | 1.461942 | 6.63721668 | Perkinsus marinus ATCC 5 | 31276 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.0236 | NR | XP_002774905.1 | 423536 | g5704 | i0 | 38.3 | 0.753303964757709 | 60 | 37 | 39.6 | 0 | 172 | 351 | 259 | 318 | XP_002774905.1 hypothetical protein Pmar_PMAR007438 [Perkinsus marinus ATCC 50983] | diamond | 342 | 45.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus marinus | |||
| 28811375 | 28811375 | PRJNA352610_P_NODE_32028_length_241_cov_0.916667_g31967_i0 | PRJNA352610 | 32028 | 241 | 0.916667 | 2.20916747 | Perkinsus chesapeaki | 330153 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 2.53e-4 | NR | KAF4664286.1 | 330153 | g31967 | i0 | 47.1 | 0.634854771784232 | 51 | 25 | 61 | 1 | 94 | 240 | 688 | 738 | KAF4664286.1 hypothetical protein FOL47_005217 [Perkinsus chesapeaki] | diamond | 153 | 48.9 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 29474464 | 29474464 | PRJNA352610_P_NODE_27830_length_247_cov_0.885057_g27769_i0 | PRJNA352610 | 27830 | 247 | 0.885057 | 2.18609079 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 4.13e-5 | NR | KAF4659573.1 | 32597 | g27769 | i0 | 34.9 | 5.35627530364372 | 63 | 39 | 74.1 | 2 | 246 | 64 | 1087 | 1149 | KAF4659573.1 hypothetical protein FOZ61_004654 [Perkinsus olseni] | diamond | 1323 | 51.2 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30643318 | 30643318 | PRJNA352610_P_NODE_11213_length_353_cov_1.096429_g11152_i0 | PRJNA352610 | 11213 | 353 | 1.096429 | 3.87039437 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.0149 | NR | KAF4690192.1 | 32597 | g11152 | i0 | 46.2 | 0.662889518413598 | 39 | 21 | 33.1 | 0 | 349 | 233 | 1023 | 1061 | KAF4690192.1 hypothetical protein FOZ60_000546 [Perkinsus olseni] | diamond | 234 | 45.4 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 30896403 | 30896403 | PRJNA352610_P_NODE_12294_length_341_cov_1.029851_g12233_i0 | PRJNA352610 | 12294 | 341 | 1.029851 | 3.51179191 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 8.349999999999999e-47 | NR | KAF4655531.1 | 32597 | g12233 | i0 | 64 | 4.83870967741935 | 111 | 40 | 97.7 | 0 | 7 | 339 | 206 | 316 | KAF4655531.1 hypothetical protein FOZ61_007528 [Perkinsus olseni] | diamond | 1650 | 167 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31117150 | 31117150 | PRJNA352610_P_NODE_11035_length_355_cov_1.453901_g10974_i0 | PRJNA352610 | 11035 | 355 | 1.453901 | 5.16134855 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 6.67e-4 | NR | KAF4754063.1 | 32597 | g10974 | i0 | 40.7 | 1.58028169014084 | 54 | 29 | 45.6 | 1 | 117 | 278 | 228 | 278 | KAF4754063.1 hypothetical protein FOZ62_024433, partial [Perkinsus olseni] | diamond | 561 | 49.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31148620 | 31148620 | PRJNA352610_P_NODE_9615_length_374_cov_1.564784_g9554_i0 | PRJNA352610 | 9615 | 374 | 1.564784 | 5.85229216 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.42e-8 | NR | KAF4736437.1 | 32597 | g9554 | i0 | 33.1 | 0.970588235294118 | 121 | 70 | 91.4 | 5 | 13 | 354 | 195 | 311 | KAF4736437.1 hypothetical protein FOZ62_016183, partial [Perkinsus olseni] | diamond | 363 | 62.8 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31939618 | 31939618 | PRJNA352610_P_NODE_26597_length_249_cov_0.875000_g26536_i0 | PRJNA352610 | 26597 | 249 | 0.875 | 2.17875 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 44.3 | 0.00336 | NR | KAF4751301.1 | 32597 | g26536 | i0 | 44.7 | 1.69879518072289 | 47 | 26 | 56.6 | 0 | 222 | 82 | 37 | 83 | KAF4751301.1 hypothetical protein FOZ62_008849, partial [Perkinsus olseni] | diamond | 423 | 44.3 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 31956813 | 31956813 | PRJNA352610_P_NODE_16417_length_305_cov_1.318966_g16356_i0 | PRJNA352610 | 16417 | 305 | 1.318966 | 4.0228463 | Perkinsozoa | 2497438 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 2.899999999999999e-29 | NR | KAF4749837.1 | 32597 | g16356 | i0 | 56.1 | 10.3868852459016 | 98 | 40 | 93.4 | 1 | 290 | 6 | 120 | 217 | KAF4749837.1 hypothetical protein FOZ63_007177, partial [Perkinsus olseni] | diamond | 3168 | 118 | 0.991525423728814 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32034692 | 32034692 | PRJNA352610_P_NODE_3118_length_572_cov_1.132265_g3057_i0 | PRJNA352610 | 3118 | 572 | 1.132265 | 6.4765558 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 234 | 2.62e-75 | NR | KAF4700315.1 | 32597 | g3057 | i0 | 75.5 | 11.0402097902098 | 151 | 36 | 79.2 | 1 | 3 | 455 | 32 | 181 | KAF4700315.1 Arf GTPase arf1 [Perkinsus olseni] | diamond | 6315 | 234 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32319785 | 32319785 | PRJNA352610_P_NODE_24959_length_251_cov_1.235955_g24898_i0 | PRJNA352610 | 24959 | 251 | 1.235955 | 3.10224705 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 48.5 | 7.66e-5 | NR | KAF4741144.1 | 32597 | g24898 | i0 | 82.6 | 0.274900398406374 | 23 | 4 | 27.5 | 0 | 4 | 72 | 16 | 38 | KAF4741144.1 hypothetical protein FOZ62_006983, partial [Perkinsus olseni] | diamond | 69 | 48.5 | 1 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus olseni | |||
| 32635228 | 32635228 | PRJNA352610_P_NODE_18520_length_290_cov_1.059908_g18459_i0 | PRJNA352610 | 18520 | 290 | 1.059908 | 3.0737332 | Perkinsus olseni | 32597 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 4.469999999999999e-42 | NR | KAF4675070.1 | 32597 | g18459 | i0 | 72.9 | 6.95172413793103 | 96 | 26 | 99.3 | 0 | 290 | 3 | 608 | 703 | KAF4675070.1 hypothetical protein FOL46_002986 [Perkinsus olseni] | diamond | 2016 | 156 | 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);;