contig_metadata
12 rows where bioproject = "PRJNA795663", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 779305 | 779305 | PRJNA795663_S_NODE_1481_length_455_cov_24.918660_g1376_i0 | PRJNA795663 | 1481 | 455 | 24.91866 | 113.379903 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 752 | 0 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g1376 | i0 | 96.696 | 99.9626373626374 | 454 | 12 | 99 | 3 | 1 | 452 | 1951 | 1499 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 45483 | 752 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 4607613 | 4607613 | PRJNA795663_S_NODE_10164_length_191_cov_49.012987_g10059_i0 | PRJNA795663 | 10164 | 191 | 49.012987 | 93.61480517 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 2.44e-85 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g10059 | i0 | 98.907 | 96.261780104712 | 183 | 2 | 96 | 0 | 9 | 191 | 1275 | 1457 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 18386 | 327 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 5882887 | 5882887 | PRJNA795663_S_NODE_15085_length_163_cov_15.365079_g14980_i0 | PRJNA795663 | 15085 | 163 | 15.365079 | 25.04507877 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 296 | 5.68e-76 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g14980 | i0 | 99.387 | 100.478527607362 | 163 | 1 | 100 | 0 | 1 | 163 | 1532 | 1370 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 16378 | 296 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 9707772 | 9707772 | PRJNA795663_S_NODE_8788_length_203_cov_7.524096_g8683_i0 | PRJNA795663 | 8788 | 203 | 7.524096 | 15.27391488 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 9.44e-85 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g8683 | i0 | 98.378 | 91.1625615763547 | 185 | 3 | 91 | 0 | 1 | 185 | 1393 | 1209 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 18506 | 326 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 10144797 | 10144797 | PRJNA795663_S_NODE_12328_length_177_cov_13.278571_g12223_i0 | PRJNA795663 | 12328 | 177 | 13.278571 | 23.50307067 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.87e-84 | NTclustered | gi|1695780|gb|U42448.1|CAU42448 | 45110 | g12223 | i0 | 99.435 | 98.4519774011299 | 177 | 1 | 100 | 0 | 1 | 177 | 606 | 782 | Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence | blastn | 17426 | 327 | 0.990825688073395 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 11420304 | 11420304 | PRJNA795663_S_NODE_7709_length_215_cov_3.022472_g7604_i0 | PRJNA795663 | 7709 | 215 | 3.022472 | 6.4983148 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.7699999999999993e-95 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g7604 | i0 | 100 | 91.3209302325581 | 195 | 0 | 91 | 0 | 21 | 215 | 1021 | 1215 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 19634 | 361 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 13532907 | 13532907 | PRJNA795663_S_NODE_1211_length_494_cov_161.916849_g1109_i0 | PRJNA795663 | 1211 | 494 | 161.916849 | 799.86923406 | Cercomonas sp. HFCC540 | 458868 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 8.809999999999997e-119 | NTclustered | gi|161015708|gb|EF681942.1| | 458868 | g1109 | i0 | 84.479 | 36.4251012145749 | 451 | 65 | 91 | 5 | 26 | 474 | 686 | 239 | Cercomonas sp. HFCC540 28S ribosomal RNA gene, partial sequence | blastn | 17994 | 440 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC540 | |||
| 16081914 | 16081914 | PRJNA795663_S_NODE_2573_length_353_cov_14.348101_g2468_i0 | PRJNA795663 | 2573 | 353 | 14.348101 | 50.64879653 | Paracercomonas crassicauda | 466266 | SAR_Eukaryotes | SAR_Eukaryotes | 652 | 0 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g2468 | i0 | 100 | 98.3512747875354 | 353 | 0 | 100 | 0 | 1 | 353 | 384 | 32 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 34718 | 652 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 22456725 | 22456725 | PRJNA795663_S_NODE_9438_length_197_cov_4.518750_g9333_i0 | PRJNA795663 | 9438 | 197 | 4.51875 | 8.9019375 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 9.17e-80 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g9333 | i0 | 94.949 | 170.091370558376 | 198 | 9 | 100 | 1 | 1 | 197 | 2506 | 2703 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 33508 | 309 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 22894015 | 22894015 | PRJNA795663_S_NODE_4338_length_279_cov_29.479339_g4233_i0 | PRJNA795663 | 4338 | 279 | 29.479339 | 82.24735581 | Paracercomonas | 372085 | SAR_Eukaryotes | SAR_Eukaryotes | 468 | 2.15e-127 | NTclustered | gi|262262832|gb|FJ790725.1| | 466266 | g4233 | i0 | 99.609 | 91.7956989247312 | 256 | 1 | 92 | 0 | 24 | 279 | 752 | 1007 | Paracercomonas crassicauda strain ATCC 50316 18S ribosomal RNA gene, partial sequence | blastn | 25611 | 468 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas crassicauda | |||
| 23732118 | 23732118 | PRJNA795663_S_NODE_13039_length_173_cov_4.823529_g12934_i0 | PRJNA795663 | 13039 | 173 | 4.823529 | 8.34470517 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 3.61e-83 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g12934 | i0 | 100 | 100.768786127168 | 173 | 0 | 100 | 0 | 1 | 173 | 2725 | 2897 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 17433 | 320 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 25005859 | 25005859 | PRJNA795663_S_NODE_4020_length_288_cov_32.661355_g3915_i0 | PRJNA795663 | 4020 | 288 | 32.661355 | 94.0647024 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 375 | 1.3899999999999998e-99 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g3915 | i0 | 92.135 | 55.2326388888889 | 267 | 19 | 92 | 2 | 24 | 288 | 1953 | 2219 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 15907 | 375 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina |
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);;