contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA743294" and tax_clade = "Apusozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8375258 | 8375258 | PRJNA743294_P_NODE_1907_length_1041_cov_5.605372_g1634_i0 | PRJNA743294 | 1907 | 1041 | 5.605372 | 58.35192252 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 405 | 7.04e-108 | NTclustered | gi|923134252|ref|XM_013905138.1| | 461836 | g1634 | i0 | 76.492 | 16.4197886647454 | 821 | 147 | 77 | 32 | 152 | 949 | 997 | 200 | Thecamonas trahens ATCC 50062 adenine nucleotide translocator (AMSG_02751), mRNA | blastn | 17093 | 405 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 8375312 | 8375312 | PRJNA743294_P_NODE_26447_length_321_cov_1.798387_g25991_i0 | PRJNA743294 | 26447 | 321 | 1.798387 | 5.77282227 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 174 | 6.16e-39 | NTclustered | gi|923131752|ref|XM_013903888.1| | 461836 | g25991 | i0 | 81.776 | 17.9563862928349 | 214 | 33 | 66 | 4 | 82 | 292 | 517 | 307 | Thecamonas trahens ATCC 50062 60S ribosomal protein (AMSG_04094), mRNA | blastn | 5764 | 174 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 9650491 | 9650491 | PRJNA743294_P_NODE_328_length_1916_cov_5.810635_g250_i0 | PRJNA743294 | 328 | 1916 | 5.810635 | 111.3317666 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 872 | 0 | NTclustered | gi|923137248|ref|XM_013906635.1| | 461836 | g250 | i0 | 78.333 | 52.4926931106472 | 1380 | 278 | 72 | 19 | 400 | 1770 | 1877 | 510 | Thecamonas trahens ATCC 50062 inositol-3-phosphate synthase (AMSG_00912), mRNA | blastn | 100576 | 872 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 13475968 | 13475968 | PRJNA743294_P_NODE_42791_length_261_cov_1.872340_g42335_i0 | PRJNA743294 | 42791 | 261 | 1.87234 | 4.8868074 | Thecamonas trahens | 529818 | Root_unresolved | Root_unresolved | 67.6 | 8.5e-7 | NTclustered | gi|923122628|ref|XM_013899330.1| | 461836 | g42335 | i0 | 93.478 | 0.176245210727969 | 46 | 2 | 18 | 1 | 21 | 66 | 2524 | 2568 | Thecamonas trahens ATCC 50062 major vault protein (AMSG_09422), mRNA | blastn | 46 | 67.6 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Thecamonas | Thecamonas trahens | ||||
| 23675086 | 23675086 | PRJNA743294_P_NODE_38319_length_274_cov_1.144279_g37863_i0 | PRJNA743294 | 38319 | 274 | 1.144279 | 3.13532446 | Singekia franciliensis | 2925418 | Root_unresolved | Root_unresolved | 468 | 2.11e-127 | NTclustered | gi|2206682165|gb|OM966638.1| | 2925418 | g37863 | i0 | 97.445 | 42.014598540146 | 274 | 7 | 100 | 0 | 1 | 274 | 3565 | 3838 | Singekia franciliensis strain ORSAYFEB19APU1 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 | 11512 | 468 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Singekia | Singekia franciliensis | ||||
| 24948608 | 24948608 | PRJNA743294_P_NODE_45520_length_254_cov_2.906077_g45064_i0 | PRJNA743294 | 45520 | 254 | 2.906077 | 7.38143558 | Apusomonas proboscidea | 41120 | Root_unresolved | Root_unresolved | 219 | 2.1499999999999998e-52 | NTclustered | gi|116222168|gb|DQ980460.1| | 41120 | g45064 | i0 | 82.879 | 101.358267716535 | 257 | 31 | 99 | 11 | 3 | 254 | 517 | 269 | Apusomonas proboscidea clone aphsp90 Hsp90 mRNA, partial cds | blastn | 25745 | 219 | 1 | Eukaryota | Apusozoa | Apusomonadida | Apusomonadidae | Apusomonas | Apusomonas proboscidea |
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);;