contig_metadata
13 rows where bioproject = "PRJNA1237888" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1621281 | 1621281 | PRJNA1237888_S_NODE_2962_length_235_cov_2.419355_g2912_i0 | PRJNA1237888 | 2962 | 235 | 2.419355 | 5.68548425 | Licmophora juergensii | 210598 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 1.8199999999999993e-107 | NTclustered | gi|2862228907|gb|PQ645541.1| | 210598 | g2912 | i0 | 97.447 | 99.9744680851064 | 235 | 6 | 100 | 0 | 1 | 235 | 3028 | 3262 | Licmophora juergensii isolate AGSB0420 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23494 | 401 | 1 | Eukaryota | Sar | Bacillariophyta | Fragilariophyceae | Licmophorales | Licmophoraceae | Licmophora | Licmophora juergensii | ||
| 4173836 | 4173836 | PRJNA1237888_S_NODE_764_length_453_cov_3.990099_g714_i0 | PRJNA1237888 | 764 | 453 | 3.990099 | 18.07514847 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 730 | 0 | NTclustered | gi|2633519340|gb|OR805654.1| | 2126271 | g714 | i0 | 95.796 | 198.066225165563 | 452 | 19 | 99 | 0 | 1 | 452 | 121071 | 121522 | Naviculales sp. strain SZCZO2114 plastid, complete genome | blastn | 89724 | 730 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculales sp. | ||||
| 4877904 | 4877904 | PRJNA1237888_S_NODE_4524_length_193_cov_1.958333_g4474_i0 | PRJNA1237888 | 4524 | 193 | 1.958333 | 3.77958269 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.6499999999999996e-35 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4474 | i0 | 90.909 | 1.88082901554404 | 121 | 10 | 62 | 1 | 1 | 120 | 2962 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 363 | 161 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 5450135 | 5450135 | PRJNA1237888_S_NODE_285_length_673_cov_4.065705_g248_i0 | PRJNA1237888 | 285 | 673 | 4.065705 | 27.36219465 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 669 | 0 | NTclustered | gi|146762526|gb|EF553458.1| | 2850 | g248 | i0 | 91.296 | 73.7221396731055 | 494 | 37 | 73 | 6 | 1 | 492 | 4071 | 4560 | Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 49615 | 669 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 5450150 | 5450150 | PRJNA1237888_S_NODE_6045_length_169_cov_0.875000_g5995_i0 | PRJNA1237888 | 6045 | 169 | 0.875 | 1.47875 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 6.0699999999999995e-56 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g5995 | i0 | 91.667 | 8.02366863905325 | 168 | 10 | 98 | 3 | 1 | 165 | 3396 | 3562 | Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1356 | 230 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 13100496 | 13100496 | PRJNA1237888_S_NODE_4591_length_192_cov_1.090909_g4541_i0 | PRJNA1237888 | 4591 | 192 | 1.090909 | 2.09454528 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.017 | NTclustered | gi|156101300|ref|XM_001616294.1| | 5855 | g4541 | i0 | 100 | 0.145833333333333 | 28 | 0 | 15 | 0 | 159 | 186 | 3872 | 3845 | Plasmodium vivax hypothetical protein, conserved (PVX_114780), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 14375680 | 14375680 | PRJNA1237888_S_NODE_5712_length_173_cov_1.717742_g5662_i0 | PRJNA1237888 | 5712 | 173 | 1.717742 | 2.97169366 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 3.6600000000000005e-73 | NTclustered | gi|2633519340|gb|OR805654.1| | 2126271 | g5662 | i0 | 97.605 | 196.398843930636 | 167 | 4 | 97 | 0 | 7 | 173 | 120932 | 121098 | Naviculales sp. strain SZCZO2114 plastid, complete genome | blastn | 33977 | 287 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculales sp. | ||||
| 17627551 | 17627551 | PRJNA1237888_S_NODE_2454_length_259_cov_1.728571_g2404_i0 | PRJNA1237888 | 2454 | 259 | 1.728571 | 4.47699889 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 7.16e-122 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2404 | i0 | 98.062 | 98.2934362934363 | 258 | 5 | 99 | 0 | 1 | 258 | 2313 | 2056 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25458 | 449 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18901310 | 18901310 | PRJNA1237888_S_NODE_6135_length_168_cov_8.025210_g6085_i0 | PRJNA1237888 | 6135 | 168 | 8.02521 | 13.4823528 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 3.87e-13 | NTclustered | gi|363586005|gb|JN391431.1| | 5865 | g6085 | i0 | 77.143 | 95.8630952380952 | 175 | 24 | 99 | 10 | 2 | 168 | 2575 | 2409 | Babesia bovis isolate Shanxian 28S ribosomal RNA gene, partial sequence | blastn | 16105 | 87.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 24001834 | 24001834 | PRJNA1237888_S_NODE_559_length_517_cov_3.047009_g510_i0 | PRJNA1237888 | 559 | 517 | 3.047009 | 15.75303653 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 671 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g510 | i0 | 93.231 | 83.7214700193424 | 458 | 27 | 89 | 4 | 60 | 517 | 1953 | 1500 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 43284 | 671 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24572932 | 24572932 | PRJNA1237888_S_NODE_3340_length_222_cov_1.560694_g3290_i0 | PRJNA1237888 | 3340 | 222 | 1.560694 | 3.46474068 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.96e-75 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g3290 | i0 | 97.126 | 67.9864864864865 | 174 | 5 | 78 | 0 | 49 | 222 | 1569 | 1396 | Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15093 | 294 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25275948 | 25275948 | PRJNA1237888_S_NODE_3700_length_212_cov_0.950920_g3650_i0 | PRJNA1237888 | 3700 | 212 | 0.95092 | 2.0159504 | Pseudochilodonopsis | 1170555 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.6499999999999996e-87 | NTclustered | gi|906358594|gb|KR611083.2| | 1170556 | g3650 | i0 | 97.927 | 85.1839622641509 | 193 | 4 | 91 | 0 | 20 | 212 | 610 | 802 | Pseudochilodonopsis fluviatilis isolate QZS2013071501 small subunit ribosomal RNA gene, partial sequence | blastn | 18059 | 335 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Pseudochilodonopsis | Pseudochilodonopsis fluviatilis | ||
| 30326750 | 30326750 | PRJNA1237888_S_NODE_6812_length_165_cov_0.896552_g6762_i0 | PRJNA1237888 | 6812 | 165 | 0.896552 | 1.4793108 | Symbiodinium sp. CCMP2592 | 631055 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0252 | NR | CAE6961798.1 | 631055 | g6762 | i0 | 44.9 | 1.78181818181818 | 49 | 27 | 89.1 | 0 | 4 | 150 | 16 | 64 | CAE6961798.1 ngoBVM [Symbiodinium sp. CCMP2592] | diamond | 294 | 42 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2592 |
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);;