contig_metadata
11 rows where bioproject = "PRJNA939370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 914619 | 914619 | PRJNA939370_S_NODE_1941_length_196_cov_1.102041_g1889_i0 | PRJNA939370 | 1941 | 196 | 1.102041 | 2.16000036 | Protaspis grandis | 361427 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 7.45e-41 | NTclustered | gi|290760486|gb|GQ144689.1| | 361427 | g1889 | i0 | 83.684 | 46.4081632653061 | 190 | 31 | 97 | 0 | 6 | 195 | 1805 | 1994 | Protaspis grandis large subunit ribosomal RNA gene, partial sequence | blastn | 9096 | 180 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Protaspis | Protaspis grandis | ||
| 1256148 | 1256148 | PRJNA939370_S_NODE_2001_length_193_cov_1.125000_g1949_i0 | PRJNA939370 | 2001 | 193 | 1.125 | 2.17125 | Chromulinaceae | 98651 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.1499999999999996e-94 | NTclustered | gi|161015697|gb|EF681931.1| | 89044 | g1949 | i0 | 100 | 100 | 193 | 0 | 100 | 0 | 1 | 193 | 875 | 1067 | Spumella elongata strain CCAP955/1 28S ribosomal RNA gene, partial sequence | blastn | 19300 | 357 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella elongata | |||
| 2190064 | 2190064 | PRJNA939370_S_NODE_3162_length_162_cov_1.265487_g3110_i0 | PRJNA939370 | 3162 | 162 | 1.265487 | 2.05008894 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 250 | 4.45e-62 | NTclustered | gi|161015657|gb|EF666122.1| | 466266 | g3110 | i0 | 94.512 | 101.364197530864 | 164 | 5 | 100 | 3 | 1 | 162 | 184 | 23 | Cercomonas crassicauda 28S ribosomal RNA gene, partial sequence | blastn | 16421 | 250 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 8567601 | 8567601 | PRJNA939370_S_NODE_1267_length_246_cov_3.624365_g1215_i0 | PRJNA939370 | 1267 | 246 | 3.624365 | 8.9159379 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.14e-120 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g1215 | i0 | 99.187 | 100.955284552846 | 246 | 2 | 100 | 0 | 1 | 246 | 2042 | 1797 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 24835 | 444 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 10184883 | 10184883 | PRJNA939370_S_NODE_828_length_320_cov_39.793358_g776_i0 | PRJNA939370 | 828 | 320 | 39.793358 | 127.3387456 | Scrippsiella | 54902 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.8e-52 | NTclustered | gi|1815646385|gb|MH497038.1| | 106540 | g776 | i0 | 89.143 | 55.834375 | 175 | 19 | 55 | 0 | 143 | 317 | 110 | 284 | Scrippsiella ramonii strain GeoB 398 large subunit ribosomal RNA gene, partial sequence | blastn | 17867 | 219 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Peridiniaceae | Scrippsiella | Scrippsiella ramonii | |||
| 12393852 | 12393852 | PRJNA939370_S_NODE_990_length_285_cov_6.067797_g938_i0 | PRJNA939370 | 990 | 285 | 6.067797 | 17.29322145 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 9.2e-22 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g938 | i0 | 84.252 | 26.1052631578947 | 127 | 13 | 44 | 4 | 3 | 127 | 2658 | 2779 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 7440 | 117 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 13668295 | 13668295 | PRJNA939370_S_NODE_2531_length_173_cov_1.395161_g2479_i0 | PRJNA939370 | 2531 | 173 | 1.395161 | 2.41362853 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 1.68e-81 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g2479 | i0 | 99.422 | 101.982658959538 | 173 | 1 | 100 | 0 | 1 | 173 | 1052 | 880 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 17643 | 315 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 13668301 | 13668301 | PRJNA939370_S_NODE_51_length_946_cov_7.879599_g33_i0 | PRJNA939370 | 51 | 946 | 7.879599 | 74.54100654 | Cryptosporidium sp. | 90962 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 3.3200000000000004e-26 | NTclustered | gi|2165328180|gb|OL865400.1| | 90962 | g33 | i0 | 86.777 | 12.7610993657505 | 121 | 14 | 13 | 2 | 591 | 710 | 86 | 205 | Cryptosporidium sp. isolate PRBOV409 large subunit ribosomal RNA gene, partial sequence | blastn | 12072 | 134 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium sp. | ||
| 16217650 | 16217650 | PRJNA939370_S_NODE_553_length_389_cov_42.811765_g501_i0 | PRJNA939370 | 553 | 389 | 42.811765 | 166.53776585 | uncultured Eimeriidae | 404735 | SAR_Eukaryotes | SAR_Eukaryotes | 604 | 2.279999999999999e-168 | NTclustered | gi|134022138|gb|EF023488.1| | 404735 | g501 | i0 | 94.656 | 100.377892030848 | 393 | 15 | 100 | 4 | 1 | 389 | 1271 | 1661 | Eimeriidae environmental sample clone Amb_18S_1074 18S ribosomal RNA gene, partial sequence | blastn | 39047 | 604 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | uncultured Eimeriidae | |||
| 20041289 | 20041289 | PRJNA939370_S_NODE_1816_length_202_cov_1.888889_g1764_i0 | PRJNA939370 | 1816 | 202 | 1.888889 | 3.81555578 | Chrysolepidomonas dendrolepidota | 64707 | SAR_Eukaryotes | SAR_Eukaryotes | 84.2 | 6.24e-12 | NTclustered | gi|16326553|gb|AF409121.1| | 64707 | g1764 | i0 | 97.917 | 0.693069306930693 | 48 | 1 | 24 | 0 | 155 | 202 | 3852 | 3899 | Chrysolepidomonas dendrolepidota internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 140 | 84.2 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chrysolepidomonadaceae | Chrysolepidomonas | Chrysolepidomonas dendrolepidota | |||
| 30498998 | 30498998 | PRJNA939370_S_NODE_2133_length_188_cov_0.985612_g2081_i0 | PRJNA939370 | 2133 | 188 | 0.985612 | 1.85295056 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 1.86e-6 | NR | KRX06453.1 | 266149 | g2081 | i0 | 43.5 | 0.98936170212766 | 62 | 35 | 98.9 | 0 | 186 | 1 | 69 | 130 | KRX06453.1 Ribosomal protein L11, N-terminal [Pseudocohnilembus persalinus] | diamond | 186 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus |
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);;