contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2212490 | 2212490 | PRJNA951810_P_NODE_33462_length_344_cov_1.564576_g33120_i0 | PRJNA951810 | 33462 | 344 | 1.564576 | 5.38214144 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 453 | 7.630000000000001e-123 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g33120 | i0 | 90.407 | 98.3982558139535 | 344 | 33 | 100 | 0 | 1 | 344 | 758 | 1101 | Platyamoeba placida actin mRNA, partial cds | blastn | 33849 | 453 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 4766581 | 4766581 | PRJNA951810_P_NODE_93264_length_296_cov_4.197309_g92920_i0 | PRJNA951810 | 93264 | 296 | 4.197309 | 12.42403464 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 60.2 | 1.64e-4 | NTclustered | gi|470484210|ref|XM_004343996.1| | 1257118 | g92920 | i0 | 91.111 | 0.152027027027027 | 45 | 2 | 15 | 2 | 229 | 272 | 446 | 403 | Acanthamoeba castellanii str. Neff Peroxin 13 (Pex13), putative (ACA1_053870), partial mRNA | blastn | 45 | 60.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7315775 | 7315775 | PRJNA951810_P_NODE_65506_length_310_cov_2.780591_g65163_i0 | PRJNA951810 | 65506 | 310 | 2.780591 | 8.6198321 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 145 | 4.6399999999999994e-30 | NTclustered | gi|470531839|ref|XM_004358199.1| | 1257118 | g65163 | i0 | 84.828 | 0.670967741935484 | 145 | 20 | 46 | 2 | 1 | 144 | 435 | 292 | Acanthamoeba castellanii str. Neff thiF family protein (ACA1_085210), partial mRNA | blastn | 208 | 145 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11139539 | 11139539 | PRJNA951810_P_NODE_134589_length_269_cov_10.183673_g134244_i0 | PRJNA951810 | 134589 | 269 | 10.183673 | 27.39408037 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 228 | 3.809999999999999e-55 | NTclustered | gi|470427085|ref|XM_004337911.1| | 1257118 | g134244 | i0 | 98.45 | 0.479553903345725 | 129 | 2 | 48 | 0 | 128 | 256 | 1539 | 1411 | Acanthamoeba castellanii str. Neff 4aminobutyrate aminotransferase (ACA1_321730), partial mRNA | blastn | 129 | 228 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11467551 | 11467551 | PRJNA951810_P_NODE_34569_length_337_cov_5.189394_g34226_i0 | PRJNA951810 | 34569 | 337 | 5.189394 | 17.48825778 | Ripella | 1217112 | Discosea | other_Eukaryota | 520 | 7.249999999999999e-143 | NTclustered | gi|1269228350|gb|MF683475.1| | 2047821 | g34226 | i0 | 94.444 | 91.7329376854599 | 342 | 11 | 100 | 6 | 1 | 337 | 182 | 520 | Ripella platypodia clone 23.4.23 18S ribosomal RNA gene, partial sequence | blastn | 30914 | 520 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 19115634 | 19115634 | PRJNA951810_P_NODE_90535_length_297_cov_4.343750_g90191_i0 | PRJNA951810 | 90535 | 297 | 4.34375 | 12.9009375 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 135 | 2.6600000000000003e-27 | NTclustered | gi|881634|gb|U29610.1|ACU29610 | 5755 | g90191 | i0 | 78.112 | 2.96969696969697 | 233 | 37 | 74 | 6 | 7 | 226 | 836 | 605 | Acanthaoeba castellanii actin-related protein 3 Arp3 mRNA, complete cds | blastn | 882 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 21338739 | 21338739 | PRJNA951810_P_NODE_180737_length_231_cov_4.031646_g180392_i0 | PRJNA951810 | 180737 | 231 | 4.031646 | 9.31310226 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 390 | 3.849999999999999e-104 | NTclustered | gi|1269228471|gb|MF683596.1| | 2047823 | g180392 | i0 | 96.996 | 101.155844155844 | 233 | 5 | 100 | 2 | 1 | 231 | 1549 | 1317 | Ripella tribonemae clone 22.1.14 18S ribosomal RNA gene, partial sequence | blastn | 23367 | 390 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae |
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);;