contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21422 | 21422 | PRJEB14803_P_NODE_18001_length_277_cov_5.793388_g17535_i0 | PRJEB14803 | 18001 | 277 | 5.793388 | 16.04768476 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.78e-73 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g17535 | i0 | 85.614 | 46.1480144404332 | 285 | 29 | 100 | 7 | 1 | 277 | 1881 | 1601 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 12783 | 289 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 2571311 | 2571311 | PRJEB14803_P_NODE_26643_length_213_cov_42.191011_g26177_i0 | PRJEB14803 | 26643 | 213 | 42.191011 | 89.86685343 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 2.72e-100 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g26177 | i0 | 98.592 | 97.6244131455399 | 213 | 3 | 100 | 0 | 1 | 213 | 1549 | 1761 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 20794 | 377 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 3847617 | 3847617 | PRJEB14803_P_NODE_23944_length_229_cov_2.969072_g23478_i0 | PRJEB14803 | 23944 | 229 | 2.969072 | 6.79917488 | Sandona mutans | 563755 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 3.76e-114 | NTclustered | gi|224996445|gb|FJ654277.1| | 563755 | g23478 | i0 | 100 | 99.9825327510917 | 229 | 0 | 100 | 0 | 1 | 229 | 441 | 669 | Cercozoa sp. ATCC50314p145at3 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 22896 | 424 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Sandonidae | Sandona | Sandona mutans | |||
| 5123853 | 5123853 | PRJEB14803_P_NODE_27845_length_207_cov_3.488372_g27379_i0 | PRJEB14803 | 27845 | 207 | 3.488372 | 7.22093004 | Cercozoa sp. CC-2009d | 629762 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 1.08e-4 | NTclustered | gi|290760487|gb|GQ144690.1| | 629762 | g27379 | i0 | 90.909 | 3.57487922705314 | 44 | 4 | 21 | 0 | 1 | 44 | 2310 | 2267 | Cercozoa sp. CC-2009d large subunit ribosomal RNA gene, partial sequence | blastn | 740 | 60.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. CC-2009d | ||||||
| 6399525 | 6399525 | PRJEB14803_P_NODE_16986_length_288_cov_2.893281_g16520_i0 | PRJEB14803 | 16986 | 288 | 2.893281 | 8.33264928 | Thaumatomonas sp. DDM-2005 | 310812 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 8.56e-82 | NTclustered | gi|58414952|gb|AY748811.1| | 310812 | g16520 | i0 | 86.458 | 132.520833333333 | 288 | 39 | 100 | 0 | 1 | 288 | 17 | 304 | Thaumatomonas sp. DDM-2005 polyubiquitin (UBQ) gene, partial cds | blastn | 38166 | 316 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomonas | Thaumatomonas sp. DDM-2005 | ||
| 7673728 | 7673728 | PRJEB14803_P_NODE_37847_length_171_cov_1.470588_g37381_i0 | PRJEB14803 | 37847 | 171 | 1.470588 | 2.51470548 | Mesofila sp. ATCC PRA-54 | 439948 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 2.31e-25 | NTclustered | gi|160337346|gb|EF455768.1| | 439948 | g37381 | i0 | 83.824 | 26.1461988304094 | 136 | 20 | 79 | 2 | 34 | 168 | 794 | 928 | Dimorpha sp. ATCC PRA-54 alpha-tubulin (atub) gene, partial cds | blastn | 4471 | 128 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila sp. ATCC PRA-54 | ||||
| 11499372 | 11499372 | PRJEB14803_P_NODE_11830_length_365_cov_9.657576_g11365_i0 | PRJEB14803 | 11830 | 365 | 9.657576 | 35.2501524 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 2.959999999999999e-112 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11365 | i0 | 88.022 | 57.627397260274 | 359 | 36 | 98 | 6 | 9 | 365 | 4022 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 21034 | 418 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 15323756 | 15323756 | PRJEB14803_P_NODE_8493_length_452_cov_2.153477_g8032_i0 | PRJEB14803 | 8493 | 452 | 2.153477 | 9.73371604 | Euglypha rotunda | 39714 | SAR_Eukaryotes | SAR_Eukaryotes | 475 | 2.1899999999999994e-129 | NTclustered | gi|145558660|gb|EF517356.1| | 39714 | g8032 | i0 | 85.619 | 99.6703539823009 | 452 | 65 | 100 | 0 | 1 | 452 | 322 | 773 | Euglypha rotunda strain CCAP 1520/1 actin gene, partial cds | blastn | 45051 | 475 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Euglyphidae | Euglypha | Euglypha rotunda | ||
| 16598288 | 16598288 | PRJEB14803_P_NODE_28694_length_203_cov_3.589286_g28228_i0 | PRJEB14803 | 28694 | 203 | 3.589286 | 7.28625058 | Glissomonad sp. Panama103 | 563749 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.319999999999999e-99 | NTclustered | gi|219524909|gb|EU709272.1| | 563749 | g28228 | i0 | 100 | 97.5812807881773 | 202 | 0 | 99 | 0 | 1 | 202 | 259 | 58 | Glissomonad sp. Panama103 18S ribosomal RNA gene, partial sequence | blastn | 19809 | 374 | 1 | Eukaryota | Sar | Cercozoa | Glissomonad sp. Panama103 | ||||||
| 17873137 | 17873137 | PRJEB14803_P_NODE_42515_length_159_cov_3.483871_g42049_i0 | PRJEB14803 | 42515 | 159 | 3.483871 | 5.53935489 | Thaumatomastix sp. CC002-Boundary Bay | 741090 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.67e-44 | NTclustered | gi|290760490|gb|GQ144693.1| | 741090 | g42049 | i0 | 90.909 | 79.3018867924528 | 143 | 11 | 90 | 2 | 3 | 145 | 1826 | 1686 | Thaumatomastix sp. CC002-Boundary Bay large subunit ribosomal RNA gene, partial sequence | blastn | 12609 | 191 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. CC002-Boundary Bay | ||
| 20422100 | 20422100 | PRJEB14803_P_NODE_18417_length_273_cov_2.134454_g17951_i0 | PRJEB14803 | 18417 | 273 | 2.134454 | 5.82705942 | Paracercomonas sp. | 1979800 | SAR_Eukaryotes | SAR_Eukaryotes | 340 | 4.7799999999999996e-89 | NTclustered | gi|1326162414|gb|MG775634.1| | 1979800 | g17951 | i0 | 90 | 95.0879120879121 | 270 | 17 | 97 | 8 | 1 | 265 | 624 | 888 | Paracercomonas sp. strain SF61_P_Poa small subunit ribosomal RNA gene, partial sequence | blastn | 25959 | 340 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas sp. | |||
| 21698030 | 21698030 | PRJEB14803_P_NODE_11498_length_372_cov_5.094955_g11033_i0 | PRJEB14803 | 11498 | 372 | 5.094955 | 18.9532326 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.8499999999999997e-99 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g11033 | i0 | 86.066 | 61.0188172043011 | 366 | 31 | 97 | 11 | 11 | 372 | 4018 | 3669 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 22699 | 375 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis |
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);;