contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA1000943" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 999277 | 999277 | PRJNA1000943_P_NODE_8321_length_286_cov_2.863850_g8183_i0 | PRJNA1000943 | 8321 | 286 | 2.86385 | 8.190611 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 119 | 2.57e-22 | NTclustered | gi|155620|gb|M93361.1|ACAACTPH | 5755 | g8183 | i0 | 83.594 | 0.895104895104895 | 128 | 19 | 44 | 2 | 22 | 148 | 391 | 265 | Acanthamoeba castellanii actophorin mRNA, complete cds | blastn | 256 | 119 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 1419783 | 1419783 | PRJNA1000943_P_NODE_10782_length_255_cov_2.247253_g10644_i0 | PRJNA1000943 | 10782 | 255 | 2.247253 | 5.73049515 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 156 | 1.72e-33 | NTclustered | gi|1269228457|gb|MF683582.1| | 2047823 | g10644 | i0 | 87.591 | 50.9333333333333 | 137 | 13 | 53 | 4 | 68 | 201 | 1364 | 1229 | Ripella tribonemae clone 70.1.17 18S ribosomal RNA gene, partial sequence | blastn | 12988 | 156 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 3971429 | 3971429 | PRJNA1000943_P_NODE_15944_length_229_cov_2.397436_g15806_i0 | PRJNA1000943 | 15944 | 229 | 2.397436 | 5.49012844 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 287 | 5.14e-73 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g15806 | i0 | 88.983 | 47.5152838427948 | 236 | 17 | 100 | 9 | 1 | 229 | 1177 | 1410 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 10881 | 287 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 3971447 | 3971447 | PRJNA1000943_P_NODE_2984_length_447_cov_4.558824_g2847_i0 | PRJNA1000943 | 2984 | 447 | 4.558824 | 20.37794328 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 715 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g2847 | i0 | 95.759 | 101.485458612975 | 448 | 11 | 100 | 6 | 1 | 447 | 987 | 547 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 45364 | 715 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 6523543 | 6523543 | PRJNA1000943_P_NODE_8346_length_286_cov_1.464789_g8208_i0 | PRJNA1000943 | 8346 | 286 | 1.464789 | 4.18929654 | Ripella tribonemae | 2047823 | Discosea | other_Eukaryota | 204 | 6.899999999999999e-48 | NTclustered | gi|1269228466|gb|MF683591.1| | 2047823 | g8208 | i0 | 84.615 | 66.2342657342657 | 208 | 28 | 73 | 4 | 69 | 276 | 892 | 689 | Ripella tribonemae clone 22.1.8 18S ribosomal RNA gene, partial sequence | blastn | 18943 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella tribonemae | |||
| 7376724 | 7376724 | PRJNA1000943_P_NODE_1646_length_591_cov_1.959459_g1510_i0 | PRJNA1000943 | 1646 | 591 | 1.959459 | 11.58040269 | Vannellidae | 95227 | Discosea | other_Eukaryota | 928 | 0 | NTclustered | gi|399764204|gb|JQ271715.1| | 1217115 | g1510 | i0 | 95.118 | 100.639593908629 | 594 | 20 | 100 | 8 | 1 | 591 | 1094 | 1681 | Ripella sp. GP2 18S ribosomal RNA gene, partial sequence | blastn | 59478 | 929 | 0.998923573735199 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. GP2 | |||
| 9072640 | 9072640 | PRJNA1000943_P_NODE_6108_length_327_cov_1.200787_g5970_i0 | PRJNA1000943 | 6108 | 327 | 1.200787 | 3.92657349 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 344 | 4.53e-90 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g5970 | i0 | 85.671 | 42.2782874617737 | 328 | 45 | 100 | 2 | 1 | 327 | 1592 | 1266 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 13825 | 344 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11623685 | 11623685 | PRJNA1000943_P_NODE_13490_length_247_cov_0.896552_g13352_i0 | PRJNA1000943 | 13490 | 247 | 0.896552 | 2.21448344 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 58.4 | 4.8e-4 | NTclustered | gi|470492282|ref|XM_004345943.1| | 1257118 | g13352 | i0 | 100 | 0.238866396761134 | 31 | 0 | 13 | 0 | 151 | 181 | 691 | 721 | Acanthamoeba castellanii str. Neff uncharacterized protein (ACA1_183950), partial mRNA | blastn | 59 | 58.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 11623766 | 11623766 | PRJNA1000943_P_NODE_6490_length_319_cov_1.130081_g6352_i0 | PRJNA1000943 | 6490 | 319 | 1.130081 | 3.60495839 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 95.3 | 4.9e-15 | NTclustered | gi|470384599|ref|XM_004334016.1| | 1257118 | g6352 | i0 | 86.905 | 0.382445141065831 | 84 | 11 | 26 | 0 | 4 | 87 | 720 | 803 | Acanthamoeba castellanii str. Neff Fibrillarin, putative (ACA1_025690), partial mRNA | blastn | 122 | 95.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 13752712 | 13752712 | PRJNA1000943_P_NODE_1911_length_548_cov_4.235789_g1775_i0 | PRJNA1000943 | 1911 | 548 | 4.235789 | 23.21212372 | Ripella | 1217112 | Discosea | other_Eukaryota | 870 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g1775 | i0 | 95.764 | 99.8065693430657 | 543 | 18 | 99 | 5 | 9 | 548 | 1 | 541 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54694 | 870 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 15447824 | 15447824 | PRJNA1000943_P_NODE_1513_length_619_cov_2.115385_g1378_i0 | PRJNA1000943 | 1513 | 619 | 2.115385 | 13.09423315 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 420 | 1.4599999999999998e-112 | NTclustered | gi|470437282|ref|XM_004338924.1| | 1257118 | g1378 | i0 | 80 | 91.4168012924071 | 585 | 103 | 93 | 13 | 6 | 583 | 620 | 43 | Acanthamoeba castellanii str. Neff adenine nucleotide translocator, putative (ACA1_128450), partial mRNA | blastn | 56587 | 420 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19270734 | 19270734 | PRJNA1000943_P_NODE_5016_length_355_cov_2.812057_g4879_i0 | PRJNA1000943 | 5016 | 355 | 2.812057 | 9.98280235 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 486 | 7.77e-133 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g4879 | i0 | 99.624 | 59.8028169014084 | 266 | 1 | 75 | 0 | 29 | 294 | 252 | 517 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 21230 | 486 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 21821976 | 21821976 | PRJNA1000943_P_NODE_15638_length_240_cov_6.958084_g15500_i0 | PRJNA1000943 | 15638 | 240 | 6.958084 | 16.6994016 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 333 | 6.88e-87 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g15500 | i0 | 94.495 | 10.1916666666667 | 218 | 8 | 90 | 4 | 3 | 219 | 218 | 4 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 2446 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus |
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);;