contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA1031674" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1441311 | 1441311 | PRJNA1031674_P_NODE_12562_length_285_cov_1.334906_g12351_i0 | PRJNA1031674 | 12562 | 285 | 1.334906 | 3.8044821 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 492 | 1.31e-134 | NTclustered | gi|2082264800|ref|XM_043070043.1| | 3055 | g12351 | i0 | 98.561 | 0.975438596491228 | 278 | 4 | 98 | 0 | 1 | 278 | 550 | 273 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_14g613550v5), mRNA | blastn | 278 | 492 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 1441545 | 1441545 | PRJNA1031674_P_NODE_28042_length_241_cov_0.916667_g27831_i0 | PRJNA1031674 | 28042 | 241 | 0.916667 | 2.20916747 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 80.5 | 9.95e-11 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g27831 | i0 | 80.645 | 4.17427385892116 | 124 | 7 | 76 | 8 | 121 | 241 | 99979 | 100088 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 1006 | 80.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 2717194 | 2717194 | PRJNA1031674_P_NODE_22803_length_250_cov_0.870056_g22592_i0 | PRJNA1031674 | 22803 | 250 | 0.870056 | 2.17514 | Phyllosiphon coccidium | 1837062 | Plants | Plants | 451 | 1.91e-122 | NTclustered | gi|2473928268|ref|NC_072900.1| | 1837062 | g22592 | i0 | 99.2 | 88.576 | 250 | 2 | 100 | 0 | 1 | 250 | 109417 | 109168 | Phyllosiphon coccidium clone S213 chloroplast, complete genome | blastn | 22144 | 451 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Phyllosiphon | Phyllosiphon coccidium | |
| 5269644 | 5269644 | PRJNA1031674_P_NODE_25825_length_245_cov_0.895349_g25614_i0 | PRJNA1031674 | 25825 | 245 | 0.895349 | 2.19360505 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 453 | 5.1900000000000006e-123 | NTclustered | gi|2082261585|ref|XM_043068686.1| | 3055 | g25614 | i0 | 100 | 1.48571428571429 | 245 | 0 | 100 | 0 | 1 | 245 | 984 | 740 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g537800v5), mRNA | blastn | 364 | 453 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9094402 | 9094402 | PRJNA1031674_P_NODE_4808_length_381_cov_1.863636_g4598_i0 | PRJNA1031674 | 4808 | 381 | 1.863636 | 7.10045316 | Stichococcus bacillaris | 37433 | Plants | Plants | 407 | 6.729999999999999e-109 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g4598 | i0 | 86.234 | 101.472440944882 | 385 | 42 | 100 | 8 | 1 | 381 | 4696 | 4319 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 38661 | 407 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 9094437 | 9094437 | PRJNA1031674_P_NODE_7188_length_328_cov_3.047059_g6977_i0 | PRJNA1031674 | 7188 | 328 | 3.047059 | 9.99435352 | Chlorococcum sp. KSF0227 | 2978530 | Plants | Plants | 510 | 4.24e-140 | NTclustered | gi|2441075444|gb|OP448669.1| | 2978530 | g6977 | i0 | 94.801 | 112.301829268293 | 327 | 17 | 99 | 0 | 1 | 327 | 131775 | 131449 | Chlorococcum sp. KSF0227 chloroplast, complete genome | blastn | 36835 | 510 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorococcaceae | Chlorococcum | Chlorococcum sp. KSF0227 | |
| 10369786 | 10369786 | PRJNA1031674_P_NODE_12549_length_285_cov_1.367925_g12338_i0 | PRJNA1031674 | 12549 | 285 | 1.367925 | 3.89858625 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 490 | 4.71e-134 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g12338 | i0 | 97.88 | 108.926315789474 | 283 | 6 | 99 | 0 | 1 | 283 | 220370 | 220652 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 31044 | 490 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 10369966 | 10369966 | PRJNA1031674_P_NODE_23749_length_248_cov_1.291429_g23538_i0 | PRJNA1031674 | 23749 | 248 | 1.291429 | 3.20274392 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 459 | 1.13e-124 | NTclustered | gi|2082244992|ref|XM_001692235.2| | 3055 | g23538 | i0 | 100 | 1 | 248 | 0 | 100 | 0 | 1 | 248 | 4058 | 3811 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g222700v5), mRNA | blastn | 248 | 459 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10370145 | 10370145 | PRJNA1031674_P_NODE_9089_length_306_cov_1.064378_g8878_i0 | PRJNA1031674 | 9089 | 306 | 1.064378 | 3.25699668 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 484 | 2.3699999999999996e-132 | NTclustered | gi|1610617827|ref|NC_041430.1| | 332213 | g8878 | i0 | 95.13 | 1.00653594771242 | 308 | 13 | 100 | 1 | 1 | 306 | 9652 | 9345 | Chlorosarcinopsis eremi strain MKA.28 mitochondrion, complete genome | blastn | 308 | 484 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 11645283 | 11645283 | PRJNA1031674_P_NODE_21750_length_252_cov_1.134078_g21539_i0 | PRJNA1031674 | 21750 | 252 | 1.134078 | 2.85787656 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 466 | 6.89e-127 | NTclustered | gi|2082260615|ref|XM_043068304.1| | 3055 | g21539 | i0 | 100 | 1 | 252 | 0 | 100 | 0 | 1 | 252 | 2796 | 2545 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_12g516200v5), mRNA | blastn | 252 | 466 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 13760149 | 13760149 | PRJNA1031674_P_NODE_18491_length_264_cov_3.753927_g18280_i0 | PRJNA1031674 | 18491 | 264 | 3.753927 | 9.9103672799999991 | Chloroidium | 1034479 | Plants | Plants | 444 | 3.41e-120 | NTclustered | gi|255506502|gb|GQ168949.1| | 3082 | g18280 | i0 | 96.97 | 111.776515151515 | 264 | 8 | 100 | 0 | 1 | 264 | 222 | 485 | Pseudochlorella aquatica strain SAG 2149 D1/32 kD photosystem II reaction center protein (psbA) gene, partial cds; chloroplast | blastn | 29509 | 444 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium saccharophilum | |
| 15469515 | 15469515 | PRJNA1031674_P_NODE_1993_length_538_cov_3.419355_g1785_i0 | PRJNA1031674 | 1993 | 538 | 3.419355 | 18.3961299 | Protosiphon botryoides | 44656 | Plants | Plants | 723 | 0 | NTclustered | gi|1509778881|gb|MG778491.1| | 44656 | g1785 | i0 | 90.909 | 117.355018587361 | 539 | 47 | 100 | 2 | 1 | 538 | 22595 | 23132 | Protosiphon botryoides RNA polymerase beta subunit protein b (rpoBb), RNA polymerase beta subunit protein a (rpoBa), photosystem II protein VI (psbF), photosystem II protein L (psbL), cytochrome b6/f complex subunit V (petG), ribosomal protein S3 (rps3), RNA polymerase beta'' subunit (rpoC2), and D1 reaction center protein of photosystem II (psbA) genes, complete cds; and photosystem I P700 chlorophyll a apoprotein A1 (psaA) gene, exon 3 and partial cds; chloroplast | blastn | 63137 | 723 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Protosiphonaceae | Protosiphon | Protosiphon botryoides | |
| 16743550 | 16743550 | PRJNA1031674_P_NODE_1634_length_583_cov_36.347059_g1427_i0 | PRJNA1031674 | 1634 | 583 | 36.347059 | 211.90335397 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 1055 | 0 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g1427 | i0 | 99.314 | 94.3310463121784 | 583 | 4 | 100 | 0 | 1 | 583 | 128871 | 129453 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 54995 | 1055 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 16743669 | 16743669 | PRJNA1031674_P_NODE_23114_length_249_cov_1.375000_g22903_i0 | PRJNA1031674 | 23114 | 249 | 1.375 | 3.42375 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 460 | 3.16e-125 | NTclustered | gi|2082251207|ref|XM_043064441.1| | 3055 | g22903 | i0 | 100 | 4.81124497991968 | 249 | 0 | 100 | 0 | 1 | 249 | 1221 | 1469 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_07g345050v5), mRNA | blastn | 1198 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 16743677 | 16743677 | PRJNA1031674_P_NODE_23674_length_248_cov_1.680000_g23463_i0 | PRJNA1031674 | 23674 | 248 | 1.68 | 4.1664 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 409 | 1.16e-109 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g23463 | i0 | 96.371 | 99.258064516129 | 248 | 9 | 100 | 0 | 1 | 248 | 159507 | 159754 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 24616 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 18018548 | 18018548 | PRJNA1031674_P_NODE_21135_length_254_cov_1.817680_g20924_i0 | PRJNA1031674 | 21135 | 254 | 1.81768 | 4.6169072 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 470 | 5.37e-128 | NTclustered | gi|2082244992|ref|XM_001692235.2| | 3055 | g20924 | i0 | 100 | 2.53543307086614 | 254 | 0 | 100 | 0 | 1 | 254 | 1911 | 2164 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_04g222700v5), mRNA | blastn | 644 | 470 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18018556 | 18018556 | PRJNA1031674_P_NODE_21675_length_252_cov_1.709497_g21464_i0 | PRJNA1031674 | 21675 | 252 | 1.709497 | 4.30793244 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 460 | 3.2e-125 | NTclustered | gi|2082265174|ref|XM_001689807.2| | 3055 | g21464 | i0 | 99.605 | 13.2380952380952 | 253 | 0 | 100 | 1 | 1 | 252 | 665 | 413 | Chlamydomonas reinhardtii ribosomal protein L5 (CHLRE_14g621450v5), mRNA | blastn | 3336 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20567662 | 20567662 | PRJNA1031674_P_NODE_10677_length_291_cov_2.000000_g10466_i0 | PRJNA1031674 | 10677 | 291 | 2 | 5.82 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 473 | 4.8599999999999986e-129 | NTclustered | gi|2082256724|ref|XM_043066733.1| | 3055 | g10466 | i0 | 95.41 | 2.09621993127148 | 305 | 0 | 100 | 1 | 1 | 291 | 3848 | 4152 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_10g436800v5), mRNA | blastn | 610 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20567844 | 20567844 | PRJNA1031674_P_NODE_20637_length_256_cov_2.103825_g20426_i0 | PRJNA1031674 | 20637 | 256 | 2.103825 | 5.385792 | Nannochloris normandinae | 926285 | Plants | Plants | 424 | 4.28e-114 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g20426 | i0 | 96.498 | 86.4375 | 257 | 8 | 100 | 1 | 1 | 256 | 1625 | 1369 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 22128 | 424 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 21408972 | 21408972 | PRJNA1031674_P_NODE_4897_length_379_cov_1.241830_g4687_i0 | PRJNA1031674 | 4897 | 379 | 1.24183 | 4.7065357 | Trebouxia | 13786 | Plants | Plants | 686 | 0 | NTclustered | gi|49781197|gb|AY648107.1| | 283661 | g4687 | i0 | 99.469 | 100.414248021108 | 377 | 2 | 99 | 0 | 3 | 379 | 1827 | 1451 | Trebouxia sp. Wei 22-c 26S ribosomal RNA gene, partial sequence | blastn | 38057 | 689 | 0.995645863570392 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. Wei 22-c | |
| 21843453 | 21843453 | PRJNA1031674_P_NODE_13678_length_281_cov_1.990385_g13467_i0 | PRJNA1031674 | 13678 | 281 | 1.990385 | 5.59298185 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 505 | 1.65e-138 | NTclustered | gi|238534971|gb|GQ176394.1| | 3055 | g13467 | i0 | 99.638 | 2.85053380782918 | 276 | 1 | 98 | 0 | 6 | 281 | 3 | 278 | Chlamydomonas reinhardtii clone CNA43 molecular marker mRNA sequence | blastn | 801 | 505 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 21843485 | 21843485 | PRJNA1031674_P_NODE_15138_length_276_cov_4.428571_g14927_i0 | PRJNA1031674 | 15138 | 276 | 4.428571 | 12.22285596 | Chloroidium sp. KL-2023a | 3031248 | Plants | Plants | 488 | 1.6299999999999995e-133 | NTclustered | gi|2450595352|gb|ON986219.1| | 3031248 | g14927 | i0 | 98.551 | 142.141304347826 | 276 | 4 | 100 | 0 | 1 | 276 | 219920 | 220195 | Chloroidium sp. KL-2023a clone 2023 chloroplast, complete genome | blastn | 39231 | 488 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium sp. KL-2023a | |
| 21843785 | 21843785 | PRJNA1031674_P_NODE_7998_length_313_cov_12.170833_g7787_i0 | PRJNA1031674 | 7998 | 313 | 12.170833 | 38.09470729 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 558 | 1.41e-154 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g7787 | i0 | 99.673 | 122.380191693291 | 306 | 0 | 98 | 1 | 1 | 306 | 130623 | 130319 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 38305 | 558 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 23118934 | 23118934 | PRJNA1031674_P_NODE_20299_length_257_cov_3.233696_g20088_i0 | PRJNA1031674 | 20299 | 257 | 3.233696 | 8.31059872 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 409 | 1.2e-109 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g20088 | i0 | 99.119 | 94.284046692607 | 227 | 2 | 100 | 0 | 31 | 257 | 160389 | 160163 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 24231 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 23959082 | 23959082 | PRJNA1031674_P_NODE_14239_length_279_cov_3.165049_g14028_i0 | PRJNA1031674 | 14239 | 279 | 3.165049 | 8.83048671 | Chlorophyceae | 3166 | Plants | Plants | 512 | 9.81e-141 | NTclustered | gi|338784396|gb|HQ246433.1| | 1050260 | g14028 | i0 | 99.642 | 95.9749103942652 | 279 | 1 | 100 | 0 | 1 | 279 | 542 | 264 | Chlorosarcinopsis sp. A KF-2011 strain ZA3-2 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 26777 | 512 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis sp. A KF-2011 | |
| 24392988 | 24392988 | PRJNA1031674_P_NODE_9520_length_299_cov_3.969027_g9309_i0 | PRJNA1031674 | 9520 | 299 | 3.969027 | 11.86739073 | Stichococcus bacillaris | 37433 | Plants | Plants | 268 | 2.54e-67 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g9309 | i0 | 83.224 | 83.866220735786 | 304 | 40 | 99 | 11 | 1 | 297 | 4651 | 4950 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 25076 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 25233176 | 25233176 | PRJNA1031674_P_NODE_5560_length_361_cov_15.576389_g5350_i0 | PRJNA1031674 | 5560 | 361 | 15.576389 | 56.23076429 | Eukaryota | 2759 | Plants | Plants | 662 | 0 | NTclustered | gi|22535964|gb|AF513371.1| | 202784 | g5350 | i0 | 99.723 | 99.6481994459834 | 361 | 1 | 100 | 0 | 1 | 361 | 1619 | 1259 | Chlorophycean sp. SEV3VF14 18S small subunit ribosomal RNA gene, partial sequence | blastn | 35973 | 662 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorophyceae sp. SEV3-VF14 |
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);;