contig_metadata
18 rows where bioproject = "PRJNA966993", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8594891 | 8594891 | PRJNA966993_P_NODE_1247_length_1666_cov_4.180163_g1107_i0 | PRJNA966993 | 1247 | 1666 | 4.180163 | 69.64151558 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 697 | 4.09e-248 | NR | MES1909605.1 | 1215613 | g1107 | i0 | 77.6 | 4.77370948379352 | 433 | 97 | 78 | 0 | 21 | 1319 | 1 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 7953 | 701 | 0.994293865905849 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 8595107 | 8595107 | PRJNA966993_P_NODE_35547_length_359_cov_2.006993_g35095_i0 | PRJNA966993 | 35547 | 359 | 2.006993 | 7.20510487 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 3.1499999999999996e-57 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g35095 | i0 | 80.793 | 28.3649025069638 | 328 | 39 | 91 | 17 | 1 | 325 | 3733 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 10183 | 235 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 10194306 | 10194306 | PRJNA966993_P_NODE_43708_length_326_cov_2.434783_g43256_i0 | PRJNA966993 | 43708 | 326 | 2.434783 | 7.93739258 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 148 | 1.79e-41 | NR | MES1911029.1 | 1215613 | g43256 | i0 | 67 | 1.03067484662577 | 112 | 33 | 99.4 | 1 | 326 | 3 | 88 | 199 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 336 | 148 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 11145714 | 11145714 | PRJNA966993_P_NODE_32009_length_376_cov_2.495050_g31557_i0 | PRJNA966993 | 32009 | 376 | 2.49505 | 9.381388 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 625 | 1.6799999999999998e-174 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g31557 | i0 | 96.561 | 24.5212765957447 | 378 | 11 | 100 | 2 | 1 | 376 | 469 | 846 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 9220 | 625 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 12421443 | 12421443 | PRJNA966993_P_NODE_62970_length_280_cov_2.082126_g62518_i0 | PRJNA966993 | 62970 | 280 | 2.082126 | 5.8299528 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.6799999999999996e-124 | NTclustered | gi|302026154|gb|GQ377660.1| | 188950 | g62518 | i0 | 96.071 | 28.6571428571429 | 280 | 11 | 100 | 0 | 1 | 280 | 190 | 469 | Bodomorpha minima beta-tubulin (Btub) gene, partial cds | blastn | 8024 | 457 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14970405 | 14970405 | PRJNA966993_P_NODE_78732_length_256_cov_1.819672_g78280_i0 | PRJNA966993 | 78732 | 256 | 1.819672 | 4.65836032 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.61e-37 | NR | MES1911491.1 | 1215613 | g78280 | i0 | 77.1 | 2.91796875 | 83 | 19 | 97.3 | 0 | 250 | 2 | 242 | 324 | MES1911491.1 Actin-related protein 2 [Cercozoa sp. M6MM] | diamond | 747 | 138 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 16245267 | 16245267 | PRJNA966993_P_NODE_73773_length_264_cov_2.083770_g73321_i0 | PRJNA966993 | 73773 | 264 | 2.08377 | 5.5011528 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 1.5e-42 | NR | ACF24571.1 | 67809 | g73321 | i0 | 81.7 | 1.86363636363636 | 82 | 15 | 93.2 | 0 | 262 | 17 | 67 | 148 | ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata] | diamond | 492 | 146 | 0.993150684931507 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 17520596 | 17520596 | PRJNA966993_P_NODE_87194_length_248_cov_1.640000_g86742_i0 | PRJNA966993 | 87194 | 248 | 1.64 | 4.0672 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 153 | 5.02e-45 | NR | ACF24574.1 | 67809 | g86742 | i0 | 91.4 | 0.979838709677419 | 81 | 7 | 98 | 0 | 3 | 245 | 30 | 110 | ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata] | diamond | 243 | 153 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 23894576 | 23894576 | PRJNA966993_P_NODE_32179_length_375_cov_3.341060_g31727_i0 | PRJNA966993 | 32179 | 375 | 3.34106 | 12.528975 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 638 | 2.15e-178 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g31727 | i0 | 97.333 | 99.4666666666667 | 375 | 10 | 100 | 0 | 1 | 375 | 589 | 215 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 37300 | 638 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 25168316 | 25168316 | PRJNA966993_P_NODE_43120_length_329_cov_0.890625_g42668_i0 | PRJNA966993 | 43120 | 329 | 0.890625 | 2.93015625 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 3.55e-86 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g42668 | i0 | 96.059 | 71.0030395136778 | 203 | 8 | 62 | 0 | 126 | 328 | 765 | 563 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 23360 | 331 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 28005299 | 28005299 | PRJNA966993_P_NODE_68365_length_272_cov_3.000000_g67913_i0 | PRJNA966993 | 68365 | 272 | 3 | 8.16 | Cercomonas sp. ATCC 5 | 1979794 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 8.36e-37 | NR | CAE46439.1 | 45112 | g67913 | i0 | 76.1 | 0.970588235294118 | 88 | 21 | 97.1 | 0 | 271 | 8 | 239 | 326 | CAE46439.1 RNA polymerase II largest subunit, partial [Cercomonas sp. ATCC 50318] | diamond | 264 | 138 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50318 | |||
| 30152023 | 30152023 | PRJNA966993_P_NODE_52412_length_299_cov_2.384956_g51960_i0 | PRJNA966993 | 52412 | 299 | 2.384956 | 7.13101844 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 91.3 | 5.74e-19 | NR | MES1912280.1 | 1215613 | g51960 | i0 | 48.4 | 3.62207357859532 | 91 | 47 | 91.3 | 0 | 27 | 299 | 402 | 492 | MES1912280.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1083 | 91.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30531311 | 30531311 | PRJNA966993_P_NODE_50953_length_304_cov_1.000000_g50501_i0 | PRJNA966993 | 50953 | 304 | 1 | 3.04 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 84.3 | 2.31e-17 | NR | MES1912193.1 | 1215613 | g50501 | i0 | 56 | 3.59210526315789 | 84 | 37 | 82.9 | 0 | 268 | 17 | 6 | 89 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 1092 | 84.3 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31163027 | 31163027 | PRJNA966993_P_NODE_36935_length_353_cov_1.453571_g36483_i0 | PRJNA966993 | 36935 | 353 | 1.453571 | 5.13110563 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 93.6 | 1.94e-19 | NR | MES1907101.1 | 1215613 | g36483 | i0 | 39.3 | 2.96600566572238 | 117 | 68 | 98.6 | 2 | 350 | 3 | 494 | 608 | MES1907101.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1047 | 93.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31447997 | 31447997 | PRJNA966993_P_NODE_77116_length_259_cov_1.639785_g76664_i0 | PRJNA966993 | 77116 | 259 | 1.639785 | 4.24704315 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 70.1 | 9.64e-12 | NR | MES1913896.1 | 1215613 | g76664 | i0 | 46.4 | 1.92277992277992 | 84 | 44 | 97.3 | 1 | 257 | 6 | 41 | 123 | MES1913896.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 498 | 70.1 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32397140 | 32397140 | PRJNA966993_P_NODE_44419_length_324_cov_1.227092_g43967_i0 | PRJNA966993 | 44419 | 324 | 1.227092 | 3.97577808 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 78.6 | 1.54e-14 | NR | MES1917378.1 | 1215613 | g43967 | i0 | 39.8 | 0.814814814814815 | 88 | 53 | 81.5 | 0 | 48 | 311 | 1 | 88 | MES1917378.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 264 | 78.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32492142 | 32492142 | PRJNA966993_P_NODE_57579_length_288_cov_1.432558_g57127_i0 | PRJNA966993 | 57579 | 288 | 1.432558 | 4.12576704 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.39e-26 | NR | AAT09092.1 | 227086 | g57127 | i0 | 58 | 1.83333333333333 | 81 | 34 | 84.4 | 0 | 287 | 45 | 29 | 109 | AAT09092.1 RAS-like GTPase [Bigelowiella natans] | diamond | 528 | 105 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 32838580 | 32838580 | PRJNA966993_P_NODE_36680_length_354_cov_1.644128_g36228_i0 | PRJNA966993 | 36680 | 354 | 1.644128 | 5.82021312 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 9.56e-18 | NR | MES1909935.1 | 1215613 | g36228 | i0 | 47.4 | 3.72881355932203 | 95 | 50 | 80.5 | 0 | 331 | 47 | 337 | 431 | MES1909935.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1320 | 88.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;