contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1158727" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1580172 | 1580172 | PRJNA1158727_P_NODE_46622_length_533_cov_4.036957_g39176_i0 | PRJNA1158727 | 46622 | 533 | 4.036957 | 21.51698081 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 815 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g39176 | i0 | 94.393 | 101.15947467167 | 535 | 23 | 100 | 7 | 1 | 533 | 14 | 543 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 53918 | 815 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 3588239 | 3588239 | PRJNA1158727_P_NODE_77403_length_347_cov_3.817518_g69942_i0 | PRJNA1158727 | 77403 | 347 | 3.817518 | 13.24678746 | Vannellidae | 95227 | Discosea | other_Eukaryota | 577 | 4.3799999999999985e-160 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g69942 | i0 | 96.821 | 100.190201729107 | 346 | 10 | 99 | 1 | 2 | 347 | 1679 | 1335 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 34766 | 579 | 0.996545768566494 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 5408974 | 5408974 | PRJNA1158727_P_NODE_59385_length_429_cov_1.721910_g51924_i0 | PRJNA1158727 | 59385 | 429 | 1.72191 | 7.3869939 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 224 | 8.289999999999998e-54 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g51924 | i0 | 80.201 | 65.5990675990676 | 298 | 59 | 69 | 0 | 1 | 298 | 418 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 28142 | 224 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6681669 | 6681669 | PRJNA1158727_P_NODE_132726_length_253_cov_1.677778_g125265_i0 | PRJNA1158727 | 132726 | 253 | 1.677778 | 4.24477834 | Stenamoeba aeronauta | 2971262 | Discosea | other_Eukaryota | 403 | 5.499999999999998e-108 | NTclustered | gi|2283789716|gb|OP179856.1| | 2971262 | g125265 | i0 | 95.331 | 76.2806324110672 | 257 | 7 | 100 | 5 | 1 | 253 | 391 | 136 | Stenamoeba aeronauta strain Stenaero small subunit ribosomal RNA gene, partial sequence | blastn | 19299 | 403 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Thecamoebida | Stenamoeba | Stenamoeba aeronauta | |||
| 6683225 | 6683225 | PRJNA1158727_P_NODE_41866_length_592_cov_1.495183_g34462_i0 | PRJNA1158727 | 41866 | 592 | 1.495183 | 8.85148336 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 483 | 1.7499999999999999e-131 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g34462 | i0 | 81.802 | 89.3361486486486 | 577 | 103 | 97 | 2 | 17 | 592 | 1839 | 1264 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 52887 | 483 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 6684722 | 6684722 | PRJNA1158727_P_NODE_94066_length_305_cov_0.995690_g86605_i0 | PRJNA1158727 | 94066 | 305 | 0.99569 | 3.0368545 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 102 | 2.78e-17 | NTclustered | gi|470459156|ref|XM_004341277.1| | 1257118 | g86605 | i0 | 92.857 | 2.89508196721311 | 70 | 5 | 23 | 0 | 1 | 70 | 1097 | 1166 | Acanthamoeba castellanii str. Neff ribosomal protein L3, putative (ACA1_264110), partial mRNA | blastn | 883 | 102 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 9232408 | 9232408 | PRJNA1158727_P_NODE_164788_length_238_cov_2.478788_g157326_i0 | PRJNA1158727 | 164788 | 238 | 2.478788 | 5.89951544 | Ripella sp. PS2 | 1217116 | Discosea | other_Eukaryota | 176 | 1.22e-39 | NTclustered | gi|399764205|gb|JQ271716.1| | 1217116 | g157326 | i0 | 83.59 | 82.0168067226891 | 195 | 25 | 80 | 7 | 48 | 238 | 1376 | 1185 | Ripella sp. PS2 18S ribosomal RNA gene, partial sequence | blastn | 19520 | 176 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. PS2 | |||
| 21982138 | 21982138 | PRJNA1158727_P_NODE_39738_length_622_cov_4.289617_g32355_i0 | PRJNA1158727 | 39738 | 622 | 4.289617 | 26.68141774 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 455 | 4.02e-123 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g32355 | i0 | 80.56 | 60.2958199356913 | 607 | 105 | 97 | 9 | 21 | 622 | 2520 | 1922 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 37504 | 455 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;