contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA812001" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9738447 | 9738447 | PRJNA812001_P_NODE_14228_length_427_cov_19.392655_g13982_i0 | PRJNA812001 | 14228 | 427 | 19.392655 | 82.80663685 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 8.900000000000001e-30 | NR | KAJ1429398.1 | 483371 | g13982 | i0 | 72.1 | 0.477751756440281 | 68 | 19 | 47.8 | 0 | 402 | 199 | 93 | 160 | KAJ1429398.1 Alpha/Beta hydrolase protein [Ochromonadaceae sp. CCMP2298] | diamond | 204 | 115 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 21212490 | 21212490 | PRJNA812001_P_NODE_14037_length_430_cov_1.478992_g13791_i0 | PRJNA812001 | 14037 | 430 | 1.478992 | 6.3596656 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 6.9e-25 | NR | CEO98920.1 | 37360 | g13791 | i0 | 57.6 | 1.18604651162791 | 85 | 36 | 59.3 | 0 | 15 | 269 | 156 | 240 | CEO98920.1 hypothetical protein PBRA_007034 [Plasmodiophora brassicae] | diamond | 510 | 105 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 24176201 | 24176201 | PRJNA812001_P_NODE_96819_length_248_cov_0.880000_g96573_i0 | PRJNA812001 | 96819 | 248 | 0.88 | 2.1824 | Paramecium | 5884 | SAR_Eukaryotes | SAR_Eukaryotes | 129 | 2.32e-33 | NR | ADU54561.1 | 5885 | g96573 | i0 | 76.8 | 1.98387096774194 | 82 | 19 | 99.2 | 0 | 246 | 1 | 252 | 333 | ADU54561.1 mitochondrial-type hsp70 1, partial [Paramecium caudatum] | diamond | 492 | 129 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium caudatum | ||
| 26642621 | 26642621 | PRJNA812001_P_NODE_103261_length_246_cov_2.260116_g103015_i0 | PRJNA812001 | 103261 | 246 | 2.260116 | 5.55988536 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.77e-4 | NR | YP_009118057.1 | 372086 | g103015 | i0 | 44.4 | 0.658536585365854 | 54 | 30 | 65.9 | 0 | 187 | 26 | 5 | 58 | YP_009118057.1 ribosomal protein S3 [Paracercomonas marina] | diamond | 162 | 49.3 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 26769410 | 26769410 | PRJNA812001_P_NODE_80101_length_251_cov_0.865169_g79855_i0 | PRJNA812001 | 80101 | 251 | 0.865169 | 2.17157419 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 4.05e-5 | NR | CAD8186117.1 | 43138 | g79855 | i0 | 39.5 | 3.87250996015936 | 81 | 46 | 96.8 | 1 | 6 | 248 | 62 | 139 | CAD8186117.1 unnamed protein product [Paramecium pentaurelia] | diamond | 972 | 51.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 27938806 | 27938806 | PRJNA812001_P_NODE_66645_length_266_cov_1.544041_g66399_i0 | PRJNA812001 | 66645 | 266 | 1.544041 | 4.10714906 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 99.8 | 4.41e-22 | NR | XP_001026696.2 | 312017 | g66399 | i0 | 58 | 0.913533834586466 | 81 | 33 | 91.4 | 1 | 254 | 12 | 141 | 220 | XP_001026696.2 squalene-tetrahymanol cyclase [Tetrahymena thermophila SB210] | diamond | 243 | 99.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28001986 | 28001986 | PRJNA812001_P_NODE_103085_length_247_cov_0.885057_g102839_i0 | PRJNA812001 | 103085 | 247 | 0.885057 | 2.18609079 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 2.52e-41 | NR | XP_013248133.1 | 5801 | g102839 | i0 | 89 | 1.9919028340081 | 82 | 9 | 99.6 | 0 | 1 | 246 | 685 | 766 | XP_013248133.1 hypothetical protein, conserved [Eimeria acervulina] | diamond | 492 | 154 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 29431226 | 29431226 | PRJNA812001_P_NODE_111089_length_245_cov_0.895349_g110843_i0 | PRJNA812001 | 111089 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 109 | 1.05e-25 | NR | TNV85376.1 | 5974 | g110843 | i0 | 72.3 | 18.3061224489796 | 65 | 18 | 79.6 | 0 | 244 | 50 | 440 | 504 | TNV85376.1 hypothetical protein FGO68_gene7213 [Halteria grandinella] | diamond | 4485 | 110 | 0.990909090909091 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 29453887 | 29453887 | PRJNA812001_P_NODE_93630_length_248_cov_1.211429_g93384_i0 | PRJNA812001 | 93630 | 248 | 1.211429 | 3.00434392 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 55.8 | 3.2e-7 | NR | CAG9315069.1 | 1481888 | g93384 | i0 | 34.2 | 0.955645161290323 | 79 | 52 | 95.6 | 0 | 2 | 238 | 12 | 90 | CAG9315069.1 unnamed protein product [Blepharisma stoltei] | diamond | 237 | 55.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 30054112 | 30054112 | PRJNA812001_P_NODE_95991_length_248_cov_0.880000_g95745_i0 | PRJNA812001 | 95991 | 248 | 0.88 | 2.1824 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 3.36e-24 | NR | CAD8169588.1 | 43137 | g95745 | i0 | 60.3 | 3.84677419354839 | 78 | 31 | 94.4 | 0 | 13 | 246 | 1358 | 1435 | CAD8169588.1 unnamed protein product [Paramecium octaurelia] | diamond | 954 | 105 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 30433783 | 30433783 | PRJNA812001_P_NODE_26833_length_347_cov_1.062044_g26587_i0 | PRJNA812001 | 26833 | 347 | 1.062044 | 3.68529268 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.98e-34 | NR | XP_004030147.1 | 5932 | g26587 | i0 | 51.3 | 0.976945244956772 | 113 | 55 | 97.7 | 0 | 339 | 1 | 61 | 173 | XP_004030147.1 hypothetical protein IMG5_167050 [Ichthyophthirius multifiliis] | diamond | 339 | 127 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 30528136 | 30528136 | PRJNA812001_P_NODE_131393_length_241_cov_0.916667_g131147_i0 | PRJNA812001 | 131393 | 241 | 0.916667 | 2.20916747 | Paramecium pentaurelia | 43138 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 1.32e-30 | NR | CAD8175259.1 | 43138 | g131147 | i0 | 69.6 | 1.92946058091286 | 79 | 24 | 98.3 | 0 | 239 | 3 | 376 | 454 | CAD8175259.1 unnamed protein product [Paramecium pentaurelia] | diamond | 465 | 123 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium pentaurelia | ||
| 30622837 | 30622837 | PRJNA812001_P_NODE_7273_length_574_cov_4.229541_g7028_i0 | PRJNA812001 | 7273 | 574 | 4.229541 | 24.27756534 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 1.15e-19 | NR | CAI2377036.1 | 5936 | g7028 | i0 | 73.1 | 0.350174216027875 | 67 | 18 | 35 | 0 | 201 | 1 | 1 | 67 | CAI2377036.1 unnamed protein product [Moneuplotes crassus] | diamond | 201 | 89 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 30686046 | 30686046 | PRJNA812001_P_NODE_16433_length_405_cov_2.750000_g16187_i0 | PRJNA812001 | 16433 | 405 | 2.75 | 11.1375 | Tetraparma gracilis | 2962635 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00978 | NR | GMI36873.1 | 2962635 | g16187 | i0 | 31.3 | 0.733333333333333 | 99 | 62 | 70.4 | 3 | 39 | 323 | 1097 | 1193 | GMI36873.1 hypothetical protein TeGR_g4213 [Tetraparma gracilis] | diamond | 297 | 46.6 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Tetraparma | Tetraparma gracilis | |||
| 30717672 | 30717672 | PRJNA812001_P_NODE_137294_length_223_cov_7.340000_g137048_i0 | PRJNA812001 | 137294 | 223 | 7.34 | 16.3682 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 1.02e-4 | NR | XP_013332868.1 | 5804 | g137048 | i0 | 57.5 | 1.0762331838565 | 40 | 17 | 53.8 | 0 | 1 | 120 | 420 | 459 | XP_013332868.1 enolase 2, putative [Eimeria maxima] | diamond | 240 | 49.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 31508152 | 31508152 | PRJNA812001_P_NODE_16796_length_402_cov_1.969605_g16550_i0 | PRJNA812001 | 16796 | 402 | 1.969605 | 7.9178121 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 3.76e-11 | NR | CEO98592.1 | 37360 | g16550 | i0 | 51.7 | 0.43283582089552203 | 58 | 28 | 43.3 | 0 | 1 | 174 | 162 | 219 | CEO98592.1 hypothetical protein PBRA_006706 [Plasmodiophora brassicae] | diamond | 174 | 68.9 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 31760987 | 31760987 | PRJNA812001_P_NODE_121617_length_243_cov_0.905882_g121371_i0 | PRJNA812001 | 121617 | 243 | 0.905882 | 2.20129326 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 149 | 8.83e-44 | NR | CAI2368921.1 | 5936 | g121371 | i0 | 97.5 | 0.987654320987654 | 80 | 2 | 98.8 | 0 | 2 | 241 | 45 | 124 | CAI2368921.1 unnamed protein product [Moneuplotes crassus] | diamond | 240 | 149 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32267442 | 32267442 | PRJNA812001_P_NODE_82298_length_251_cov_0.865169_g82052_i0 | PRJNA812001 | 82298 | 251 | 0.865169 | 2.17157419 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.66e-48 | NR | CAI2367898.1 | 5936 | g82052 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 249 | 1 | 166 | 248 | CAI2367898.1 unnamed protein product [Moneuplotes crassus] | diamond | 249 | 167 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32646176 | 32646176 | PRJNA812001_P_NODE_24800_length_354_cov_6.996441_g24554_i0 | PRJNA812001 | 24800 | 354 | 6.996441 | 24.76740114 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 67 | 4.26e-10 | NR | KAJ1434520.1 | 483371 | g24554 | i0 | 43.5 | 0.779661016949153 | 92 | 47 | 73.7 | 1 | 322 | 62 | 1363 | 1454 | KAJ1434520.1 hypothetical protein B484DRAFT_417407 [Ochromonadaceae sp. CCMP2298] | diamond | 276 | 67 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 |
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);;