contig_metadata
10 rows where bioproject = "PRJNA859990" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 845950 | 845950 | PRJNA859990_S_NODE_6561_length_387_cov_1.203822_g6300_i0 | PRJNA859990 | 6561 | 387 | 1.203822 | 4.65879114 | Isotricha sp. | 1917196 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 4.97e-155 | NTclustered | gi|2643596952|gb|PP067624.1| | 1917196 | g6300 | i0 | 98.131 | 150.868217054264 | 321 | 6 | 83 | 0 | 1 | 321 | 3418 | 3738 | Isotricha sp. isolate 03.MDA04 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 58386 | 560 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha sp. | ||
| 5949290 | 5949290 | PRJNA859990_S_NODE_5465_length_419_cov_1.355491_g5204_i0 | PRJNA859990 | 5465 | 419 | 1.355491 | 5.67950729 | Polyplastron multivesiculatum | 47894 | SAR_Eukaryotes | SAR_Eukaryotes | 741 | 0 | NTclustered | gi|2643596968|gb|PP067640.1| | 47894 | g5204 | i0 | 98.568 | 96.7350835322196 | 419 | 6 | 100 | 0 | 1 | 419 | 2040 | 2458 | Polyplastron multivesiculatum isolate 03.MDA01 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 40532 | 741 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Polyplastron | Polyplastron multivesiculatum | ||
| 7224054 | 7224054 | PRJNA859990_S_NODE_16386_length_259_cov_2.118280_g16125_i0 | PRJNA859990 | 16386 | 259 | 2.11828 | 5.4863452 | Isotricha prostoma | 5987 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 4.309999999999998e-119 | NTclustered | gi|2643596954|gb|PP067626.1| | 5987 | g16125 | i0 | 97.665 | 92.2857142857143 | 257 | 4 | 99 | 2 | 4 | 259 | 2439 | 2184 | Isotricha prostoma isolate 03.MDA03 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 23902 | 440 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha prostoma | ||
| 11439874 | 11439874 | PRJNA859990_S_NODE_18529_length_249_cov_1.170455_g18268_i0 | PRJNA859990 | 18529 | 249 | 1.170455 | 2.91443295 | Entodinium | 40635 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 3.2e-115 | NTclustered | gi|1102610265|gb|KY111856.1| | 40636 | g18268 | i0 | 97.59 | 99.9919678714859 | 249 | 6 | 100 | 0 | 1 | 249 | 57 | 305 | Entodinium sp. isolate B2 small subunit ribosomal RNA gene, partial sequence | blastn | 24898 | 427 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium sp. | ||
| 13599571 | 13599571 | PRJNA859990_S_NODE_17791_length_251_cov_1.286517_g17530_i0 | PRJNA859990 | 17791 | 251 | 1.286517 | 3.22915767 | Polyplastron multivesiculatum | 47894 | SAR_Eukaryotes | SAR_Eukaryotes | 442 | 1.1599999999999995e-119 | NTclustered | gi|2643596968|gb|PP067640.1| | 47894 | g17530 | i0 | 99.184 | 71.8286852589641 | 245 | 2 | 98 | 0 | 1 | 245 | 3879 | 4123 | Polyplastron multivesiculatum isolate 03.MDA01 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 18029 | 442 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Polyplastron | Polyplastron multivesiculatum | ||
| 14874007 | 14874007 | PRJNA859990_S_NODE_8972_length_336_cov_2.456274_g8711_i0 | PRJNA859990 | 8972 | 336 | 2.456274 | 8.25308064 | Diplophrys mutabilis | 1407010 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 7.700000000000001e-98 | NTclustered | gi|550533550|dbj|AB856527.1| | 1407010 | g8711 | i0 | 86.782 | 26.0625 | 348 | 26 | 98 | 14 | 7 | 336 | 1074 | 729 | Diplophrys mutabilis gene for 18S ribosomal RNA, partial sequence | blastn | 8757 | 370 | 1 | Eukaryota | Sar | Bigyra | Amphitremida | Diplophrys | Diplophrys mutabilis | ||||
| 19087503 | 19087503 | PRJNA859990_S_NODE_12575_length_291_cov_2.155963_g12314_i0 | PRJNA859990 | 12575 | 291 | 2.155963 | 6.27385233 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.8899999999999996e-73 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g12314 | i0 | 100 | 52.9415807560137 | 156 | 0 | 54 | 0 | 70 | 225 | 1599 | 1754 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 15406 | 289 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 21638142 | 21638142 | PRJNA859990_S_NODE_17777_length_251_cov_1.331461_g17516_i0 | PRJNA859990 | 17777 | 251 | 1.331461 | 3.34196711 | root | 1 | Root_unresolved | Root_unresolved | 363 | 9.249999999999997e-96 | NTclustered | gi|166044540|emb|CU367449.1| | 100861 | g17516 | i0 | 97.209 | 13.2868525896414 | 215 | 5 | 85 | 1 | 38 | 251 | 333 | 119 | Aphanomyces euteiches cDNA | blastn | 3335 | 363 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 25462711 | 25462711 | PRJNA859990_S_NODE_15080_length_269_cov_1.561224_g14819_i0 | PRJNA859990 | 15080 | 269 | 1.561224 | 4.19969256 | Entodinium | 40635 | SAR_Eukaryotes | SAR_Eukaryotes | 484 | 2.0499999999999994e-132 | NTclustered | gi|2643596937|gb|PP067609.1| | 47911 | g14819 | i0 | 99.254 | 99.631970260223 | 268 | 2 | 99 | 0 | 1 | 268 | 583 | 850 | Entodinium caudatum isolate SAG3_0_NT_6493 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence | blastn | 26801 | 484 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium caudatum | ||
| 29076342 | 29076342 | PRJNA859990_S_NODE_18288_length_250_cov_0.870056_g18027_i0 | PRJNA859990 | 18288 | 250 | 0.870056 | 2.17514 | Pelagomonas calceolata | 35677 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00403 | NR | CAH0373016.1 | 35677 | g18027 | i0 | 46.3 | 0.648 | 54 | 28 | 63.6 | 1 | 205 | 47 | 96 | 149 | CAH0373016.1 unnamed protein product [Pelagomonas calceolata] | diamond | 162 | 45.4 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Pelagomonas | Pelagomonas calceolata |
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);;