contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA694770" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 674548 | 674548 | PRJNA694770_P_NODE_46181_length_308_cov_0.982979_g45887_i0 | PRJNA694770 | 46181 | 308 | 0.982979 | 3.02757532 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 536 | 6.51e-148 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g45887 | i0 | 98.052 | 100.545454545455 | 308 | 6 | 100 | 0 | 1 | 308 | 1669 | 1362 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 30968 | 536 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 1181455 | 1181455 | PRJNA694770_P_NODE_94401_length_243_cov_6.217647_g94107_i0 | PRJNA694770 | 94401 | 243 | 6.217647 | 15.10888221 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4399999999999996e-118 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g94107 | i0 | 99.177 | 100.333333333333 | 243 | 2 | 100 | 0 | 1 | 243 | 2897 | 2655 | Colpoda sp. isolate JGP15 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 | 24381 | 438 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 2455376 | 2455376 | PRJNA694770_P_NODE_2302_length_1316_cov_2.432824_g2115_i0 | PRJNA694770 | 2302 | 1316 | 2.432824 | 32.01596384 | Pseudocohnilembidae | 35102 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g2115 | i0 | 80.224 | 60.1534954407295 | 1072 | 156 | 80 | 36 | 249 | 1307 | 5371 | 6399 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 79162 | 754 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 3225355 | 3225355 | PRJNA694770_P_NODE_3863_length_1009_cov_3.127137_g3625_i0 | PRJNA694770 | 3863 | 1009 | 3.127137 | 31.55281233 | Tetrahymena paravorax | 5905 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 9.27e-72 | NTclustered | gi|114329857|ref|NC_008338.1| | 5905 | g3625 | i0 | 75.389 | 5.93062438057483 | 707 | 113 | 69 | 45 | 1 | 695 | 3295 | 2638 | Tetrahymena paravorax mitochondrion, complete genome | blastn | 5984 | 285 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena paravorax | ||
| 5779367 | 5779367 | PRJNA694770_P_NODE_92985_length_244_cov_0.900585_g92691_i0 | PRJNA694770 | 92985 | 244 | 0.900585 | 2.1974274 | Plasmodium brasilianum | 5824 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.73e-4 | NTclustered | gi|2785766342|ref|XM_067218290.1| | 5824 | g92691 | i0 | 94.595 | 0.278688524590164 | 37 | 2 | 15 | 0 | 137 | 173 | 3037 | 3073 | Plasmodium brasilianum uncharacterized protein (MKS88_005062), partial mRNA | blastn | 68 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium brasilianum | ||
| 6284959 | 6284959 | PRJNA694770_P_NODE_6625_length_746_cov_4.741456_g6345_i0 | PRJNA694770 | 6625 | 746 | 4.741456 | 35.37126176 | Colpodidae | 5978 | SAR_Eukaryotes | SAR_Eukaryotes | 1155 | 0 | NTclustered | gi|2166921685|gb|OL894853.1| | 63136 | g6345 | i0 | 96.317 | 75.1809651474531 | 706 | 20 | 94 | 5 | 43 | 746 | 1021 | 320 | Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 56085 | 1155 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 7558073 | 7558073 | PRJNA694770_P_NODE_26506_length_380_cov_1.293160_g26212_i0 | PRJNA694770 | 26506 | 380 | 1.29316 | 4.914008 | root | 1 | Root_unresolved | Root_unresolved | 686 | 0 | NTclustered | gi|166044642|emb|CU367551.1| | 100861 | g26212 | i0 | 99.211 | 100.097368421053 | 380 | 3 | 100 | 0 | 1 | 380 | 317 | 696 | Aphanomyces euteiches cDNA | blastn | 38037 | 691 | 0.992764109985528 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 15978496 | 15978496 | PRJNA694770_P_NODE_89313_length_246_cov_0.890173_g89019_i0 | PRJNA694770 | 89313 | 246 | 0.890173 | 2.18982558 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.15e-104 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g89019 | i0 | 95.528 | 1.49186991869919 | 246 | 10 | 100 | 1 | 1 | 246 | 1289 | 1045 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 367 | 392 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 20306980 | 20306980 | PRJNA694770_P_NODE_44036_length_314_cov_1.278008_g43742_i0 | PRJNA694770 | 44036 | 314 | 1.278008 | 4.01294512 | root | 1 | Root_unresolved | Root_unresolved | 508 | 1.45e-139 | NTclustered | gi|166044588|emb|CU367497.1| | 100861 | g43742 | i0 | 95.86 | 73.5700636942675 | 314 | 13 | 100 | 0 | 1 | 314 | 32 | 345 | Aphanomyces euteiches cDNA | blastn | 23101 | 508 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 21076128 | 21076128 | PRJNA694770_P_NODE_13197_length_514_cov_2.056689_g12903_i0 | PRJNA694770 | 13197 | 514 | 2.056689 | 10.57138146 | Colpoda steini | 63136 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 7.159999999999998e-115 | NTclustered | gi|2166921685|gb|OL894853.1| | 63136 | g12903 | i0 | 98.361 | 30.4766536964981 | 244 | 2 | 47 | 2 | 1 | 244 | 245 | 4 | Colpoda steini clone MITTA small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 15665 | 427 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda steini | ||
| 21582933 | 21582933 | PRJNA694770_P_NODE_50917_length_294_cov_2.248869_g50623_i0 | PRJNA694770 | 50917 | 294 | 2.248869 | 6.61167486 | root | 1 | Root_unresolved | Root_unresolved | 544 | 3.69e-150 | NTclustered | gi|166046790|emb|CU367365.1| | 100861 | g50623 | i0 | 100 | 14.9795918367347 | 294 | 0 | 100 | 0 | 1 | 294 | 798 | 505 | Aphanomyces euteiches cDNA | blastn | 4404 | 544 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 22858277 | 22858277 | PRJNA694770_P_NODE_60618_length_279_cov_1.092233_g60324_i0 | PRJNA694770 | 60618 | 279 | 1.092233 | 3.04733007 | root | 1 | Root_unresolved | Root_unresolved | 468 | 2.15e-127 | NTclustered | gi|166044639|emb|CU367548.1| | 100861 | g60324 | i0 | 97.445 | 69.8530465949821 | 274 | 7 | 98 | 0 | 1 | 274 | 391 | 118 | Aphanomyces euteiches cDNA | blastn | 19489 | 468 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches |
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);;