contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA980839" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4786040 | 4786040 | PRJNA980839_P_NODE_169764_length_270_cov_2.553299_g165980_i0 | PRJNA980839 | 169764 | 270 | 2.553299 | 6.8939073 | Nolandia orientalis | 1607835 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.27e-114 | NTclustered | gi|759083538|gb|KM222155.1| | 1607835 | g165980 | i0 | 95.167 | 99.9925925925926 | 269 | 13 | 99 | 0 | 1 | 269 | 888 | 620 | Nolandia orientalis voucher PXM2010102401 large subunit ribosomal RNA gene, partial sequence | blastn | 26998 | 425 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Nolandia | Nolandia orientalis | ||
| 6063530 | 6063530 | PRJNA980839_P_NODE_75545_length_439_cov_4.270492_g71761_i0 | PRJNA980839 | 75545 | 439 | 4.270492 | 18.74745988 | Alphamonas edax | 2605704 | SAR_Eukaryotes | SAR_Eukaryotes | 806 | 0 | NTclustered | gi|36140553|gb|AY234843.1| | 2605704 | g71761 | i0 | 99.773 | 100.041002277904 | 440 | 0 | 100 | 1 | 1 | 439 | 988 | 549 | Colpodella edax 18S ribosomal RNA gene, partial sequence | blastn | 43918 | 806 | 1 | Eukaryota | Sar | Alphamonaceae | Alphamonas | Alphamonas edax | |||||
| 7336409 | 7336409 | PRJNA980839_P_NODE_210026_length_248_cov_0.880000_g206242_i0 | PRJNA980839 | 210026 | 248 | 0.88 | 2.1824 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 3.4e-70 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g206242 | i0 | 89.593 | 69.2016129032258 | 221 | 19 | 88 | 4 | 30 | 248 | 3901 | 3683 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 17162 | 278 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 7338310 | 7338310 | PRJNA980839_P_NODE_88246_length_393_cov_2.403125_g84462_i0 | PRJNA980839 | 88246 | 393 | 2.403125 | 9.44428125 | Alphamonas edax | 2605704 | SAR_Eukaryotes | SAR_Eukaryotes | 713 | 0 | NTclustered | gi|972268871|gb|KU159288.1| | 2605704 | g84462 | i0 | 99.488 | 100.81679389313 | 391 | 2 | 99 | 0 | 1 | 391 | 2178 | 1788 | Colpodella edax 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 39621 | 713 | 1 | Eukaryota | Sar | Alphamonaceae | Alphamonas | Alphamonas edax | |||||
| 8612733 | 8612733 | PRJNA980839_P_NODE_53707_length_571_cov_4.242972_g49952_i0 | PRJNA980839 | 53707 | 571 | 4.242972 | 24.22737012 | Phytocercomonas venanatans | 2065209 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 1.51e-27 | NTclustered | gi|1315527750|gb|MF034900.1| | 2065209 | g49952 | i0 | 84.028 | 23.4973730297723 | 144 | 22 | 25 | 1 | 97 | 239 | 9346 | 9489 | Phytocercomonas venanatans 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 13417 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Phytocercomonas | Phytocercomonas venanatans | |||
| 8613264 | 8613264 | PRJNA980839_P_NODE_80767_length_418_cov_3.478261_g76983_i0 | PRJNA980839 | 80767 | 418 | 3.478261 | 14.53913098 | Schizochytrium sp. ATCC 20888 | 368446 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 1.2499999999999995e-106 | NTclustered | gi|85822988|gb|DQ356660.1| | 368446 | g76983 | i0 | 85.233 | 96.9832535885167 | 386 | 57 | 92 | 0 | 20 | 405 | 983 | 598 | Schizochytrium sp. ATCC 20888 actin gene, partial cds | blastn | 40539 | 399 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Schizochytrium | Schizochytrium sp. ATCC 20888 | |||
| 8923140 | 8923140 | PRJNA980839_P_NODE_216487_length_246_cov_1.364162_g212703_i0 | PRJNA980839 | 216487 | 246 | 1.364162 | 3.35583852 | Thalassiosiraceae | 29202 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.14e-120 | NTclustered | gi|2632235341|gb|OR922723.1| | 35128 | g212703 | i0 | 99.187 | 100.00406504065 | 246 | 2 | 100 | 0 | 1 | 246 | 3591 | 3836 | Thalassiosira pseudonana strain AGSB0188 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24601 | 444 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Thalassiosirales | Thalassiosiraceae | Thalassiosira | Thalassiosira pseudonana | ||
| 12437372 | 12437372 | PRJNA980839_P_NODE_188810_length_256_cov_2.349727_g185026_i0 | PRJNA980839 | 188810 | 256 | 2.349727 | 6.01530112 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.51e-128 | NTclustered | gi|325194423|emb|FR825253.1| | 890382 | g185026 | i0 | 100 | 99.61328125 | 255 | 0 | 99 | 0 | 2 | 256 | 901 | 647 | Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 | blastn | 25501 | 472 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 14984612 | 14984612 | PRJNA980839_P_NODE_116392_length_330_cov_2.202335_g112608_i0 | PRJNA980839 | 116392 | 330 | 2.202335 | 7.2677055 | Nitzschia palea | 303400 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 9.98e-82 | NTclustered | gi|586947715|gb|KF913343.1| | 303400 | g112608 | i0 | 85.535 | 4.83939393939394 | 318 | 29 | 96 | 9 | 15 | 330 | 739 | 437 | Nitzschia palea strain M2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1597 | 316 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia palea | ||
| 17537673 | 17537673 | PRJNA980839_P_NODE_49494_length_611_cov_3.661710_g45759_i0 | PRJNA980839 | 49494 | 611 | 3.66171 | 22.3730481 | Coleps hirtus | 60000 | SAR_Eukaryotes | SAR_Eukaryotes | 1066 | 0 | NTclustered | gi|328684911|gb|HM122027.1| | 394492 | g45759 | i0 | 98.2 | 65.9230769230769 | 611 | 9 | 100 | 1 | 1 | 611 | 623 | 15 | Coleps hirtus hirtus isolate SNK09101903 macronuclear | blastn | 40279 | 1066 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 18808284 | 18808284 | PRJNA980839_P_NODE_101755_length_358_cov_2.164912_g97971_i0 | PRJNA980839 | 101755 | 358 | 2.164912 | 7.75038496 | Alphamonas edax | 2605704 | SAR_Eukaryotes | SAR_Eukaryotes | 640 | 5.689999999999999e-179 | NTclustered | gi|972268871|gb|KU159288.1| | 2605704 | g97971 | i0 | 98.883 | 35.2905027932961 | 358 | 4 | 100 | 0 | 1 | 358 | 981 | 624 | Colpodella edax 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 12634 | 640 | 1 | Eukaryota | Sar | Alphamonaceae | Alphamonas | Alphamonas edax | |||||
| 21672111 | 21672111 | PRJNA980839_P_NODE_119597_length_325_cov_1.833333_g115813_i0 | PRJNA980839 | 119597 | 325 | 1.833333 | 5.95833225 | Coleps | 6003 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.4199999999999993e-167 | NTclustered | gi|1825575437|gb|MT253687.1| | 60000 | g115813 | i0 | 100 | 99.4953846153846 | 325 | 0 | 100 | 0 | 1 | 325 | 28 | 352 | Coleps hirtus strain CCAP 1613/14 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 32336 | 601 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 23912444 | 23912444 | PRJNA980839_P_NODE_55159_length_559_cov_1.742798_g51401_i0 | PRJNA980839 | 55159 | 559 | 1.742798 | 9.74224082 | Eimeria stiedai | 471275 | SAR_Eukaryotes | SAR_Eukaryotes | 553 | 1.2399999999999996e-152 | NTclustered | gi|511997|emb|Z33907.1| | 471275 | g51401 | i0 | 98.718 | 5.98747763864043 | 312 | 2 | 56 | 2 | 1 | 311 | 311 | 1 | E.stiedae (U82/129) DNA sequence (1173bp) | blastn | 3347 | 553 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria stiedai | ||
| 24221551 | 24221551 | PRJNA980839_P_NODE_147199_length_289_cov_3.185185_g143415_i0 | PRJNA980839 | 147199 | 289 | 3.185185 | 9.20518465 | root | 1 | Root_unresolved | Root_unresolved | 488 | 1.7199999999999998e-133 | NTclustered | gi|613433395|gb|KJ410683.1| | 145522 | g143415 | i0 | 97.232 | 177.771626297578 | 289 | 7 | 100 | 1 | 1 | 289 | 64942 | 65229 | Nannochloropsis oceanica strain LAMB0001 chloroplast, partial genome | blastn | 51376 | 490 | 0.995918367346939 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Monodopsidaceae | Nannochloropsis | Nannochloropsis oceanica | |||
| 25183763 | 25183763 | PRJNA980839_P_NODE_158520_length_280_cov_1.077295_g154736_i0 | PRJNA980839 | 158520 | 280 | 1.077295 | 3.016426 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2643439136|emb|OX456574.1| | 1481888 | g154736 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 142 | 169 | 16674 | 16701 | Blepharisma stoltei strain ATCC30299 genome assembly, organelle: mitochondrion | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei |
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);;