contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1054617" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176499 | 176499 | PRJNA1054617_S_NODE_1541_length_382_cov_5.404130_g1453_i0 | PRJNA1054617 | 1541 | 382 | 5.40413 | 20.6437766 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g1453 | i0 | 100 | 46.848167539267 | 359 | 0 | 95 | 0 | 24 | 382 | 15936 | 15578 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 17896 | 664 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 5279240 | 5279240 | PRJNA1054617_S_NODE_2145_length_339_cov_1.952703_g2057_i0 | PRJNA1054617 | 2145 | 339 | 1.952703 | 6.61966317 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 627 | 4.1799999999999996e-175 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g2057 | i0 | 100 | 34.9174041297935 | 339 | 0 | 100 | 0 | 1 | 339 | 16011 | 16349 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 11837 | 627 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 6554446 | 6554446 | PRJNA1054617_S_NODE_6546_length_218_cov_1.577143_g6458_i0 | PRJNA1054617 | 6546 | 218 | 1.577143 | 3.43817174 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 4.62e-108 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g6458 | i0 | 100 | 103.362385321101 | 218 | 0 | 100 | 0 | 1 | 218 | 972 | 755 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 22533 | 403 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7388954 | 7388954 | PRJNA1054617_S_NODE_10306_length_181_cov_1.666667_g10218_i0 | PRJNA1054617 | 10306 | 181 | 1.666667 | 3.01666727 | Halophytophthora | 127445 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 6.759999999999998e-41 | NTclustered | gi|2213903054|gb|OK091209.1| | 2874299 | g10218 | i0 | 84.831 | 61.6906077348066 | 178 | 27 | 98 | 0 | 1 | 178 | 1085 | 1262 | Halophytophthora sp. MHJ-2021b isolate CBS 147241 from Portugal cytochrome oxidase subunit I (coxI) gene, partial cds; mitochondrial | blastn | 11166 | 180 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Halophytophthora | Halophytophthora celeris | ||
| 9104133 | 9104133 | PRJNA1054617_S_NODE_4848_length_246_cov_0.906404_g4760_i0 | PRJNA1054617 | 4848 | 246 | 0.906404 | 2.22975384 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.4500000000000002e-123 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g4760 | i0 | 100 | 4.92276422764228 | 246 | 0 | 100 | 0 | 1 | 246 | 80554 | 80799 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 1211 | 455 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 15479298 | 15479298 | PRJNA1054617_S_NODE_11333_length_174_cov_1.404580_g11245_i0 | PRJNA1054617 | 11333 | 174 | 1.40458 | 2.4439692 | Babesia microti | 5868 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 4.01e-13 | NTclustered | gi|1206245954|ref|XR_002459985.1| | 1133968 | g11245 | i0 | 84.444 | 1.7183908045977 | 90 | 13 | 51 | 1 | 86 | 174 | 3088 | 3177 | Babesia microti strain RI 28S ribosomal RNA rRNA | blastn | 299 | 87.9 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia microti | ||
| 18028310 | 18028310 | PRJNA1054617_S_NODE_13955_length_159_cov_1.982759_g13867_i0 | PRJNA1054617 | 13955 | 159 | 1.982759 | 3.15258681 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.98e-75 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g13867 | i0 | 100 | 1 | 159 | 0 | 100 | 0 | 1 | 159 | 132819 | 132977 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 159 | 294 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 18862785 | 18862785 | PRJNA1054617_S_NODE_13975_length_159_cov_1.793103_g13887_i0 | PRJNA1054617 | 13975 | 159 | 1.793103 | 2.85103377 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.98e-75 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g13887 | i0 | 100 | 99.9056603773585 | 159 | 0 | 100 | 0 | 1 | 159 | 1102 | 944 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 15885 | 294 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 20577575 | 20577575 | PRJNA1054617_S_NODE_15157_length_154_cov_1.657658_g15069_i0 | PRJNA1054617 | 15157 | 154 | 1.657658 | 2.55279332 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 1.19e-47 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g15069 | i0 | 90.26 | 37.6883116883117 | 154 | 15 | 100 | 0 | 1 | 154 | 1908 | 2061 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 5804 | 202 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 23963700 | 23963700 | PRJNA1054617_S_NODE_2739_length_308_cov_3.860377_g2651_i0 | PRJNA1054617 | 2739 | 308 | 3.860377 | 11.88996116 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.008 | NTclustered | gi|299830252|ref|NC_014262.1| | 5885 | g2651 | i0 | 92.105 | 0.493506493506494 | 38 | 3 | 12 | 0 | 1 | 38 | 1453 | 1490 | Paramecium caudatum mitochondrion, complete genome | blastn | 152 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 24402475 | 24402475 | PRJNA1054617_S_NODE_1860_length_356_cov_1.757188_g1772_i0 | PRJNA1054617 | 1860 | 356 | 1.757188 | 6.25558928 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 486 | 7.79e-133 | NTclustered | gi|1389870282|gb|MH356267.1| | 1654720 | g1772 | i0 | 92.69 | 18.4691011235955 | 342 | 17 | 95 | 8 | 1 | 337 | 344 | 682 | Chilodonella piscicola strain SC small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 6575 | 486 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;