contig_metadata
14 rows where bioproject = "PRJNA453567", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1716624 | 1716624 | PRJNA453567_P_NODE_13282_length_252_cov_1.451163_g13045_i0 | PRJNA453567 | 13282 | 252 | 1.451163 | 3.65693076 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.2499999999999993e-115 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g13045 | i0 | 97.222 | 85.5476190476191 | 252 | 7 | 100 | 0 | 1 | 252 | 736 | 485 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 21558 | 427 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 1716776 | 1716776 | PRJNA453567_P_NODE_4782_length_474_cov_2.677346_g4549_i0 | PRJNA453567 | 4782 | 474 | 2.677346 | 12.69062004 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 758 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g4549 | i0 | 95.417 | 55.0126582278481 | 480 | 15 | 100 | 6 | 1 | 474 | 1026 | 548 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 26076 | 758 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2368795 | 2368795 | PRJNA453567_P_NODE_1882_length_845_cov_2.440594_g1732_i0 | PRJNA453567 | 1882 | 845 | 2.440594 | 20.6230193 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 5.889999999999998e-99 | NR | MES1912193.1 | 1215613 | g1732 | i0 | 66.8 | 2.51715976331361 | 238 | 79 | 84.5 | 0 | 27 | 740 | 2 | 239 | MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] | diamond | 2127 | 300 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 2992445 | 2992445 | PRJNA453567_P_NODE_18223_length_208_cov_3.649123_g17986_i0 | PRJNA453567 | 18223 | 208 | 3.649123 | 7.59017584 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.4199999999999996e-99 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g17986 | i0 | 99.038 | 33.5865384615385 | 208 | 2 | 100 | 0 | 1 | 208 | 2696 | 2903 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 6986 | 374 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2992465 | 2992465 | PRJNA453567_P_NODE_21783_length_188_cov_2.066225_g21546_i0 | PRJNA453567 | 21783 | 188 | 2.066225 | 3.884503 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.13e-73 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g21546 | i0 | 94.271 | 25.8989361702128 | 192 | 6 | 100 | 4 | 1 | 188 | 2407 | 2217 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4869 | 289 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14470479 | 14470479 | PRJNA453567_P_NODE_2392_length_733_cov_2.755747_g2216_i0 | PRJNA453567 | 2392 | 733 | 2.755747 | 20.19962551 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 1.2499999999999995e-168 | NTclustered | gi|238617666|gb|FJ973412.1| | 188950 | g2216 | i0 | 81.658 | 97.1678035470669 | 736 | 129 | 100 | 5 | 1 | 733 | 1152 | 420 | Bodomorpha minima strain ATCC 50339 alpha-tubulin (atub) gene, partial cds | blastn | 71224 | 606 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 15744435 | 15744435 | PRJNA453567_P_NODE_18033_length_210_cov_1.352601_g17796_i0 | PRJNA453567 | 18033 | 210 | 1.352601 | 2.8404621 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.6999999999999998e-95 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g17796 | i0 | 97.619 | 84.4285714285714 | 210 | 5 | 100 | 0 | 1 | 210 | 296 | 505 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 17730 | 361 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 19567564 | 19567564 | PRJNA453567_P_NODE_12696_length_258_cov_41.203620_g12459_i0 | PRJNA453567 | 12696 | 258 | 41.20362 | 106.3053396 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.2699999999999985e-130 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g12459 | i0 | 100 | 87.3565891472868 | 258 | 0 | 100 | 0 | 1 | 258 | 1704 | 1447 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 22538 | 477 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 20843587 | 20843587 | PRJNA453567_P_NODE_31357_length_156_cov_2.621849_g31120_i0 | PRJNA453567 | 31357 | 156 | 2.621849 | 4.09008444 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.1899999999999994e-72 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g31120 | i0 | 99.363 | 5.95512820512821 | 157 | 0 | 100 | 1 | 1 | 156 | 1499 | 1655 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 929 | 283 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 23394144 | 23394144 | PRJNA453567_P_NODE_9159_length_315_cov_3.899281_g8922_i0 | PRJNA453567 | 9159 | 315 | 3.899281 | 12.28273515 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.01e-36 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g8922 | i0 | 78.596 | 23.4825396825397 | 285 | 37 | 90 | 17 | 1 | 282 | 3776 | 4039 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 7397 | 167 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 28008492 | 28008492 | PRJNA453567_P_NODE_6105_length_406_cov_1.373984_g5869_i0 | PRJNA453567 | 6105 | 406 | 1.373984 | 5.57837504 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 91.7 | 1.91e-18 | NR | MES1910123.1 | 1215613 | g5869 | i0 | 43.3 | 2.80788177339901 | 127 | 63 | 90.1 | 2 | 6 | 371 | 3045 | 3167 | MES1910123.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1140 | 91.7 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28355529 | 28355529 | PRJNA453567_P_NODE_1086_length_1128_cov_3.575619_g996_i0 | PRJNA453567 | 1086 | 1128 | 3.575619 | 40.33298232 | Hondaea | 2315209 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 7.999999999999999e-26 | NR | MES1909711.1 | 1215613 | g996 | i0 | 38.6 | 1.13829787234043 | 202 | 107 | 52.4 | 5 | 1126 | 536 | 267 | 456 | MES1909711.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1284 | 120 | 0.991666666666667 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30518447 | 30518447 | PRJNA453567_P_NODE_24173_length_178_cov_2.482270_g23936_i0 | PRJNA453567 | 24173 | 178 | 2.48227 | 4.4184406 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 40.8 | 0.0193 | NR | AAT09062.1 | 227086 | g23936 | i0 | 52.9 | 0.573033707865168 | 34 | 16 | 57.3 | 0 | 147 | 46 | 47 | 80 | AAT09062.1 selenoprotein W 1 [Bigelowiella natans] | diamond | 102 | 40.8 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 31308362 | 31308362 | PRJNA453567_P_NODE_2315_length_748_cov_2.789030_g2143_i0 | PRJNA453567 | 2315 | 748 | 2.78903 | 20.8619444 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 87 | 1.6e-15 | NR | MES1908555.1 | 1215613 | g2143 | i0 | 44.8 | 2.31417112299465 | 96 | 52 | 38.5 | 1 | 79 | 366 | 4 | 98 | MES1908555.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1731 | 87 | 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);;